From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
cc: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>,
        Andrei Lepikhov <lepihov@gmail.com>,
        Matheus Alcantara <matheusssilv97@gmail.com>,
        Guillaume Lelarge <guillaume@lelarge.info>,
        Daniel Gustafsson <daniel@yesql.se>,
        Ibrar Ahmed <ibrar.ahmad@gmail.com>,
        "Gregory Stark (as CFM)" <stark.cfm@gmail.com>,
        Amit Kapila <amit.kapila16@gmail.com>,
        Justin Pryzby <pryzby@telsasoft.com>, Peter Geoghegan <pg@bowt.ie>,
        vignesh C <vignesh21@gmail.com>,
        "David G. Johnston" <david.g.johnston@gmail.com>,
        pgsql-hackers@lists.postgresql.org
Subject: Re: explain analyze rows=%.0f
In-reply-to: <CA+TgmobT9gPQLtw143oGnKVNtaOrTDOy+ZbLfe18MVZ9POjaWg@mail.gmail.com>
References: <CA+TgmoZv8DvmeQHQAX+rkn68id2N+DoUhFZB36d-_w1tyAeqeA@mail.gmail.com> <CAM-w4HNLRO8QJvF3x13wjjdkJHobORxaKrcuyF1cKaTiXuvDbA@mail.gmail.com> <CALtqXTcZE6YW=m9ZmNU6sRJ+RTC15NFc__foP1S2KaWvGOf6JA@mail.gmail.com> <DBBD7E90-677A-4BF3-A5DD-B1A5D12F800C@yesql.se> <A141D263-CA95-4873-BCC7-2573C908DAED@yesql.se> <c54a600c-31f8-4db6-b049-e643ae812d38@tantorlabs.com> <CAECtzeVpocPwcQ0ccrXsmcvH_8YkJBdUfsJCzb8NKrEodmCg_w@mail.gmail.com> <55695d15-c738-4401-8883-58bc855c9b03@tantorlabs.com> <58bb3a5b-c92a-408c-b02a-f47aedc1c0e2@tantorlabs.com> <CAFY6G8f6Sdu9cvfF2NYWWZMHD0ecTCPuNT7VktPH5NwxY7hcog@mail.gmail.com> <70bc1af0-6910-4f71-84ba-fa02095fe9ba@tantorlabs.com> <CAFY6G8dgp494Xi2+VUUyM2CvuSQ+3nnzWi44gURWbCHjEWW89g@mail.gmail.com> <fc28108a-8e7e-4f7d-b8f4-0bcc1581650d@tantorlabs.com> <CA+Tgmobgkh5CW=4Xpejw9nR6Onv8SZh0nnr+=HmNAFyyHZb0eg@mail.gmail.com> <3212947.1739306803@sss.pgh.pa.us> <eb73d4e1-4235-41b5-90a8-b0196550f62b@gmail.com> <a51fc17e-8702-4928-863b-ea3eecf940bf@tantor!
 labs.com> <CA+TgmobT9gPQLtw143oGnKVNtaOrTDOy+ZbLfe18MVZ9POjaWg@mail.gmail.com>
Comments: In-reply-to Robert Haas <robertmhaas@gmail.com>
	message dated "Wed, 12 Feb 2025 13:19:11 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3365159.1739385615.1@sss.pgh.pa.us>
Date: Wed, 12 Feb 2025 13:40:15 -0500
Message-ID: <3365160.1739385615@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/3365160.1739385615%40sss.pgh.pa.us>
Precedence: bulk

Robert Haas <robertmhaas@gmail.com> writes:
> I agree that showing 2 digits after the decimal point in all cases is
> not ideal, but I suggest that we take a practical approach. Figuring
> out dynamically what number of decimal digits to display in each case
> sounds complicated and we may spend a bunch of time arguing about the
> details of that and get nothing committed. If we just show 2 digits
> after the decimal point, it will not be perfect, but it will be 10^2
> times better than what we have now.

I was idly speculating yesterday about letting the Ryu code print
the division result, so that we get a variable number of digits.
Realistically, that'd probably result in many cases in more digits
than anybody wants, so it's not a serious proposal.  I'm cool with
the fixed-two-digits approach to start with.

			regards, tom lane