Send As SMS

Friday, May 05, 2006

Examining PosgtreSQL's locks

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