Re: Locks analyze

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Locks analyze
Date: 2023-10-13 02:21:34
Message-ID: ED834456-7DAF-4A33-B9B3-E86BEF67D9BE@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Oct 12, 2023, at 5:46 PM, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> wrote:
>
> How do I analyze locks and resolve it. Is there only one query that helps? This lock issue leading to high connections it seems.

What lock issue? What do you mean leading to high connections?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-10-13 06:02:57 Re: Locks analyze
Previous Message Tom Lane 2023-10-13 02:03:58 Re: Fwd: Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'?