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