finding the other statement causing a sharelock

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: finding the other statement causing a sharelock
Date: 2010-11-08 19:52:15
Message-ID: 20101108205215.48bd3711@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I get

DETAIL: Process 24749 waits for ShareLock on transaction 113443492;
blocked by process 25199. Process 25199 waits for ShareLock on
transaction 113442820; blocked by process 24749.

I would like to know both statements that caused the sharelock
problem.

This is a long running transaction. I know one of the statement. I'd
like to know the other.

How?

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-11-08 20:31:58 Re: ERROR: Out of memory - when connecting to database
Previous Message Leif Biberg Kristensen 2010-11-08 19:39:51 Re: Full Vacuum/Reindex vs autovacuum