Re: [ADMIN] [GENERAL] How to detect Postgres deadlocks?

2006-08-23 Thread Peter Eisentraut
andre wrote: 1) Which sql queries should I use to detect deadlocks while they are happening? I see the deadlock info on the log file, but I'd like to query the database to see them as they happen... Since deadlocks are broken up within one second, it will be hard to actually see them. You

Re: [ADMIN] [GENERAL] How to detect Postgres deadlocks?

2006-08-23 Thread Scott Marlowe
On Wed, 2006-08-23 at 14:45, andre wrote: Hi, We are using Postgres 7.4.5, and I'm trying to find a way to detect and gather deadlock information. 1) Which sql queries should I use to detect deadlocks while they are happening? I see the deadlock info on the log file, but I'd like to