arthurmde

-- 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;

-- show long-running queries (greater than 5 minutes)
SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,