From a7bfaf711b5a1ecb4fe58d3b46db1911383dbfb8 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Wed, 10 Jul 2024 14:32:59 +0900 Subject: [PATCH v2 3/5] Add memory/disk usage for Table Function Scan nodes in EXPLAIN --- src/backend/commands/explain.c | 14 ++++++++++++++ 1 file changed, 14 insertions(+) diff --git a/src/backend/commands/explain.c b/src/backend/commands/explain.c index 661e9101cb..1a4e83ad38 100644 --- a/src/backend/commands/explain.c +++ b/src/backend/commands/explain.c @@ -128,6 +128,7 @@ 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_table_func_can_info(TableFuncScanState *tscanstate, ExplainState *es); static void show_memoize_info(MemoizeState *mstate, List *ancestors, ExplainState *es); static void show_hashagg_info(AggState *aggstate, ExplainState *es); @@ -2112,6 +2113,7 @@ ExplainNode(PlanState *planstate, List *ancestors, if (plan->qual) show_instrumentation_count("Rows Removed by Filter", 1, planstate, es); + show_table_func_can_info(castNode(TableFuncScanState, planstate), es); break; case T_TidScan: { @@ -3387,6 +3389,18 @@ show_ctescan_info(CteScanState *ctescanstate, ExplainState *es) show_storage_info(tupstore, es); } +/* + * Show information on Table Function Scan node, storage method and maximum + * memory/disk space used. + */ +static void +show_table_func_can_info(TableFuncScanState *tscanstate, ExplainState *es) +{ + Tuplestorestate *tupstore = tscanstate->tupstore; + + show_storage_info(tupstore, es); +} + /* * Show information on memoize hits/misses/evictions and memory usage. */ -- 2.25.1