Re: EXPLAIN ANALYZE

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: EXPLAIN ANALYZE
Дата
Msg-id 200612110024.13036.peter_e@gmx.net
обсуждение исходный текст
Ответ на Re: EXPLAIN ANALYZE  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: EXPLAIN ANALYZE  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-hackers
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?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: postgresql roadmap for horizontal scalability?
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: EXPLAIN ANALYZE