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.
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2010-11-30 16:54:48|
|Subject: Re: postgresql statements are waiting|
|Previous:||From: Tom Lane||Date: 2010-11-30 16:49:55|
|Subject: Re: tidscan not work ? Pg 8.4.5 + WinXP |