MongoDB Enterprise mongos> db.finefoods.find({userId: “A10CJYBXXJ2BKB”}).explain(1) { “queryPlanner” : { “mongosPlannerVersion” : 1, “winningPlan” : { “stage” : “SHARD_MERGE”, “shards” : [ { “shardName” : “shard01”, “connectionString” : “shard01/localhost:30001,localhost:30002,localhost:30003”, “serverInfo” : { “host” : “Christophers-MacBook-Pro.local”, “port” : 30001, “version” : “4.0.24”, “gitVersion” : “9df1b3a80f39cf7e7ccd6264a207518426a524f6” }, “plannerVersion” : 1, “namespace” : “test.finefoods”, “indexFilterSet” : false, “parsedQuery” : { “userId” : { “$eq” : “A10CJYBXXJ2BKB” } }, “winningPlan” : { “stage” : “SHARDING_FILTER”, “inputStage” : { “stage” : “COLLSCAN”, “filter” : { “userId” : { “$eq” : “A10CJYBXXJ2BKB” } }, “direction” : “forward” } }, “rejectedPlans” : [ ] }, { “shardName” : “shard03", “connectionString” : “shard03/localhost:30007,localhost:30008,localhost:30009", “serverInfo” : { “host” : “Christophers-MacBook-Pro.local”, “port” : 30007, “version” : “4.0.24", “gitVersion” : “9df1b3a80f39cf7e7ccd6264a207518426a524f6" }, “plannerVersion” : 1, “namespace” : “test.finefoods”, “indexFilterSet” : false, “parsedQuery” : { “userId” : { “$eq” : “A10CJYBXXJ2BKB” } }, “winningPlan” : { “stage” : “SHARDING_FILTER”, “inputStage” : { “stage” : “COLLSCAN”, “filter” : { “userId” : { “$eq” : “A10CJYBXXJ2BKB” } }, “direction” : “forward” } }, “rejectedPlans” : [ ] }, { “shardName” : “shard02”, “connectionString” : “shard02/localhost:30004,localhost:30005,localhost:30006”, “serverInfo” : { “host” : “Christophers-MacBook-Pro.local”, “port” : 30004, “version” : “4.0.24”, “gitVersion” : “9df1b3a80f39cf7e7ccd6264a207518426a524f6” }, “plannerVersion” : 1, “namespace” : “test.finefoods”, “indexFilterSet” : false, “parsedQuery” : { “userId” : { “$eq” : “A10CJYBXXJ2BKB” } }, “winningPlan” : { “stage” : “SHARDING_FILTER”, “inputStage” : { “stage” : “COLLSCAN”, “filter” : { “userId” : { “$eq” : “A10CJYBXXJ2BKB” } }, “direction” : “forward” } }, “rejectedPlans” : [ ] } ] } }, “executionStats” : { “nReturned” : 1, “executionTimeMillis” : 61, “totalKeysExamined” : 0, “totalDocsExamined” : 285000, “executionStages” : { “stage” : “SHARD_MERGE”, “nReturned” : 1, “executionTimeMillis” : 61, “totalKeysExamined” : 0, “totalDocsExamined” : 285000, “totalChildMillis” : NumberLong(148), “shards” : [ { “shardName” : “shard01", “executionSuccess” : true, “executionStages” : { “stage” : “SHARDING_FILTER”, “nReturned” : 1, “executionTimeMillisEstimate” : 22, “works” : 55649, “advanced” : 1, “needTime” : 55647, “needYield” : 0, “saveState” : 435, “restoreState” : 435, “isEOF” : 1, “invalidates” : 0, “chunkSkips” : 0, “inputStage” : { “stage” : “COLLSCAN”, “filter” : { “userId” : { “$eq” : “A10CJYBXXJ2BKB” } }, “nReturned” : 1, “executionTimeMillisEstimate” : 22, “works” : 55649, “advanced” : 1, “needTime” : 55647, “needYield” : 0, “saveState” : 435, “restoreState” : 435, “isEOF” : 1, “invalidates” : 0, “direction” : “forward”, “docsExamined” : 55647 } } }, { “shardName” : “shard03”, “executionSuccess” : true, “executionStages” : { “stage” : “SHARDING_FILTER”, “nReturned” : 0, “executionTimeMillisEstimate” : 44, “works” : 114528, “advanced” : 0, “needTime” : 114527, “needYield” : 0, “saveState” : 895, “restoreState” : 895, “isEOF” : 1, “invalidates” : 0, “chunkSkips” : 0, “inputStage” : { “stage” : “COLLSCAN”, “filter” : { “userId” : { “$eq” : “A10CJYBXXJ2BKB” } }, “nReturned” : 0, “executionTimeMillisEstimate” : 32, “works” : 114528, “advanced” : 0, “needTime” : 114527, “needYield” : 0, “saveState” : 895, “restoreState” : 895, “isEOF” : 1, “invalidates” : 0, “direction” : “forward”, “docsExamined” : 114526 } } }, { “shardName” : “shard02", “executionSuccess” : true, “executionStages” : { “stage” : “SHARDING_FILTER”, “nReturned” : 0, “executionTimeMillisEstimate” : 45, “works” : 114829, “advanced” : 0, “needTime” : 114828, “needYield” : 0, “saveState” : 897, “restoreState” : 897, “isEOF” : 1, “invalidates” : 0, “chunkSkips” : 0, “inputStage” : { “stage” : “COLLSCAN”, “filter” : { “userId” : { “$eq” : “A10CJYBXXJ2BKB” } }, “nReturned” : 0, “executionTimeMillisEstimate” : 45, “works” : 114829, “advanced” : 0, “needTime” : 114828, “needYield” : 0, “saveState” : 897, “restoreState” : 897, “isEOF” : 1, “invalidates” : 0, “direction” : “forward”, “docsExamined” : 114827 } } } ] }, “allPlansExecution” : [ { “shardName” : “shard01", “allPlans” : [ ] }, { “shardName” : “shard03”, “allPlans” : [ ] }, { “shardName” : “shard02", “allPlans” : [ ] } ] }, “serverInfo” : { “host” : “Christophers-MacBook-Pro.local”, “port” : 30000, “version” : “4.0.24”, “gitVersion” : “9df1b3a80f39cf7e7ccd6264a207518426a524f6” }, “ok” : 1, “operationTime” : Timestamp(1620230291, 1), “$clusterTime” : { “clusterTime” : Timestamp(1620230291, 1), “signature” : { “hash” : BinData(0,“i1XTHhGi9hSTyZYHqZnS0CgfzQM=“), “keyId” : NumberLong(“6956251976040448020") } } }