How to find backend which locking ?

From: Vaclav Kulakovsky <vaclav(dot)kulakovsky(at)definity(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: How to find backend which locking ?
Date: 2002-04-18 14:00:25
Message-ID: Pine.LNX.4.44.0204181553460.14366-100000@vigo.diz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi all,

is there any way how to find backend which is blocking ? I turned on
LOCK_DEBUG, but I can see only active locks. It would be great to have a
possibility to show tree how backends wait for each other.

Regards,

Vak

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-04-18 14:24:49 Re: Performance of column order
Previous Message wsheldah 2002-04-18 13:42:26 Re: PERL DBI and Novell Netware