Re: Planning time in explain/explain analyze

On 12/24/2013 05:09 AM, Robert Haas wrote:
>> Yeah.  The alternatives seem to be:
>>
>> 1. Change a lot of regression tests.  This would be a serious PITA,
>> not so much for the one-time cost as for every time we needed to
>> back-patch a regression test that includes explain output.  -1.
>>
>> 2. Don't display the planning time by default, necessitating a new
>> PLANNING_TIME ON option.  This has backwards compatibility to
>> recommend it, but not much else.
>>
>> 3. Let COSTS OFF suppress it.
>
> Another option would be to not display it by default, but make VERBOSE
> show it.  However, I think making it controlled by COSTS is a better
> fit.

After some thinking COSTS OFF really seems to be the best option. I have 
changed this in the patch and will submit a patch with updated 
documentation as soon as I get the time. Adding "Planning time" to all 
explain outputs (only 37 of them) in the documentation should not 
clutter anything too much.

-- 
Andreas Karlsson