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: ^wanthttps://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."
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:
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."
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."
pg_stat_statements
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
