Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
Date
Msg-id 778DD7DC-E41C-4287-A791-316ED259C492@yesql.se
Whole thread Raw
In response to Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
> On 20 Nov 2024, at 22:22, David Rowley <dgrowleyml@gmail.com> wrote:
>
> On Thu, 21 Nov 2024 at 08:30, Guillaume Lelarge <guillaume@lelarge.info> wrote:
>> OK, I'm fine with this. v4 patch attached with one plan showing read, written, and dirtied buffers.
>
> I think this might be a good time for anyone out there who is against
> turning on BUFFERS when ANALYZE is on to speak up.
>
> Votes for changing this so far seem to be: Me, Michael Christofides,
> Guillaume Lelarge, Robert, Greg Sabino Mullane, and David Fetter (from
> 2020) [1].

I would also like to see this on by default, while it does make it more verbose
the extra data is valuable in debugging. +1 from me.

--
Daniel Gustafsson




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Support LIKE with nondeterministic collations
Next
From: David Rowley
Date:
Subject: Re: Remove useless GROUP BY columns considering unique index