From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
cc: Robert Haas <robertmhaas@gmail.com>,
        Guillaume Lelarge <guillaume@lelarge.info>,
        Greg Sabino Mullane <htamfids@gmail.com>,
        Michael Christofides <michael@pgmustard.com>,
        "David G. Johnston" <david.g.johnston@gmail.com>,
        Nikolay Samokhvalov <samokhvalov@gmail.com>,
        pgsql-hackers@postgresql.org
Subject: Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
In-reply-to: <CAApHDvpc3R_ssqVHn=Bz32WGXCVN=GhTu1+dXov6T6uhDCLsLQ@mail.gmail.com>
References: <CANNMO++9W_UA8PB9AkDRF3JBv4K7K1FnisrXTjicL+WZhwUJzw@mail.gmail.com> <CA+TgmoZF7PbO7DB_VMQS4664EgOdObhFtAoLUb83bp3i-623UQ@mail.gmail.com> <CANNMO++d9CKuJEzSnRWFCHcmKr2DGASTtEMZ9bpEYHSa4QFQvA@mail.gmail.com> <3076356.1730831425@sss.pgh.pa.us> <CANNMO++W7MM8T0KyXN3ZheXXt-uLVM3aEtZd+WNfZ=obxffUiA@mail.gmail.com> <CAKFQuwbLq3GWoJw-zNa43pkcfg5gh4gGQKMptQtp4qX_nQL9AQ@mail.gmail.com> <CAApHDvrYwEt=ueMTn39okNihZffhKgqvxedLqDJu=hmSsZ=g9Q@mail.gmail.com> <CAFwT4nC5255GkSt1WEfTHi6cwUuY4fjUmH15nD91c1JvNoOxNA@mail.gmail.com> <CAECtzeUKbyZNuFRu4DTr_3p44egDXGbPpGonixqJninWXyBvnQ@mail.gmail.com> <CA+TgmobY4N3QYWTW4bj9K=gG3Q4rTAsZLvi_=ODZYRBpk=ZVNA@mail.gmail.com> <CAECtzeVvrjxXmE3TB9zz3MD_RwiE=MCg2Xjx0HXoSn4e-VRSOg@mail.gmail.com> <CAECtzeWpusNrZADkQ01ZZL_fFtOWtwtnw_uixqy9hgK0qUCScQ@mail.gmail.com> <CA+TgmoZO2HtDGHf7K4rmNdfUGuS=ngsPgwrH=JdyF6Okcnzfkw@mail.gmail.com> <CAECtzeW=yo4H-G8rBheWwiET-e+PaBpOHHaL9Yu0JpYTd557_Q@mail.gmail.com> <CAECtzeUwpK5gNWQqoK4ZjwXANtdE2fWirJyaBDqkytP!
 zfWZqzg@mail.gmail.com> <CAKAnmm+QQP-dTkjsDVbEcphrdXqCTq-ALTCMUwPaYWZmqUp=NQ@mail.gmail.com> <CAECtzeVkkmvmHWVOTzwpX_GX+k4h7EWAyfERqes9C0z4pzMN2A@mail.gmail.com> <CAApHDvoZkip1pERLWcW7T5unmWgt1=yYybXpxqOWBGFP7kbryA@mail.gmail.com> <CA+TgmoYa4C+-ooKxCQ2dkqMucysrMsc2OXNV2Pd8vTLmSXf75w@mail.gmail.com> <CAApHDvowEgBX0w-4+UFYL9NmMYSyOF2mxrCSZXhiBe+VUYuW=A@mail.gmail.com> <1558996.1732576353@sss.pgh.pa.us> <CAApHDvpc3R_ssqVHn=Bz32WGXCVN=GhTu1+dXov6T6uhDCLsLQ@mail.gmail.com>
Comments: In-reply-to David Rowley <dgrowleyml@gmail.com>
	message dated "Wed, 27 Nov 2024 16:02:11 +1300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1770478.1732677586.1@sss.pgh.pa.us>
Date: Tue, 26 Nov 2024 22:19:46 -0500
Message-ID: <1770479.1732677586@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1770479.1732677586%40sss.pgh.pa.us>
Precedence: bulk

David Rowley <dgrowleyml@gmail.com> writes:
> On Tue, 26 Nov 2024 at 12:12, Tom Lane <tgl@sss.pgh.pa.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