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

From: Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>
To: Michael Christofides <michael(at)pgmustard(dot)com>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Greg Sabino Mullane <htamfids(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
Date: 2025-02-09 12:05:32
Message-ID: CAGECzQQJ1xtPTo0tEcKwtMv_LbwwKnTEqTsRRrswHOPXSrGKuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 13 Dec 2024 at 16:59, Michael Christofides
<michael(at)pgmustard(dot)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/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rushabh Lathia 2025-02-09 12:25:23 Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints
Previous Message Alexander Korotkov 2025-02-09 11:58:56 Re: Replace IN VALUES with ANY in WHERE clauses during optimization