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

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN.
Date: 2024-09-17 06:00:38
Message-ID: E1sqRGQ-001THo-5o@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers 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(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2024-09-17 09:37:07 pgsql: Add temporal PRIMARY KEY and UNIQUE constraints
Previous Message Nathan Bossart 2024-09-16 21:34:03 pgsql: Fix redefinition of typedef.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2024-09-17 06:06:26 Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN
Previous Message Laurenz Albe 2024-09-17 06:00:18 Wrong results with equality search using trigram index and non-deterministic collation