> > >> 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.