On Sun, 2006-12-10 at 13:00 +0000, Simon Riggs wrote:
> With that requirement in mind, how about something simple like:
>
> explain_analyze_timeout = n
>
> When timeout is reached the EA returns results as if it had finished
> executing normally, though with some additional text to make it very
> clear that the displayed results are partial execution only.
Sounds like a bit of a kludge, IMHO. EXPLAIN ANALYZE isn't designed to
provide online feedback about the execution of a query, which I think is
the real feature here. There has been prior discussion about how to do
online progress indication for queries in general[1] -- I think some
sort of "online EXPLAIN ANALYZE" would be a natural part of such a
feature.
-Neil
[1] http://developer.postgresql.org/index.php/Query_progress_indication