MongoDB seems to use different index than it chooses when using explain I have a query indexes like below in a fairly large collection: