Re: Printing window function OVER clauses in EXPLAIN

David Rowley <dgrowleyml@gmail.com>

From: David Rowley <dgrowleyml@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Álvaro Herrera <alvherre@alvh.no-ip.org>, pgsql-hackers@lists.postgresql.org
Date: 2025-03-11T01:16:07Z
Lists: pgsql-hackers
On Tue, 11 Mar 2025 at 05:18, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Here's a hopefully-final v3 that makes the two changes discussed.
> Now with a draft commit message, too.

Looks good to me.

The only minor points I noted down while reviewing were 1)
name_active_windows()'s newname variable could be halved in size and,
2) explain.sql's new test could name the window "w1" instead of "w" to
exercise the name selection code a bit better. Both are minor points,
but I thought I'd mention them anyway.

David



Commits

  1. Improve EXPLAIN's display of window functions.