On 11/3/23 10:44 AM, Adrian Klaver wrote:
>
>
> On 11/3/23 10:40 AM, shashidhar Reddy wrote:
>> Hello All,
>>
>> I have a Postgresql function scheduled to run on the database, some
>> tines it is taking too long than usual time, is it possible to get
>> the execution plan of this function or any other way to troubleshoot
>
>
> You might to take a look at the contrib module:
>
^want
>
>
> https://www.postgresql.org/docs/current/pgstatstatements.html
>
>
> "The |pg_stat_statements| module provides a means for tracking
> planning and execution statistics of all SQL statements executed by a
> server."
>