Thank you Adrian fir the reply, I am looking for something like complete execution plan of the function just like EXPLAIN does.
On Fri, 3 Nov, 2023, 11:15 pm Adrian Klaver, <adrian.klaver@xxxxxxxxxxx> wrote:
On 11/3/23 10:44 AM, Adrian Klaver wrote:
^want
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_statementsmodule provides a means for tracking planning and execution statistics of all SQL statements executed by a server."
