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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance