Tom Lane wrote:
>Nathan Wilhelmi <wilhelmi(at)ucar(dot)edu> writes:
>
>
>>Hello - Trying to track down a lock contention problem, I have a process
>>that does a series of select / insert operations. At some point the
>>process grabs a series of RowExclusiveLock(s) and has the obvious effect
>>of stalling other processes. I logged all the statements and don't see
>>any for update or explicit lock statements.
>>
>>
>
>Insert statements would naturally take RowExclusiveLock, but that
>doesn't block other DML operations. So the question is what *else*
>are you doing?
>
> regards, tom lane
>
>
Good question, is there anyway to figure out which rows are locked?
-Nate