Robert Haas <robertmh...@gmail.com> writes: > On Tue, Feb 11, 2025 at 12:14 PM Andrei Lepikhov <lepi...@gmail.com> wrote: >> I support the idea in general, but I believe it should be expanded to >> cover all cases of parameterised plan nodes. Each rescan iteration may >> produce a different number of tuples, and rounding can obscure important >> data.
> I agree strongly with all of this. I believe we should just implement > what was agreed here: > https://www.postgresql.org/message-id/21013.1243618236%40sss.pgh.pa.us > Let's just display 2 fractional digits when nloops>1, else 0, and call it > good. Note that that formulation has nothing especially to do with parameterized plan nodes. Any nestloop inner side would end up getting shown with fractional rowcounts. Maybe that's fine. I suggest that when thinking about what to change here, you start by considering how you'd adjust the docs at https://www.postgresql.org/docs/devel/using-explain.html to explain the new behavior. If you can't explain it clearly for users, then maybe it's not such a great idea. regards, tom lane
