Skip site navigation (1) Skip section navigation (2)

Re: postgresql statements are waiting

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "bakkiya" <bakkiya(at)gmail(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: postgresql statements are waiting
Date: 2010-11-30 16:52:53
Message-ID: 4CF4D7850200002500037F87@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
bakkiya <bakkiya(at)gmail(dot)com> wrote:
 
> 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.
 
You probably need to take a look at pg_locks for details.  If you
combine information from pg_locks, pg_stat_activity, and pg_class,
you can get a pretty good idea what's up.
 
-Kevin

In response to

pgsql-performance by date

Next:From: Scott MarloweDate: 2010-11-30 16:54:48
Subject: Re: postgresql statements are waiting
Previous:From: Tom LaneDate: 2010-11-30 16:49:55
Subject: Re: tidscan not work ? Pg 8.4.5 + WinXP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group