Index not being used

From: Ralph Smith <smithrn(at)u(dot)washington(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Index not being used
Date: 2007-08-13 23:25:19
Message-ID: 76FE42D1-7793-41CC-B756-1CA8034C08F8@u.washington.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm confused. Shouldn't this index be used?
(It's running on v7.4.7)

airburst=> \d stats2
Table "public.stats2"
Column | Type | Modifiers
-----------+-----------------------+-----------
lab | character varying(30) |
name | character varying(50) |
status | character varying(40) |
eventtime | integer |
username | character varying(30) |
pkey | character varying(60) |
Indexes:
"stats2_etime_index" btree (eventtime)

airburst=> \d stats2_etime_index
Index "public.stats2_etime_index"
Column | Type
-----------+---------
eventtime | integer
btree, for table "public.stats2"

airburst=> explain select count(*) from stats2 where eventtime >
1167638400 ;
QUERY PLAN
-----------------------------------------------------------------------
Aggregate (cost=185247.97..185247.97 rows=1 width=0)
-> Seq Scan on stats2 (cost=0.00..179622.45 rows=2250205 width=0)
Filter: (eventtime > 1167638400)
(3 rows)

Thanks,
Ralph

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-08-13 23:39:46 Re: Index not being used
Previous Message Peter Childs 2007-08-13 22:11:06 Re: Reordering columns, will this ever be simple?