From e4eb2288c90e92a42ba85c672d477b1a93ebf6f8 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Wed, 10 Jul 2024 14:09:46 +0900 Subject: [PATCH v2 2/5] Add memory/disk usage for CTE Scan nodes in EXPLAIN --- src/backend/commands/explain.c | 15 +++++++++++++++ 1 file changed, 15 insertions(+) diff --git a/src/backend/commands/explain.c b/src/backend/commands/explain.c index 43ef33295e..661e9101cb 100644 --- a/src/backend/commands/explain.c +++ b/src/backend/commands/explain.c @@ -127,6 +127,7 @@ static void show_incremental_sort_info(IncrementalSortState *incrsortstate, static void show_hash_info(HashState *hashstate, ExplainState *es); static void show_storage_info(Tuplestorestate *tupstore, ExplainState *es); static void show_material_info(MaterialState *mstate, ExplainState *es); +static void show_ctescan_info(CteScanState *ctescanstate, ExplainState *es); static void show_memoize_info(MemoizeState *mstate, List *ancestors, ExplainState *es); static void show_hashagg_info(AggState *aggstate, ExplainState *es); @@ -2028,6 +2029,8 @@ ExplainNode(PlanState *planstate, List *ancestors, if (plan->qual) show_instrumentation_count("Rows Removed by Filter", 1, planstate, es); + if (IsA(plan, CteScan)) + show_ctescan_info(castNode(CteScanState, planstate), es); break; case T_Gather: { @@ -3372,6 +3375,18 @@ show_material_info(MaterialState *mstate, ExplainState *es) show_storage_info(tupstore, es); } +/* + * Show information on CTE Scan node, storage method and maximum memory/disk + * space used. + */ +static void +show_ctescan_info(CteScanState *ctescanstate, ExplainState *es) +{ + Tuplestorestate *tupstore = ctescanstate->leader->cte_table; + + show_storage_info(tupstore, es); +} + /* * Show information on memoize hits/misses/evictions and memory usage. */ -- 2.25.1