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: Álvaro Herrera <alvherre@alvh.no-ip.org>
Cc: David Rowley <dgrowleyml@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2025-03-10T16:18:29Z
Lists: pgsql-hackers

Attachments

=?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@alvh.no-ip.org> writes:
> On 2025-Mar-09, Tom Lane wrote:
>> David Rowley <dgrowleyml@gmail.com> writes:
>>> What are your thoughts on being a bit more brief with the naming and
>>> just prefix with "w" instead of "window"?

>> OK by me, any objections elsewhere?

> WFM.

Here's a hopefully-final v3 that makes the two changes discussed.
Now with a draft commit message, too.

I looked for documentation examples that needed updates, but there
don't seem to be any.  Our documentation of EXPLAIN output is
mighty thin anyway.  I don't want to try to improve that situation
as part of this patch.

			regards, tom lane

Commits

  1. Improve EXPLAIN's display of window functions.