A partial index can work perfectly when you test a query with literal values, yet disappear when the same query is executed […]