Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE - Mailing list pgsql-hackers

From Jelte Fennema-Nio
Subject Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
Date
Msg-id DA9I5MGB2LO5.2BHSEGIAT74Y7@jeltef.nl
Whole thread Raw
In response to Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE  (Nikolay Samokhvalov <samokhvalov@gmail.com>)
List pgsql-hackers
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 = 0, log_buffers = off: 11231 tps
> log_min_duration = 0, log_buffers = on: 11106 tps
> log_min_duration = -1 (off): 13297 tps
>
> So it is possible to measure it, at least.

Seems small enough not to worry about it.



pgsql-hackers by date:

Previous
From: "Jelte Fennema-Nio"
Date:
Subject: Reduce DEBUG level of catcache refreshing messages
Next
From: Andrey Borodin
Date:
Subject: Re: Persist injection points across server restarts