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 1qr5No-002TlS-E3 for pgsql-admin@arkaria.postgresql.org; Thu, 12 Oct 2023 23:46:24 +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 1qr5Nm-00C6aZ-9G for pgsql-admin@arkaria.postgresql.org; Thu, 12 Oct 2023 23:46:22 +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 1qr5Nl-00C6aK-UJ for pgsql-admin@lists.postgresql.org; Thu, 12 Oct 2023 23:46:22 +0000 Received: from mail-vk1-xa2c.google.com ([2607:f8b0:4864:20::a2c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qr5Ng-000Cin-Qo for pgsql-admin@lists.postgresql.org; Thu, 12 Oct 2023 23:46:21 +0000 Received: by mail-vk1-xa2c.google.com with SMTP id 71dfb90a1353d-4a40c8dd9b0so436549e0c.0 for ; Thu, 12 Oct 2023 16:46:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1697154376; x=1697759176; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=4LeGmb882LfpI1k/cCYOm8ETUDKeRZpTxdQ7OK+m5Jg=; b=jyj44kB+MxbxxqxdNXzgzVdNBGapBZcZJU2QpGi1Hi2U9IGgIZkEJi7iFBshXwzrFu T0JfceLIPCTuImYGTTRHARiU+YGfK9D6TpAJQZZdDsaSMjUNpOyz7lRqOx5I5ilBe75H uK4bqlKb2TcoVh+mpbUL/9z+iEEhMZCQr2cDgl6322KEgilqqb3TR6xjxKSXSROE0Jy9 rD9xYprUZDLr0tL70JJv7qqqfdu547jbwoJRIV5nTn5CENQUZ0kuSGEYfzwl7V3oz8bu AbsAB3K+usJyug31ZnfQW/DRW9ThB0PT3fEwKhGM9BEnTsgcVsOtBm62mPHFuE6UZ7xx V8pg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697154376; x=1697759176; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=4LeGmb882LfpI1k/cCYOm8ETUDKeRZpTxdQ7OK+m5Jg=; b=bbBqS5ZPHa/y8OqQLbYaOVaVweKTUhQUHi8M0JoV4m5F364EIqLGRfe10P70XZzE5S MHLuLFv8BGJDKdtFIyUl3Z9I4B4xTAPEB1ncpPiVdxMaxi8SzDLhzcjhnRXqL3AwSwFC j6oLQiIYgBTBePItkPR9XRX1fd1jzCdVn3wALJXYIAPuBuQjJlwpjrt4XhDUzcWE+t5B 7HI1d9CY8kZMJnwD+i2s3iO0VYDnDIHMJwjNMlTwk2iCQMfBWfDuXbIDW4cKmAcBSoIZ DCP8/7EixmgwP8ienrhBUllO5Q3vG+1b7v+Da497g/sxdeUxSGUq8AUPQhNZ7iwqJkJq +cOQ== X-Gm-Message-State: AOJu0YwUbUCbc5pnMFnlWwd4d5Z0z528AJ0hI3IbpZTw3cmoEYrS5iYG F5BLHUWcd/ab765KkGsspaQaCLYIYH4hH1U6TD9vzhpb X-Google-Smtp-Source: AGHT+IHuYJwBylhWuD3OqwCNw7ZTxOJxiNlpji41wzxx6UG0Nb0vhLLb/IwSRrry8ZnwgkppGIRpcSFQKsEtbMRz1R8= X-Received: by 2002:a1f:e641:0:b0:48f:8891:29d9 with SMTP id d62-20020a1fe641000000b0048f889129d9mr21722634vkh.13.1697154375513; Thu, 12 Oct 2023 16:46:15 -0700 (PDT) MIME-Version: 1.0 From: Rajesh Kumar Date: Fri, 13 Oct 2023 05:16:04 +0530 Message-ID: Subject: Locks analyze To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000ae7e6006078d8b76" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ae7e6006078d8b76 Content-Type: text/plain; charset="UTF-8" Hi team How do I analyze locks and resolve it. Is there only one query that helps? This lock issue leading to high connections it seems. --000000000000ae7e6006078d8b76 Content-Type: text/html; charset="UTF-8"
Hi team

How do I analyze locks and resolve it. Is there only one query that helps? This lock issue leading to high connections it seems.

--000000000000ae7e6006078d8b76--