Re: Discard All in pgbouncer

Поиск
Список
Период
Сортировка
От Samed YILDIRIM
Тема Re: Discard All in pgbouncer
Дата
Msg-id CAAo1mbkLHPZYr7AGthoSg3pFf14LLNbEbZdCJUUoVxm6Bd1jjg@mail.gmail.com
обсуждение исходный текст
Ответ на Discard All in pgbouncer  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Ответы Re: Discard All in pgbouncer  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Список pgsql-admin
Hi Rajesh,

DISCARD ALL is the query that is executed by PgBouncer in order to sanitise a database session before assigning it to another client. If you see this query in pg_stat_activity and status of the session is idle, most probably it is ok. Probably what you see is the last executed query for the session. And the session is idle and waiting to be assigned to a client. :)

Best regards.
Samed YILDIRIM

On Mon, 9 Oct 2023, 17:07 Rajesh Kumar, <rajeshkumar.dba09@gmail.com> wrote:
Hi,

I could see queries like DISCARD ALL is idle for more than 5minutes (we are using pgbouncer).

Why is it idle for more than 5mns? I read about pgbouncer and could not understand this thing. If resetting a connection using query becomes one idle connection, I don't understand the pooling system here 

Plz help

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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: Discard All in pgbouncer
Следующее
От: Ron
Дата:
Сообщение: Re: Discard All in pgbouncer