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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Greg Sabino Mullane <htamfids(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>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
Date: 2024-11-27 03:19:46
Message-ID: 1770479.1732677586@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David Rowley <dgrowleyml(at)gmail(dot)com> writes:
> On Tue, 26 Nov 2024 at 12:12, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> I'm kind of -0.5, but I'd not bothered to vote because it was
>> pretty clear what the result was going to be.

> Just so I can properly understand, how much of the -0.5 is "don't like
> the idea" vs "rather make changes to well-known behaviour"?

Well, I'm with Robert in that I've not found the buffer counts to be
all that useful most of the time. I grant that they're sometimes
useful, but that's not enough to justify them being on by default:
EXPLAIN output is cluttered enough already. And I'm also not
thrilled with changing longstanding behavior, but that's a
relatively minor point in this case.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2024-11-27 03:20:28 Re: Improve the error message for logical replication of regular column to generated column.
Previous Message Andrey Borodin 2024-11-27 03:11:11 Re: UUID v7