Re: postgresql statements are waiting - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: postgresql statements are waiting
Date
Msg-id AANLkTi=U48HBU4j-5UF_ZeyxtzZg4ARb874cPo3qnBe1@mail.gmail.com
Whole thread Raw
In response to postgresql statements are waiting  (bakkiya <bakkiya@gmail.com>)
List pgsql-performance
On Tue, Nov 30, 2010 at 4:38 AM, bakkiya <bakkiya@gmail.com> wrote:
>
> Hi,
> I am working on a performance issue with a partitioned table. Some of my sql
> statements against this partition table is in waiting state for long time. I
> have queried waiting=true in pg_stat_activity. Now, is there a way to find
> out which sql is making other statements to wait.

http://wiki.postgresql.org/wiki/Lock_Monitoring

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: postgresql statements are waiting
Next
From: Maciek Sakrejda
Date:
Subject: Re: Simple database, multiple instances?