Re: Indexes not used

"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