Re: SELECT .. FOR UPDATE: find out who locked a row

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Mar 15, 2018 at 1:30 PM, Enrico Thierbach <eno@xxxxxxxxxxxx> wrote:

Now I wonder if it is possible, given the id of one of the locked rows in the queue table, to find out which connection/which transaction owns the lock

​I'd start here:​

https://www.postgresql.org/docs/10/static/view-pg-locks.html

​​

and the pg_stat_activity view:

https://www.postgresql.org/docs/10/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE

The system doesn't really understand your model ID/PK field - the system views and catalogs using system identifiers.

David J.