Horton

Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE

Jelte Fennema-Nio <postgres@jeltef.nl>

View thread View on postgr.es
From: Jelte Fennema-Nio <postgres@jeltef.nl>
To: Michael Christofides <michael@pgmustard.com>
Cc: David Rowley <dgrowleyml@gmail.com>, Guillaume Lelarge <guillaume@lelarge.info>, Greg Sabino Mullane <htamfids@gmail.com>, Robert Haas <robertmhaas@gmail.com>, "David G. Johnston" <david.g.johnston@gmail.com>, Nikolay Samokhvalov <samokhvalov@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Date: 2025-02-09T12:05:32Z
Lists: pgsql-hackers 
On Fri, 13 Dec 2024 at 16:59, Michael Christofides
<michael@pgmustard.com> wrote:
>
> > I've pushed the main patch.
>
> Woohoo! And thank you. I've already seen quite a lot of positivity around the commit on Twitter[1][2][3].

I wanted to highlight this other patch[1] by Atsushi Torikoshi, which
adds "actual filesystem I/O" metrics to EXPLAIN BUFFERS (and thus now
to default ANALYZE). I marked that patch as "ready for committer" just
now. I'm sharing it here for visibility, because it seems like people
interested in BUFFERS as default would probably also be interested in
that patch. And because it's pretty simple, I think it would be a good
candidate to commit for PG18.

[1]: https://commitfest.postgresql.org/52/5526/

Commits

  1. Fix further fallout from EXPLAIN ANALYZE BUFFERS change

  2. Add missing BUFFERS OFF in regression tests, take 2

  3. Add missing BUFFERS OFF in select_into regression tests

  4. Enable BUFFERS with EXPLAIN ANALYZE by default