Stephen Frost <sfrost@snowman.net> writes:
> * Stephen Frost (sfrost@snowman.net) wrote:
>> Would be nice if there was a CTE ID or similar to link between
>> the pieces of the InitPlan and the CTE nodes.
> Erm, of course, the CTE *has* an ID already, since you name them. Could
> we get that ID/name up into the piece of the InitPlan that is handling
> that CTE?
I'm not sure but will be glad to take a look. Assuming it's not
unreasonably difficult, does anyone object to a format like this:
Nested Loop (cost=1266.59..1001458.19 rows=35936310 width=52) InitPlan CTE abc -> Seq Scan on foo
(cost=0.00..34.25rows=647 width=12) Filter: (id < 200) CTE wumpus -> Seq Scan on tab1
(cost=0.00..27.70rows=1770 width=16) -> CTE Scan on abc x (cost=0.00..35.40 rows=1770 width=16) -> Materialize
(cost=1204.64..1566.67rows=20303 width=36) -> Hash Join (cost=42.05..1025.34 rows=20303 width=36) ...
regards, tom lane