From: | Peter Hunsberger <peter(dot)hunsberger(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Scara Maccai <m_lists(at)yahoo(dot)it>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Query progress indication - an implementation |
Date: | 2009-06-29 18:55:31 |
Message-ID: | cc159a4a0906291155p3f8232a6n8e18a439fa648784@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Jun 29, 2009 at 1:07 PM, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Josh Berkus <josh(at)agliodbs(dot)com> writes:
>> So, while an actual % completed indicator would be perfect, a "query
>> steps completed, current step =" would still be very useful and a large
>> improvement over what we have now.
>
> I think this is pretty much nonsense --- most queries run all their plan
> nodes concurrently to some extent. You can't usefully say that a query
> is "on" some node, nor measure progress by whether some node is "done".
What you get in Toad for Oracle is the ability to see long running
processes with multiple lines, one per process currently underway. If
I recall correctly, the returned information includes what operation
is underway (eg, physical reads), the % complete, start time, time
remaining and elapsed time. Time remaining has been mostly useless
every time I've had to drill down to this level, but otherwise this
has been relatively useful information.
--
Peter Hunsberger
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-06-29 18:57:59 | Re: [PATCH] [v8.5] Security checks on largeobjects |
Previous Message | Tom Lane | 2009-06-29 18:53:07 | Re: pre-proposal: permissions made easier |