Re: Postgres exporter v0.14.0 Connection Leak Issue - Mailing list pgsql-admin

From kamal deen
Subject Re: Postgres exporter v0.14.0 Connection Leak Issue
Date
Msg-id CAAGAcEdSHD5-mYpZrmwWGuPtLy3mkyYF-aiyvGdsKEP3abaN4w@mail.gmail.com
Whole thread Raw
In response to Re: Postgres exporter v0.14.0 Connection Leak Issue  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Postgres exporter v0.14.0 Connection Leak Issue
List pgsql-admin

We have seen sudden spikes in the number of idle connections after installed Postgres Exporter v0.14.0.


On Mon, Dec 30, 2024, 11:30 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
Have these spikes suddenly started happening, after months/years of not having lots of idle connections?
OR
Have you seen sudden spikes in the number of idle connections for as long as you've been running Postgres Exporter v0.14.0?

On Mon, Dec 30, 2024 at 12:56 PM kamal deen <kamaldeendba@gmail.com> wrote:
Hi John,

Example.


Out of 200 max connections , 160 idle connections consumed by postgres exporter suddenly during non peak hours. There's is no specific time pattern.

Please let me know if need any other details.

SK


On Mon, Dec 30, 2024, 11:14 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Mon, Dec 30, 2024 at 11:53 AM kamal deen <kamaldeendba@gmail.com> wrote:
Hi All,

We have observed sudden connection spikes in some of our prod instances

Define "sudden".
 
due to idle session which was created by postgres exporters. 

We have fixed this  post restarted the postgres exporter services.

Kindly share if we have any bug fixes for the same.


Thanks in advance.

SK



--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!


--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Postgres exporter v0.14.0 Connection Leak Issue
Next
From: Ron Johnson
Date:
Subject: Re: Postgres exporter v0.14.0 Connection Leak Issue