Re: Discard All in pgbouncer - Mailing list pgsql-admin

From Ron
Subject Re: Discard All in pgbouncer
Date
Msg-id d7af179d-714f-ebe2-ddb7-19a1dffdd7b4@gmail.com
Whole thread Raw
In response to Discard All in pgbouncer  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Responses Re: Discard All in pgbouncer
List pgsql-admin
On 10/9/23 09:07, Rajesh Kumar 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

In your case, "Idle" just means that DISCARD ALL was the last statement that the pid executed.  Now, it's just doing nothing, because there's nothing to do.  IOW, this is just fine.  No need to worry.

--
Born in Arizona, moved to Babylonia.

pgsql-admin by date:

Previous
From: Samed YILDIRIM
Date:
Subject: Re: Discard All in pgbouncer
Next
From: Rajesh Kumar
Date:
Subject: Re: Discard All in pgbouncer