Questions About TODO: Issuing NOTICEs for row count differences in EXPLAIN ANALYZE
KAZAR Ayoub <ma_kazar@esi.dz>
From: KAZAR Ayoub <ma_kazar@esi.dz>
To: pgsql-hackers@lists.postgresql.org
Date: 2024-10-28T23:43:16Z
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.