Thread: lock owner

lock owner

From
Helge Bahmann
Date:
Hello,

If query execution is blocked because a record/table is locked, how can
I find out which backend is holding the lock?

Regards,
Helge


Re: lock owner

From
Tom Lane
Date:
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