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

From: Christoph Berg <myon(at)debian(dot)org>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN.
Date: 2025-03-31 15:40:20
Message-ID: Z-q3ZAM4OhE-4UiI@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Re: Tatsuo Ishii
> Add memory/disk usage for Window aggregate nodes in EXPLAIN.

This is failing for PG18 on Debian unstable on 32-bit i386:

******** build/src/test/regress/regression.diffs ********
diff -U3 /build/reproducible-path/postgresql-18-18~~devel.20250331/src/test/regress/expected/explain.out /build/reproducible-path/postgresql-18-18~~devel.20250331/build/src/test/regress/results/explain.out
--- /build/reproducible-path/postgresql-18-18~~devel.20250331/src/test/regress/expected/explain.out 2025-03-31 06:17:21.000000000 +0000
+++ /build/reproducible-path/postgresql-18-18~~devel.20250331/build/src/test/regress/results/explain.out 2025-03-31 15:18:19.914783369 +0000
@@ -792,7 +792,7 @@
----------------------------------------------------------------------------------
WindowAgg (actual time=N.N..N.N rows=N.N loops=N)
Window: w1 AS ()
- Storage: Disk Maximum Storage: NkB
+ Storage: Memory Maximum Storage: NkB
-> Function Scan on generate_series a (actual time=N.N..N.N rows=N.N loops=N)
Planning Time: N.N ms
Execution Time: N.N ms

This is the first build of PG18 on i386, so I cannot say if it broke with that commit or later.

Full log: https://buildd.debian.org/status/fetch.php?pkg=postgresql-18&arch=i386&ver=18%7E%7Edevel.20250331-1&stamp=1743434305&raw=0

Christoph

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2025-03-31 16:16:44 pgsql: Fix accidentally-harmless thinko in psqlscan_test_variable().
Previous Message Peter Eisentraut 2025-03-31 14:58:18 pgsql: doc: Mention clock synchronization recommendation for hot_standb

Browse pgsql-hackers by date

  From Date Subject
Next Message Corey Huinker 2025-03-31 15:53:02 Re: Add partial :-variable expansion to psql \copy
Previous Message Dean Rasheed 2025-03-31 15:33:13 Re: INSERT ... ON CONFLICT DO SELECT [FOR ...] take 2