Postgres active queries

From UVOO Tech Wiki

Revision as of 23:23, 7 August 2022 by Busk (talk | contribs) (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%' ```")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

Retrieved from "https://tech.uvoo.io/index.php?title=Postgres_active_queries&oldid=3322"