On Tue, Nov 30, 2010 at 4:38 AM, bakkiya <bakkiya@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
