Re: Wildly erratic query performance

Поиск
Список
Период
Сортировка
От Dennis Brakhane
Тема Re: Wildly erratic query performance
Дата
Msg-id 20081031221635.GA4413@thinky
обсуждение исходный текст
Ответ на Re: Wildly erratic query performance  (Eric Schwarzenbach <subscriber@blackbrook.org>)
Список pgsql-general
Дерево обсуждения 
On Fri, Oct 31, 2008 at 04:36:02PM -0400, Eric Schwarzenbach wrote:
> As I explained already (no pun intended) running the query using EXPLAIN
> makes the wild variation go away. So I cannot get explain results for a
> fast and for a slow execution.

EXPLAIN only determines and outputs the query plan. It does not actually
run the query.

You probably want to use EXPLAIN ANALYZE
Вложения

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Are there plans to add data compression feature to postgresql?
Следующее
От: Ron Mayer
Дата:
Сообщение: Re: Are there plans to add data compression feature to postgresql?