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:
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."