Skip to content

Instantly share code, notes, and snippets.

@rupurt

rupurt/current-locks.sql

Created August 14, 2017 17:10
Show Gist options
  • Save rupurt/a62112510c023390a5a4e6a1b5805f25 to your computer and use it in GitHub Desktop.
Save rupurt/a62112510c023390a5a4e6a1b5805f25 to your computer and use it in GitHub Desktop.
Download ZIP
Current Postgres Locks
Raw
current-locks.sql
SELECT
pg_class.relname,
pg_locks.mode
FROM pg_locks
JOIN pg_class ON pg_class.oid = pg_locks.relation
ORDER BY mode ASC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment