From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: wiki on monitoring locks has queries that don't seem to work |
Date: | 2013-11-25 22:06:38 |
Message-ID: | CAOR=d=25u7N5XuxeoVxfCzrQWV4B=THO+mb0AXVTRtOr7WKfQg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Nov 25, 2013 at 1:47 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> 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
well it's gone now. it was a delete on sl_log_1 in slony. I'll wait
for it to happen again and can repost it. meanwhile I'll try the link
you posted. Thanks.
--
To understand recursion, one must first understand recursion.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2013-11-25 22:24:25 | Re: [GENERAL] pg_upgrade ?deficiency |
Previous Message | Nelson Green | 2013-11-25 22:01:14 | Inserting rows containing composite foreign keys |