他的回复:
试试这个select ss.pid,ss.usesysid,ss.usename,ss.application_name,ss.client_addr,ss.query_start,ss.state,ss.query from pg_stat_activity ss inner join (select backendid,pg_stat_get_backend_pid(s.backendid) as procpid from (select pg_stat_get_backend_idset() as backendid) s) ff on ss.pid = ff.procpid;