Re: postgresql statements are waiting

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: bakkiya <bakkiya(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql statements are waiting
Date: 2010-11-30 16:54:48
Message-ID: AANLkTi=U48HBU4j-5UF_ZeyxtzZg4ARb874cPo3qnBe1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Nov 30, 2010 at 4:38 AM, bakkiya <bakkiya(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Maciek Sakrejda 2010-11-30 17:16:26 Re: Simple database, multiple instances?
Previous Message Kevin Grittner 2010-11-30 16:52:53 Re: postgresql statements are waiting