Re: meaning of explain

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: meaning of explain
Дата
Msg-id 20020709081356.V38937-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на meaning of explain  (Auri Mason <amason@syntrex.com>)
Список pgsql-admin
On Tue, 9 Jul 2002, Auri Mason wrote:

> in order to measure the improve of performances after a vacuum+reindex (do
> you suggest something more?), I want to understand exactly the output of
> the explain command.
> After a google search I found a broken link posted by Tom.

As a suggestion, vaccum analyze rather than vacuum to get the stats
updated and I'd suggest checking chapter 11 of the user's guide if you're
using 7.2 which appears to have a section on explain.


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: createuser --password
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: multiple primary keys