-- show running queries (pre 9.2)

SELECT procpid, age(clock_timestamp(), query_start), usename, current_query

FROM pg_stat_activity

WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'

ORDER BY query_start desc;

-- show running queries (9.2)

SELECT pid, age(clock_timestamp(), query_start), usename, query

FROM pg_stat_activity

WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

ORDER BY query_start desc;