From: Monica Libero <mparotti@libero.it>
To: pgsql-admin@postgresql.org
Date: Sat, 21 Aug 2004 00:26:47 +0200
Message-ID: <000201c499d0$9ca01280$d70106c0@fisso> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mparotti@libero.it
Subject: Re:
In-Reply-To: <000201c499d0$9ca01280$d70106c0@fisso>
References: <000201c499d0$9ca01280$d70106c0@fisso>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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