{ "queryPlanner" : { "mongosPlannerVersion" : 1, "winningPlan" : { "stage" : "SHARD_MERGE", "shards" : [ { "shardName" : "segmentation-rs", "connectionString" : "segmentation-rs/192.168.140.69:27017", "serverInfo" : { "host" : "ip-192-168-140-69", "port" : 27017, "version" : "4.0.5", "gitVersion" : "3739429dd92b92d1b0ab120911a23d50bf03c412" }, "plannerVersion" : 1, "namespace" : "segmentation.contacts", "indexFilterSet" : false, "parsedQuery" : { "COUNTRY" : { "$eq" : "US" } }, "winningPlan" : { "stage" : "COUNT", "inputStage" : { "stage" : "SHARDING_FILTER", "inputStage" : { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "COUNTRY" : 1 }, "indexName" : "COUNTRY_1", "isMultiKey" : false, "multiKeyPaths" : { "COUNTRY" : [ ] }, "isUnique" : false, "isSparse" : true, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "COUNTRY" : [ "[\"US\", \"US\"]" ] } } } } }, "rejectedPlans" : [ ] }, { "shardName" : "segmentation-rs2", "connectionString" : "segmentation-rs2/192.168.152.98:27017", "serverInfo" : { "host" : "ip-192-168-152-98", "port" : 27017, "version" : "4.0.5", "gitVersion" : "3739429dd92b92d1b0ab120911a23d50bf03c412" }, "plannerVersion" : 1, "namespace" : "segmentation.contacts", "indexFilterSet" : false, "parsedQuery" : { "COUNTRY" : { "$eq" : "US" } }, "winningPlan" : { "stage" : "COUNT", "inputStage" : { "stage" : "SHARDING_FILTER", "inputStage" : { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "COUNTRY" : 1 }, "indexName" : "COUNTRY_1", "isMultiKey" : false, "multiKeyPaths" : { "COUNTRY" : [ ] }, "isUnique" : false, "isSparse" : true, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "COUNTRY" : [ "[\"US\", \"US\"]" ] } } } } }, "rejectedPlans" : [ ] } ] } }, "executionStats" : { "nReturned" : 0, "executionTimeMillis" : 34224, "totalKeysExamined" : 13844662, "totalDocsExamined" : 13844662, "executionStages" : { "stage" : "SHARD_MERGE", "nReturned" : 0, "executionTimeMillis" : 34224, "totalKeysExamined" : 13844662, "totalDocsExamined" : 13844662, "totalChildMillis" : NumberLong(63271), "shards" : [ { "shardName" : "segmentation-rs", "executionSuccess" : true, "executionStages" : { "stage" : "COUNT", "nReturned" : 0, "executionTimeMillisEstimate" : 27860, "works" : 6923922, "advanced" : 0, "needTime" : 6923921, "needYield" : 0, "saveState" : 54093, "restoreState" : 54093, "isEOF" : 1, "invalidates" : 0, "nCounted" : 6923921, "nSkipped" : 0, "inputStage" : { "stage" : "SHARDING_FILTER", "nReturned" : 6923921, "executionTimeMillisEstimate" : 27410, "works" : 6923922, "advanced" : 6923921, "needTime" : 0, "needYield" : 0, "saveState" : 54093, "restoreState" : 54093, "isEOF" : 1, "invalidates" : 0, "chunkSkips" : 0, "inputStage" : { "stage" : "FETCH", "nReturned" : 6923921, "executionTimeMillisEstimate" : 16480, "works" : 6923922, "advanced" : 6923921, "needTime" : 0, "needYield" : 0, "saveState" : 54093, "restoreState" : 54093, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 6923921, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 6923921, "executionTimeMillisEstimate" : 3500, "works" : 6923922, "advanced" : 6923921, "needTime" : 0, "needYield" : 0, "saveState" : 54093, "restoreState" : 54093, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "COUNTRY" : 1 }, "indexName" : "COUNTRY_1", "isMultiKey" : false, "multiKeyPaths" : { "COUNTRY" : [ ] }, "isUnique" : false, "isSparse" : true, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "COUNTRY" : [ "[\"US\", \"US\"]" ] }, "keysExamined" : 6923921, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0 } } } } }, { "shardName" : "segmentation-rs2", "executionSuccess" : true, "executionStages" : { "stage" : "COUNT", "nReturned" : 0, "executionTimeMillisEstimate" : 33180, "works" : 6920742, "advanced" : 0, "needTime" : 6920741, "needYield" : 0, "saveState" : 54068, "restoreState" : 54068, "isEOF" : 1, "invalidates" : 0, "nCounted" : 6920741, "nSkipped" : 0, "inputStage" : { "stage" : "SHARDING_FILTER", "nReturned" : 6920741, "executionTimeMillisEstimate" : 32500, "works" : 6920742, "advanced" : 6920741, "needTime" : 0, "needYield" : 0, "saveState" : 54068, "restoreState" : 54068, "isEOF" : 1, "invalidates" : 0, "chunkSkips" : 0, "inputStage" : { "stage" : "FETCH", "nReturned" : 6920741, "executionTimeMillisEstimate" : 21430, "works" : 6920742, "advanced" : 6920741, "needTime" : 0, "needYield" : 0, "saveState" : 54068, "restoreState" : 54068, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 6920741, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 6920741, "executionTimeMillisEstimate" : 3610, "works" : 6920742, "advanced" : 6920741, "needTime" : 0, "needYield" : 0, "saveState" : 54068, "restoreState" : 54068, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "COUNTRY" : 1 }, "indexName" : "COUNTRY_1", "isMultiKey" : false, "multiKeyPaths" : { "COUNTRY" : [ ] }, "isUnique" : false, "isSparse" : true, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "COUNTRY" : [ "[\"US\", \"US\"]" ] }, "keysExamined" : 6920741, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0 } } } } } ] }, "allPlansExecution" : [ { "shardName" : "segmentation-rs", "allPlans" : [ ] }, { "shardName" : "segmentation-rs2", "allPlans" : [ ] } ] }, "ok" : 1, "operationTime" : Timestamp(1547463575, 1), "$clusterTime" : { "clusterTime" : Timestamp(1547463575, 1), "signature" : { "hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="), "keyId" : NumberLong(0) } } }