Skip to content

Instantly share code, notes, and snippets.

@superchell

superchell/check idle in transaction

Created August 7, 2020 20:09
Show Gist options
  • Save superchell/1089dbed64037cb5323dba4f34e8362f to your computer and use it in GitHub Desktop.
Save superchell/1089dbed64037cb5323dba4f34e8362f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
check idle in transaction
SELECT usename, state, query FROM pg_stat_activity WHERE wait_event IS NOT NULL AND backend_type = 'client backend' AND state = 'idle in transaction';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment