Re: Queries not using Index

"Daryl Herzmann" <akrherz@iastate.edu> wrote:
> snet=# select count(valid) from t2002_06;
>   count  
> ---------
>  1513895

> snet=# explain SELECT * from t2002_06 WHERE station = 'SGLI4';
> NOTICE:  QUERY PLAN:
> 
> Seq Scan on t2002_06  (cost=0.00..35379.69 rows=35564 width=47)


Can you do the following query for better understand your situation ?

select count(*) from t2002_06 where station = 'SGLI4';

select count(*) from t2002_06;




Ciao 
Gaetano.