Finding execution plan

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

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

On Fri, Nov 3, 2023 at 10:44:12AM -0700, 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:

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

Since he asked about execution plans, I was thinking auto_explain:

https://www.postgresql.org/docs/current/auto-explain.html

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.

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@aklaver.com>
wrote:

On 11/3/23 10:54 AM, Bruce Momjian wrote:

On Fri, Nov 3, 2023 at 10:44:12AM -0700, 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:

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

Since he asked about execution plans, I was thinking auto_explain:

https://www.postgresql.org/docs/current/auto-explain.html

Yeah, that would be the better option.

Hello Bruce,

I do not see parameters starting with auto_explain. in configuration file
and also do I need to enable logging collector. Please guide me on this.

On Fri, 3 Nov, 2023, 11:24 pm Bruce Momjian, <bruce@momjian.us> wrote: