pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN.
Tatsuo Ishii <ishii@postgresql.org>
From: Tatsuo Ishii <ishii@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Date: 2024-09-17T06:00:38Z
Lists: pgsql-hackers
Add memory/disk usage for Window aggregate nodes in EXPLAIN. This commit is similar to 1eff8279d and expands the idea to Window aggregate nodes so that users can know how much memory or disk the tuplestore used. This commit uses newly introduced tuplestore_get_stats() to inquire this information and add some additional output in EXPLAIN ANALYZE to display the information for the Window aggregate node. Reviewed-by: David Rowley, Ashutosh Bapat, Maxim Orlov, Jian He Discussion: https://postgr.es/m/20240706.202254.89740021795421286.ishii%40postgresql.org Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/95d6e9af07d2e5af2fdd272e72b5b552bad3ea0a Modified Files -------------- src/backend/commands/explain.c | 68 +++++++++++++++++++++++++---------- src/test/regress/expected/explain.out | 38 ++++++++++++++++++++ src/test/regress/sql/explain.sql | 9 +++++ 3 files changed, 97 insertions(+), 18 deletions(-)
Commits
-
Fix failing regression test on x86-32 machines
- 3dbdf86c6364 18.0 landed
-
Add memory/disk usage for Window aggregate nodes in EXPLAIN.
- 95d6e9af07d2 18.0 cited