Re: Finding execution plan

2023-11-08 Thread shashidhar Reddy
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, wrote: > On Fri, Nov 3, 2023 at 10:44:12AM -0700, Adrian Klaver wrote: > > > > On 11/3/23

Re: Finding execution plan

2023-11-03 Thread shashidhar Reddy
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, wrote: > > On 11/3/23 10:44 AM, Adrian Klaver wrote: > > > On 11/3/23 10:40 AM, shashidhar Reddy wrote: > > Hello All, > >

Re: Finding execution plan

2023-11-03 Thread Adrian Klaver
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

Re: Finding execution plan

2023-11-03 Thread Bruce Momjian
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 >

Re: Finding execution plan

2023-11-03 Thread Adrian Klaver
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 t

Re: Finding execution plan

2023-11-03 Thread Adrian Klaver
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 th

Finding execution plan

2023-11-03 Thread shashidhar Reddy
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