Helge Bahmann <bahmann@math.tu-freiberg.de> writes:
> If query execution is blocked because a record/table is locked, how can
> I find out which backend is holding the lock?
There isn't any good way right now. Someone needs to write some code
that dumps out the state of the lock tables in a useful form ...
regards, tom lane