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