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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message pasman pasmański 2010-11-30 11:43:05 tidscan not work ? Pg 8.4.5 + WinXP
Previous Message Robert Haas 2010-11-30 00:21:59 Re: MVCC performance issue