Re: Question about a query plan - Mailing list pgsql-general

Bill Moseley <moseley@hank.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