Re: New EXPLAIN option: ALL

> On May 8, 2019, at 4:22 PM, Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com> wrote:
>
> On 07/05/2019 09:30, David Fetter wrote:
>> Folks,
>>
>> It can get a little tedious turning on (or off) all the boolean
>> options to EXPLAIN, so please find attached a shortcut.
>
> I would rather have a set of gucs such as default_explain_buffers,
> default_explain_summary, and default_explain_format.
>
> Of course if you default BUFFERS to on(*) and don't do ANALYZE, that
> should not result in an error.
>
> (*) Defaulting BUFFERS to on is something I want regardless of anything
> else we do.

I think this, plus Tom’s suggesting of changing what VERBOSE does, is the best way to handle this. Especially since VERBOSE is IMHO pretty useless...

I’m +1 on trying to move away from ANALYZE as well, though I think it’s mostly orthogonal...