Difference between revisions of "Postgres active queries"
Jump to navigation
Jump to search
(Created page with "``` SELECT pid, age(clock_timestamp(), query_start), usename, query FROM pg_stat_activity WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' ```") |
(No difference)
|
Latest revision as of 23:23, 7 August 2022
SELECT pid, age(clock_timestamp(), query_start), usename, query FROM pg_stat_activity WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'