MongoDB Enterprise Venmo-shard-0:PRIMARY> db.all.find({Name: {$in: []}}).explain("executionStats") { "queryPlanner" : { "plannerVersion" : 1, "namespace" : "email.all", "indexFilterSet" : false, "parsedQuery" : { "Name" : { "$in" : [ ] } }, "winningPlan" : { "stage" : "COLLSCAN", "filter" : { "Name" : { "$in" : [ ] } }, "direction" : "forward" }, "rejectedPlans" : [ ] }, "executionStats" : { "executionSuccess" : true, "nReturned" : 0, "executionTimeMillis" : 6, "totalKeysExamined" : 0, "totalDocsExamined" : 13357, "executionStages" : { "stage" : "COLLSCAN", "filter" : { "Name" : { "$in" : [ ] } }, "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 13359, "advanced" : 0, "needTime" : 13358, "needYield" : 0, "saveState" : 104, "restoreState" : 104, "isEOF" : 1, "invalidates" : 0, "direction" : "forward", "docsExamined" : 13357 } }, "serverInfo" : { "host" : "venmo-shard-00-01-psgxh.mongodb.net", "port" : 27017, "version" : "4.0.17", "gitVersion" : "0bc918c73390f6e4d6349660e4cd233f5900b69a" }, "ok" : 1, "operationTime" : Timestamp(1586213819, 1), "$clusterTime" : { "clusterTime" : Timestamp(1586213819, 1), "signature" : { "hash" : BinData(0,"qKhuLZayJxWcbHLAclO2BE5ixto="), "keyId" : NumberLong("6766618402439036930") } } } MongoDB Enterprise Venmo-shard-0:PRIMARY> db.all.explain().aggregate([{$match: {Name: {$in: []}}}]) { "stages" : [ { "$cursor" : { "query" : { "Name" : { "$in" : [ ] } }, "queryPlanner" : { "plannerVersion" : 1, "namespace" : "email.all", "indexFilterSet" : false, "parsedQuery" : { "Name" : { "$in" : [ ] } }, "winningPlan" : { "stage" : "COLLSCAN", "filter" : { "Name" : { "$in" : [ ] } }, "direction" : "forward" }, "rejectedPlans" : [ ] } } } ], "serverInfo" : { "host" : "venmo-shard-00-01-psgxh.mongodb.net", "port" : 27017, "version" : "4.0.17", "gitVersion" : "0bc918c73390f6e4d6349660e4cd233f5900b69a" }, "ok" : 1, "operationTime" : Timestamp(1586214182, 1), "$clusterTime" : { "clusterTime" : Timestamp(1586214182, 1), "signature" : { "hash" : BinData(0,"0bIdML7mONv9e7S26zVjUOunDGU="), "keyId" : NumberLong("6766618402439036930") } } }