Re: Query Progress Estimator

On Sun, Oct 23, 2005 at 02:04:02AM +0530, Anuj Tripathi wrote:
> Hi
> I am trying to implement Query Progress estimator in postgres for
> queries with long run time.I am looking for info regarding the number of
> tuples already processsed by a running query .
> I would be very thankful if someone can suggest where can i find it or
> the data structure that holds the value.

Currently, that information is only tracked on a per-node level in an
EXPLAIN ANALYZE query. And the total number of tuples output so far is
stored in a local variable in ExecutePlan(), so you're have to change
something if you want to get it everywhere...

> Right now I am exploring postgres using ddd ( debugger ).Can
> anyone suggest a better utility /editor/tool for exploring the same in a
> better way ?

Can't help you there, I generally use a combination of grep, less, joe
and gdb but I'm not sure I would recommend that to anyone...

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.