{ "queryPlanner" : { "plannerVersion" : NumberInt(1), "namespace" : "test.fast", "indexFilterSet" : false, "parsedQuery" : { "$and" : [ { "age" : { "$lt" : NumberInt(777217) } }, { "email" : { "$lt" : "z" } }, { "name" : { "$lt" : "z" } }, { "age" : { "$gt" : NumberInt(200) } }, { "email" : { "$gt" : "bdnsa28831283d" } }, { "name" : { "$gt" : "1234" } } ] }, "winningPlan" : { "stage" : "LIMIT", "limitAmount" : NumberInt(20), "inputStage" : { "stage" : "SKIP", "skipAmount" : NumberInt(0), "inputStage" : { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "age" : NumberInt(1), "name" : NumberInt(1), "email" : NumberInt(1) }, "indexName" : "age_1_name_1_email_1", "isMultiKey" : false, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : NumberInt(1), "direction" : "forward", "indexBounds" : { "age" : [ "(200.0, 777217.0)" ], "name" : [ "(\"1234\", \"z\")" ], "email" : [ "(\"bdnsa28831283d\", \"z\")" ] } } } } }, "rejectedPlans" : [ { "stage" : "LIMIT", "limitAmount" : NumberInt(20), "inputStage" : { "stage" : "SKIP", "skipAmount" : NumberInt(0), "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "email" : { "$lt" : "z" } }, { "name" : { "$lt" : "z" } }, { "email" : { "$gt" : "bdnsa28831283d" } }, { "name" : { "$gt" : "1234" } } ] }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "age" : NumberInt(1) }, "indexName" : "age_1", "isMultiKey" : false, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : NumberInt(1), "direction" : "forward", "indexBounds" : { "age" : [ "(200.0, 777217.0)" ] } } } } } ] }, "executionStats" : { "executionSuccess" : true, "nReturned" : NumberInt(20), "executionTimeMillis" : NumberInt(4), "totalKeysExamined" : NumberInt(563), "totalDocsExamined" : NumberInt(360), "executionStages" : { "stage" : "LIMIT", "nReturned" : NumberInt(20), "executionTimeMillisEstimate" : NumberInt(0), "works" : NumberInt(564), "advanced" : NumberInt(20), "needTime" : NumberInt(543), "needYield" : NumberInt(0), "saveState" : NumberInt(8), "restoreState" : NumberInt(8), "isEOF" : NumberInt(1), "invalidates" : NumberInt(0), "limitAmount" : NumberInt(20), "inputStage" : { "stage" : "SKIP", "nReturned" : NumberInt(20), "executionTimeMillisEstimate" : NumberInt(0), "works" : NumberInt(563), "advanced" : NumberInt(20), "needTime" : NumberInt(543), "needYield" : NumberInt(0), "saveState" : NumberInt(8), "restoreState" : NumberInt(8), "isEOF" : NumberInt(0), "invalidates" : NumberInt(0), "skipAmount" : NumberInt(0), "inputStage" : { "stage" : "FETCH", "nReturned" : NumberInt(360), "executionTimeMillisEstimate" : NumberInt(0), "works" : NumberInt(563), "advanced" : NumberInt(360), "needTime" : NumberInt(203), "needYield" : NumberInt(0), "saveState" : NumberInt(8), "restoreState" : NumberInt(8), "isEOF" : NumberInt(0), "invalidates" : NumberInt(0), "docsExamined" : NumberInt(360), "alreadyHasObj" : NumberInt(0), "inputStage" : { "stage" : "IXSCAN", "nReturned" : NumberInt(360), "executionTimeMillisEstimate" : NumberInt(0), "works" : NumberInt(563), "advanced" : NumberInt(360), "needTime" : NumberInt(203), "needYield" : NumberInt(0), "saveState" : NumberInt(8), "restoreState" : NumberInt(8), "isEOF" : NumberInt(0), "invalidates" : NumberInt(0), "keyPattern" : { "age" : NumberInt(1), "name" : NumberInt(1), "email" : NumberInt(1) }, "indexName" : "age_1_name_1_email_1", "isMultiKey" : false, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : NumberInt(1), "direction" : "forward", "indexBounds" : { "age" : [ "(200.0, 777217.0)" ], "name" : [ "(\"1234\", \"z\")" ], "email" : [ "(\"bdnsa28831283d\", \"z\")" ] }, "keysExamined" : NumberInt(563), "dupsTested" : NumberInt(0), "dupsDropped" : NumberInt(0), "seenInvalidated" : NumberInt(0) } } } }, "allPlansExecution" : [ { "nReturned" : NumberInt(20), "executionTimeMillisEstimate" : NumberInt(10), "totalKeysExamined" : NumberInt(563), "totalDocsExamined" : NumberInt(563), "executionStages" : { "stage" : "LIMIT", "nReturned" : NumberInt(20), "executionTimeMillisEstimate" : NumberInt(10), "works" : NumberInt(563), "advanced" : NumberInt(20), "needTime" : NumberInt(543), "needYield" : NumberInt(0), "saveState" : NumberInt(8), "restoreState" : NumberInt(8), "isEOF" : NumberInt(1), "invalidates" : NumberInt(0), "limitAmount" : NumberInt(20), "inputStage" : { "stage" : "SKIP", "nReturned" : NumberInt(20), "executionTimeMillisEstimate" : NumberInt(10), "works" : NumberInt(563), "advanced" : NumberInt(20), "needTime" : NumberInt(543), "needYield" : NumberInt(0), "saveState" : NumberInt(8), "restoreState" : NumberInt(8), "isEOF" : NumberInt(0), "invalidates" : NumberInt(0), "skipAmount" : NumberInt(0), "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "email" : { "$lt" : "z" } }, { "name" : { "$lt" : "z" } }, { "email" : { "$gt" : "bdnsa28831283d" } }, { "name" : { "$gt" : "1234" } } ] }, "nReturned" : NumberInt(360), "executionTimeMillisEstimate" : NumberInt(10), "works" : NumberInt(563), "advanced" : NumberInt(360), "needTime" : NumberInt(203), "needYield" : NumberInt(0), "saveState" : NumberInt(8), "restoreState" : NumberInt(8), "isEOF" : NumberInt(0), "invalidates" : NumberInt(0), "docsExamined" : NumberInt(563), "alreadyHasObj" : NumberInt(0), "inputStage" : { "stage" : "IXSCAN", "nReturned" : NumberInt(563), "executionTimeMillisEstimate" : NumberInt(10), "works" : NumberInt(563), "advanced" : NumberInt(563), "needTime" : NumberInt(0), "needYield" : NumberInt(0), "saveState" : NumberInt(8), "restoreState" : NumberInt(8), "isEOF" : NumberInt(0), "invalidates" : NumberInt(0), "keyPattern" : { "age" : NumberInt(1) }, "indexName" : "age_1", "isMultiKey" : false, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : NumberInt(1), "direction" : "forward", "indexBounds" : { "age" : [ "(200.0, 777217.0)" ] }, "keysExamined" : NumberInt(563), "dupsTested" : NumberInt(0), "dupsDropped" : NumberInt(0), "seenInvalidated" : NumberInt(0) } } } } }, { "nReturned" : NumberInt(20), "executionTimeMillisEstimate" : NumberInt(0), "totalKeysExamined" : NumberInt(563), "totalDocsExamined" : NumberInt(360), "executionStages" : { "stage" : "LIMIT", "nReturned" : NumberInt(20), "executionTimeMillisEstimate" : NumberInt(0), "works" : NumberInt(563), "advanced" : NumberInt(20), "needTime" : NumberInt(543), "needYield" : NumberInt(0), "saveState" : NumberInt(8), "restoreState" : NumberInt(8), "isEOF" : NumberInt(1), "invalidates" : NumberInt(0), "limitAmount" : NumberInt(20), "inputStage" : { "stage" : "SKIP", "nReturned" : NumberInt(20), "executionTimeMillisEstimate" : NumberInt(0), "works" : NumberInt(563), "advanced" : NumberInt(20), "needTime" : NumberInt(543), "needYield" : NumberInt(0), "saveState" : NumberInt(8), "restoreState" : NumberInt(8), "isEOF" : NumberInt(0), "invalidates" : NumberInt(0), "skipAmount" : NumberInt(0), "inputStage" : { "stage" : "FETCH", "nReturned" : NumberInt(360), "executionTimeMillisEstimate" : NumberInt(0), "works" : NumberInt(563), "advanced" : NumberInt(360), "needTime" : NumberInt(203), "needYield" : NumberInt(0), "saveState" : NumberInt(8), "restoreState" : NumberInt(8), "isEOF" : NumberInt(0), "invalidates" : NumberInt(0), "docsExamined" : NumberInt(360), "alreadyHasObj" : NumberInt(0), "inputStage" : { "stage" : "IXSCAN", "nReturned" : NumberInt(360), "executionTimeMillisEstimate" : NumberInt(0), "works" : NumberInt(563), "advanced" : NumberInt(360), "needTime" : NumberInt(203), "needYield" : NumberInt(0), "saveState" : NumberInt(8), "restoreState" : NumberInt(8), "isEOF" : NumberInt(0), "invalidates" : NumberInt(0), "keyPattern" : { "age" : NumberInt(1), "name" : NumberInt(1), "email" : NumberInt(1) }, "indexName" : "age_1_name_1_email_1", "isMultiKey" : false, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : NumberInt(1), "direction" : "forward", "indexBounds" : { "age" : [ "(200.0, 777217.0)" ], "name" : [ "(\"1234\", \"z\")" ], "email" : [ "(\"bdnsa28831283d\", \"z\")" ] }, "keysExamined" : NumberInt(563), "dupsTested" : NumberInt(0), "dupsDropped" : NumberInt(0), "seenInvalidated" : NumberInt(0) } } } } } ] }, "serverInfo" : { "host" : "MacBook-Pro.local", "port" : NumberInt(27017), "version" : "3.2.1", "gitVersion" : "a14d55980c2cdc565d4704a7e3ad37e4e535c1b2" }, "ok" : NumberInt(1) }