Re: - Mailing list pgsql-admin

From Bender, Cheryl
Subject Re:
Date
Msg-id D5DB5D0D27171247AFEC9648EE98752F03220126@KCEX2KV1.mri-kc.int
Whole thread Raw
In response to  ("Monica Libero" <mparotti@libero.it>)
List pgsql-admin
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




pgsql-admin by date:

Previous
From: "Goulet, Dick"
Date:
Subject: Re: Setup for a db class
Next
From: "Jeff Stout"
Date:
Subject: Postgres and Funk Radius