pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN. - Mailing list pgsql-committers

From Tatsuo Ishii
Subject pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN.
Date
Msg-id E1sqRGQ-001THo-5o@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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(-)


pgsql-committers by date:

Previous
From: Nathan Bossart
Date:
Subject: pgsql: Fix redefinition of typedef.
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Add temporal FOREIGN KEY contraints