Re: [ADMIN]

[Bender, Cheryl]

Title: Message

Are you sure there is current activity on your backend when you are running this query?  I get the same result because there are no queries executing.      Cheryl Bender -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Monica Libero Sent: Friday, August 20, 2004 5:27 PM To: [EMAIL PROTECTED] Subject: [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 Fabio RESTELLI