Mime-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset=UTF-8; format=Flowed
Date: Fri, 30 May 2025 14:43:14 +0200
Message-Id: <DA9I5MGB2LO5.2BHSEGIAT74Y7@jeltef.nl>
Cc: "Michael Christofides" <michael@pgmustard.com>, "Guillaume Lelarge"
 <guillaume@lelarge.info>, "Greg Sabino Mullane" <htamfids@gmail.com>,
 "Robert Haas" <robertmhaas@gmail.com>, "David G. Johnston"
 <david.g.johnston@gmail.com>, "Nikolay Samokhvalov"
 <samokhvalov@gmail.com>, "Tom Lane" <tgl@sss.pgh.pa.us>,
 <pgsql-hackers@postgresql.org>
Subject: Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend
 VERBOSE
To: "David Rowley" <dgrowleyml@gmail.com>, "Fujii Masao"
 <masao.fujii@oss.nttdata.com>
From: "Jelte Fennema-Nio" <postgres@jeltef.nl>
References: 
 <CANNMO++9W_UA8PB9AkDRF3JBv4K7K1FnisrXTjicL+WZhwUJzw@mail.gmail.com>
 <CAECtzeWpusNrZADkQ01ZZL_fFtOWtwtnw_uixqy9hgK0qUCScQ@mail.gmail.com>
 <CA+TgmoZO2HtDGHf7K4rmNdfUGuS=ngsPgwrH=JdyF6Okcnzfkw@mail.gmail.com>
 <CAECtzeW=yo4H-G8rBheWwiET-e+PaBpOHHaL9Yu0JpYTd557_Q@mail.gmail.com>
 <CAKAnmmLOkvJ85MGyouFBr2tS+0TSZ87=t=8iaZKU25WG98nZaw@mail.gmail.com>
 <CAECtzeUwpK5gNWQqoK4ZjwXANtdE2fWirJyaBDqkytPzfWZqzg@mail.gmail.com>
 <CAKAnmm+QQP-dTkjsDVbEcphrdXqCTq-ALTCMUwPaYWZmqUp=NQ@mail.gmail.com>
 <CAECtzeVkkmvmHWVOTzwpX_GX+k4h7EWAyfERqes9C0z4pzMN2A@mail.gmail.com>
 <CAApHDvpj0Cj6Z8VnDN5htzF24b4_hKL+1_n=HOehLHkBK_E_TQ@mail.gmail.com>
 <CAECtzeUWiA+FNq0qGp94Ez4UAwbEZyB7avTqKDs6wkPhU56mpw@mail.gmail.com>
 <CAApHDvqjmr=CZ2M57eErxn2Ubcb0d2EmppZhTj8k==Ud_eRfoQ@mail.gmail.com>
 <CAApHDvqLdzgz77JsE-yTki3w9UiKQ-uTMLRctazcu+99-ips3g@mail.gmail.com>
 <CAApHDvqJcsNsmU4d8q24qZy4Rm0OzxQ4jDRRNBV1P6xrYWwxCQ@mail.gmail.com>
 <CAFwT4nABCCOs242KoOToR54NVhDsHC73dm50qBWBwpt9unA3wg@mail.gmail.com>
 <a6206e08-0607-42fe-91fd-e7bd45fa235a@oss.nttdata.com>
 <CAApHDvpqjJqXq2eBXzCqeoAyVANnVg7brrkRiQMENBo8tf44_Q@mail.gmail.com>
In-Reply-To: 
 <CAApHDvpqjJqXq2eBXzCqeoAyVANnVg7brrkRiQMENBo8tf44_Q@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/DA9I5MGB2LO5.2BHSEGIAT74Y7%40jeltef.nl>
Precedence: bulk

On Fri May 30, 2025 at 1:55 PM CEST, David Rowley wrote:
> By my count, those who think we should change log_buffers to true are:
> Robert [1], Michael Christofides [2], Fujii [3].

+1 for me on changing the default. It just seems confusing to have
different defaults for auto_explain and EXPLAIN. I'd even vote for
making that change still for PG18, since this feels like an oversight
that the defaults were not kept aligned.


> log_min_duration =3D 0, log_buffers =3D off: 11231 tps
> log_min_duration =3D 0, log_buffers =3D on: 11106 tps
> log_min_duration =3D -1 (off): 13297 tps
>
> So it is possible to measure it, at least.

Seems small enough not to worry about it.