Обсуждение: Re: Number of disk pages obtained by explain analyze (fwd)

Поиск
Список
Период
Сортировка

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

От
Tourtounis Sotiris
Дата:
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?



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

От
Stephan Szabo
Дата:
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).