Search Postgresql Archives

Re: Finding execution plan

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux