Questions About TODO: Issuing NOTICEs for row count differences in EXPLAIN ANALYZE

From: KAZAR Ayoub <ma_kazar(at)esi(dot)dz>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Questions About TODO: Issuing NOTICEs for row count differences in EXPLAIN ANALYZE
Date: 2024-10-28 23:43:16
Message-ID: CA+K2Run9ZSY1dKiZpskXPmgTaN_pLMsd=Ftt-82UPjh=pFsHDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello Hackers,
I am currently looking into the following TODO item, "Have EXPLAIN ANALYZE
issue NOTICE messages when the estimated and actual row counts differ by a
specified percentage."
What's the current status of this TODO, and is there any prior discussion
or rationale behind it ?
Specifically:
- How can we come up with a percentage for row count differences (fixed
value or dynamic)?
- Should we consider a configurable param for users ?
- Is there anything extra to consider ?

Thank you.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2024-10-29 00:29:28 Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on
Previous Message Andy Fan 2024-10-28 23:38:31 Re: Considering fractional paths in Append node