Greetnigs, * Enrico Thierbach (eno@xxxxxxxxxxxx) wrote: > I guess with your query I can figure out which connection holds a lock, but > it seems I cannot correlate those locks to the rows which actually are > locked, since `pg_locks` seems not to reference this in any way. What I gave you would work, or you could use the pgrowlocks extension: https://www.postgresql.org/docs/current/static/pgrowlocks.html Using pgrowlocks will be slow if you have a lot of records in the table though, hence the other approach I mentioned since it sounds like you know the ID that you're interested in. Thanks! Stephen
Attachment:
signature.asc
Description: PGP signature
