Psql Oldest Running Query

psql_oldest_query.sql

SELECT application_name, 
       pid, 
       state,
       age(clock_timestamp(), query_start), /* How long has the query has been running in h:m:s */
       usename, 
       query /* The query text */
FROM pg_stat_activity
WHERE state != 'idle'
AND query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start asc;