Received: from pns.mm.eutelsat.org (pns.mm.eutelsat.org [194.214.173.227])
	by postgresql.org (Postfix) with ESMTP id 1C3D2475B26
	for <pgsql-sql@postgresql.org>; Tue, 23 Jul 2002 08:54:21 -0400 (EDT)
Received: from nts-03.mm.eutelsat.org (localhost [127.0.0.1])
	by pns.mm.eutelsat.org (8.11.6/linuxconf) with ESMTP id g6NCsHC13838;
	Tue, 23 Jul 2002 14:54:17 +0200
Received: from dell-01.mm.eutelsat.org (IDENT:root@dell-01.mm.eutelsat.org
	[194.214.173.17])
	by nts-03.mm.eutelsat.org (8.9.3/8.8.7) with ESMTP id NAA27346;
	Tue, 23 Jul 2002 13:47:53 +0200
Received: from GMENDOLA2 (gmendola2.mm.eutelsat.org [194.214.173.26])
	by dell-01.mm.eutelsat.org (8.11.2/8.8.7) with SMTP id g6NCrlc30010;
	Tue, 23 Jul 2002 14:53:47 +0200
Message-ID: <000e01c23248$5c3bc410$d60ffea9@GMENDOLA2>
From: "Gaetano Mendola" <mendola@bigfoot.com>
To: "Daryl Herzmann" <akrherz@iastate.edu>,
	<pgsql-sql@postgresql.org>
References: 
 <Pine.LNX.4.44.0207221340470.31790-100000@akrherz.agron.iastate.edu>
Subject: Re: Queries not using Index
Date: Tue, 23 Jul 2002 14:56:28 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Archive-Number: 200207/348
X-Sequence-Number: 8726

"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.