Re: Question regarding DEALLOCATE pdo_stmt_00000001

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: Question regarding DEALLOCATE pdo_stmt_00000001
Дата
Msg-id CAKFQuwbppXha_Qr8qP88-vtLLf9Ts6gMWjg=aURbN+jcmfSZ1g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question regarding DEALLOCATE pdo_stmt_00000001  (Laurentius Purba <lpurba@sproutloud.com>)
Список pgsql-general

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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Need help on triggers - postgres 9.1.2
Следующее
От: Khangelani Gama
Дата:
Сообщение: Re: Need help on triggers - postgres 9.1.2