EXPLAIN ANALYZE not considering primary and unique indices!

From: Sanjay <skpatel20(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: EXPLAIN ANALYZE not considering primary and unique indices!
Date: 2007-08-27 12:21:48
Message-ID: 1188217308.576102.165830@e9g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

Say I have a simple table WEBSITE(website_id int4 PRIMARY KEY, name
VARCHAR(30)). While I try this:

EXPLAIN ANALYZE SELECT * FROM WEBSITE WHERE website_id = 1

the output is:
--------------------------------------------------------------------------------------
Seq Scan on website (cost=0.00..1.31 rows=1 width=162) (actual
time=0.047..0.051 rows=1 loops=1)
Filter: (website_id = 1)
Total runtime: 0.102 ms
---------------------------------------------------------------------------------------
Wondering why it is not using the index, which would have been
automatically created for the primary key.

Needing help.

thanks
Sanjay

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2007-08-27 12:23:38 Re: simple query runs 26 seconds
Previous Message Marcelo de Moraes Serpa 2007-08-27 11:44:56 Re: create or replace for tables and schemas