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.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
