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;
Subscribe to:
Post Comments (Atom)
Disclaimer:The views expressed here reflect my personal opinion on various entities. They have no connection to my employer.
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:
Post a Comment