postgresql状态查询
SELECT * FROM pg_stat_activity WHERE datname='ams' and waiting='t';
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;
作者 gznofeng