Re: Beginner Question - Mailing list pgsql-performance

From Tom Lane
Subject Re: Beginner Question
Date
Msg-id 27869.1176130157@sss.pgh.pa.us
Whole thread Raw
In response to Beginner Question  ("s d" <s.d.sauron@gmail.com>)
List pgsql-performance
"s d" <s.d.sauron@gmail.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

pgsql-performance by date:

Previous
From: "s d"
Date:
Subject: Beginner Question
Next
From: "Alex Deucher"
Date:
Subject: Re: postgres 8.2 seems to prefer Seq Scan