Re: Show 'Rows Removed by Filter' with two fractional digits in EXPLAIN

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Andrei Lepikhov <lepihov(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>
Subject: Re: Show 'Rows Removed by Filter' with two fractional digits in EXPLAIN
Date: 2026-11-09 13:28:58
Message-ID: CA+TgmoarOJGdGO1uySjDTwqobkoTPZtNr41RGi7PJFyFiOQVfw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Nov 6, 2026 at 3:57 AM Andrei Lepikhov <lepihov(at)gmail(dot)com> wrote:
> 1. Always print two digits, as actual rows do now.
> 2. Leave the math to users and print exact totals without dividing by nloops.

I think we should do #1. Dividing by nloops is never what I personally
want for any of these, but we got enough consensus on it to move
forward with it for the actual row counts, so I think doing the same
thing here makes sense to me. Maybe eventually we will get consensus
on other changes, but I think we probably don't have it now, and doing
what we can do is better than arguing a case we probably won't win.

--
Robert Haas
Databricks

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2026-11-09 13:41:52 Re: reconsider_full_join_clause fails to consider if COALESCE() arguments are NULL-preserving
Previous Message Keyerror Smart 2026-11-09 13:18:58 Re: MERGE fails with RETURNING when an excluded inheritance parent has an extra-column child