Re: pg_locks: who is locking ?

Alexandre Arruda wrote:
> Hi,
>
> My Database have a lot of locks not granted every moments in a day.
>
> Can I create a view that returns someting like this ?
>
> User    Granted    Table    Who_is_locking_me  PID
> ----    -------    -----    -----------------  ---
> joe    f    foo    frank              1212
> jeff    f    foo    frank              1313
> ann    f    foo    frank              1414
> frank    t    foo                   1111
> (...)
>
> (Or the locked transactions, if the table cold't be retrived)

You can look up more data about a backend by joining pg_locks to
pg_stat_activity, using the PID (I think it's called procpid on one view
and pid on the other).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support