Examining PosgtreSQL's locks
For posterity, a quick hack for use when diagnosing deadlocks:
SELECT pg_class.relname, pg_locks.*(If any unexpected locks appear, grepping syslog for the PID will give you the remote TCP port number, etc.)
FROM pg_class JOIN pg_locks ON pg_class.oid = pg_locks.relation
WHERE granted
ORDER BY pid;
<< Home