Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tSKwT-00FmjA-VO for pgsql-admin@arkaria.postgresql.org; Mon, 30 Dec 2024 18:56:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tSKwR-00E8yN-B4 for pgsql-admin@arkaria.postgresql.org; Mon, 30 Dec 2024 18:56:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tSKwQ-00E8yE-QQ for pgsql-admin@lists.postgresql.org; Mon, 30 Dec 2024 18:56:38 +0000 Received: from mail-pj1-x102f.google.com ([2607:f8b0:4864:20::102f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tSKwO-001ICX-36 for pgsql-admin@postgresql.org; Mon, 30 Dec 2024 18:56:37 +0000 Received: by mail-pj1-x102f.google.com with SMTP id 98e67ed59e1d1-2ee67e9287fso12551739a91.0 for ; Mon, 30 Dec 2024 10:56:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1735584996; x=1736189796; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=XKt2pyf2DTIAR31KTqjQeV/aEpvcUjMSCwCM3H5mGsw=; b=UUoA74W0SPReuburTfeeIHDqoV3gGtjlqHa2oFaO3bC1dSRFQhQCoooMD8/vJVKcyY YluzFAiHzTTTuRWqOGkPvLSyIOXwcJXkIuoXqes1tEdBgM3R+CU5hxEAhK05V6mxE0AC /Lm/Oxuh30RRMHOXJgNxOjdopDSmwZP0iN4XddwCRxhIMZJdnfzuQjjxGD2GBI1SaXCm dfSjW2qW52obPdofJKSXjt0vNVZjIp6T3kKAamWKll1aS4PGjoBJhSSEDa2Jtq/gOwrT h4xa86udK2boMs8F7G4sQhGa1C78Z1+/l7zMYVdSINB1RMDN9dpF+GnwFLJRbYg467BE Sv9A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1735584996; x=1736189796; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=XKt2pyf2DTIAR31KTqjQeV/aEpvcUjMSCwCM3H5mGsw=; b=FgbIr2KyRtRh6NbqwjIsxa2nRCgILvUOrMovvbR4VBYcdexRcIxUO0o+7EAuT+mPJp 5QXV4FKEVP3b7py0AZewEdgFkME9JVr1+z2qJ2gz/h0aBJxgh7hIFKSFGJghFqM8XuAj Tz5vbP0t8ssheWZYKeEF22zggzNEbELConMLV6LnmWO2RYLlgei3qZUsMzXUdUnUySwd KL2iU1WDDcCRDTKN/RB2tl6zMiHEI8GPA6Vl7b1VVg+5ZMuBtkIuzWd/X1HaIMMg6AoE EWzsK3fLJSqFoImcfvgrR7gMhO3c1zKrE66LAOnITQrdQh8BCxwjij7QivBQH6XgFvDn hjgg== X-Gm-Message-State: AOJu0YzFwukFKn4Voem6P0XFDqoUkMInAidDETEtVkHvO/Pi3v1OOQ5f /vdjjKuaro9YxoG69y2pIiFf+0ZEzQyu5rmulUDQR9bBsgBRccNLqdGoG+NalNePCiB7/FbWZ89 Ves8DMqld8rXhMHRATivklMeOGSE= X-Gm-Gg: ASbGncu6ivGW/1B72F6ckWeN7OErMJqTsDupNlKx+SN3AXU7OqGe0maXsqZCHYiD+cY CwW/0WJc+yJg0YKfya9AhQZdL4PB+NUwMbd/1PM5s/ZteUBCMut2wvJmfvLd6RCZ7KV4ntge2 X-Google-Smtp-Source: AGHT+IFn6Q+wH2iDWp+e0GqB43mmFOZmYEzKtrB8dCK8Xt668fpCc8q6O8ZdqsoXdmmQtEhvAdbRkJpbXvyYq7KMm1M= X-Received: by 2002:a17:90a:e18b:b0:2ee:9902:18b4 with SMTP id 98e67ed59e1d1-2f452ee838bmr53593735a91.27.1735584996065; Mon, 30 Dec 2024 10:56:36 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: kamal deen Date: Tue, 31 Dec 2024 00:26:25 +0530 Message-ID: Subject: Re: Postgres exporter v0.14.0 Connection Leak Issue To: Ron Johnson Cc: pgsql-admin Content-Type: multipart/alternative; boundary="0000000000002b0c42062a815f09" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002b0c42062a815f09 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Yes , this is the one but we have installed v0.14.0 On Mon, Dec 30, 2024, 11:44=E2=80=AFPM Ron Johnson wrote: > Is this the project, or some other postgres exporter? > https://github.com/prometheus-community/postgres_exporter > > On Mon, Dec 30, 2024 at 1:04=E2=80=AFPM kamal deen 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=E2=80=AFPM Ron Johnson >> 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=E2=80=AFPM kamal deen >>> 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=E2=80=AFPM Ron Johnson >>>> wrote: >>>> >>>>> On Mon, Dec 30, 2024 at 11:53=E2=80=AFAM kamal deen >>>>> 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 , and butter sauce. > Don't boil me, I'm still alive. > lobster! > --0000000000002b0c42062a815f09 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Yes , this is the one but we have installed v0.14.0<= br>
On Mon, Dec 30, 2024, 11:44=E2=80=AFPM Ron Johnson <<= a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com> w= rote:
Is this the project, or some other postgres exporter?

On Mon, Dec 30, 2024 at 1:04=E2=80=AFPM kamal deen <kam= aldeendba@gmail.com> wrote:

We ha= ve seen=C2=A0sudden spikes=C2=A0in the number of idle connections af= ter installed Postgres Exporter v0.14.0.

<= div dir=3D"auto">
On Mon, Dec 30, 2024, 11:30=E2=80=AFPM Ron Johnson = <ronljohnsonjr@gmail.com> wrote:
Have these spikes sudd= enly started happening, after months/years of not having lots of idle c= onnections?
OR
Have you seen sudden spikes in the numb= er of idle connections for as long as you've been running Postgres Expo= rter v0.14.0?

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

Example.

=

Out of 200 max connecti= ons , 160 idle connections consumed by postgres exporter suddenly during no= n 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=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Mon, Dec 30= , 2024 at 11:53=E2=80=AFAM kamal deen <kamalde= endba@gmail.com> wrote:
Hi All,

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

= Define "sudden".
=C2=A0
due to idle se= ssion which was created by postgres exporters.=C2=A0

We have fixed this=C2=A0 post restarted the po= stgres 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!
--0000000000002b0c42062a815f09--