SELECT p.procpid, p.usename, p.current_query, current_timestamp – p.query_start as time
FROM pg_stat_activity AS p
WHERE current_query not like ‘<IDLE>’
order by p.query_start
SELECT pg_class.relname, pg_locks.transactionid, pg_locks.mode, pg_locks.granted as “g”,
pg_stat_activity.current_query, pg_stat_activity.query_start,
age(now(),pg_stat_activity.query_start) as “age”, pg_stat_activity.procpid
from pg_stat_activity,pg_locks
left outer join pg_class on
(pg_locks.relation = pg_class.oid)
where pg_locks.pid=pg_stat_activity.procpid and pg_stat_activity.procpid = <pid>
order by query_start;