Horton

Add memory/disk usage for Window aggregate nodes in EXPLAIN.

Tatsuo Ishii <ishii@postgresql.org>

View on postgr.es
Commit: 95d6e9af07d2e5af2fdd272e72b5b552bad3ea0a
Author: Tatsuo Ishii <ishii@postgresql.org>
Date: 2024-09-17T05:38:53Z
Releases: 18.0 
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

Files

PathChange+/−
src/backend/commands/explain.c modified +50 −18
src/test/regress/expected/explain.out modified +38 −0
src/test/regress/sql/explain.sql modified +9 −0

Discussion