DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
	b=A48MevtmxOkHURfnnRDmUNMuGOYlOKpkQUxpgDX1OvqYUU0tBQRg9HeJuvpjSDllnOLqUvW0dqgxqMnFi4hEkFyV+U5dm9sHibrcxY8ztsC21/qx5v/LhUH9GqXNAuhODVhPGumus6+TN4utjP8QmBe3BT8wZLbHyi3EpSrX/Ng=
Message-ID: <c4a5ac250710100551y51a93372u22e2eba612faf164@mail.gmail.com>
Date: Wed, 10 Oct 2007 13:51:21 +0100
From: "James Shaw" <js102@zepler.net>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: Possible mistake in 'Using EXPLAIN' section
Cc: pgsql-docs@postgresql.org
In-Reply-To: <13020.1192018254@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <c4a5ac250710100406j51c34512k47ef125c32c6f910@mail.gmail.com>
	<13020.1192018254@sss.pgh.pa.us>

On 10/10/2007, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "James Shaw" <js102@zepler.net> writes:
> > The example given has "Seq Scan on tenk1 (cost=0.00..458.00" in the example,
> > but then says, "you will find out that tenk1 has 358 disk pages" and "the
> > cost is estimated at 358 page reads".  Shouldn't this be 458 disk page
> > reads?
>
> No.  Why did you stop reading in mid-sentence?

I'm sorry, I misunderstood.  I've reread, and understand where the
extra 100 comes from now.  Perhaps this could be reworded:

This is about as straightforward as it gets.  If you do
SELECT relpages, reltuples FROM pg_class WHERE relname = 'tenk1';

you will find out that tenk1 has 358 disk pages and 10000 rows.  The
estimated cost is (disk pages read * seq_page_cost) + (number of rows
read * cpu_tuple_cost).  By default, seq_page_cost is 1.0 and
cpu_tuple_cost is 0.01.  Therefore, the estimated cost is (358 * 1.0)
+ (10000 * 0.01) = 458.

Thanks
James