(NONE)

[r***@libero.it]

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




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Jouneau Luc]

Post by r***@libero.it
help me!
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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)