Locks analyze

From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Locks analyze
Date: 2023-10-12 23:46:04
Message-ID: CAJk5AtaHsNNp-R3zmeeZ9G06LH_yHXEdCN7TpeR2HTO4Tde7Hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Zhaoxun Yan 2023-10-13 01:41:48 Re: Fwd: Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'?
Previous Message Ron 2023-10-12 13:29:16 Re: Fwd: Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'?