Samuel Gendler <sgendler(at)ideasculptor(dot)com> wrote:
> The planner knows how many rows are expected for each step of the
> query plan, so it would be theoretically possible to compute how
> far along it is in processing a query based on those estimates,
> wouldn't it?
And it is sometimes off by orders of magnitude. How much remaining
time do you report when the number of rows actually processed so far
is five times the estimated rows that the step would process? How
about after it chugs on from there to 20 time she estimated row
count? Of course, on your next query it might finish after
processing only 5% of the estimated rows....
-Kevin