On Thu, 2024-10-03 at 11:44 +1300, David Rowley wrote: > 2) Laurenz is misunderstanding what "Disabled Nodes" means. It has > nothing to do with other Paths which were considered and rejected. It > might be better named as "Disabled Degree". It tracks how many plan > nodes below and including this node are disabled. > > Because of #2, I think I now understand why Laurenz was interested in > only showing this with VERBOSE. If it worked the way Laurenz thought, > I'd probably agree with him.
Ah, thanks, now I see the light. You only see a "disabled node" if the optimizer chose a node you explicitly disabled, like a sequential scan, a nested loop join or a sort. I completely agree with you: it should always be displayed, and a boolean is the appropriate way. The display just shouldn't be propagated up the tree to nodes that were not actually disabled. Perhaps a line of documentation on the EXPLAIN reference page or on the "Using EXPLAIN" page would be in order. Yours, Laurenz Albe
