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 1tSK0F-00FfsU-Ov for pgsql-admin@arkaria.postgresql.org; Mon, 30 Dec 2024 17:56:32 +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 1tSK0E-00DiNC-35 for pgsql-admin@arkaria.postgresql.org; Mon, 30 Dec 2024 17:56:29 +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 1tSK0D-00DiN3-Nn for pgsql-admin@lists.postgresql.org; Mon, 30 Dec 2024 17:56:29 +0000 Received: from mail-pj1-x1031.google.com ([2607:f8b0:4864:20::1031]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tSK0B-002NYi-1Y for pgsql-admin@postgresql.org; Mon, 30 Dec 2024 17:56:28 +0000 Received: by mail-pj1-x1031.google.com with SMTP id 98e67ed59e1d1-2f4409fc8fdso10485739a91.1 for ; Mon, 30 Dec 2024 09:56:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1735581385; x=1736186185; 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=eeWpY5ldkj+3o2rL5XQuxBnlnfzxSXgQiYYyB4oitfI=; b=M22TzNYE2fDFAD5ptqW4+pi+ibNJUlYMKS5zhO0/dWTjNMvlcwFtubs2II7Q4H3amw VABF4eSkxEtPDR99kTzlBIJOtf8fftdSQ1vqTaeyufilggLQc+O06CCVVVOK+HkhxNa+ o0A0c3xsZNGRwrvceExG5t2QObtp9KMBE5FPUPHZschorejf8rj0bsja62Wddk/Xu+b7 V7FA+s2cj1X0PxF0ZgPRE4ilSrU0yDhUmH3XIVPdZIRq1yTueOOQ2L3tE8k42parMmHl PYzHfc5vZ8R992yE1qk08w1XXZ36zRmA4n7O81S6TRKXTSqBPYL6PWpUZn/adyLYirgc Wa0g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1735581385; x=1736186185; 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=eeWpY5ldkj+3o2rL5XQuxBnlnfzxSXgQiYYyB4oitfI=; b=wBLhi3OOIKniuz1kkhhtxiuqpg0y+6FyOZ7qRPwaj9jdyfFxlO8o70X+bZmrVwh1+E qSmTV3lLp4Y7TZvOtaMkxB8U+lVbd8+mNutdYiTbfHofy2SLnfrUpmvEimIdeuTnQoas Nzl+lXP0LMmJ5an6vucvqh7jJ5iGWJ8PnUUS4ld7dTcV6MMMY6yG/TnBdrmNdAR6bIZa w/GdeyYEa/SVIwDX5y5MpTLixgIBdayOTsOFaWT9VEwPI7IEYriRtbtcvWboq3NF2OYn cTdLrjj7jsbhDUfmKvXRQvFh6TKAfUJnhtxRQcWSBdhbjXPU8eBCBTDB6zZMhrUFMWP9 avEw== X-Gm-Message-State: AOJu0YyvU0uBLkWagI1yA1TxuMjgAQWLZYFXah9dNqtIcceyepyPfVjX lvqODVNjW5XXmNnNPEdBaK/qf5Jmojg6lrnXpuhwSFHyrnakBVxfbsMFHUtQUdHw3PsDdfXLGFP jeGu+VMyBXM5LxvFo/k9GSIiYIuo= X-Gm-Gg: ASbGnctLoDyA2iGBXEu93wi8IrN0RKi3y0Pi0OL7H1jxmP8BSKIfaN8k2UUli+XkCVi 6Lm0asoa2HbZAzuNUHFlCbGVD07uNlwsJgBFqJdbXaIELWtWiYA1iN5zWiPqMWZRGpFuu3c9D X-Google-Smtp-Source: AGHT+IEacOKvLdppO5z8trvAr6waeZcMbar2mZieI16jHKzYff6oRazxT4KcP0RsPNWrVZJWlFMKZvkgvHtWf1afv6w= X-Received: by 2002:a17:90b:3a43:b0:2ee:94a0:255c with SMTP id 98e67ed59e1d1-2f4536d25fcmr55522554a91.13.1735581385177; Mon, 30 Dec 2024 09:56:25 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: kamal deen Date: Mon, 30 Dec 2024 23:26:14 +0530 Message-ID: Subject: Re: Postgres exporter v0.14.0 Connection Leak Issue To: Ron Johnson Cc: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000f1435c062a808710" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f1435c062a808710 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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! > --000000000000f1435c062a808710 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi John,

Example.


Out of 200 max connections , 160 idle connections consumed b= y postgres exporter suddenly during non peak hours. There's is no speci= fic 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 <kamaldeendba@gmail.com> wrote= :
Hi All,

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

Define "sudden".<= /div>
=C2=A0
due to idle session which was created by = postgres exporters.=C2=A0

We have fixed this=C2=A0 post restarted the postgres exporter services.

Kindly share if we have a= ny 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!
--000000000000f1435c062a808710--