Re: EXPLAIN ANALYZE
От | Neil Conway |
---|---|
Тема | Re: EXPLAIN ANALYZE |
Дата | |
Msg-id | 1165760903.21592.47.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: EXPLAIN ANALYZE ("Simon Riggs" <simon@2ndquadrant.com>) |
Ответы |
Re: EXPLAIN ANALYZE
|
Список | 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
В списке pgsql-hackers по дате отправления: