From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Álvaro Herrera <alvherre@alvh.no-ip.org>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Printing window function OVER clauses in EXPLAIN
Date: Sun, 09 Mar 2025 21:13:28 -0400
Message-ID: <641586.1741569208@sss.pgh.pa.us> (raw)
In-Reply-To: <CAApHDvpT8W3svBF_4u-0wJ5UMU1weL+aZD8jwbJLBB3zkY5_8w@mail.gmail.com>
References: <202503091412.mzlgmzmmzwim@alvherre.pgsql>
<279724.1741535141@sss.pgh.pa.us>
<616793.1741558789@sss.pgh.pa.us>
<CAApHDvpT8W3svBF_4u-0wJ5UMU1weL+aZD8jwbJLBB3zkY5_8w@mail.gmail.com>
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"? Looking at window.out, I see
> that the EXPLAIN output does become quite a bit wider than before. I
> favour the idea of saving a bit of space. There is an example in
> src/sgml/advanced.sgml that has "OVER w", so it does not seem overly
> strange to me to name them "w1", "w2", etc.
OK by me, any objections elsewhere?
>> * In passing, I editorialized on the order in which the Run Condition
>> annotation comes out:
> I did it that way because "Rows Removed by Filter" is a property of
> "Filter", so it makes sense to me for those to be together. It doesn't
> make sense to me to put something unrelated between them.
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.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, dgrowleyml@gmail.com, alvherre@alvh.no-ip.org, pgsql-hackers@lists.postgresql.org
Subject: Re: Printing window function OVER clauses in EXPLAIN
In-Reply-To: <641586.1741569208@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox