Re: Beginner Question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "s d" <s(dot)d(dot)sauron(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Beginner Question
Date: 2007-04-09 14:49:17
Message-ID: 27869.1176130157@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"s d" <s(dot)d(dot)sauron(at)gmail(dot)com> writes:
> 1. i can undestand where the cost=11.53 came from but where did the
> 1192.09 come form? The values are in milli right ?

No, the unit of estimated cost is 1 disk page fetch. See
http://www.postgresql.org/docs/8.2/static/using-explain.html

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alex Deucher 2007-04-09 18:43:55 Re: postgres 8.2 seems to prefer Seq Scan
Previous Message Jan de Visser 2007-04-09 11:51:53 Re: Beginner Question