Re: Meaning of transaction pg_locks?

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