How to find backend which blocking ?

From: Vaclav Kulakovsky <vaclav(dot)kulakovsky(at)definity(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: How to find backend which blocking ?
Date: 2002-04-18 18:23:49
Message-ID: Pine.LNX.4.44.0204182019440.19668-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.
Or can somebody say if it is possible to write it ?

Regards,

Vak

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-04-18 20:24:08 Re: [GENERAL/OFF-TOPIC]: identifying runaway DB clients
Previous Message Ed Loehr 2002-04-18 18:05:55 Re: Questions on 7.2.1 query plan choices