Re: Query performance

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: Query performance
Дата
Msg-id 2f4958ff0910120640q1f56fcbfg922573a8594320a6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query performance  (Matthew Wakeling <matthew@flymine.org>)
Список pgsql-performance


2009/10/12 Matthew Wakeling <matthew@flymine.org>
This is an EXPLAIN, not an EXPLAIN ANALYSE. If it was an EXPLAIN ANALYSE, it would show how much memory was used, and whether it was a disc sort or an in-memory sort. As it is only an EXPLAIN, the query hasn't actually been run, and we have no information about whether the sort would be performed on disc or not.
 
true, I was looking at it as if it was explain analyze output :)
sorry.

--
GJ

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

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: Re: Query performance
Следующее
От: Cédric Villemain
Дата:
Сообщение: Re: Best suiting OS