março 8th, 2010
postgresql – show full processlist
Posted by
Felipe Olivaes in
Postgre SQL
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;
