Samuel Gendler <sgendler@xxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
