Re: Number of disk pages obtained by explain analyze (fwd)

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Number of disk pages obtained by explain analyze (fwd)
Дата
Msg-id 20020924081520.D93401-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Re: Number of disk pages obtained by explain analyze (fwd)  (Tourtounis Sotiris <tourtoun@csd.uoc.gr>)
Список pgsql-general
On Tue, 24 Sep 2002, Tourtounis Sotiris wrote:

> Thanks for the answer.
>
> The question I have is whether or not explain analyze returns the
> actual disk page access and evaluation time of a query. If not how we
> can mesure them?

It returns evaluation time.  I don't think it returns disk page accesses
specifically, although possibly some of the query statistics in either
the stats generator or one of the verbose logging options would do it (not
sure).


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

Предыдущее
От: Yury Bokhoncovich
Дата:
Сообщение: Re: rotatelog / logrotate with PostgreSQL
Следующее
От: "Peter Darley"
Дата:
Сообщение: Re: Buffer Analysis