Thursday, September 14, 2006

Finding open locks in Postgres

Found a useful query to find open locks in postgres:

select pg_class.relname,pg_locks.* from pg_class,pg_locks where pg_class.relfilenode=pg_locks.relation;

No comments: