Greetnigs, * Enrico Thierbach (e...@open-lab.org) 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
signature.asc
Description: PGP signature
