Postgres Pro
Downloads
Home   >   mailing lists

finding the other statement causing a sharelock - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject finding the other statement causing a sharelock
Date
Msg-id 20101108205215.48bd3711@dawn.webthatworks.it
Whole thread Raw
Responses Re: finding the other statement causing a sharelock  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Leif Biberg Kristensen
Date:
Subject: Re: Full Vacuum/Reindex vs autovacuum
Next
From: Tom Lane
Date:
Subject: Re: ERROR: Out of memory - when connecting to database