Re: Meaning of transaction pg_locks? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Meaning of transaction pg_locks?
Date
Msg-id 22095.1226458383@sss.pgh.pa.us
Whole thread Raw
In response to Meaning of transaction pg_locks?  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: Meaning of transaction pg_locks?  (Philip Warner <pjw@rhyme.com.au>)
List 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


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: Meaning of transaction pg_locks?
Next
From: Tom Lane
Date:
Subject: Re: Reducing some DDL Locks to ShareLock