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;
Showing posts with label postgres. Show all posts
Showing posts with label postgres. Show all posts
Thursday, September 14, 2006
Finding open locks in Postgres
Subscribe to:
Posts (Atom)