Re: RDS postgresql 17 function monitoring

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Brajendra Pratap Singh <singh(dot)bpratap766(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: RDS postgresql 17 function monitoring
Date: 2026-10-19 21:32:58
Message-ID: 25a81bd69ccecc2d7e694ac652b191a63941e471.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2026-10-16 at 23:09 +0530, Brajendra Pratap Singh wrote:
> We need to monitor a function which is running since long to understand at which
> step it is currently running and taking long time to debug the function.

I usually use auto_explain for that, with auto_explain.log_nested_statements set
to "on" and a sufficiently low auto_explain.log_min_duration.

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message 2026-10-20 13:12:03 AW: AW: Extract text from XML, pay attention to XML Entities
Previous Message Adrian Klaver 2026-10-19 16:56:04 Re: RDS postgresql 17 function monitoring