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 1tSK7b-00Fgoa-Kw for pgsql-admin@arkaria.postgresql.org; Mon, 30 Dec 2024 18:04:08 +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 1tSK7a-00DqbR-R4 for pgsql-admin@arkaria.postgresql.org; Mon, 30 Dec 2024 18:04:06 +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 1tSK7a-00DqbJ-Ds for pgsql-admin@lists.postgresql.org; Mon, 30 Dec 2024 18:04:06 +0000 Received: from mail-pl1-x62a.google.com ([2607:f8b0:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tSK7X-002Njz-Jo for pgsql-admin@postgresql.org; Mon, 30 Dec 2024 18:04:05 +0000 Received: by mail-pl1-x62a.google.com with SMTP id d9443c01a7336-21a1e6fd923so68118525ad.1 for ; Mon, 30 Dec 2024 10:04:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1735581842; x=1736186642; 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=HDehazE2epbxdLHwRMOYLMf0/+mYHL5iaXTr8RZn/sg=; b=ID0NBnXJbKeAprfLJUUv1F5V3UcV/PyVwh2HoKtKH3qDMHkYmPo8e5HgnyAx5rgGlU r927JotAcmkHacOM7354INH5Kw/jAHDRM75ZTZk5/TaOle0/09475QYA2YwpkaBvZOAz FkgrTXozncnpBdLVhSDr2iwbXR731VIZaKHAc+NchAMR8jixdQewh5HhzOQbod/BiWpt hT2oApXXhmPNfbPYfobqya2NvQSGqGLNA0PZ0uP1CXiyN/NqoHxpoAKUxIvh61sFzjl3 QhTemRj3q+oKswdXb+/ZjB45Ep/7DvwMsEggqSEJ/efLOeKObkdB3dUj3344MQaX/jHt AZfg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1735581842; x=1736186642; 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=HDehazE2epbxdLHwRMOYLMf0/+mYHL5iaXTr8RZn/sg=; b=jcdh6tLufb7CQqbhmdRzN/HptVrwqS0PCS+yDcvfpZ3B3c2vnkaSHtf/kSB6ZTVI1G d56AyFx8jrGns9AhH+lN29b58TeZi2soBp3wLKtXhLlRhfLN0kRvQ1gkoJDZHxLHL96p gakklMOfgqIwn/qLYg78B9BrYbFrMitryxXATcBEA9TExIDI+67JizqlbzN33PSwiu1S lTpNBEwBe5KjLpQKDMZifFtuiJnzhlFFjIPHNi5dWI7gZ1yIbLqPRmuO4q8ebHhaZRZF 37qasCvSjHT07iGg5GA64F5+RUwpnx1+gCfOrL8B9t4CWDGaDcjmvwiAUGx2wkL8/i3c TFuA== X-Gm-Message-State: AOJu0YzdrUVMsICothyLb7FoB0EVT089MCSd/4FEwHUTmHCHP6bnEytG TMcSr6S0g7QbGJsHi9v0U75+7ZbRR10LSGOxYzhUXWbWvOP9RiwsmeQau/Jf6BPFophdnFNLb2G 0ygGDYUR6LWIOl1Ioo+LMT9w05kE= X-Gm-Gg: ASbGncvUwF5abHP7mtOuqiB3f3fmYXkckTueRD0MiiHfGZaAwWFM/TqUIMnnmSANZSN TdsNkMj9n8KXpJkNJlMw8HhbqNHGeghrC8pW8jsgUhRUHDU+NxkLpFmSS9AFqjgTuTq3tsoCM X-Google-Smtp-Source: AGHT+IHNjS56+gT0rXIH0i9evLr8nIiPCeemkfuoAoaTouBV/iKolcLYIPyVoNlqnmXcjzGebRRfPAb5PlW94l7B6fE= X-Received: by 2002:a17:90b:2dc1:b0:2ea:8d1e:a85f with SMTP id 98e67ed59e1d1-2f452e4963bmr57826475a91.17.1735581841645; Mon, 30 Dec 2024 10:04:01 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: kamal deen Date: Mon, 30 Dec 2024 23:33:50 +0530 Message-ID: Subject: Re: Postgres exporter v0.14.0 Connection Leak Issue To: Ron Johnson Cc: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000266840062a80a37c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000266840062a80a37c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 instance= s >>>> >>> >>> 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! >>> >> > > -- > Death to , and butter sauce. > Don't boil me, I'm still alive. > lobster! > --000000000000266840062a80a37c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

We have seen=C2=A0sud= den spikes=C2=A0in the number of idle connections after installed Postg= res Exporter v0.14.0.

On Mon, Dec 30, 2024, 11:30=E2=80=AFPM Ron Johns= on <ronljohnsonjr@gmail.com> wrote:

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

Example.


Out of 200 ma= x 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 oth= er 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 <kamaldeendba@gmail.= com> wrote:
Hi All,

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

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

<= div dir=3D"auto">We have fixed this=C2=A0 post restarted the postgres expor= ter services.

Kindly sha= re 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> lobs= ter!


--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--000000000000266840062a80a37c--