79357723

Date: 2025-01-15 09:52:13
Score: 1
Natty:
Report link

Might be too late for this to be relevant for the OP but for anyone googling this it is to do with transaction vs tuple context.

"Although tuples are a lockable type of object, information about row-level locks is stored on disk, not in memory, and therefore row-level locks normally do not appear in this view. If a process is waiting for a row-level lock, it will usually appear in the view as waiting for the permanent transaction ID of the current holder of that row lock."

from https://www.postgresql.org/docs/17/view-pg-locks.html

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: SteWood