At this point you'd probably like a more automatic way to log locking problems than to just watch pg_locks all day. There is a pair of database parameters that allow doing that, as a by-product of sorts of how the database defends itself against deadlock problems.