Postgres Pro
Downloads
Home   >   mailing lists

How to find backend which blocking ? - Mailing list pgsql-general

From Vaclav Kulakovsky
Subject How to find backend which blocking ?
Date
Msg-id Pine.LNX.4.44.0204182019440.19668-100000@vigo.diz
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: [GENERAL/OFF-TOPIC]: identifying runaway DB clients
Next
From: Ed Loehr
Date:
Subject: Re: Questions on 7.2.1 query plan choices