From: Erik Wasser <erik.wasser@iquer.net>
To: pgsql-sql@postgresql.org
Subject: 'show full processlist' in postgres?
Date: Fri, 1 Jul 2005 15:58:46 +0200
User-Agent: KMail/1.7.2
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200507011558.46408.erik.wasser@iquer.net>

Hallo pgsql-sql@postgresql.org,

I'm looking for a way to display the active querys of postgres. The 
mysql way is a 'show [full] processlist'.

After I've read http://pgsqld.active-venture.com/monitoring-stats.html I 
set STATS_COMMAND_STRING, STATS_BLOCK_LEVEL, STATS_ROW_LEVEL and 
STATS_START_COLLECTOR to 'true'.

Then I executed the query from the bottom of the page:

> 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) AS S;

The result was:

 procpid | current_query
---------+---------------
    1367 |
   27387 |
     930 |
   28425 | <IDLE>
(4 rows)

Why there isn't any query in the 'current_query' row? Calling the query 
multiple times just changes the PID (sometimes) but 'current_query' was 
always empty. How do I show up the a list of querys that will be 
processed right in this moment?

P.S: I'm using postgresql 7.4.7 and I was logged I as 'postgres'.

-- 
So long... Fuzz