Thread

Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE

Kirk Wolak <wolakk@gmail.com> — 2024-11-06T00:13:50Z

On Tue, Nov 5, 2024 at 1:19 PM Nikolay Samokhvalov <samokhvalov@gmail.com>
wrote:

>
>> > 2) VERBOSE doesn't include BUFFERS, and doesn't include SETTINGS; it
>> might
>> > be also confusing sometimes. Let's include them so VERBOSE would be
>> really
>> > verbose?
>>
>> This is not likely to fly for compatibility reasons.
>>
>
> Can you elaborate?
>

I am not sure about the compatibility reasons (other than backtesting, or
scripts?).

But, personally, as a relatively new person to PG, I was surprised that
VERBOSE did not include the buffers.
Could we somehow turn this on?  (GUC: VERBOSE_INCLUDES_BUFFERS = yes/no)?