Re: explain vs auto_explain

2024-10-19 Thread Vijaykumar Jain
On Sat, 19 Oct 2024 at 22:55, David G. Johnston wrote: > > With auto_explain you end up producing multiple individual explains, one > for each top-level query being executed. Each one produced by auto_explain > which hooks into the point where a top-level query begins execution. > Running explai

Re: explain vs auto_explain

2024-10-19 Thread Vijaykumar Jain
On Sat, 19 Oct 2024 at 23:48, Vijaykumar Jain < vijaykumarjain.git...@gmail.com> wrote: > > > ok, it makes sense for the reason of having auto_explain. but maybe i did > ask correctly, > why do we not have the extended flags in auto_explain , in , explain wrt > nested_statements, and triggers ...

Re: explain vs auto_explain

2024-10-19 Thread David G. Johnston
On Sat, Oct 19, 2024 at 10:43 AM Vijaykumar Jain < vijaykumarjain.git...@gmail.com> wrote: > i tried to check the code for auto_explain , there is nothing that helps > understand why it was provided as a separate . > Probably because output to log was easier than reworking the internals to make o

Re: explain vs auto_explain

2024-10-19 Thread Tom Lane
"David G. Johnston" writes: > On Sat, Oct 19, 2024 at 10:43 AM Vijaykumar Jain < > vijaykumarjain.git...@gmail.com> wrote: >> i tried to check the code for auto_explain , there is nothing that helps >> understand why it was provided as a separate . > Probably because output to log was easier than

Re: explain vs auto_explain

2024-10-19 Thread Vijaykumar Jain
On Sat, 19 Oct 2024 at 23:31, Tom Lane wrote: > "David G. Johnston" writes: > > On Sat, Oct 19, 2024 at 10:43 AM Vijaykumar Jain < > > vijaykumarjain.git...@gmail.com> wrote: > >> i tried to check the code for auto_explain , there is nothing that helps > >> understand why it was provided as a se

Re: explain vs auto_explain

2024-10-19 Thread David G. Johnston
On Sat, Oct 19, 2024 at 10:05 AM Vijaykumar Jain < vijaykumarjain.git...@gmail.com> wrote: > Why does auto_explain have extended flags to support nested statements and > triggers whereas explain does not. > the objects of concern have the same ownership and access, so it does not > even sound like