Horton

Re: Meaning of transaction pg_locks?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Philip Warner <pjw@rhyme.com.au>
Cc: pgsql-hackers@postgresql.org
Date: 2008-11-12T02:53:03Z
Lists: pgsql-hackers 
Philip Warner <pjw@rhyme.com.au> writes:
> Partial output of "select * from pg_locks":

>            |           |  1192675195 | 62860 | ShareLock           | f
>            |           |  1192675195 | 62814 | ExclusiveLock       | t
>            |           |  1192675195 | 62838 | ShareLock           | f
>            |           |  1192675195 | 63525 | ShareLock           | f

> where 1192675195 is the 'transaction' field.

> I am not at all clear what the processes are waiting for,

Neither are we, because you left out all the columns that might tell
that ...

			regards, tom lane