Re: wiki on monitoring locks has queries that don't seem to work

On Mon, Nov 25, 2013 at 11:57 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

> So I'm running 8.4 and go to this
> page:http://wiki.postgresql.org/wiki/Lock_Monitoring
>
> I have a query that is definitely blocked by another query. I run the
> first or third queries, the ones that explicitly say that they're for
> <9.2 and neither produces any output. The third query gives me a list
> of 182 rows, only a few of which are actually locked in any meaningful
> ways.
>

Those queries only find row-level locks, not object-level locks (as
indicated). I suspect that you are blocking on object-level locks. Maybe
you will have better luck with
http://wiki.postgresql.org/wiki/Lock_dependency_information.

>
> Now if I run this query:
>
> select relname,pg_locks.* from pg_class,pg_locks where
> relfilenode=relation and not granted;
>
> I get the one row for the update / insert / delete that is getting blocked.
>

Can you show us that row?

Cheers,

Jeff