"D. Duccini" <duccini(at)backpack(dot)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