Thumbs up on this from a lurker.
I recall a previous post about some sort of "progress bar" hack that
would show you where in a plan a currently executing query was at. Has
any work been done on this?
Josh Reich
Jim C. Nasby wrote:
> On Mon, Dec 11, 2006 at 12:24:12AM +0100, Peter Eisentraut wrote:
>
>> Simon Riggs wrote:
>>
>>> Well, I'd like a way of making EXPLAIN ANALYZE return something
>>> useful within a reasonable amount of time. We can define that as the
>>> amount of time that the user considers is their goal for the query.
>>>
>> What sort of "useful" results would you expect to be able to see from
>> such an aborted EXPLAIN ANALYZE? I cannot quite imagine what
>> instructive value a partially executed plan output would have. It's
>> not like we can somehow ensure executing an equal proportion of each
>> plan node or something. Do you have a specific case in mind?
>>
>
> The query is most likely to get canceled while it is working on whatever
> node in the plan is the bottleneck, and it's likely going to be easy to
> spot since nodes above it wouldn't have gotten much done.
>