9.3 - On an idle connection the value of query is the last executed query -
which in this case is some form session cleanup command before returning the
connection to the pool.So, it is a normal behavior in Postgres.One more thing that bothers me, why this idle connection can be stayed idle for 3 days. Is this a zombie process?
You said:
"I am using PostgreSQL 9.3.2 and PgBouncer."
It is PgBouncer that is keeping these connections open and available for immediate usage in its connection pool.
David J.
