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 1tSKHn-00Fhxn-It for pgsql-admin@arkaria.postgresql.org; Mon, 30 Dec 2024 18:14:40 +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 1tSKHm-00Dw55-I7 for pgsql-admin@arkaria.postgresql.org; Mon, 30 Dec 2024 18:14:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tSKHm-00Dw4x-4U for pgsql-admin@lists.postgresql.org; Mon, 30 Dec 2024 18:14:37 +0000 Received: from mail-oo1-xc33.google.com ([2607:f8b0:4864:20::c33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tSKHi-002Nnz-Px for pgsql-admin@postgresql.org; Mon, 30 Dec 2024 18:14:37 +0000 Received: by mail-oo1-xc33.google.com with SMTP id 006d021491bc7-5f31b3db5ecso4076611eaf.0 for ; Mon, 30 Dec 2024 10:14:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1735582473; x=1736187273; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=OGatuYiOjpQZ0pahC3DW4ewjRjaATzGkBFE8cpFwxBE=; b=eKaNQCNStMxdWxZLhLKobu8EYe4vUFIg9czW+9w2wnkZvkPJKAoEoGi849qCkcPzRW 3bHfyzI5yWzyZfrsoep8M2XTBbk4/TRX0S3ZRrspIzZ4vy0V0QVCv8nh7ECosSYHYOpN vyAWBySU8T+E5yD5mjdHkjUCmxYED4Oc6js8/VgV83goDbM9QU1G3YXgzzF2y63IYr8V nyD+JcAVhys7GPoxO+Q899QKZPVl28+4MgSXLddFOIhskP8FWCkDAfc5GXkA0p7ozYBs DNIrUCi/G7/VehybK1Kbi4AWC7oRZSsqFiQr+kZ5jnUL8ySMRTnWq3lqcHKJV8BXu/yr gbVg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1735582473; x=1736187273; h=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=OGatuYiOjpQZ0pahC3DW4ewjRjaATzGkBFE8cpFwxBE=; b=ukV2pVNNQvSjbDqVrP0gltSI5bQFy7DAxN9/tI2t0DwEnXfVT4CtBVii+OEMi4Q1lz RrYySk+KxIMgqXus8JRnfKV9o7MjGEuSawKl/qanE9YTNj3TTYyYz0tiundUgeQWcc1P 6YmNWAfW7/EavOdHcQZD2nIjBKLPgimnSiJwe8Zh9kwYLNFW8/SWgUw+EhVtl8QIhAd4 HSUXjiNNCFb28XkUNGUTQHwCcr/x/xET/CfNXMMVBRaa8iayt/KiDtFbpVSqpFfkHKU5 Po2O71XMoVw7B8VEh+11ncHWIO78qBr8FZ9xAooDtmbBOFcf1IpnJbN7vG3ZZReDHnlm wTWg== X-Gm-Message-State: AOJu0YyevUdLJfpBQc9SmKm1KGy3+py6aavfcdHwjb4YzaPthKzs/QGq 1RDYbtrvix23P7ShOczps3svs9kOixImPw+vM6L3xGMne7rt++0lyTPxVneFjhGa8ge0NVXC4XJ qIWgSQpTXyyUm3iO/pLet8zNluRk7lhVl X-Gm-Gg: ASbGnctWtzHwQed4TSFEvMjAv5Akj0ciNSPVYmhmjnKHvx0/ArK/LFPKpr47PJqEXzv yaegDhyEmKRC1tbaDH2jaIOEDw8WNpl7IF2UTTiqp0OcJEe0YsZJwvzWXc8ngQLjP0q4CKB6u X-Google-Smtp-Source: AGHT+IGxEKxXsDwzjLKTDR9WZNGkrvVW0Zmug23ODFYQpICezoqtSAio8s9T32EhWh6TONrc9w6IV1AbUrSpcAtPS7I= X-Received: by 2002:a05:6871:620f:b0:288:2906:6882 with SMTP id 586e51a60fabf-2a7fb4c1d83mr21236468fac.29.1735582472923; Mon, 30 Dec 2024 10:14:32 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Mon, 30 Dec 2024 13:14:22 -0500 Message-ID: Subject: Re: Postgres exporter v0.14.0 Connection Leak Issue To: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000c6f314062a80c897" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c6f314062a80c897 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 instanc= es >>>>> >>>> >>>> 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 >>>>> >>>>> --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000c6f314062a80c897 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Is this the project, or some other postgr= es exporter?
On Mon, Dec 30, 2024 at 1:04=E2=80=AFPM kamal dee= n <kamaldeendba@gmail.com&= gt; wrote:

We have seen=C2=A0sudden s= pikes=C2=A0in the number of idle connections after installed Postgres E= xporter v0.14.0.


= On Mon, Dec 30, 2024, 11:30=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.com> wr= ote:
Have these spikes suddenly started happening, after months/yea= rs of not having lots of idle connections?
OR
Have you seen <= b>sudden spikes in the number of idle connections for as long as you= 9;ve been running Postgres Exporter v0.14.0?

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

Example.


Out= of 200 max connections , 160 idle connections consumed by postgres exporte= r suddenly during non peak hours. There's is no specific time pattern.<= /div>

Please let me know if ne= ed any other details.

SK=


On Mon, Dec 30, 2024, 11:14=E2=80=AFPM Ron Jo= hnson <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!
--000000000000c6f314062a80c897--