Hi! Thanks for your help!
On Tue, 23 Jul 2002, Gaetano Mendola wrote: >"Daryl Herzmann" <[EMAIL PROTECTED]> 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'; snet=# select count(*) from t2002_06 where station = 'SGLI4'; count ------- 39319 >select count(*) from t2002_06; snet=# select count(*) from t2002_06; count --------- 1513895 In another email, it was suggested that I do this... snet=# explain analyze select * from t2002_06 WHERE station = 'SAMI4'; NOTICE: QUERY PLAN: Seq Scan on t2002_06 (cost=0.00..35379.69 rows=34979 width=47) (actual time=67.89..3734.93 rows=38146 loops=1) Total runtime: 3748.33 msec EXPLAIN snet=# set enable_seqscan=off; SET VARIABLE snet=# explain analyze select * from t2002_06 WHERE station = 'SAMI4'; NOTICE: QUERY PLAN: Index Scan using t2002_06_station_idx on t2002_06 (cost=0.00..132124.96 rows=34979 width=47) (actual time=72.03..298.85 rows=38146 loops=1) Total runtime: 317.76 msec EXPLAIN Thanks so much! Daryl ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
