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

postgresql statements are waiting

From: bakkiya <bakkiya(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: postgresql statements are waiting
Date: 2010-11-30 11:38:00
Message-ID: 1291117080292-3285939.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-performance
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.

Thanks for your help.
-- 
View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-statements-are-waiting-tp3285939p3285939.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

Responses

pgsql-performance by date

Next:From: pasman pasmaƄskiDate: 2010-11-30 11:43:05
Subject: tidscan not work ? Pg 8.4.5 + WinXP
Previous:From: Robert HaasDate: 2010-11-30 00:21:59
Subject: Re: MVCC performance issue

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