criteria = { event_id: '5ea92da4a5522a080614d29f', label_ids: ['6048a3c4b3d10c003c14b22e'], event_campaign_optin: true } Guest.where(criteria).count => 0 (should be 5) ap Guest.where(criteria).explain['queryPlanner'].except('rejectedPlans') result : { "plannerVersion" => 1, "namespace" => "mobicheckin-app.guests", "indexFilterSet" => false, "parsedQuery" => { "$and" => [ [0] { "deleted_at" => { "$eq" => nil } }, [1] { "event_campaign_optin" => { "$eq" => true } }, [2] { "event_id" => { "$eq" => BSON::ObjectId('5ea92da4a5522a080614d29f') } }, [3] { "label_ids" => { "$eq" => [ [0] BSON::ObjectId('6048a3c4b3d10c003c14b22e') ] } } ] }, "winningPlan" => { "stage" => "SORT", "sortPattern" => { "created_at" => -1 }, "inputStage" => { "stage" => "SORT_KEY_GENERATOR", "inputStage" => { "stage" => "FETCH", "filter" => { "$and" => [ [0] { "deleted_at" => { "$eq" => nil } }, [1] { "event_campaign_optin" => { "$eq" => true } }, [2] { "label_ids" => { "$eq" => [ [0] BSON::ObjectId('6048a3c4b3d10c003c14b22e') ] } } ] }, "inputStage" => { "stage" => "IXSCAN", "keyPattern" => { "event_id" => 1, "thematics_quartile" => 1 }, "indexName" => "event_id_1_thematics_quartile_1", "isMultiKey" => false, "multiKeyPaths" => { "event_id" => [], "thematics_quartile" => [] }, "isUnique" => false, "isSparse" => false, "isPartial" => false, "indexVersion" => 1, "direction" => "forward", "indexBounds" => { "event_id" => [ [0] "[ObjectId('5ea92da4a5522a080614d29f'), ObjectId('5ea92da4a5522a080614d29f')]" ], "thematics_quartile" => [ [0] "[MinKey, MaxKey]" ] } } } } } }