This is the 100-member case of SERVER-82548, which executes very quickly. Adding one extra member to the array becomes very slow. XXX = anonymized data { "explainVersion": "2", "queryPlanner": { "namespace": "XXX_production.reservations", "indexFilterSet": false, "parsedQuery": { "$and": [ { "deleted_at": { "$eq": null } }, { "_id": { "$in": [ "XXXXX19070f78ebe16000260", "XXXXX19370f78ebe16000263", "XXXXX19570f78ebe16000268", "XXXXX19770f78ebe1600026c", "XXXXX19870f78ebe16000271", "XXXXX19a70f78ebe16000277", "XXXXX19b70f78ebe16000278", "XXXXX19d70f78ebe16000280", "XXXXX19f70f78ebe16000286", "XXXXX1a070f78ebe1600028d", "XXXXX1a170f78ebe16000293", "XXXXX1a470f78ebe1600029a", "XXXXX1a670f78ebe1600029e", "XXXXX1a870f78ebe160002a3", "XXXXX1aa70f78ebe160002a6", "XXXXX1ac70f78ebe160002ab", "XXXXX1af70f78ebe160002ae", "XXXXX1b170f78ebe160002b1", "XXXXX1b470f78ebe160002b4", "XXXXX1b670f78ebe160002ba", "XXXXX1b770f78ebe160002bd", "XXXXX1b870f78ebe160002c2", "XXXXX1bb70f78ebe160002c4", "XXXXX1c070f78ebe160002c9", "XXXXX1c170f78ebe160002cf", "XXXXX1c470f78ebe160002d1", "XXXXX1c770f78ebe160002d8", "XXXXX1c970f78ebe160002dd", "XXXXX1cb70f78ebe160002e2", "XXXXX1cf70f78ebe160002ec", "XXXXX1d170f78ebe160002f0", "XXXXX1d370f78ebe160002f2", "XXXXX1d570f78ebe160002f4", "XXXXX1d870f78ebe160002f7", "XXXXX1dc70f78ebe160002fc", "XXXXX1dd70f78ebe16000301", "XXXXX1e270f78ebe16000303", "XXXXX1e470f78ebe16000307", "XXXXX1e670f78ebe16000309", "XXXXX1e870f78ebe16000313", "XXXXX1ec70f78ebe16000316", "XXXXX1ed70f78ebe1600031b", "XXXXX1f070f78ebe1600031f", "XXXXX1f470f78ebe16000321", "XXXXX1f670f78ebe16000326", "XXXXX1f870f78ebe1600032b", "XXXXX1fb70f78ebe1600032c", "XXXXX1fd70f78ebe16000332", "XXXXX1fe70f78ebe16000337", "XXXXX20270f78ebe1600033b", "XXXXX20670f78ebe16000341", "XXXXX20870f78ebe16000346", "XXXXX20b70f78ebe16000348", "XXXXX20e70f78ebe16000350", "XXXXX21070f78ebe16000355", "XXXXX21170f78ebe16000359", "XXXXX21270f78ebe1600035a", "XXXXX21470f78ebe1600035d", "XXXXX21570f78ebe16000366", "XXXXX21870f78ebe1600036c", "XXXXX21a70f78ebe1600036f", "XXXXX21c70f78ebe16000370", "XXXXX21f70f78ebe16000372", "XXXXX22070f78ebe16000376", "XXXXX22270f78ebe1600037c", "XXXXX22470f78ebe1600037d", "XXXXX22570f78ebe16000380", "XXXXX22770f78ebe16000383", "XXXXX22b70f78ebe16000387", "XXXXX22c70f78ebe1600038b", "XXXXX22e70f78ebe16000392", "XXXXX23070f78ebe16000397", "XXXXX23470f78ebe1600039d", "XXXXX23570f78ebe160003a3", "XXXXX23770f78ebe160003a7", "XXXXX23870f78ebe160003ac", "XXXXX23b70f78ebe160003af", "XXXXX23d70f78ebe160003b5", "XXXXX23f70f78ebe160003bb", "XXXXX24170f78ebe160003c3", "XXXXX24270f78ebe160003c7", "XXXXX24370f78ebe160003cb", "XXXXX24570f78ebe160003cd", "XXXXX24970f78ebe160003d2", "XXXXX24d70f78ebe160003d7", "XXXXX25070f78ebe160003d9", "XXXXX25470f78ebe160003da", "XXXXX25670f78ebe160003df", "XXXXX25870f78ebe160003e2", "XXXXX25970f78ebe160003e6", "XXXXX25d70f78ebe160003f0", "XXXXX25f70f78ebe160003f2", "XXXXX26170f78ebe160003f6", "XXXXX26370f78ebe160003fb", "XXXXX26670f78ebe16000402", "XXXXX26870f78ebe16000406", "XXXXX26d70f78ebe1600040d", "XXXXX28170f78ebe16000422", "XXXXX28c70f78ebe16000438", "XXXXX29370f78ebe16000446" ] } } ] }, "queryHash": "9144BF3E", "planCacheKey": "3BDB9717", "maxIndexedOrSolutionsReached": false, "maxIndexedAndSolutionsReached": false, "maxScansToExplodeReached": false, "winningPlan": { "queryPlan": { "stage": "SORT", "planNodeId": 3, "sortPattern": { "shop_id": 1, "st": 1 }, "memLimit": 104857600, "type": "simple", "inputStage": { "stage": "FETCH", "planNodeId": 2, "filter": { "deleted_at": { "$eq": null } }, "inputStage": { "stage": "IXSCAN", "planNodeId": 1, "keyPattern": { "_id": 1 }, "indexName": "_id_", "isMultiKey": false, "isUnique": true, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "forward", "indexBounds": { "_id": [ "[ObjectId('XXXXX19070f78ebe16000260'), ObjectId('XXXXX19070f78ebe16000260')]", "[ObjectId('XXXXX19370f78ebe16000263'), ObjectId('XXXXX19370f78ebe16000263')]", "[ObjectId('XXXXX19570f78ebe16000268'), ObjectId('XXXXX19570f78ebe16000268')]", "[ObjectId('XXXXX19770f78ebe1600026c'), ObjectId('XXXXX19770f78ebe1600026c')]", "[ObjectId('XXXXX19870f78ebe16000271'), ObjectId('XXXXX19870f78ebe16000271')]", "[ObjectId('XXXXX19a70f78ebe16000277'), ObjectId('XXXXX19a70f78ebe16000277')]", "[ObjectId('XXXXX19b70f78ebe16000278'), ObjectId('XXXXX19b70f78ebe16000278')]", "[ObjectId('XXXXX19d70f78ebe16000280'), ObjectId('XXXXX19d70f78ebe16000280')]", "[ObjectId('XXXXX19f70f78ebe16000286'), ObjectId('XXXXX19f70f78ebe16000286')]", "[ObjectId('XXXXX1a070f78ebe1600028d'), ObjectId('XXXXX1a070f78ebe1600028d')]", "[ObjectId('XXXXX1a170f78ebe16000293'), ObjectId('XXXXX1a170f78ebe16000293')]", "[ObjectId('XXXXX1a470f78ebe1600029a'), ObjectId('XXXXX1a470f78ebe1600029a')]", "[ObjectId('XXXXX1a670f78ebe1600029e'), ObjectId('XXXXX1a670f78ebe1600029e')]", "[ObjectId('XXXXX1a870f78ebe160002a3'), ObjectId('XXXXX1a870f78ebe160002a3')]", "[ObjectId('XXXXX1aa70f78ebe160002a6'), ObjectId('XXXXX1aa70f78ebe160002a6')]", "[ObjectId('XXXXX1ac70f78ebe160002ab'), ObjectId('XXXXX1ac70f78ebe160002ab')]", "[ObjectId('XXXXX1af70f78ebe160002ae'), ObjectId('XXXXX1af70f78ebe160002ae')]", "[ObjectId('XXXXX1b170f78ebe160002b1'), ObjectId('XXXXX1b170f78ebe160002b1')]", "[ObjectId('XXXXX1b470f78ebe160002b4'), ObjectId('XXXXX1b470f78ebe160002b4')]", "[ObjectId('XXXXX1b670f78ebe160002ba'), ObjectId('XXXXX1b670f78ebe160002ba')]", "[ObjectId('XXXXX1b770f78ebe160002bd'), ObjectId('XXXXX1b770f78ebe160002bd')]", "[ObjectId('XXXXX1b870f78ebe160002c2'), ObjectId('XXXXX1b870f78ebe160002c2')]", "[ObjectId('XXXXX1bb70f78ebe160002c4'), ObjectId('XXXXX1bb70f78ebe160002c4')]", "[ObjectId('XXXXX1c070f78ebe160002c9'), ObjectId('XXXXX1c070f78ebe160002c9')]", "[ObjectId('XXXXX1c170f78ebe160002cf'), ObjectId('XXXXX1c170f78ebe160002cf')]", "[ObjectId('XXXXX1c470f78ebe160002d1'), ObjectId('XXXXX1c470f78ebe160002d1')]", "[ObjectId('XXXXX1c770f78ebe160002d8'), ObjectId('XXXXX1c770f78ebe160002d8')]", "[ObjectId('XXXXX1c970f78ebe160002dd'), ObjectId('XXXXX1c970f78ebe160002dd')]", "[ObjectId('XXXXX1cb70f78ebe160002e2'), ObjectId('XXXXX1cb70f78ebe160002e2')]", "[ObjectId('XXXXX1cf70f78ebe160002ec'), ObjectId('XXXXX1cf70f78ebe160002ec')]", "[ObjectId('XXXXX1d170f78ebe160002f0'), ObjectId('XXXXX1d170f78ebe160002f0')]", "[ObjectId('XXXXX1d370f78ebe160002f2'), ObjectId('XXXXX1d370f78ebe160002f2')]", "[ObjectId('XXXXX1d570f78ebe160002f4'), ObjectId('XXXXX1d570f78ebe160002f4')]", "[ObjectId('XXXXX1d870f78ebe160002f7'), ObjectId('XXXXX1d870f78ebe160002f7')]", "[ObjectId('XXXXX1dc70f78ebe160002fc'), ObjectId('XXXXX1dc70f78ebe160002fc')]", "[ObjectId('XXXXX1dd70f78ebe16000301'), ObjectId('XXXXX1dd70f78ebe16000301')]", "[ObjectId('XXXXX1e270f78ebe16000303'), ObjectId('XXXXX1e270f78ebe16000303')]", "[ObjectId('XXXXX1e470f78ebe16000307'), ObjectId('XXXXX1e470f78ebe16000307')]", "[ObjectId('XXXXX1e670f78ebe16000309'), ObjectId('XXXXX1e670f78ebe16000309')]", "[ObjectId('XXXXX1e870f78ebe16000313'), ObjectId('XXXXX1e870f78ebe16000313')]", "[ObjectId('XXXXX1ec70f78ebe16000316'), ObjectId('XXXXX1ec70f78ebe16000316')]", "[ObjectId('XXXXX1ed70f78ebe1600031b'), ObjectId('XXXXX1ed70f78ebe1600031b')]", "[ObjectId('XXXXX1f070f78ebe1600031f'), ObjectId('XXXXX1f070f78ebe1600031f')]", "[ObjectId('XXXXX1f470f78ebe16000321'), ObjectId('XXXXX1f470f78ebe16000321')]", "[ObjectId('XXXXX1f670f78ebe16000326'), ObjectId('XXXXX1f670f78ebe16000326')]", "[ObjectId('XXXXX1f870f78ebe1600032b'), ObjectId('XXXXX1f870f78ebe1600032b')]", "[ObjectId('XXXXX1fb70f78ebe1600032c'), ObjectId('XXXXX1fb70f78ebe1600032c')]", "[ObjectId('XXXXX1fd70f78ebe16000332'), ObjectId('XXXXX1fd70f78ebe16000332')]", "[ObjectId('XXXXX1fe70f78ebe16000337'), ObjectId('XXXXX1fe70f78ebe16000337')]", "[ObjectId('XXXXX20270f78ebe1600033b'), ObjectId('XXXXX20270f78ebe1600033b')]", "[ObjectId('XXXXX20670f78ebe16000341'), ObjectId('XXXXX20670f78ebe16000341')]", "[ObjectId('XXXXX20870f78ebe16000346'), ObjectId('XXXXX20870f78ebe16000346')]", "[ObjectId('XXXXX20b70f78ebe16000348'), ObjectId('XXXXX20b70f78ebe16000348')]", "[ObjectId('XXXXX20e70f78ebe16000350'), ObjectId('XXXXX20e70f78ebe16000350')]", "[ObjectId('XXXXX21070f78ebe16000355'), ObjectId('XXXXX21070f78ebe16000355')]", "[ObjectId('XXXXX21170f78ebe16000359'), ObjectId('XXXXX21170f78ebe16000359')]", "[ObjectId('XXXXX21270f78ebe1600035a'), ObjectId('XXXXX21270f78ebe1600035a')]", "[ObjectId('XXXXX21470f78ebe1600035d'), ObjectId('XXXXX21470f78ebe1600035d')]", "[ObjectId('XXXXX21570f78ebe16000366'), ObjectId('XXXXX21570f78ebe16000366')]", "[ObjectId('XXXXX21870f78ebe1600036c'), ObjectId('XXXXX21870f78ebe1600036c')]", "[ObjectId('XXXXX21a70f78ebe1600036f'), ObjectId('XXXXX21a70f78ebe1600036f')]", "[ObjectId('XXXXX21c70f78ebe16000370'), ObjectId('XXXXX21c70f78ebe16000370')]", "[ObjectId('XXXXX21f70f78ebe16000372'), ObjectId('XXXXX21f70f78ebe16000372')]", "[ObjectId('XXXXX22070f78ebe16000376'), ObjectId('XXXXX22070f78ebe16000376')]", "[ObjectId('XXXXX22270f78ebe1600037c'), ObjectId('XXXXX22270f78ebe1600037c')]", "[ObjectId('XXXXX22470f78ebe1600037d'), ObjectId('XXXXX22470f78ebe1600037d')]", "[ObjectId('XXXXX22570f78ebe16000380'), ObjectId('XXXXX22570f78ebe16000380')]", "[ObjectId('XXXXX22770f78ebe16000383'), ObjectId('XXXXX22770f78ebe16000383')]", "[ObjectId('XXXXX22b70f78ebe16000387'), ObjectId('XXXXX22b70f78ebe16000387')]", "[ObjectId('XXXXX22c70f78ebe1600038b'), ObjectId('XXXXX22c70f78ebe1600038b')]", "[ObjectId('XXXXX22e70f78ebe16000392'), ObjectId('XXXXX22e70f78ebe16000392')]", "[ObjectId('XXXXX23070f78ebe16000397'), ObjectId('XXXXX23070f78ebe16000397')]", "[ObjectId('XXXXX23470f78ebe1600039d'), ObjectId('XXXXX23470f78ebe1600039d')]", "[ObjectId('XXXXX23570f78ebe160003a3'), ObjectId('XXXXX23570f78ebe160003a3')]", "[ObjectId('XXXXX23770f78ebe160003a7'), ObjectId('XXXXX23770f78ebe160003a7')]", "[ObjectId('XXXXX23870f78ebe160003ac'), ObjectId('XXXXX23870f78ebe160003ac')]", "[ObjectId('XXXXX23b70f78ebe160003af'), ObjectId('XXXXX23b70f78ebe160003af')]", "[ObjectId('XXXXX23d70f78ebe160003b5'), ObjectId('XXXXX23d70f78ebe160003b5')]", "[ObjectId('XXXXX23f70f78ebe160003bb'), ObjectId('XXXXX23f70f78ebe160003bb')]", "[ObjectId('XXXXX24170f78ebe160003c3'), ObjectId('XXXXX24170f78ebe160003c3')]", "[ObjectId('XXXXX24270f78ebe160003c7'), ObjectId('XXXXX24270f78ebe160003c7')]", "[ObjectId('XXXXX24370f78ebe160003cb'), ObjectId('XXXXX24370f78ebe160003cb')]", "[ObjectId('XXXXX24570f78ebe160003cd'), ObjectId('XXXXX24570f78ebe160003cd')]", "[ObjectId('XXXXX24970f78ebe160003d2'), ObjectId('XXXXX24970f78ebe160003d2')]", "[ObjectId('XXXXX24d70f78ebe160003d7'), ObjectId('XXXXX24d70f78ebe160003d7')]", "[ObjectId('XXXXX25070f78ebe160003d9'), ObjectId('XXXXX25070f78ebe160003d9')]", "[ObjectId('XXXXX25470f78ebe160003da'), ObjectId('XXXXX25470f78ebe160003da')]", "[ObjectId('XXXXX25670f78ebe160003df'), ObjectId('XXXXX25670f78ebe160003df')]", "[ObjectId('XXXXX25870f78ebe160003e2'), ObjectId('XXXXX25870f78ebe160003e2')]", "[ObjectId('XXXXX25970f78ebe160003e6'), ObjectId('XXXXX25970f78ebe160003e6')]", "[ObjectId('XXXXX25d70f78ebe160003f0'), ObjectId('XXXXX25d70f78ebe160003f0')]", "[ObjectId('XXXXX25f70f78ebe160003f2'), ObjectId('XXXXX25f70f78ebe160003f2')]", "[ObjectId('XXXXX26170f78ebe160003f6'), ObjectId('XXXXX26170f78ebe160003f6')]", "[ObjectId('XXXXX26370f78ebe160003fb'), ObjectId('XXXXX26370f78ebe160003fb')]", "[ObjectId('XXXXX26670f78ebe16000402'), ObjectId('XXXXX26670f78ebe16000402')]", "[ObjectId('XXXXX26870f78ebe16000406'), ObjectId('XXXXX26870f78ebe16000406')]", "[ObjectId('XXXXX26d70f78ebe1600040d'), ObjectId('XXXXX26d70f78ebe1600040d')]", "[ObjectId('XXXXX28170f78ebe16000422'), ObjectId('XXXXX28170f78ebe16000422')]", "[ObjectId('XXXXX28c70f78ebe16000438'), ObjectId('XXXXX28c70f78ebe16000438')]", "[ObjectId('XXXXX29370f78ebe16000446'), ObjectId('XXXXX29370f78ebe16000446')]" ] } } } }, "slotBasedPlan": { "slots": "$$RESULT=s26 env: { s2 = Nothing (SEARCH_META), s10 = {\"_id\" : 1}, s14 = [{\"l\" : KS(64XXXXX19070F78EBE160002600104), \"h\" : KS(64XXXXX19070F78EBE16000260FE04)}, {\"l\" : KS(64XXXXX19370F78EBE160002630104), \"h\" : KS(64XXXXX19370F78EBE16000263FE04)}, {\"l\" : KS(64XXXXX19570F78EBE160002680104), \"h\" : KS(64XXXXX19570F78EBE16000268FE04)}, {\"l\" : KS(64XXXXX19770F78EBE1600026C0104), \"h\" : KS(64XXXXX19770F78EBE1600026CFE04)}, {\"l\" : KS(64XXXXX19870F78EBE160002710104), \"h\" : KS(64XXXXX19870F78EBE16000271FE04)}, {\"l\" : KS(64XXXXX19A70F78EBE160002770104), \"h\" : KS(64XXXXX19A70F78EBE16000277FE04)}, {\"l\" : KS(64XXXXX19B70F78EBE160002780104), \"h\" : KS(64XXXXX19B70F78EBE16000278FE04)}, {\"l\" : KS(64XXXXX19D70F78EBE160002800104), \"h\" : KS(64XXXXX19D70F78EBE16000280FE04)}, {...}, ...], s25 = false, s3 = Timestamp(1698595935, 11) (CLUSTER_TIME), s6 = Nothing, s1 = TimeZoneDatabase(US/Arizona...Asia/Ujung_Pandang) (timeZoneDB), s4 = 1698595935293 (NOW) }", "stages": "[3] sort [s32, s33] [asc, asc] [s26] \n[3] project [s32 = \n if (isArray(s28) ?: false) \n then (_internalLeast(s28) ?: undefined) \n else (s28 ?: null) \n, s33 = \n if (isArray(s29) ?: false) \n then (_internalLeast(s29) ?: undefined) \n else (s29 ?: null) \n] \n[3] project [s31 = (!((isArray(s28) ?: false)) || (!((isArray(s29) ?: false)) || fail(2, \"cannot sort with keys that are parallel arrays\")))] \n[2] filter {traverseF(s30, lambda(l1.0) { ((\n if (typeMatch(l1.0, 1088ll) ?: true) \n then null \n else l1.0 \n== null) ?: false) }, false)} \n[2] nlj inner [] [s20, s21, s22, s23, s24] \n left \n [1] branch {s25} [s20, s21, s22, s23, s24] \n [s5, s7, s8, s9, s10] [1] ixscan_generic s6 s9 s5 s7 s8 lowPriority [] @\"c877ec6d-fc21-491e-b571-cba824619e81\" @\"_id_\" true \n [s11, s17, s18, s19, s10] [1] nlj inner [] [s12, s13] \n left \n [1] project [s12 = getField(s15, \"l\"), s13 = getField(s15, \"h\")] \n [1] unwind s15 s16 s14 false \n [1] limit 1 \n [1] coscan \n right \n [1] ixseek s12 s13 s19 s11 s17 s18 [] @\"c877ec6d-fc21-491e-b571-cba824619e81\" @\"_id_\" true \n right \n [2] limit 1 \n [2] seek s20 s26 s27 s21 s22 s23 s24 [s28 = shop_id, s29 = st, s30 = deleted_at] @\"c877ec6d-fc21-491e-b571-cba824619e81\" true false \n" } }, "rejectedPlans": [ { "queryPlan": { "stage": "FETCH", "planNodeId": 2, "filter": { "$and": [ { "deleted_at": { "$eq": null } }, { "_id": { "$in": [ "XXXXX19070f78ebe16000260", "XXXXX19370f78ebe16000263", "XXXXX19570f78ebe16000268", "XXXXX19770f78ebe1600026c", "XXXXX19870f78ebe16000271", "XXXXX19a70f78ebe16000277", "XXXXX19b70f78ebe16000278", "XXXXX19d70f78ebe16000280", "XXXXX19f70f78ebe16000286", "XXXXX1a070f78ebe1600028d", "XXXXX1a170f78ebe16000293", "XXXXX1a470f78ebe1600029a", "XXXXX1a670f78ebe1600029e", "XXXXX1a870f78ebe160002a3", "XXXXX1aa70f78ebe160002a6", "XXXXX1ac70f78ebe160002ab", "XXXXX1af70f78ebe160002ae", "XXXXX1b170f78ebe160002b1", "XXXXX1b470f78ebe160002b4", "XXXXX1b670f78ebe160002ba", "XXXXX1b770f78ebe160002bd", "XXXXX1b870f78ebe160002c2", "XXXXX1bb70f78ebe160002c4", "XXXXX1c070f78ebe160002c9", "XXXXX1c170f78ebe160002cf", "XXXXX1c470f78ebe160002d1", "XXXXX1c770f78ebe160002d8", "XXXXX1c970f78ebe160002dd", "XXXXX1cb70f78ebe160002e2", "XXXXX1cf70f78ebe160002ec", "XXXXX1d170f78ebe160002f0", "XXXXX1d370f78ebe160002f2", "XXXXX1d570f78ebe160002f4", "XXXXX1d870f78ebe160002f7", "XXXXX1dc70f78ebe160002fc", "XXXXX1dd70f78ebe16000301", "XXXXX1e270f78ebe16000303", "XXXXX1e470f78ebe16000307", "XXXXX1e670f78ebe16000309", "XXXXX1e870f78ebe16000313", "XXXXX1ec70f78ebe16000316", "XXXXX1ed70f78ebe1600031b", "XXXXX1f070f78ebe1600031f", "XXXXX1f470f78ebe16000321", "XXXXX1f670f78ebe16000326", "XXXXX1f870f78ebe1600032b", "XXXXX1fb70f78ebe1600032c", "XXXXX1fd70f78ebe16000332", "XXXXX1fe70f78ebe16000337", "XXXXX20270f78ebe1600033b", "XXXXX20670f78ebe16000341", "XXXXX20870f78ebe16000346", "XXXXX20b70f78ebe16000348", "XXXXX20e70f78ebe16000350", "XXXXX21070f78ebe16000355", "XXXXX21170f78ebe16000359", "XXXXX21270f78ebe1600035a", "XXXXX21470f78ebe1600035d", "XXXXX21570f78ebe16000366", "XXXXX21870f78ebe1600036c", "XXXXX21a70f78ebe1600036f", "XXXXX21c70f78ebe16000370", "XXXXX21f70f78ebe16000372", "XXXXX22070f78ebe16000376", "XXXXX22270f78ebe1600037c", "XXXXX22470f78ebe1600037d", "XXXXX22570f78ebe16000380", "XXXXX22770f78ebe16000383", "XXXXX22b70f78ebe16000387", "XXXXX22c70f78ebe1600038b", "XXXXX22e70f78ebe16000392", "XXXXX23070f78ebe16000397", "XXXXX23470f78ebe1600039d", "XXXXX23570f78ebe160003a3", "XXXXX23770f78ebe160003a7", "XXXXX23870f78ebe160003ac", "XXXXX23b70f78ebe160003af", "XXXXX23d70f78ebe160003b5", "XXXXX23f70f78ebe160003bb", "XXXXX24170f78ebe160003c3", "XXXXX24270f78ebe160003c7", "XXXXX24370f78ebe160003cb", "XXXXX24570f78ebe160003cd", "XXXXX24970f78ebe160003d2", "XXXXX24d70f78ebe160003d7", "XXXXX25070f78ebe160003d9", "XXXXX25470f78ebe160003da", "XXXXX25670f78ebe160003df", "XXXXX25870f78ebe160003e2", "XXXXX25970f78ebe160003e6", "XXXXX25d70f78ebe160003f0", "XXXXX25f70f78ebe160003f2", "XXXXX26170f78ebe160003f6", "XXXXX26370f78ebe160003fb", "XXXXX26670f78ebe16000402", "XXXXX26870f78ebe16000406", "XXXXX26d70f78ebe1600040d", "XXXXX28170f78ebe16000422", "XXXXX28c70f78ebe16000438", "XXXXX29370f78ebe16000446" ] } } ] }, "inputStage": { "stage": "IXSCAN", "planNodeId": 1, "keyPattern": { "shop_id": 1, "st": 1, "deleted_at": 1 }, "indexName": "shop_id_1_st_1_deleted_at_1", "isMultiKey": false, "multiKeyPaths": { "shop_id": [ ], "st": [ ], "deleted_at": [ ] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 1, "direction": "forward", "indexBounds": { "shop_id": [ "[MinKey, MaxKey]" ], "st": [ "[MinKey, MaxKey]" ], "deleted_at": [ "[MinKey, MaxKey]" ] } } }, "slotBasedPlan": { "slots": "$$RESULT=s10 env: { s3 = Timestamp(1698595935, 11) (CLUSTER_TIME), s9 = {\"shop_id\" : 1, \"st\" : 1, \"deleted_at\" : 1}, s14 = [bsonObjectId(\"XXXXX1a070f78ebe1600028d\"), bsonObjectId(\"XXXXX19f70f78ebe16000286\"), bsonObjectId(\"XXXXX22b70f78ebe16000387\"), bsonObjectId(\"XXXXX20670f78ebe16000341\"), bsonObjectId(\"XXXXX19870f78ebe16000271\"), bsonObjectId(\"XXXXX19a70f78ebe16000277\"), bsonObjectId(\"XXXXX19b70f78ebe16000278\"), bsonObjectId(\"XXXXX19d70f78ebe16000280\"), bsonObjectId(\"XXXXX1cf70f78ebe160002ec\"), bsonObjectId(\"XXXXX1cb70f78ebe160002e2\"), ...], s2 = Nothing (SEARCH_META), s4 = 1698595935293 (NOW), s1 = TimeZoneDatabase(US/Arizona...Asia/Ujung_Pandang) (timeZoneDB) }", "stages": "[2] filter {(traverseF(s13, lambda(l1.0) { ((\n if (typeMatch(l1.0, 1088ll) ?: true) \n then null \n else l1.0 \n== null) ?: false) }, false) && traverseF(s12, lambda(l2.0) { isMember(l2.0, s14) }, false))} \n[2] nlj inner [] [s5, s6, s7, s8, s9] \n left \n [1] ixseek KS(0A0A0A0104) KS(F0F0F0FE04) s8 s5 s6 s7 lowPriority [] @\"c877ec6d-fc21-491e-b571-cba824619e81\" @\"shop_id_1_st_1_deleted_at_1\" true \n right \n [2] limit 1 \n [2] seek s5 s10 s11 s6 s7 s8 s9 [s12 = _id, s13 = deleted_at] @\"c877ec6d-fc21-491e-b571-cba824619e81\" true false \n" } }, { "queryPlan": { "stage": "FETCH", "planNodeId": 2, "filter": { "$and": [ { "deleted_at": { "$eq": null } }, { "_id": { "$in": [ "XXXXX19070f78ebe16000260", "XXXXX19370f78ebe16000263", "XXXXX19570f78ebe16000268", "XXXXX19770f78ebe1600026c", "XXXXX19870f78ebe16000271", "XXXXX19a70f78ebe16000277", "XXXXX19b70f78ebe16000278", "XXXXX19d70f78ebe16000280", "XXXXX19f70f78ebe16000286", "XXXXX1a070f78ebe1600028d", "XXXXX1a170f78ebe16000293", "XXXXX1a470f78ebe1600029a", "XXXXX1a670f78ebe1600029e", "XXXXX1a870f78ebe160002a3", "XXXXX1aa70f78ebe160002a6", "XXXXX1ac70f78ebe160002ab", "XXXXX1af70f78ebe160002ae", "XXXXX1b170f78ebe160002b1", "XXXXX1b470f78ebe160002b4", "XXXXX1b670f78ebe160002ba", "XXXXX1b770f78ebe160002bd", "XXXXX1b870f78ebe160002c2", "XXXXX1bb70f78ebe160002c4", "XXXXX1c070f78ebe160002c9", "XXXXX1c170f78ebe160002cf", "XXXXX1c470f78ebe160002d1", "XXXXX1c770f78ebe160002d8", "XXXXX1c970f78ebe160002dd", "XXXXX1cb70f78ebe160002e2", "XXXXX1cf70f78ebe160002ec", "XXXXX1d170f78ebe160002f0", "XXXXX1d370f78ebe160002f2", "XXXXX1d570f78ebe160002f4", "XXXXX1d870f78ebe160002f7", "XXXXX1dc70f78ebe160002fc", "XXXXX1dd70f78ebe16000301", "XXXXX1e270f78ebe16000303", "XXXXX1e470f78ebe16000307", "XXXXX1e670f78ebe16000309", "XXXXX1e870f78ebe16000313", "XXXXX1ec70f78ebe16000316", "XXXXX1ed70f78ebe1600031b", "XXXXX1f070f78ebe1600031f", "XXXXX1f470f78ebe16000321", "XXXXX1f670f78ebe16000326", "XXXXX1f870f78ebe1600032b", "XXXXX1fb70f78ebe1600032c", "XXXXX1fd70f78ebe16000332", "XXXXX1fe70f78ebe16000337", "XXXXX20270f78ebe1600033b", "XXXXX20670f78ebe16000341", "XXXXX20870f78ebe16000346", "XXXXX20b70f78ebe16000348", "XXXXX20e70f78ebe16000350", "XXXXX21070f78ebe16000355", "XXXXX21170f78ebe16000359", "XXXXX21270f78ebe1600035a", "XXXXX21470f78ebe1600035d", "XXXXX21570f78ebe16000366", "XXXXX21870f78ebe1600036c", "XXXXX21a70f78ebe1600036f", "XXXXX21c70f78ebe16000370", "XXXXX21f70f78ebe16000372", "XXXXX22070f78ebe16000376", "XXXXX22270f78ebe1600037c", "XXXXX22470f78ebe1600037d", "XXXXX22570f78ebe16000380", "XXXXX22770f78ebe16000383", "XXXXX22b70f78ebe16000387", "XXXXX22c70f78ebe1600038b", "XXXXX22e70f78ebe16000392", "XXXXX23070f78ebe16000397", "XXXXX23470f78ebe1600039d", "XXXXX23570f78ebe160003a3", "XXXXX23770f78ebe160003a7", "XXXXX23870f78ebe160003ac", "XXXXX23b70f78ebe160003af", "XXXXX23d70f78ebe160003b5", "XXXXX23f70f78ebe160003bb", "XXXXX24170f78ebe160003c3", "XXXXX24270f78ebe160003c7", "XXXXX24370f78ebe160003cb", "XXXXX24570f78ebe160003cd", "XXXXX24970f78ebe160003d2", "XXXXX24d70f78ebe160003d7", "XXXXX25070f78ebe160003d9", "XXXXX25470f78ebe160003da", "XXXXX25670f78ebe160003df", "XXXXX25870f78ebe160003e2", "XXXXX25970f78ebe160003e6", "XXXXX25d70f78ebe160003f0", "XXXXX25f70f78ebe160003f2", "XXXXX26170f78ebe160003f6", "XXXXX26370f78ebe160003fb", "XXXXX26670f78ebe16000402", "XXXXX26870f78ebe16000406", "XXXXX26d70f78ebe1600040d", "XXXXX28170f78ebe16000422", "XXXXX28c70f78ebe16000438", "XXXXX29370f78ebe16000446" ] } } ] }, "inputStage": { "stage": "IXSCAN", "planNodeId": 1, "keyPattern": { "shop_id": 1, "st": 1, "sts": 1, "vtc": 1, "ola?": 1, "ivr?": 1, "deleted_at": 1 }, "indexName": "shop_id_1_st_1_sts_1_vtc_1_ola?_1_ivr?_1_deleted_at_1", "isMultiKey": false, "multiKeyPaths": { "shop_id": [ ], "st": [ ], "sts": [ ], "vtc": [ ], "ola?": [ ], "ivr?": [ ], "deleted_at": [ ] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 1, "direction": "forward", "indexBounds": { "shop_id": [ "[MinKey, MaxKey]" ], "st": [ "[MinKey, MaxKey]" ], "sts": [ "[MinKey, MaxKey]" ], "vtc": [ "[MinKey, MaxKey]" ], "ola?": [ "[MinKey, MaxKey]" ], "ivr?": [ "[MinKey, MaxKey]" ], "deleted_at": [ "[MinKey, MaxKey]" ] } } }, "slotBasedPlan": { "slots": "$$RESULT=s10 env: { s1 = TimeZoneDatabase(US/Arizona...Asia/Ujung_Pandang) (timeZoneDB), s9 = {\"shop_id\" : 1, \"st\" : 1, \"sts\" : 1, \"vtc\" : 1, \"ola?\" : 1, \"ivr?\" : 1, \"deleted_at\" : 1}, s14 = [bsonObjectId(\"XXXXX1a070f78ebe1600028d\"), bsonObjectId(\"XXXXX19f70f78ebe16000286\"), bsonObjectId(\"XXXXX22b70f78ebe16000387\"), bsonObjectId(\"XXXXX20670f78ebe16000341\"), bsonObjectId(\"XXXXX19870f78ebe16000271\"), bsonObjectId(\"XXXXX19a70f78ebe16000277\"), bsonObjectId(\"XXXXX19b70f78ebe16000278\"), bsonObjectId(\"XXXXX19d70f78ebe16000280\"), bsonObjectId(\"XXXXX1cf70f78ebe160002ec\"), bsonObjectId(\"XXXXX1cb70f78ebe160002e2\"), ...], s4 = 1698595935293 (NOW), s2 = Nothing (SEARCH_META), s3 = Timestamp(1698595935, 11) (CLUSTER_TIME) }", "stages": "[2] filter {(traverseF(s13, lambda(l1.0) { ((\n if (typeMatch(l1.0, 1088ll) ?: true) \n then null \n else l1.0 \n== null) ?: false) }, false) && traverseF(s12, lambda(l2.0) { isMember(l2.0, s14) }, false))} \n[2] nlj inner [] [s5, s6, s7, s8, s9] \n left \n [1] ixseek KS(0A0A0A0A0A0A0A0104) KS(F0F0F0F0F0F0F0FE04) s8 s5 s6 s7 lowPriority [] @\"c877ec6d-fc21-491e-b571-cba824619e81\" @\"shop_id_1_st_1_sts_1_vtc_1_ola?_1_ivr?_1_deleted_at_1\" true \n right \n [2] limit 1 \n [2] seek s5 s10 s11 s6 s7 s8 s9 [s12 = _id, s13 = deleted_at] @\"c877ec6d-fc21-491e-b571-cba824619e81\" true false \n" } }, { "queryPlan": { "stage": "FETCH", "planNodeId": 2, "filter": { "$and": [ { "deleted_at": { "$eq": null } }, { "_id": { "$in": [ "XXXXX19070f78ebe16000260", "XXXXX19370f78ebe16000263", "XXXXX19570f78ebe16000268", "XXXXX19770f78ebe1600026c", "XXXXX19870f78ebe16000271", "XXXXX19a70f78ebe16000277", "XXXXX19b70f78ebe16000278", "XXXXX19d70f78ebe16000280", "XXXXX19f70f78ebe16000286", "XXXXX1a070f78ebe1600028d", "XXXXX1a170f78ebe16000293", "XXXXX1a470f78ebe1600029a", "XXXXX1a670f78ebe1600029e", "XXXXX1a870f78ebe160002a3", "XXXXX1aa70f78ebe160002a6", "XXXXX1ac70f78ebe160002ab", "XXXXX1af70f78ebe160002ae", "XXXXX1b170f78ebe160002b1", "XXXXX1b470f78ebe160002b4", "XXXXX1b670f78ebe160002ba", "XXXXX1b770f78ebe160002bd", "XXXXX1b870f78ebe160002c2", "XXXXX1bb70f78ebe160002c4", "XXXXX1c070f78ebe160002c9", "XXXXX1c170f78ebe160002cf", "XXXXX1c470f78ebe160002d1", "XXXXX1c770f78ebe160002d8", "XXXXX1c970f78ebe160002dd", "XXXXX1cb70f78ebe160002e2", "XXXXX1cf70f78ebe160002ec", "XXXXX1d170f78ebe160002f0", "XXXXX1d370f78ebe160002f2", "XXXXX1d570f78ebe160002f4", "XXXXX1d870f78ebe160002f7", "XXXXX1dc70f78ebe160002fc", "XXXXX1dd70f78ebe16000301", "XXXXX1e270f78ebe16000303", "XXXXX1e470f78ebe16000307", "XXXXX1e670f78ebe16000309", "XXXXX1e870f78ebe16000313", "XXXXX1ec70f78ebe16000316", "XXXXX1ed70f78ebe1600031b", "XXXXX1f070f78ebe1600031f", "XXXXX1f470f78ebe16000321", "XXXXX1f670f78ebe16000326", "XXXXX1f870f78ebe1600032b", "XXXXX1fb70f78ebe1600032c", "XXXXX1fd70f78ebe16000332", "XXXXX1fe70f78ebe16000337", "XXXXX20270f78ebe1600033b", "XXXXX20670f78ebe16000341", "XXXXX20870f78ebe16000346", "XXXXX20b70f78ebe16000348", "XXXXX20e70f78ebe16000350", "XXXXX21070f78ebe16000355", "XXXXX21170f78ebe16000359", "XXXXX21270f78ebe1600035a", "XXXXX21470f78ebe1600035d", "XXXXX21570f78ebe16000366", "XXXXX21870f78ebe1600036c", "XXXXX21a70f78ebe1600036f", "XXXXX21c70f78ebe16000370", "XXXXX21f70f78ebe16000372", "XXXXX22070f78ebe16000376", "XXXXX22270f78ebe1600037c", "XXXXX22470f78ebe1600037d", "XXXXX22570f78ebe16000380", "XXXXX22770f78ebe16000383", "XXXXX22b70f78ebe16000387", "XXXXX22c70f78ebe1600038b", "XXXXX22e70f78ebe16000392", "XXXXX23070f78ebe16000397", "XXXXX23470f78ebe1600039d", "XXXXX23570f78ebe160003a3", "XXXXX23770f78ebe160003a7", "XXXXX23870f78ebe160003ac", "XXXXX23b70f78ebe160003af", "XXXXX23d70f78ebe160003b5", "XXXXX23f70f78ebe160003bb", "XXXXX24170f78ebe160003c3", "XXXXX24270f78ebe160003c7", "XXXXX24370f78ebe160003cb", "XXXXX24570f78ebe160003cd", "XXXXX24970f78ebe160003d2", "XXXXX24d70f78ebe160003d7", "XXXXX25070f78ebe160003d9", "XXXXX25470f78ebe160003da", "XXXXX25670f78ebe160003df", "XXXXX25870f78ebe160003e2", "XXXXX25970f78ebe160003e6", "XXXXX25d70f78ebe160003f0", "XXXXX25f70f78ebe160003f2", "XXXXX26170f78ebe160003f6", "XXXXX26370f78ebe160003fb", "XXXXX26670f78ebe16000402", "XXXXX26870f78ebe16000406", "XXXXX26d70f78ebe1600040d", "XXXXX28170f78ebe16000422", "XXXXX28c70f78ebe16000438", "XXXXX29370f78ebe16000446" ] } } ] }, "inputStage": { "stage": "IXSCAN", "planNodeId": 1, "keyPattern": { "shop_id": 1, "st": 1, "et": 1 }, "indexName": "shop_id_1_st_1_et_1", "isMultiKey": false, "multiKeyPaths": { "shop_id": [ ], "st": [ ], "et": [ ] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "forward", "indexBounds": { "shop_id": [ "[MinKey, MaxKey]" ], "st": [ "[MinKey, MaxKey]" ], "et": [ "[MinKey, MaxKey]" ] } } }, "slotBasedPlan": { "slots": "$$RESULT=s10 env: { s3 = Timestamp(1698595935, 11) (CLUSTER_TIME), s1 = TimeZoneDatabase(US/Arizona...Asia/Ujung_Pandang) (timeZoneDB), s4 = 1698595935293 (NOW), s9 = {\"shop_id\" : 1, \"st\" : 1, \"et\" : 1}, s2 = Nothing (SEARCH_META), s14 = [bsonObjectId(\"XXXXX1ec70f78ebe16000316\"), bsonObjectId(\"XXXXX23d70f78ebe160003b5\"), bsonObjectId(\"XXXXX23f70f78ebe160003bb\"), bsonObjectId(\"XXXXX24170f78ebe160003c3\"), bsonObjectId(\"XXXXX25470f78ebe160003da\"), bsonObjectId(\"XXXXX24d70f78ebe160003d7\"), bsonObjectId(\"XXXXX24370f78ebe160003cb\"), bsonObjectId(\"XXXXX24570f78ebe160003cd\"), bsonObjectId(\"XXXXX1b170f78ebe160002b1\"), bsonObjectId(\"XXXXX1b670f78ebe160002ba\"), ...] }", "stages": "[2] filter {(traverseF(s13, lambda(l1.0) { ((\n if (typeMatch(l1.0, 1088ll) ?: true) \n then null \n else l1.0 \n== null) ?: false) }, false) && traverseF(s12, lambda(l2.0) { isMember(l2.0, s14) }, false))} \n[2] nlj inner [] [s5, s6, s7, s8, s9] \n left \n [1] ixseek KS(0A0A0A0104) KS(F0F0F0FE04) s8 s5 s6 s7 lowPriority [] @\"c877ec6d-fc21-491e-b571-cba824619e81\" @\"shop_id_1_st_1_et_1\" true \n right \n [2] limit 1 \n [2] seek s5 s10 s11 s6 s7 s8 s9 [s12 = _id, s13 = deleted_at] @\"c877ec6d-fc21-491e-b571-cba824619e81\" true false \n" } } ] }, "executionStats": { "executionSuccess": true, "nReturned": 100, "executionTimeMillis": 182, "totalKeysExamined": 100, "totalDocsExamined": 100, "executionStages": { "stage": "sort", "planNodeId": 3, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 2, "saveState": 1, "restoreState": 1, "isEOF": 1, "memLimit": 104857600, "totalDataSizeSorted": 0, "usedDisk": false, "spills": 0, "spilledDataStorageSize": 0, "orderBySlots": { "32": "asc", "33": "asc" }, "outputSlots": [ 26 ], "inputStage": { "stage": "project", "planNodeId": 3, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "projections": { "32": "\n if (isArray(s28) ?: false) \n then (_internalLeast(s28) ?: undefined) \n else (s28 ?: null) \n", "33": "\n if (isArray(s29) ?: false) \n then (_internalLeast(s29) ?: undefined) \n else (s29 ?: null) \n" }, "inputStage": { "stage": "project", "planNodeId": 3, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "projections": { "31": "(!((isArray(s28) ?: false)) || (!((isArray(s29) ?: false)) || fail(2, \"cannot sort with keys that are parallel arrays\"))) " }, "inputStage": { "stage": "filter", "planNodeId": 2, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "numTested": 100, "filter": "traverseF(s30, lambda(l1.0) { ((\n if (typeMatch(l1.0, 1088ll) ?: true) \n then null \n else l1.0 \n== null) ?: false) }, false) ", "inputStage": { "stage": "nlj", "planNodeId": 2, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "totalDocsExamined": 100, "totalKeysExamined": 100, "collectionScans": 0, "collectionSeeks": 100, "indexScans": 0, "indexSeeks": 100, "indexesUsed": [ "_id_", "_id_" ], "innerOpens": 100, "innerCloses": 1, "outerProjects": [ ], "outerCorrelated": [ 20, 21, 22, 23, 24 ], "outerStage": { "stage": "branch", "planNodeId": 1, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "numTested": 1, "thenBranchOpens": 0, "thenBranchCloses": 0, "elseBranchOpens": 1, "elseBranchCloses": 1, "filter": "s25 ", "thenSlots": [ 5, 7, 8, 9, 10 ], "elseSlots": [ 11, 17, 18, 19, 10 ], "outputSlots": [ 20, 21, 22, 23, 24 ], "thenStage": { "stage": "ixscan_generic", "planNodeId": 1, "nReturned": 0, "executionTimeMillisEstimate": 0, "opens": 0, "closes": 0, "saveState": 1, "restoreState": 1, "isEOF": 0, "indexName": "_id_", "keysExamined": 0, "seeks": 0, "numReads": 0, "indexKeySlot": 9, "recordIdSlot": 5, "snapshotIdSlot": 7, "indexIdentSlot": 8, "outputSlots": [ ], "indexKeysToInclude": "00000000000000000000000000000000" }, "elseStage": { "stage": "nlj", "planNodeId": 1, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "totalDocsExamined": 0, "totalKeysExamined": 100, "collectionScans": 0, "collectionSeeks": 0, "indexScans": 0, "indexSeeks": 100, "indexesUsed": [ "_id_" ], "innerOpens": 100, "innerCloses": 1, "outerProjects": [ ], "outerCorrelated": [ 12, 13 ], "outerStage": { "stage": "project", "planNodeId": 1, "nReturned": 100, "executionTimeMillisEstimate": 0, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "projections": { "12": "getField(s15, \"l\") ", "13": "getField(s15, \"h\") " }, "inputStage": { "stage": "unwind", "planNodeId": 1, "nReturned": 100, "executionTimeMillisEstimate": 0, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "inputSlot": 14, "outSlot": 15, "outIndexSlot": 16, "preserveNullAndEmptyArrays": 0, "inputStage": { "stage": "limit", "planNodeId": 1, "nReturned": 1, "executionTimeMillisEstimate": 0, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "limit": 1, "inputStage": { "stage": "coscan", "planNodeId": 1, "nReturned": 1, "executionTimeMillisEstimate": 0, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 0 } } } }, "innerStage": { "stage": "ixseek", "planNodeId": 1, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 100, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "indexName": "_id_", "keysExamined": 100, "seeks": 100, "numReads": 200, "indexKeySlot": 19, "recordIdSlot": 11, "snapshotIdSlot": 17, "indexIdentSlot": 18, "outputSlots": [ ], "indexKeysToInclude": "00000000000000000000000000000000", "seekKeyLow": "s12 ", "seekKeyHigh": "s13 " } } }, "innerStage": { "stage": "limit", "planNodeId": 2, "nReturned": 100, "executionTimeMillisEstimate": 0, "opens": 100, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "limit": 1, "inputStage": { "stage": "seek", "planNodeId": 2, "nReturned": 100, "executionTimeMillisEstimate": 0, "opens": 100, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 0, "numReads": 100, "recordSlot": 26, "recordIdSlot": 27, "seekKeySlot": 20, "snapshotIdSlot": 21, "indexIdentSlot": 22, "indexKeySlot": 23, "indexKeyPatternSlot": 24, "fields": [ "shop_id", "st", "deleted_at" ], "outputSlots": [ 28, 29, 30 ] } } } } } } }, "allPlansExecution": [ { "nReturned": 100, "executionTimeMillisEstimate": 4, "totalKeysExamined": 100, "totalDocsExamined": 100, "score": 2.335648172757475, "executionStages": { "stage": "sort", "planNodeId": 3, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "memLimit": 104857600, "totalDataSizeSorted": 0, "usedDisk": false, "spills": 0, "spilledDataStorageSize": 0, "orderBySlots": { "32": "asc", "33": "asc" }, "outputSlots": [ 26 ], "inputStage": { "stage": "project", "planNodeId": 3, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "projections": { "32": "\n if (isArray(s28) ?: false) \n then (_internalLeast(s28) ?: undefined) \n else (s28 ?: null) \n", "33": "\n if (isArray(s29) ?: false) \n then (_internalLeast(s29) ?: undefined) \n else (s29 ?: null) \n" }, "inputStage": { "stage": "project", "planNodeId": 3, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "projections": { "31": "(!((isArray(s28) ?: false)) || (!((isArray(s29) ?: false)) || fail(2, \"cannot sort with keys that are parallel arrays\"))) " }, "inputStage": { "stage": "filter", "planNodeId": 2, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "numTested": 100, "filter": "traverseF(s30, lambda(l1.0) { ((\n if (typeMatch(l1.0, 1088ll) ?: true) \n then null \n else l1.0 \n== null) ?: false) }, false) ", "inputStage": { "stage": "nlj", "planNodeId": 2, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "totalDocsExamined": 100, "totalKeysExamined": 100, "collectionScans": 0, "collectionSeeks": 100, "indexScans": 0, "indexSeeks": 100, "indexesUsed": [ "_id_", "_id_" ], "innerOpens": 100, "innerCloses": 1, "outerProjects": [ ], "outerCorrelated": [ 20, 21, 22, 23, 24 ], "outerStage": { "stage": "branch", "planNodeId": 1, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "numTested": 1, "thenBranchOpens": 0, "thenBranchCloses": 0, "elseBranchOpens": 1, "elseBranchCloses": 1, "filter": "s25 ", "thenSlots": [ 5, 7, 8, 9, 10 ], "elseSlots": [ 11, 17, 18, 19, 10 ], "outputSlots": [ 20, 21, 22, 23, 24 ], "thenStage": { "stage": "ixscan_generic", "planNodeId": 1, "nReturned": 0, "executionTimeMillisEstimate": 0, "opens": 0, "closes": 0, "saveState": 1, "restoreState": 1, "isEOF": 0, "indexName": "_id_", "keysExamined": 0, "seeks": 0, "numReads": 0, "indexKeySlot": 9, "recordIdSlot": 5, "snapshotIdSlot": 7, "indexIdentSlot": 8, "outputSlots": [ ], "indexKeysToInclude": "00000000000000000000000000000000" }, "elseStage": { "stage": "nlj", "planNodeId": 1, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "totalDocsExamined": 0, "totalKeysExamined": 100, "collectionScans": 0, "collectionSeeks": 0, "indexScans": 0, "indexSeeks": 100, "indexesUsed": [ "_id_" ], "innerOpens": 100, "innerCloses": 1, "outerProjects": [ ], "outerCorrelated": [ 12, 13 ], "outerStage": { "stage": "project", "planNodeId": 1, "nReturned": 100, "executionTimeMillisEstimate": 0, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "projections": { "12": "getField(s15, \"l\") ", "13": "getField(s15, \"h\") " }, "inputStage": { "stage": "unwind", "planNodeId": 1, "nReturned": 100, "executionTimeMillisEstimate": 0, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "inputSlot": 14, "outSlot": 15, "outIndexSlot": 16, "preserveNullAndEmptyArrays": 0, "inputStage": { "stage": "limit", "planNodeId": 1, "nReturned": 1, "executionTimeMillisEstimate": 0, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "limit": 1, "inputStage": { "stage": "coscan", "planNodeId": 1, "nReturned": 1, "executionTimeMillisEstimate": 0, "opens": 1, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 0 } } } }, "innerStage": { "stage": "ixseek", "planNodeId": 1, "nReturned": 100, "executionTimeMillisEstimate": 4, "opens": 100, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "indexName": "_id_", "keysExamined": 100, "seeks": 100, "numReads": 200, "indexKeySlot": 19, "recordIdSlot": 11, "snapshotIdSlot": 17, "indexIdentSlot": 18, "outputSlots": [ ], "indexKeysToInclude": "00000000000000000000000000000000", "seekKeyLow": "s12 ", "seekKeyHigh": "s13 " } } }, "innerStage": { "stage": "limit", "planNodeId": 2, "nReturned": 100, "executionTimeMillisEstimate": 0, "opens": 100, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 1, "limit": 1, "inputStage": { "stage": "seek", "planNodeId": 2, "nReturned": 100, "executionTimeMillisEstimate": 0, "opens": 100, "closes": 1, "saveState": 1, "restoreState": 1, "isEOF": 0, "numReads": 100, "recordSlot": 26, "recordIdSlot": 27, "seekKeySlot": 20, "snapshotIdSlot": 21, "indexIdentSlot": 22, "indexKeySlot": 23, "indexKeyPatternSlot": 24, "fields": [ "shop_id", "st", "deleted_at" ], "outputSlots": [ 28, 29, 30 ] } } } } } } } }, { "nReturned": 100, "executionTimeMillisEstimate": 126, "totalKeysExamined": 5000, "totalDocsExamined": 5000, "score": 1.0102979804039192, "executionStages": { "stage": "filter", "planNodeId": 2, "nReturned": 100, "executionTimeMillisEstimate": 126, "opens": 1, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 0, "numTested": 5000, "filter": "(traverseF(s13, lambda(l1.0) { ((\n if (typeMatch(l1.0, 1088ll) ?: true) \n then null \n else l1.0 \n== null) ?: false) }, false) && traverseF(s12, lambda(l2.0) { isMember(l2.0, s14) }, false)) ", "inputStage": { "stage": "nlj", "planNodeId": 2, "nReturned": 5000, "executionTimeMillisEstimate": 125, "opens": 1, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 0, "totalDocsExamined": 5000, "totalKeysExamined": 5000, "collectionScans": 0, "collectionSeeks": 5000, "indexScans": 0, "indexSeeks": 1, "indexesUsed": [ "shop_id_1_st_1_deleted_at_1" ], "innerOpens": 5000, "innerCloses": 1, "outerProjects": [ ], "outerCorrelated": [ 5, 6, 7, 8, 9 ], "outerStage": { "stage": "ixseek", "planNodeId": 1, "nReturned": 5000, "executionTimeMillisEstimate": 8, "opens": 1, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 0, "indexName": "shop_id_1_st_1_deleted_at_1", "keysExamined": 5000, "seeks": 1, "numReads": 5001, "indexKeySlot": 8, "recordIdSlot": 5, "snapshotIdSlot": 6, "indexIdentSlot": 7, "outputSlots": [ ], "indexKeysToInclude": "00000000000000000000000000000000", "seekKeyLow": "KS(0A0A0A0104) ", "seekKeyHigh": "KS(F0F0F0FE04) " }, "innerStage": { "stage": "limit", "planNodeId": 2, "nReturned": 5000, "executionTimeMillisEstimate": 117, "opens": 5000, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 1, "limit": 1, "inputStage": { "stage": "seek", "planNodeId": 2, "nReturned": 5000, "executionTimeMillisEstimate": 117, "opens": 5000, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 0, "numReads": 5000, "recordSlot": 10, "recordIdSlot": 11, "seekKeySlot": 5, "snapshotIdSlot": 6, "indexIdentSlot": 7, "indexKeySlot": 8, "indexKeyPatternSlot": 9, "fields": [ "_id", "deleted_at" ], "outputSlots": [ 12, 13 ] } } } } }, { "nReturned": 100, "executionTimeMillisEstimate": 27, "totalKeysExamined": 5000, "totalDocsExamined": 5000, "score": 1.0102979804039192, "executionStages": { "stage": "filter", "planNodeId": 2, "nReturned": 100, "executionTimeMillisEstimate": 27, "opens": 1, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 0, "numTested": 5000, "filter": "(traverseF(s13, lambda(l1.0) { ((\n if (typeMatch(l1.0, 1088ll) ?: true) \n then null \n else l1.0 \n== null) ?: false) }, false) && traverseF(s12, lambda(l2.0) { isMember(l2.0, s14) }, false)) ", "inputStage": { "stage": "nlj", "planNodeId": 2, "nReturned": 5000, "executionTimeMillisEstimate": 27, "opens": 1, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 0, "totalDocsExamined": 5000, "totalKeysExamined": 5000, "collectionScans": 0, "collectionSeeks": 5000, "indexScans": 0, "indexSeeks": 1, "indexesUsed": [ "shop_id_1_st_1_sts_1_vtc_1_ola?_1_ivr?_1_deleted_at_1" ], "innerOpens": 5000, "innerCloses": 1, "outerProjects": [ ], "outerCorrelated": [ 5, 6, 7, 8, 9 ], "outerStage": { "stage": "ixseek", "planNodeId": 1, "nReturned": 5000, "executionTimeMillisEstimate": 7, "opens": 1, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 0, "indexName": "shop_id_1_st_1_sts_1_vtc_1_ola?_1_ivr?_1_deleted_at_1", "keysExamined": 5000, "seeks": 1, "numReads": 5001, "indexKeySlot": 8, "recordIdSlot": 5, "snapshotIdSlot": 6, "indexIdentSlot": 7, "outputSlots": [ ], "indexKeysToInclude": "00000000000000000000000000000000", "seekKeyLow": "KS(0A0A0A0A0A0A0A0104) ", "seekKeyHigh": "KS(F0F0F0F0F0F0F0FE04) " }, "innerStage": { "stage": "limit", "planNodeId": 2, "nReturned": 5000, "executionTimeMillisEstimate": 20, "opens": 5000, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 1, "limit": 1, "inputStage": { "stage": "seek", "planNodeId": 2, "nReturned": 5000, "executionTimeMillisEstimate": 18, "opens": 5000, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 0, "numReads": 5000, "recordSlot": 10, "recordIdSlot": 11, "seekKeySlot": 5, "snapshotIdSlot": 6, "indexIdentSlot": 7, "indexKeySlot": 8, "indexKeyPatternSlot": 9, "fields": [ "_id", "deleted_at" ], "outputSlots": [ 12, 13 ] } } } } }, { "nReturned": 100, "executionTimeMillisEstimate": 21, "totalKeysExamined": 5000, "totalDocsExamined": 5000, "score": 1.0102979804039192, "executionStages": { "stage": "filter", "planNodeId": 2, "nReturned": 100, "executionTimeMillisEstimate": 21, "opens": 1, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 0, "numTested": 5000, "filter": "(traverseF(s13, lambda(l1.0) { ((\n if (typeMatch(l1.0, 1088ll) ?: true) \n then null \n else l1.0 \n== null) ?: false) }, false) && traverseF(s12, lambda(l2.0) { isMember(l2.0, s14) }, false)) ", "inputStage": { "stage": "nlj", "planNodeId": 2, "nReturned": 5000, "executionTimeMillisEstimate": 19, "opens": 1, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 0, "totalDocsExamined": 5000, "totalKeysExamined": 5000, "collectionScans": 0, "collectionSeeks": 5000, "indexScans": 0, "indexSeeks": 1, "indexesUsed": [ "shop_id_1_st_1_et_1" ], "innerOpens": 5000, "innerCloses": 1, "outerProjects": [ ], "outerCorrelated": [ 5, 6, 7, 8, 9 ], "outerStage": { "stage": "ixseek", "planNodeId": 1, "nReturned": 5000, "executionTimeMillisEstimate": 10, "opens": 1, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 0, "indexName": "shop_id_1_st_1_et_1", "keysExamined": 5000, "seeks": 1, "numReads": 5001, "indexKeySlot": 8, "recordIdSlot": 5, "snapshotIdSlot": 6, "indexIdentSlot": 7, "outputSlots": [ ], "indexKeysToInclude": "00000000000000000000000000000000", "seekKeyLow": "KS(0A0A0A0104) ", "seekKeyHigh": "KS(F0F0F0FE04) " }, "innerStage": { "stage": "limit", "planNodeId": 2, "nReturned": 5000, "executionTimeMillisEstimate": 9, "opens": 5000, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 1, "limit": 1, "inputStage": { "stage": "seek", "planNodeId": 2, "nReturned": 5000, "executionTimeMillisEstimate": 9, "opens": 5000, "closes": 1, "saveState": 22, "restoreState": 22, "isEOF": 0, "numReads": 5000, "recordSlot": 10, "recordIdSlot": 11, "seekKeySlot": 5, "snapshotIdSlot": 6, "indexIdentSlot": 7, "indexKeySlot": 8, "indexKeyPatternSlot": 9, "fields": [ "_id", "deleted_at" ], "outputSlots": [ 12, 13 ] } } } } } ] }, "command": { "find": "reservations", "filter": { "deleted_at": null, "_id": { "$in": [ "XXXXX1a870f78ebe160002a3", "XXXXX19870f78ebe16000271", "XXXXX1a070f78ebe1600028d", "XXXXX19370f78ebe16000263", "XXXXX19b70f78ebe16000278", "XXXXX19770f78ebe1600026c", "XXXXX1aa70f78ebe160002a6", "XXXXX19a70f78ebe16000277", "XXXXX1a670f78ebe1600029e", "XXXXX1a470f78ebe1600029a", "XXXXX19d70f78ebe16000280", "XXXXX19570f78ebe16000268", "XXXXX1a170f78ebe16000293", "XXXXX19f70f78ebe16000286", "XXXXX19070f78ebe16000260", "XXXXX1ac70f78ebe160002ab", "XXXXX1b770f78ebe160002bd", "XXXXX1af70f78ebe160002ae", "XXXXX1c470f78ebe160002d1", "XXXXX1c170f78ebe160002cf", "XXXXX1b870f78ebe160002c2", "XXXXX1b670f78ebe160002ba", "XXXXX1b470f78ebe160002b4", "XXXXX1c970f78ebe160002dd", "XXXXX1bb70f78ebe160002c4", "XXXXX1c070f78ebe160002c9", "XXXXX1c770f78ebe160002d8", "XXXXX1cf70f78ebe160002ec", "XXXXX1cb70f78ebe160002e2", "XXXXX1b170f78ebe160002b1", "XXXXX1d570f78ebe160002f4", "XXXXX1f070f78ebe1600031f", "XXXXX1d370f78ebe160002f2", "XXXXX1ec70f78ebe16000316", "XXXXX1dc70f78ebe160002fc", "XXXXX1e270f78ebe16000303", "XXXXX1d870f78ebe160002f7", "XXXXX1dd70f78ebe16000301", "XXXXX1e870f78ebe16000313", "XXXXX1d170f78ebe160002f0", "XXXXX1e470f78ebe16000307", "XXXXX1e670f78ebe16000309", "XXXXX1f470f78ebe16000321", "XXXXX1ed70f78ebe1600031b", "XXXXX21270f78ebe1600035a", "XXXXX20e70f78ebe16000350", "XXXXX21570f78ebe16000366", "XXXXX21170f78ebe16000359", "XXXXX21c70f78ebe16000370", "XXXXX20670f78ebe16000341", "XXXXX20870f78ebe16000346", "XXXXX21470f78ebe1600035d", "XXXXX21870f78ebe1600036c", "XXXXX1f670f78ebe16000326", "XXXXX1fb70f78ebe1600032c", "XXXXX21070f78ebe16000355", "XXXXX1fe70f78ebe16000337", "XXXXX21f70f78ebe16000372", "XXXXX22070f78ebe16000376", "XXXXX21a70f78ebe1600036f", "XXXXX20270f78ebe1600033b", "XXXXX1fd70f78ebe16000332", "XXXXX1f870f78ebe1600032b", "XXXXX20b70f78ebe16000348", "XXXXX22270f78ebe1600037c", "XXXXX24170f78ebe160003c3", "XXXXX23d70f78ebe160003b5", "XXXXX23b70f78ebe160003af", "XXXXX22c70f78ebe1600038b", "XXXXX22470f78ebe1600037d", "XXXXX23070f78ebe16000397", "XXXXX23f70f78ebe160003bb", "XXXXX22e70f78ebe16000392", "XXXXX22b70f78ebe16000387", "XXXXX22570f78ebe16000380", "XXXXX24270f78ebe160003c7", "XXXXX22770f78ebe16000383", "XXXXX23770f78ebe160003a7", "XXXXX23570f78ebe160003a3", "XXXXX23870f78ebe160003ac", "XXXXX23470f78ebe1600039d", "XXXXX24970f78ebe160003d2", "XXXXX25970f78ebe160003e6", "XXXXX26670f78ebe16000402", "XXXXX24570f78ebe160003cd", "XXXXX26870f78ebe16000406", "XXXXX26170f78ebe160003f6", "XXXXX25470f78ebe160003da", "XXXXX25670f78ebe160003df", "XXXXX24370f78ebe160003cb", "XXXXX24d70f78ebe160003d7", "XXXXX25d70f78ebe160003f0", "XXXXX25870f78ebe160003e2", "XXXXX25070f78ebe160003d9", "XXXXX25f70f78ebe160003f2", "XXXXX26370f78ebe160003fb", "XXXXX28c70f78ebe16000438", "XXXXX26d70f78ebe1600040d", "XXXXX28170f78ebe16000422", "XXXXX29370f78ebe16000446" ] } }, "sort": { "shop_id": 1, "st": 1 }, "$db": "tablesolution_production" }, "serverInfo": { "host": "atlas-tzcwdx-shard-00-00.uhz3j.mongodb.net", "port": 27017, "version": "7.0.2", "gitVersion": "02b3c655e1302209ef046da6ba3ef6749dd0b62a" }, "serverParameters": { "internalQueryFacetBufferSizeBytes": 104857600, "internalLookupStageIntermediateDocumentMaxSizeBytes": 104857600, "internalDocumentSourceGroupMaxMemoryBytes": 104857600, "internalQueryMaxBlockingSortMemoryUsageBytes": 104857600, "internalQueryMaxAddToSetBytes": 104857600, "internalDocumentSourceSetWindowFieldsMaxMemoryBytes": 104857600, "internalQueryFrameworkControl": "trySbeEngine" }, "ok": 1.0, "$clusterTime": { "clusterTime": { "$timestamp": { "t": 1698595935, "i": 21 } }, "signature": { "hash": { "$binary": { "base64": "ZjvIxoAn3SOaymAPuHZCsMlh7ZA=", "subType": "00" } }, "keyId": 7250897925230821726 } }, "operationTime": { "$timestamp": { "t": 1698595935, "i": 21 } } }