Horton

Re: Printing window function OVER clauses in EXPLAIN

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Álvaro Herrera <alvherre@alvh.no-ip.org>, pgsql-hackers@lists.postgresql.org
Date: 2025-03-11T15:21:00Z
Lists: pgsql-hackers 
David Rowley <dgrowleyml@gmail.com> writes:
> 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.

Thanks, pushed with those points addressed.

			regards, tom lane

Commits

  1. Improve EXPLAIN's display of window functions.