Rajesh Kumar Mallah <mallah.rajesh@xxxxxxxxx> wrote: > its now non business hours and > SELECT procpid,current_query from pg_stat_activity where > current_query not ilike '%idle%' ; > is just 5-10, i am yet to measure it during business hours. Be careful about '<IDLE> in transaction' status. Those are a problem if the transaction remains active for very long, because vacuum (autovacuum or otherwise) can't free space for dead rows which could still be visible to the '<IDLE> in transaction' connection. It's normal to see this status briefly between statements in a transaction, but it's a problem if a connection just sits there in this status. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
