Thread: postgresql statements are waiting
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.
bakkiya <bakkiya@gmail.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
On Tue, Nov 30, 2010 at 4:38 AM, bakkiya <bakkiya@gmail.com> wrote: > > 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. http://wiki.postgresql.org/wiki/Lock_Monitoring