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