Re: Regd: TODO Item : Have EXPLAIN ANALYZE issue NOTICE messages ...
Regarding: Optimizer To Do Item: Have EXPLAIN ANALYZE issue NOTICE messages
when the estimated and actual row counts differ by a specified percentage.
Hi,
After going through the thread related to the above mentioned to do Item, my
understanding is that:
Issuing notices when a problematic node occurs is useful in the case of long
running queries. It can avoid having the user wait a couple of hours to
solve the problem.
A possible solution from the archives was summarized as below:
Bruce Momjian Wrote :
I was thinking we could issue NOTICE when the estimates differed from
the actual by a specified percentage, and that NOTICE could be issued
while the query is still processing, assuming the stage completes before
the query does. This seems much easier than doing protocol changes.
Looking forward to your inputs on this.
Thank you,
Ramya
On Thu, Jun 26, 2008 at 10:22 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Show quoted text
"Ramya Chandrasekar" <csekar.ramya@gmail.com> writes:
Regd: TODO Item: Optimizer:: Have EXPLAIN ANALYZE issue NOTICE messages
when
the estimated and actual row counts differ by a specified percentage.
I think that TODO item hasn't been thought through very carefully.
NOTICEs that are dissociated from the actual explain output seem pretty
useless, or at least painful to use. You might want to go back in the
archives and read the whole thread that led up to the TODO item to see
what ideas were kicked around.regards, tom lane