Re: Number of disk pages obtained by explain analyze (fwd) - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Number of disk pages obtained by explain analyze (fwd)
Date
Msg-id 20020924081520.D93401-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: Number of disk pages obtained by explain analyze (fwd)  (Tourtounis Sotiris <tourtoun@csd.uoc.gr>)
List 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 by date:

Previous
From: Yury Bokhoncovich
Date:
Subject: Re: rotatelog / logrotate with PostgreSQL
Next
From: "Peter Darley"
Date:
Subject: Re: Buffer Analysis