Michael Shulman wrote:
Hi, This seems like it must be a common question, but Google can't find the answer for me. How do I view the currently open row-level locks? The manual says that the table pg_locks doesn't contain row-level locks, since they are stored on disk rather than in memory, but it doesn't say how one can view those locks.
If you just want to see if a lock has been taken (e.g. SELECT FOR UPDATE) then that shows in pg_locks. If you want details on the actual rows involved, then you probably want "pgrowlocks" mentioned in Appendix F. Additional Supplied Modules.
-- Richard Huxton Archonet Ltd
