| 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: | Whole Thread | Raw Message | 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
| 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 |