weird EXPLAIN

From: Varun Kacholia <varunk(at)cse(dot)iitb(dot)ac(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: weird EXPLAIN
Date: 2002-06-17 20:01:42
Message-ID: 20020618013423.B4650@voxel.cse.iitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi ,
I have just migrated to PostgreSQL...and found the following wierd :

suryadb=# explain select * from dbwin where id in (select id from wdwin
where word='bacd');
NOTICE: QUERY PLAN:
Seq Scan on dbwin (cost=0.00..8158.20 rows=1000 width=76)
^^^^^^^^^^^^^^^^^^
SubPlan
-> Materialize (cost=8.14..8.14 rows=10 width=4)
-> Index Scan using wdkwin on wdwin (cost=0.00..8.14 rows=10 width=4)

i wanted to know why a sequential scan is done on the field id
while it is a primary key in the table dbwin.this can be clearly
confirmed from the query below :

suryadb=# explain select * from dbwin where id=1234;
NOTICE: QUERY PLAN:
Index Scan using dbwin_pkey on dbwin (cost=0.00..8.14 rows=10 width=76)

why does it do a sequential scan for the query above??
Also i would be happy if someone could explain me the numbers in the
cost thing.. i read the docs....but it is kinda confusing and incomplete.

--
------
Varun
Intel Inside - Idiot outside

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Jenkins 2002-06-17 20:36:41 Re: weird EXPLAIN
Previous Message Darren Ferguson 2002-06-17 19:47:52 Re: Regualer expressions