Skip to content

Instantly share code, notes, and snippets.

@dougcole

dougcole/psql_lock_diagnostic.sql

Created November 25, 2008 09:23
Show Gist options
  • Save dougcole/28859 to your computer and use it in GitHub Desktop.
Save dougcole/28859 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
psql_lock_diagnostic.sql
select pg_class.relname,pg_locks.mode,pg_stat_activity.current_query from pg_class,pg_locks,pg_stat_activity where pg_class.relfilenode=pg_locks.relation and pg_stat_activity.procpid=pg_locks.pid;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment