(Oh - rows - I think you're reading the explain *estimated* row count, not the *actual* row count). Here is the original queries outer line of the plan:
Limit (cost=294364.63..296495.59 rows=200 width=76) (actual time=994.854..1063.958 rows=4 loops=1)
note the actual row count is 4, only the estimate is 200.
(Oh - rows - I think you're reading the explain *estimated* row count, not the *actual* row count). Here is the original queries outer line of the plan: 63..296495. 59 rows=200 width=76) (actual time=994. 854..1063. 958 rows=4 loops=1)
Limit (cost=294364.
note the actual row count is 4, only the estimate is 200.