Thread: Postgres exporter v0.140 Connection Leak Issue

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!

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!

Is this the project, or some other postgres exporter?

https://github.com/prometheus-community/postgres_exporter

On Mon, Dec 30, 2024 at 1:04 PM kamal deen <kamaldeendba@gmail.com> wrote:

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!