Bill Moseley <moseley(at)hank(dot)org> writes:
> ws2=> select count(*) from person_role;
> count
> -------
> 123
> (1 row)
> ...
> -> Seq Scan on person_role (cost=0.00..2.83 rows=1 width=4) (actual time=0.130..0.165 rows=1 loops=1)
> Filter: ((role = 2) AND (person = 94))
> Why does it say "Seq Scan" on person_role?
Probably because it doesn't consider that table big enough to warrant
using an index.
regards, tom lane