pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
2+ messages / 2 participants
[nested] [flat]
* (no subject)
@ 2004-08-09 08:17 restellifabio@libero.it <restellifabio@libero.it>
2004-08-11 07:19 ` Re: Jouneau Luc <Luc.Jouneau@diamant.jouy.inra.fr>
0 siblings, 1 reply; 2+ messages in thread
From: restellifabio@libero.it @ 2004-08-09 08:17 UTC (permalink / raw)
To: pgsql-admin
help me!
I want see all field od this query:
SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
pg_stat_get_backend_activity(s.backendid) AS current_query FROM (SELECT
pg_stat_get_backend_idset() AS backendid) s;
procpid | current_query
---------+---------------
6449 |
6397 |
7905 |
7932 |
8509 |
8018 |
6638 |
8046 |
8627 |
8068 |
8077 |
8103 |
8104 |
8105 |
8126 |
8164 |
8173 |
8198 |
8208 |
8242 |
8590 |
I is super user and not see field current_quey
by
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re:
2004-08-09 08:17 (no subject) restellifabio@libero.it <restellifabio@libero.it>
@ 2004-08-11 07:19 ` Jouneau Luc <Luc.Jouneau@diamant.jouy.inra.fr>
0 siblings, 0 replies; 2+ messages in thread
From: Jouneau Luc @ 2004-08-11 07:19 UTC (permalink / raw)
To: pgsql-admin
> help me!
> I want see all field od this query:
> SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
> pg_stat_get_backend_activity(s.backendid) AS current_query FROM (SELECT
> pg_stat_get_backend_idset() AS backendid) s;
Have you set stats_command_string to true in $PGDATA/postgresql.conf ?
Jouneau Luc
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-08-11 07:19 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-09 08:17 restellifabio@libero.it <restellifabio@libero.it>
2004-08-11 07:19 ` Re: Jouneau Luc <Luc.Jouneau@diamant.jouy.inra.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox