[PSQL - Active Queries] List Active Queries #psql

psql-list-active-queries.sql

-- PostgreSQL: List the active queries
-- see also <https://gist.github.com/rgreenjr/3637525>
SELECT ROW_NUMBER() OVER() as rn
, a.datname
, a.usename
, a.client_addr
, a.pid
, age(clock_timestamp(), a.query_start) as age_start
, age(clock_timestamp(), state_change) as age_change
, a.wait_event
, a.state
, replace(a.query, '\n', ' ') as query
FROM pg_stat_activity a 
WHERE query NOT ILIKE '%pg_stat_activity%' and (a.state <> 'idle' /*or  age(clock_timestamp(), query_start) > interval'1 day'*/) 
ORDER BY query_start ASC 
LIMIT 35
;