| Lists: | pgsql-hackers |
|---|
| From: | Scara Maccai <m_lists(at)yahoo(dot)it> |
|---|---|
| To: | Peter Hunsberger <peter(dot)hunsberger(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Query progress indication - an implementation |
| Date: | 2009-06-29 16:20:46 |
| Message-ID: | 743255.30235.qm@web24616.mail.ird.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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 finished executing).
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't tell 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.