Re: Indexes not used - Mailing list pgsql-novice

From Tom Lane
Subject Re: Indexes not used
Date
Msg-id 15082.984688058@sss.pgh.pa.us
Whole thread Raw
In response to Indexes not used  ("D. Duccini" <duccini@backpack.com>)
Responses Re: Indexes not used
List pgsql-novice
"D. Duccini" <duccini@backpack.com> writes:
> # explain select * from radusage where account = 'someuser';

> Seq Scan on radusage  (cost=0.00..13839.67 rows=5757 width=50)

Have you done a VACUUM ANALYZE?

The rows count looks like it might be a default estimate (but I'm just
counting on my fingers to guess that you have about a million rows in
the table).  If the rows count *is* accurate then a seq scan is
probably the right thing to be using...

            regards, tom lane

pgsql-novice by date:

Previous
From: "D. Duccini"
Date:
Subject: Indexes not used
Next
From: "Jeff Williams"
Date:
Subject: PosgreSQL Windows install