Horton

Re: Printing window function OVER clauses in EXPLAIN

David Rowley <dgrowleyml@gmail.com>

View thread View on postgr.es
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-10T01:17:35Z
Lists: pgsql-hackers 
On Mon, 10 Mar 2025 at 14:13, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Hmm, OK.  Do you think it could be sensible to put Run Condition
> before Filter, then?  On the same grounds of "keeping related
> things together", it could be argued that Run Condition is
> related to the Window property.  Also, the Run Condition acts
> before the Filter does, if I've got my head screwed on straight.

Yes, directly after the "Window" property makes sense for the reason
you stated. Thanks for thinking of that.

David

Commits

  1. Improve EXPLAIN's display of window functions.