Re: Query progress indication - an implementation - Mailing list pgsql-hackers

From Scara Maccai
Subject Re: Query progress indication - an implementation
Date
Msg-id 743255.30235.qm@web24616.mail.ird.yahoo.com
Whole thread Raw
In response to Query progress indication - an implementation  (Scara Maccai <m_lists@yahoo.it>)
List pgsql-hackers
> IMO
> any
> diagnostics you can provide for a low cost are
> useful.  The more
> detail, the better.  "Step 1 of 10" is good, "80%
> complete on step 1
> of 10" is better.  "80% complete on step 1, 10%
> complete on 10 steps"
> is even better.

Well, I guess  "Step 1 of 10" would be pretty trivial to implement (given the tree plan, how many branches have
finishedexecuting). 
This doesn't tell you anything about the remaining time though.
That is: "Step 1 of 10" doesn't mean that you are at 10%, nor that you are at 50%, or 99%. In fact, I'm afraid it
doesn'ttell you anything... 
I don't understand how useful such an implementation would be... "being
assured that you actually are making forward progress"... in which cases could you not be making forward progress?

Still, this won't take much time: if it's needed by someone else I guess it could be easily done.







pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] user mapping extension to pg_ident.conf
Next
From: David Fetter
Date:
Subject: Multi-Dimensional Histograms