On Tue, 25 Mar 2025 at 11:15, Tom Lane <t...@sss.pgh.pa.us> wrote: > FWIW, I share these doubts about whether these values are useful > enough to include in the default EXPLAIN output. My main beef > with them though is that they are basically numbers derived along > the way to producing a cost estimate, and I don't think we break > out such intermediate results for other node types.
The only likeness I can think of is the "(originally N)" for the buckets and batches in EXPLAIN ANALYZE for Hash Joins. I see that that only shows when one of those isn't the same as the planner's expectations Maybe there's room to show additional details for Memoize in some similar way only during EXPLAIN ANALYZE. EXPLAIN ANALYZE for Memoize currently shows things like the number of hits, misses and evictions. We could calculate what the planner expected those values to be and show those. For this case, they're almost certain not to match what the planner expected, but maybe that's ok. David
