| From: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
|---|---|
| To: | David Rowley <dgrowleyml(at)gmail(dot)com> |
| Cc: | Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Greg Sabino Mullane <htamfids(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Michael Christofides <michael(at)pgmustard(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>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE |
| Date: | 2024-11-27 09:16:45 |
| Message-ID: | 778DD7DC-E41C-4287-A791-316ED259C492@yesql.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> On 20 Nov 2024, at 22:22, David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
>
> On Thu, 21 Nov 2024 at 08:30, Guillaume Lelarge <guillaume(at)lelarge(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2024-11-27 09:30:14 | Re: Remove useless GROUP BY columns considering unique index |
| Previous Message | Richard Guo | 2024-11-27 08:45:53 | Re: An inefficient query caused by unnecessary PlaceHolderVar |