postgresql statements are waiting - Mailing list pgsql-performance

From bakkiya
Subject postgresql statements are waiting
Date
Msg-id 1291117080292-3285939.post@n5.nabble.com
Whole thread Raw
Responses Re: postgresql statements are waiting
Re: postgresql statements are waiting
List 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.

pgsql-performance by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: Simple database, multiple instances?
Next
From: Mladen Gogala
Date:
Subject: Re: SELECT INTO large FKyed table is slow