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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
