>
> The plan for the query is this:
>
> "Seq Scan on lists (cost=0.00..16.88 rows=3 width=86) (actual
> time=0.006..0.008 rows=1 loops=1)"
> " Filter: (hits @> '{7}'::integer[])"
> "Planning time: 0.058 ms"
> "Execution time: 0.025 ms"
>
> What am I doing wrong?
>
> Tim
>
With so few rows to read, it is actually slower to do a index scan followed by the table scan (in order to actually read the data).
Thats why it is using a seq scan.
Gerardo