Skip to content

Instantly share code, notes, and snippets.

@tchellomello

tchellomello/pgsql

Created September 28, 2018 19:46
Show Gist options
  • Save tchellomello/35b95488d696e0d8f901b2a1c05b644e to your computer and use it in GitHub Desktop.
Save tchellomello/35b95488d696e0d8f901b2a1c05b644e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pgsql
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment