Re: Enquiry about long-running queries

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ashish Mukherjee <ashish(dot)mukherjee(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Enquiry about long-running queries
Date: 2025-11-07 15:48:18
Message-ID: 247d1944-abba-4365-ae57-5d5f9354353d@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/7/25 05:48, Ashish Mukherjee wrote:
> Hello,
>
> I have a query like this showing up on my production database -

> The query when run from psql prompt finishes in a jiffy, so query

What client is the stuck query being run from?

>
> Regards,
> Ashish

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2025-11-08 03:25:41 Re: Enquiry about TDE with PgSQL
Previous Message Laurenz Albe 2025-11-07 15:29:25 Re: Enquiry about long-running queries