Questions About TODO: Issuing NOTICEs for row count differences in EXPLAIN ANALYZE - Mailing list pgsql-hackers

From KAZAR Ayoub
Subject Questions About TODO: Issuing NOTICEs for row count differences in EXPLAIN ANALYZE
Date
Msg-id CA+K2Run9ZSY1dKiZpskXPmgTaN_pLMsd=Ftt-82UPjh=pFsHDw@mail.gmail.com
Whole thread Raw
Responses Re: Questions About TODO: Issuing NOTICEs for row count differences in EXPLAIN ANALYZE
List 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.

pgsql-hackers by date:

Previous
From: Andy Fan
Date:
Subject: Re: Considering fractional paths in Append node
Next
From: "David G. Johnston"
Date:
Subject: Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on