Re: Making auto_explain more useful / convenient

2023-11-11 Thread Vladimir Churyukin
On Sat, Nov 11, 2023 at 7:49 AM Tom Lane wrote: > Vladimir Churyukin writes: > > Why not have an option to return EXPLAIN results as a NoticeResponse > > instead? That would make its usage more convenient. > > That seems quite useless to me, and likely actually counterproductive. > If you are ma

Re: Making auto_explain more useful / convenient

2023-11-11 Thread Vladimir Churyukin
Thank you, that answers the first part of my question. On Sat, Nov 11, 2023 at 2:43 AM Sergei Kornilov wrote: > Hello > > auto_explain.log_level is available since postgresql 12. > > postgres=# load 'auto_explain'; > LOAD > postgres=# set auto_explain.log_min_duration to 0; > SET > postgres=# se

Re: Making auto_explain more useful / convenient

2023-11-11 Thread Tom Lane
Vladimir Churyukin writes: > Why not have an option to return EXPLAIN results as a NoticeResponse > instead? That would make its usage more convenient. That seems quite useless to me, and likely actually counterproductive. If you are manually investigating query performance, you can just use EXPL