Thread:

From
"Monica Libero"
Date:

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




Re:

From
"Bender, Cheryl"
Date:
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: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Monica Libero
Sent: Friday, August 20, 2004 5:27 PM
To: pgsql-admin@postgresql.org
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