Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> 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