| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: EXPLAIN ANALYZE |
| Date: | 2006-12-10 14:28:23 |
| Message-ID: | 1165760903.21592.47.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Inaam Rana | 2006-12-10 14:49:08 | Re: Load distributed checkpoint |
| Previous Message | Simon Riggs | 2006-12-10 13:00:06 | Re: EXPLAIN ANALYZE |