Marcus Engene <mengpg2(at)engene(dot)se> writes:
> -> Index Scan using apa_item_common_x1 on apa_item_common aic
> (cost=0.00..4956.68 rows=1174 width=8) (actual time=19.854..9557.606
> rows=1226 loops=1)
If the table only has 12000 rows then it should never have used an index
scan here at all --- a plain seqscan is usually the best bet for
retrieving 10% of a table. Are you using nondefault planner settings?
How big is the table physically (VACUUM VERBOSE output about it might
tell something)?
regards, tom lane