• Tom Lane's avatar
    Teach EXPLAIN to print PARAM_EXEC Params as the referenced expressions, · 1cc29fe7
    Tom Lane authored
    rather than just $N.  This brings the display of nestloop-inner-indexscan
    plans back to where it's been, and incidentally improves the display of
    SubPlan parameters as well.  In passing, simplify the EXPLAIN code by
    having it deal primarily in the PlanState tree rather than separately
    searching Plan and PlanState trees.  This is noticeably cleaner for
    subplans, and about a wash elsewhere.
    
    One small difference from previous behavior is that EXPLAIN will no longer
    qualify local variable references in inner-indexscan plan nodes, since it
    no longer sees such nodes as possibly referencing multiple tables.  Vars
    referenced through PARAM_EXEC Params are still forcibly qualified, though,
    so I don't think the display is any more confusing than before.  Adjust a
    couple of examples in the documentation to match this behavior.
    1cc29fe7
ruleutils.c 187 KB