BUG #14015: Query Plan not optimal

The following bug has been logged on the website:

Bug reference:      14015
Logged by:          Jamie Koceniak
Email address:      jkoceniak@mediamath.com
PostgreSQL version: 9.4.6
Operating system:   Linux - Debian
Description:

One of our queries seems to have reverted back to an old query plan after
updating from 9.4.5 to 9.4.6.

9.4.6 execution time: 1045.368 ms
9.4.5 Execution time: 0.276 ms

We experienced the same issue with version 9.1 where the index scan is
looping too much

Bad plan:
Index Scan using idx1 on orders    (cost=0.29..6.38 rows=11 width=25)
(actual time=0.002..0.003 rows=1 loops=103015)