It's good to have query to see active and idle in transaction query
I propose to make "a2" with next query:
SELECT pid, client_addr, now() - query_start as "runtime", usename, datname, state, query
FROM pg_stat_activity
WHERE now() - query_start > '30 seconds'::interval and state != 'idle'
ORDER BY runtime DESC;
It's good to have query to see active and idle in transaction query I propose to make "a2" with next query:
SELECT pid, client_addr, now() - query_start as "runtime", usename, datname, state, query FROM pg_stat_activity WHERE now() - query_start > '30 seconds'::interval and state != 'idle' ORDER BY runtime DESC;