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

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

From
Tourtounis Sotiris
Date:
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)

From
Stephan Szabo
Date:
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).