Re: Postgres exporter v0.14.0 Connection Leak Issue

From: kamal deen <kamaldeendba(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgres exporter v0.14.0 Connection Leak Issue
Date: 2024-12-30 18:03:50
Message-ID: CAAGAcEdSHD5-mYpZrmwWGuPtLy3mkyYF-aiyvGdsKEP3abaN4w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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(at)gmail(dot)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(at)gmail(dot)com>
>> wrote:
>>
>>> On Mon, Dec 30, 2024 at 11:53 AM kamal deen <kamaldeendba(at)gmail(dot)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!
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-12-30 18:14:22 Re: Postgres exporter v0.14.0 Connection Leak Issue
Previous Message Ron Johnson 2024-12-30 18:00:33 Re: Postgres exporter v0.14.0 Connection Leak Issue