From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Add memory/disk usage for WindowAgg nodes in EXPLAIN |
Date: | 2024-07-06 11:22:54 |
Message-ID: | 20240706.202254.89740021795421286.ishii@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
1eff8279d4 added memory/disk usage for materialize nodes in EXPLAIN
ANALYZE.
In the commit message:
> There are a few other executor node types that use tuplestores, so we
> could also consider adding these details to the EXPLAIN ANALYZE for
> those nodes too.
So I wanted to Add memory/disk usage for WindowAgg. Patch attached.
Since WindowAgg node could create multiple tuplestore for each Window
partition, we need to track each tuplestore storage usage so that the
maximum storage usage is determined. For this purpose I added new
fields to the WindowAggState.
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
Attachment | Content-Type | Size |
---|---|---|
v1-0001-Add-memory-disk-usage-for-WindowAgg-nodes-in-EXPL.patch | text/x-patch | 4.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Wienhold | 2024-07-06 11:52:22 | Re: XML test error on Arch Linux |
Previous Message | Joel Jacobson | 2024-07-06 11:16:58 | Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands. |