"Daryl Herzmann" <akrherz(at)iastate(dot)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.