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)