V18 change on EXPLAIN ANALYZE

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: V18 change on EXPLAIN ANALYZE
Date: 2025-09-26 20:33:26
Message-ID: CAB-JLwYCgdiB=trauAV1HN5rAWQdvDGgaaY_mqziN88pBTvqqg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Hass committed ddb17e387aa28d61521227377b00f997756b8a27,
which changed how EXPLAIN indicates fractional rows. That's cool but I have
to see that change on sources because it's not explained on DOCs.

One can understand that cost=4.36, that actual time=0.009, but what means
rows=10.43 ? Costs and Time having decimals are fine but what is a row and
a half ?

So, I don't know exactly how to explain this change but I think it would be
good to have a new paragraph on [1] and explain that now when nloops > 1,
we now display two digits after the decimal point, rather than none.

[1] -
https://www.postgresql.org/docs/current/using-explain.html#USING-EXPLAIN-ANALYZE

regards
Marcos

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-09-26 20:37:58 Re: [PATCH] GROUP BY ALL
Previous Message Tom Lane 2025-09-26 20:18:32 Re: [PATCH] GROUP BY ALL