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

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Tourtounis Sotiris <tourtoun(at)csd(dot)uoc(dot)gr>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Number of disk pages obtained by explain analyze (fwd)
Date: 2002-09-24 15:16:28
Message-ID: 20020924081520.D93401-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ross J. Reedstrom 2002-09-24 15:19:49 Re: [GENERAL] CURRENT_TIMESTAMP
Previous Message Ross J. Reedstrom 2002-09-24 15:10:03 Re: [GENERAL] CURRENT_TIMESTAMP