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 1qrHzl-003Xdf-Gk for pgsql-admin@arkaria.postgresql.org; Fri, 13 Oct 2023 13:14:25 +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 1qrHzj-000dTt-96 for pgsql-admin@arkaria.postgresql.org; Fri, 13 Oct 2023 13:14:23 +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 1qrHzi-000dTT-Os for pgsql-admin@lists.postgresql.org; Fri, 13 Oct 2023 13:14:23 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qrHzg-000INq-UP for pgsql-admin@lists.postgresql.org; Fri, 13 Oct 2023 13:14:22 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 3ABF7E3B54; Fri, 13 Oct 2023 13:14:19 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1697202859; bh=XpDVFfAoPxKoAPTWbhWcXFKxftGk6PDq2Oi8zoS6/E8=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=j8w34cNW3SlYRFdDzeq2ORC59yHkDYqCkWi5uxqOG1UyDLMtCBd2Y/1YIgX7AYYQp yQgka87mhdAgJ0QYLo4d7a2MWDQYabqzG+qYF5eHM0/f3g69WuN+isSf1aASYn5746 VJeqOLOCTqTdkwUfI3q2KAhfoqjgRdr0BzBLO7UhIMTJkyk1cW+NZXI/A1Kr0ectLE tNlt5WqavjdtsKsQ2dwWL567A5BH+7xYRMDVVCd/STlN96PhsxqqCaNNCzZo12w4QP xscXj45XGPSSMKefYLUSdaefgf5TO5EpnYwK34PgDR4TlELVTdQbW90q0N+s6CgsMF 99HXg4xxViupg== X-Virus-Scanned: Debian amavisd-new at emo08-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo08-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id jp1rsSh6ZTpS; Fri, 13 Oct 2023 13:14:18 +0000 (UTC) Received: from smtpclient.apple (unknown [165.140.184.195]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 9AD25E3B53; Fri, 13 Oct 2023 13:14:18 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1697202858; bh=XpDVFfAoPxKoAPTWbhWcXFKxftGk6PDq2Oi8zoS6/E8=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=fuQrSfrvWusj9UfoU6MCwcvKc4DJyi1Gy90PmiGJktJB0ccfc8rF+Gx0r5eC0UOvz 7IZHCCwvsbUBdz3+SVXpHbpk1D73gi0PiRpunqvRF/ZLer87T0VIOARYLz3ZDXnLnJ 1rY7fm2k2ZceAbhpq33bY/QSOlClKA6YbExYCjcVSm2x70cprobUUCXVKkdzwk0Q4k xUK0s0y23oW/i2Zzzfw2G5Qu9ixN8ySyk/5FInHQMEyb7q29HfCsRPQePAnlgUWZTW FEqCgB5htqVowIWmog0W154o78/jUg+rdRV7abaNB5nfSdxqm4bv9Bat2wruAlu44I EWg9G6t0NANRw== Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.100.2.1.4\)) Subject: Re: Locks analyze From: Scott Ribe In-Reply-To: Date: Fri, 13 Oct 2023 07:14:07 -0600 Cc: Laurenz Albe , Pgsql-admin Content-Transfer-Encoding: quoted-printable Message-Id: References: <91d371667a3e27cb0da7001d048d1c417074b6ef.camel@cybertec.at> To: Rajesh Kumar X-Mailer: Apple Mail (2.3774.100.2.1.4) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Oct 13, 2023, at 3:39=E2=80=AFAM, Rajesh Kumar = wrote: >=20 > I am often facing idle connection spike. That is why I am checking all = these. Do total sessions increase along with idle sessions? Or does the total = remain the same, but more are idle?=