Feature request active and idle in transaction query

[oleg9301]

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;