MongoDB shell version: 3.0.1 connecting to: xxxxxxxxxxxxxxxx/test switched to db goods db.events.getPlanCache().listQueryShapes() [ { "query" : { "u" : { "$lt" : ISODate("2015-03-20T20:21:43Z") }, "ntfy" : true }, "sort" : { }, "projection" : { } }, { "query" : { "gt" : ObjectId("540df0cef4ac855dca049124"), "act" : "attr", "lang" : "RU", "ta" : "name", "st" : 1 }, "sort" : { }, "projection" : { } }, { "query" : { "notif_friends_scan" : { "$ne" : NumberLong(0) }, "c_rel" : { "$ne" : NumberLong(0) }, "rel_accept" : true, "act" : "rel", "ut" : ObjectId("4f6887482721dda11ac3b1ca") }, "sort" : { }, "projection" : { } }, { "query" : { "notif_friends_fb" : { "$ne" : NumberLong(0) }, "c_rel" : { "$ne" : NumberLong(0) }, "rel_accept" : true, "act" : "rel", "ut" : ObjectId("4f6887482721dda11ac3b1ca") }, "sort" : { }, "projection" : { } }, { "query" : { "c_rel" : { "$ne" : NumberLong(0) }, "rel_accept" : true, "notif_friends_rate" : { "$ne" : NumberLong(0) }, "act" : "rel", "ut" : ObjectId("4f6887482721dda11ac3b1ca") }, "sort" : { }, "projection" : { } }, { "query" : { "notif_friends_photo" : { "$ne" : NumberLong(0) }, "c_rel" : { "$ne" : NumberLong(0) }, "rel_accept" : true, "act" : "rel", "ut" : ObjectId("4f6887482721dda11ac3b1ca") }, "sort" : { }, "projection" : { } }, { "query" : { "notif_friends_pur" : { "$ne" : NumberLong(0) }, "c_rel" : { "$ne" : NumberLong(0) }, "rel_accept" : true, "act" : "rel", "ut" : ObjectId("4f6887482721dda11ac3b1ca") }, "sort" : { }, "projection" : { } } ] db.events.getPlanCache().getPlansByQuery({ gt: ObjectId('53216161688fcfc9fed24755'), act: "attr", lang: "RU", ta : "name", st: 1 }); [ { "details" : { "solution" : "(index-tagged expression tree: tree=Node\n---Leaf { gt: 1.0, ut: 1.0, act: 1.0, ta: 1.0, lang: 1.0 }, pos: 2\n---Leaf { gt: 1.0, ut: 1.0, act: 1.0, ta: 1.0, lang: 1.0 }, pos: 0\n---Leaf { gt: 1.0, ut: 1.0, act: 1.0, ta: 1.0, lang: 1.0 }, pos: 4\n---Leaf \n---Leaf { gt: 1.0, ut: 1.0, act: 1.0, ta: 1.0, lang: 1.0 }, pos: 3\n)" }, "reason" : { "score" : 2.0003, "stats" : { "stage" : "LIMIT", "nReturned" : 1, "executionTimeMillisEstimate" : 160, "works" : 1, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 1, "invalidates" : 0, "limitAmount" : 0, "inputStage" : { "stage" : "KEEP_MUTATIONS", "nReturned" : 1, "executionTimeMillisEstimate" : 160, "works" : 1, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "inputStage" : { "stage" : "SHARDING_FILTER", "nReturned" : 1, "executionTimeMillisEstimate" : 160, "works" : 1, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "chunkSkips" : 0, "inputStage" : { "stage" : "FETCH", "filter" : { "st" : { "$eq" : 1 } }, "nReturned" : 1, "executionTimeMillisEstimate" : 160, "works" : 1, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "docsExamined" : 1, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 1, "executionTimeMillisEstimate" : 160, "works" : 1, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "keyPattern" : { "gt" : 1, "ut" : 1, "act" : 1, "ta" : 1, "lang" : 1 }, "indexName" : "gt_1_ut_1_act_1_ta_1_lang_1", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "gt" : [ "[ObjectId('540df0cef4ac855dca049124'), ObjectId('540df0cef4ac855dca049124')]" ], "ut" : [ "[MinKey, MaxKey]" ], "act" : [ "[\"attr\", \"attr\"]" ], "ta" : [ "[\"name\", \"name\"]" ], "lang" : [ "[\"RU\", \"RU\"]" ] }, "keysExamined" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 0 } } } } } }, "feedback" : { "nfeedback" : 20, "averageScore" : 1.4332166666666664, "stdDevScore" : 0.2798348902289951, "scores" : [ { "score" : 1.1669666666666667 }, { "score" : 1.3336333333333332 }, { "score" : 1.1669666666666667 }, { "score" : 1.2003 }, { "score" : 1.5003 }, { "score" : 1.5003 }, { "score" : 1.5003 }, { "score" : 1.3336333333333332 }, { "score" : 2.0003 }, { "score" : 1.1253 }, { "score" : 1.5003 }, { "score" : 1.3336333333333332 }, { "score" : 1.5003 }, { "score" : 1.2503 }, { "score" : 2.0003 }, { "score" : 1.0836333333333332 }, { "score" : 2.0003 }, { "score" : 1.3336333333333332 }, { "score" : 1.3336333333333332 }, { "score" : 1.5003 } ] }, "filterSet" : false }, { "details" : { "solution" : "(index-tagged expression tree: tree=Node\n---Leaf { gt: 1, act: 1, lang: 1, ta: 1 }, pos: 1\n---Leaf { gt: 1, act: 1, lang: 1, ta: 1 }, pos: 0\n---Leaf { gt: 1, act: 1, lang: 1, ta: 1 }, pos: 2\n---Leaf \n---Leaf { gt: 1, act: 1, lang: 1, ta: 1 }, pos: 3\n)" }, "reason" : { "score" : 1.0003, "stats" : { "stage" : "LIMIT", "nReturned" : 0, "executionTimeMillisEstimate" : 30, "works" : 1, "advanced" : 0, "needTime" : 1, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "limitAmount" : 1, "inputStage" : { "stage" : "KEEP_MUTATIONS", "nReturned" : 0, "executionTimeMillisEstimate" : 30, "works" : 1, "advanced" : 0, "needTime" : 1, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "inputStage" : { "stage" : "SHARDING_FILTER", "nReturned" : 0, "executionTimeMillisEstimate" : 30, "works" : 1, "advanced" : 0, "needTime" : 1, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "chunkSkips" : 0, "inputStage" : { "stage" : "FETCH", "filter" : { "st" : { "$eq" : 1 } }, "nReturned" : 0, "executionTimeMillisEstimate" : 30, "works" : 1, "advanced" : 0, "needTime" : 1, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "docsExamined" : 1, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 1, "executionTimeMillisEstimate" : 30, "works" : 1, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "keyPattern" : { "gt" : 1, "act" : 1, "lang" : 1, "ta" : 1 }, "indexName" : "gt_act_lang_ta", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "gt" : [ "[ObjectId('540df0cef4ac855dca049124'), ObjectId('540df0cef4ac855dca049124')]" ], "act" : [ "[\"attr\", \"attr\"]" ], "lang" : [ "[\"RU\", \"RU\"]" ], "ta" : [ "[\"name\", \"name\"]" ] }, "keysExamined" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 0 } } } } } }, "feedback" : { }, "filterSet" : false }, { "details" : { "solution" : "(index-tagged expression tree: tree=Node\n---Leaf { act: 1, ta: 1, c: 1 }, pos: 0\n---Leaf \n---Leaf \n---Leaf \n---Leaf { act: 1, ta: 1, c: 1 }, pos: 1\n)" }, "reason" : { "score" : 1.0003, "stats" : { "stage" : "LIMIT", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 1, "advanced" : 0, "needTime" : 1, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "limitAmount" : 1, "inputStage" : { "stage" : "KEEP_MUTATIONS", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 1, "advanced" : 0, "needTime" : 1, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "inputStage" : { "stage" : "SHARDING_FILTER", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 1, "advanced" : 0, "needTime" : 1, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "chunkSkips" : 0, "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "gt" : { "$eq" : ObjectId("540df0cef4ac855dca049124") } }, { "lang" : { "$eq" : "RU" } }, { "st" : { "$eq" : 1 } } ] }, "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 1, "advanced" : 0, "needTime" : 1, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "docsExamined" : 1, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 1, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "keyPattern" : { "act" : 1, "ta" : 1, "c" : 1 }, "indexName" : "act_ta_c", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "act" : [ "[\"attr\", \"attr\"]" ], "ta" : [ "[\"name\", \"name\"]" ], "c" : [ "[MinKey, MaxKey]" ] }, "keysExamined" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 0 } } } } } }, "feedback" : { }, "filterSet" : false }, { "details" : { "solution" : "(index-tagged expression tree: tree=Node\n---Leaf { act: 1, c: -1 }, pos: 0\n---Leaf \n---Leaf \n---Leaf \n---Leaf \n)" }, "reason" : { "score" : 1.0003, "stats" : { "stage" : "LIMIT", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 1, "advanced" : 0, "needTime" : 1, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "limitAmount" : 1, "inputStage" : { "stage" : "KEEP_MUTATIONS", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 1, "advanced" : 0, "needTime" : 1, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "inputStage" : { "stage" : "SHARDING_FILTER", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 1, "advanced" : 0, "needTime" : 1, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "chunkSkips" : 0, "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "gt" : { "$eq" : ObjectId("540df0cef4ac855dca049124") } }, { "lang" : { "$eq" : "RU" } }, { "st" : { "$eq" : 1 } }, { "ta" : { "$eq" : "name" } } ] }, "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 1, "advanced" : 0, "needTime" : 1, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "docsExamined" : 1, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 1, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "keyPattern" : { "act" : 1, "c" : -1 }, "indexName" : "act_create", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "act" : [ "[\"attr\", \"attr\"]" ], "c" : [ "[MaxKey, MinKey]" ] }, "keysExamined" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 0 } } } } } }, "feedback" : { }, "filterSet" : false } ] db.events.find({ gt: ObjectId('53216161688fcfc9fed24755'), act: "attr", lang: "RU", ta : "name", st: 1 }).explain(true); { "queryPlanner" : { "plannerVersion" : 1, "namespace" : "goods.events", "indexFilterSet" : false, "parsedQuery" : { "$and" : [ { "act" : { "$eq" : "attr" } }, { "gt" : { "$eq" : ObjectId("53216161688fcfc9fed24755") } }, { "lang" : { "$eq" : "RU" } }, { "st" : { "$eq" : 1 } }, { "ta" : { "$eq" : "name" } } ] }, "winningPlan" : { "stage" : "KEEP_MUTATIONS", "inputStage" : { "stage" : "FETCH", "filter" : { "st" : { "$eq" : 1 } }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "gt" : 1, "act" : 1, "lang" : 1, "ta" : 1 }, "indexName" : "gt_act_lang_ta", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "gt" : [ "[ObjectId('53216161688fcfc9fed24755'), ObjectId('53216161688fcfc9fed24755')]" ], "act" : [ "[\"attr\", \"attr\"]" ], "lang" : [ "[\"RU\", \"RU\"]" ], "ta" : [ "[\"name\", \"name\"]" ] } } } }, "rejectedPlans" : [ { "stage" : "KEEP_MUTATIONS", "inputStage" : { "stage" : "FETCH", "filter" : { "st" : { "$eq" : 1 } }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "gt" : 1, "ut" : 1, "act" : 1, "ta" : 1, "lang" : 1 }, "indexName" : "gt_1_ut_1_act_1_ta_1_lang_1", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "gt" : [ "[ObjectId('53216161688fcfc9fed24755'), ObjectId('53216161688fcfc9fed24755')]" ], "ut" : [ "[MinKey, MaxKey]" ], "act" : [ "[\"attr\", \"attr\"]" ], "ta" : [ "[\"name\", \"name\"]" ], "lang" : [ "[\"RU\", \"RU\"]" ] } } } }, { "stage" : "KEEP_MUTATIONS", "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "gt" : { "$eq" : ObjectId("53216161688fcfc9fed24755") } }, { "lang" : { "$eq" : "RU" } }, { "st" : { "$eq" : 1 } } ] }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "act" : 1, "ta" : 1, "c" : 1 }, "indexName" : "act_ta_c", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "act" : [ "[\"attr\", \"attr\"]" ], "ta" : [ "[\"name\", \"name\"]" ], "c" : [ "[MinKey, MaxKey]" ] } } } }, { "stage" : "KEEP_MUTATIONS", "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "gt" : { "$eq" : ObjectId("53216161688fcfc9fed24755") } }, { "lang" : { "$eq" : "RU" } }, { "st" : { "$eq" : 1 } }, { "ta" : { "$eq" : "name" } } ] }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "act" : 1, "c" : -1 }, "indexName" : "act_create", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "act" : [ "[\"attr\", \"attr\"]" ], "c" : [ "[MaxKey, MinKey]" ] } } } } ] }, "executionStats" : { "executionSuccess" : true, "nReturned" : 1, "executionTimeMillis" : 0, "totalKeysExamined" : 1, "totalDocsExamined" : 1, "executionStages" : { "stage" : "KEEP_MUTATIONS", "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 3, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "inputStage" : { "stage" : "FETCH", "filter" : { "st" : { "$eq" : 1 } }, "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 1, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "gt" : 1, "act" : 1, "lang" : 1, "ta" : 1 }, "indexName" : "gt_act_lang_ta", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "gt" : [ "[ObjectId('53216161688fcfc9fed24755'), ObjectId('53216161688fcfc9fed24755')]" ], "act" : [ "[\"attr\", \"attr\"]" ], "lang" : [ "[\"RU\", \"RU\"]" ], "ta" : [ "[\"name\", \"name\"]" ] }, "keysExamined" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 0 } } }, "allPlansExecution" : [ { "nReturned" : 1, "executionTimeMillisEstimate" : 0, "totalKeysExamined" : 2, "totalDocsExamined" : 1, "executionStages" : { "stage" : "KEEP_MUTATIONS", "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 1, "needTime" : 1, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 0, "invalidates" : 0, "inputStage" : { "stage" : "FETCH", "filter" : { "st" : { "$eq" : 1 } }, "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 1, "needTime" : 1, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 0, "invalidates" : 0, "docsExamined" : 1, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 1, "needTime" : 1, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 0, "invalidates" : 0, "keyPattern" : { "gt" : 1, "ut" : 1, "act" : 1, "ta" : 1, "lang" : 1 }, "indexName" : "gt_1_ut_1_act_1_ta_1_lang_1", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "gt" : [ "[ObjectId('53216161688fcfc9fed24755'), ObjectId('53216161688fcfc9fed24755')]" ], "ut" : [ "[MinKey, MaxKey]" ], "act" : [ "[\"attr\", \"attr\"]" ], "ta" : [ "[\"name\", \"name\"]" ], "lang" : [ "[\"RU\", \"RU\"]" ] }, "keysExamined" : 2, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 0 } } } }, { "nReturned" : 0, "executionTimeMillisEstimate" : 0, "totalKeysExamined" : 2, "totalDocsExamined" : 2, "executionStages" : { "stage" : "KEEP_MUTATIONS", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 0, "needTime" : 2, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 0, "invalidates" : 0, "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "gt" : { "$eq" : ObjectId("53216161688fcfc9fed24755") } }, { "lang" : { "$eq" : "RU" } }, { "st" : { "$eq" : 1 } } ] }, "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 0, "needTime" : 2, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 0, "invalidates" : 0, "docsExamined" : 2, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 2, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 2, "needTime" : 0, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 0, "invalidates" : 0, "keyPattern" : { "act" : 1, "ta" : 1, "c" : 1 }, "indexName" : "act_ta_c", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "act" : [ "[\"attr\", \"attr\"]" ], "ta" : [ "[\"name\", \"name\"]" ], "c" : [ "[MinKey, MaxKey]" ] }, "keysExamined" : 2, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 0 } } } }, { "nReturned" : 0, "executionTimeMillisEstimate" : 0, "totalKeysExamined" : 2, "totalDocsExamined" : 2, "executionStages" : { "stage" : "KEEP_MUTATIONS", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 0, "needTime" : 2, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 0, "invalidates" : 0, "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "gt" : { "$eq" : ObjectId("53216161688fcfc9fed24755") } }, { "lang" : { "$eq" : "RU" } }, { "st" : { "$eq" : 1 } }, { "ta" : { "$eq" : "name" } } ] }, "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 0, "needTime" : 2, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 0, "invalidates" : 0, "docsExamined" : 2, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 2, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 2, "needTime" : 0, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 0, "invalidates" : 0, "keyPattern" : { "act" : 1, "c" : -1 }, "indexName" : "act_create", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "act" : [ "[\"attr\", \"attr\"]" ], "c" : [ "[MaxKey, MinKey]" ] }, "keysExamined" : 2, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 0 } } } }, { "nReturned" : 1, "executionTimeMillisEstimate" : 0, "totalKeysExamined" : 1, "totalDocsExamined" : 1, "executionStages" : { "stage" : "KEEP_MUTATIONS", "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "inputStage" : { "stage" : "FETCH", "filter" : { "st" : { "$eq" : 1 } }, "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 1, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 1, "needTime" : 0, "needFetch" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "gt" : 1, "act" : 1, "lang" : 1, "ta" : 1 }, "indexName" : "gt_act_lang_ta", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "gt" : [ "[ObjectId('53216161688fcfc9fed24755'), ObjectId('53216161688fcfc9fed24755')]" ], "act" : [ "[\"attr\", \"attr\"]" ], "lang" : [ "[\"RU\", \"RU\"]" ], "ta" : [ "[\"name\", \"name\"]" ] }, "keysExamined" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 0 } } } } ] }, "serverInfo" : { "host" : "xxxxxxxxxxxxxxxxxx", "port" : xxxx, "version" : "3.0.1", "gitVersion" : "534b5a3f9d10f00cd27737fbcd951032248b5952" }, "ok" : 1, "$gleStats" : { "lastOpTime" : Timestamp(0, 0), "electionId" : ObjectId("550b2519f32388e78aa34383") } } bye