> Can you provide more details? pg_locks, pg_stat_activity, the deadlock
> message?
>
> (Hmm, it would be helpful if the deadlock checker were to save the
> pg_locks contents and perhaps pg_stat_activity in a file, whenever a
> deadlock is detected.)
Great idea! As somebody who's spent hours tracking down deadlocks
recently, I'd love to have a configurable deadlocks.log file capability.