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 1tSK4P-00FgRe-Cq for pgsql-admin@arkaria.postgresql.org; Mon, 30 Dec 2024 18:00:49 +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 1tSK4O-00Dmft-PL for pgsql-admin@arkaria.postgresql.org; Mon, 30 Dec 2024 18:00:48 +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 1tSK4O-00Dmfl-9O for pgsql-admin@lists.postgresql.org; Mon, 30 Dec 2024 18:00:48 +0000 Received: from mail-oa1-x2a.google.com ([2001:4860:4864:20::2a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tSK4M-001Hkq-2K for pgsql-admin@postgresql.org; Mon, 30 Dec 2024 18:00:47 +0000 Received: by mail-oa1-x2a.google.com with SMTP id 586e51a60fabf-29e70c9dc72so4757629fac.0 for ; Mon, 30 Dec 2024 10:00:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1735581646; x=1736186446; 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=/aZiygas3XquO2FfQ3XOJlOmszMjO4XCulaYyNpFAMU=; b=bNHf2QvX0UIfMODyRE80tRhq1LwHLrmTEel7S/xDvvazNl//3ZRWJvFWDl9F/OW2Vh meXxsPbEJ9r+tklYKvUASq08aWlcgIxZVMzc8bcBiFcCSgGeMejglZohXZ+7QZ3eEtAW hVlIXQ0QeOwH532CUAicEupkb3sjgwHuJwqAkEimxlRgkK1tWFUT68L7oHpSbiuOZWZr UqJ3M/rvCRET9CfL8yuVuvwnaHR9L9W5jzbGagsPuu6kiS8F+3hIO/TJt7rNbu1AiziP CeioqFOltlVuGpbFWRoUKjCOxi0gdwbwaL67DOMhJuTdw983o2t/Tx8PwkFt0gJE6Ws1 IaEQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1735581646; x=1736186446; 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=/aZiygas3XquO2FfQ3XOJlOmszMjO4XCulaYyNpFAMU=; b=nr6Cq0vk8JDoSGd0NANbVEwLcEHVkFiORWzY3anzUs/2g0wraOclt0xiAgrn+vfMhy VwkRRM2RQ4Akitrgz18JB+d/iFi0nDQ9l5wO6PEDK4rD3FNtP8nbnIC85oxNXpCW4YLk zlbfoHgpquCsv8SS/3gcC4nQ6B5P5KBRP8TS0lASNabsG9rR9MyMYumX/Qu1J51kq6tL jz+Rz+tYlZncA1KSt8Qkwg1/8Pxcuoq5cK+J1uZZKcmNwIIemkc5XlCHq/EDlZt+wS5T jSSakd9NG3DcES9PwvuoZg+lbCTg/EZ2X3rFuZngORePJHMZCW0yFtJgu13b/v9y2VJZ SSXg== X-Gm-Message-State: AOJu0YwVH1c4VFuIRWKJtbVpkYK28irkfIXU+P/Zd/g2XsxLwPL+HtAP CdZC3hdYKTEzOauK2AgmC2OySq6F4fzd3Dbx1mJnnvZz43VCy74lCLrMgrn3HnyRUqUOgTv1q2p nJu3FUCLAcz4Epehkpf6lxwJ9ejLHYg== X-Gm-Gg: ASbGncv47rYgVGKpxLJeR2IpBb7YnfQVAVB6aTV4V45vN1G7ZH19B6JEcN82ELxs3mf mkNarW5m16TZzBhw9P51hObYGvuHgM1eMqU0LQuk= X-Google-Smtp-Source: AGHT+IGJFKOWE8cwgsnezezR8qzgGt3DWQJ9Um7zGOlidXoIF2S2hQf2SwMda7LUZj+oVMggpI8fZs/IFfzOngfYPSk= X-Received: by 2002:a05:6870:2c88:b0:29e:255e:9540 with SMTP id 586e51a60fabf-2a7fb3b1577mr21200303fac.35.1735581644505; Mon, 30 Dec 2024 10:00:44 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Mon, 30 Dec 2024 13:00:33 -0500 Message-ID: Subject: Re: Postgres exporter v0.14.0 Connection Leak Issue To: pgsql-admin Content-Type: multipart/alternative; boundary="00000000000066549b062a80973d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000066549b062a80973d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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! >> > --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --00000000000066549b062a80973d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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 lon= g as you've been running Postgres Exporter 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 connections , 160 idle connections consumed by postgres exporter su= ddenly during non peak hours. There's is no specific time pattern.

Please let me know if need a= ny other details.

SK


On Mon, Dec 30, 2024, 11:14=E2=80=AFPM Ron Johnson = <ronljohnso= njr@gmail.com> wrote:
On Mon, Dec 30, 2024 at 11:5= 3=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 postg= res exporters.=C2=A0

We = have fixed this=C2=A0 post restarted the postgres exporter services.
<= div dir=3D"auto">
Kindly share if we have any bu= g 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!
--00000000000066549b062a80973d--