birs0:SECONDARY> db.order.find({'order_status':{$elemMatch:{'update_time':{$gte:ISODate('2015-11-17T16:00:00+08'),$lt:ISODate('2015-11-17T17:00:00+08')},'status':2}}},{_id:0,order_id:1,'buyers.uid':1}).explain('allPlansExecution'); { "queryPlanner" : { "plannerVersion" : 1, "namespace" : "business_message.order", "indexFilterSet" : false, "parsedQuery" : { "order_status" : { "$elemMatch" : { "$and" : [ { "status" : { "$eq" : 2 } }, { "update_time" : { "$lt" : ISODate("2015-11-17T09:00:00Z") } }, { "update_time" : { "$gte" : ISODate("2015-11-17T08:00:00Z") } } ] } } }, "winningPlan" : { "stage" : "PROJECTION", "transformBy" : { "_id" : 0, "order_id" : 1, "buyers.uid" : 1 }, "inputStage" : { "stage" : "FETCH", "filter" : { "order_status" : { "$elemMatch" : { "$and" : [ { "update_time" : { "$lt" : ISODate("2015-11-17T09:00:00Z") } }, { "status" : { "$eq" : 2 } }, { "update_time" : { "$gte" : ISODate("2015-11-17T08:00:00Z") } } ] } } }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "order_status.update_time" : -1, "order_status.status" : -1 }, "indexName" : "order_status.update_time_-1_order_status.status_-1", "isMultiKey" : true, "direction" : "forward", "indexBounds" : { "order_status.update_time" : [ "(new Date(1447750800000), true)" ], "order_status.status" : [ "[2.0, 2.0]" ] } } } }, "rejectedPlans" : [ { "stage" : "PROJECTION", "transformBy" : { "_id" : 0, "order_id" : 1, "buyers.uid" : 1 }, "inputStage" : { "stage" : "FETCH", "filter" : { "order_status" : { "$elemMatch" : { "$and" : [ { "update_time" : { "$gte" : ISODate("2015-11-17T08:00:00Z") } }, { "status" : { "$eq" : 2 } }, { "update_time" : { "$lt" : ISODate("2015-11-17T09:00:00Z") } } ] } } }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "order_status.update_time" : -1, "order_status.status" : -1 }, "indexName" : "order_status.update_time_-1_order_status.status_-1", "isMultiKey" : true, "direction" : "forward", "indexBounds" : { "order_status.update_time" : [ "[new Date(9223372036854775807), new Date(1447747200000)]" ], "order_status.status" : [ "[2.0, 2.0]" ] } } } } ] }, "executionStats" : { "executionSuccess" : true, "nReturned" : 9586, "executionTimeMillis" : 1112726, "totalKeysExamined" : 59503675, "totalDocsExamined" : 46794327, "executionStages" : { "stage" : "PROJECTION", "nReturned" : 9586, "executionTimeMillisEstimate" : 1068799, "works" : 59503676, "advanced" : 9586, "needTime" : 59494089, "needFetch" : 0, "saveState" : 465102, "restoreState" : 465102, "isEOF" : 1, "invalidates" : 0, "transformBy" : { "_id" : 0, "order_id" : 1, "buyers.uid" : 1 }, "inputStage" : { "stage" : "FETCH", "filter" : { "order_status" : { "$elemMatch" : { "$and" : [ { "update_time" : { "$lt" : ISODate("2015-11-17T09:00:00Z") } }, { "status" : { "$eq" : 2 } }, { "update_time" : { "$gte" : ISODate("2015-11-17T08:00:00Z") } } ] } } }, "nReturned" : 9586, "executionTimeMillisEstimate" : 1067659, "works" : 59503676, "advanced" : 9586, "needTime" : 59494089, "needFetch" : 0, "saveState" : 465102, "restoreState" : 465102, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 46794327, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 46794327, "executionTimeMillisEstimate" : 142147, "works" : 59503676, "advanced" : 46794327, "needTime" : 12709348, "needFetch" : 0, "saveState" : 465102, "restoreState" : 465102, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "order_status.update_time" : -1, "order_status.status" : -1 }, "indexName" : "order_status.update_time_-1_order_status.status_-1", "isMultiKey" : true, "direction" : "forward", "indexBounds" : { "order_status.update_time" : [ "(new Date(1447750800000), true)" ], "order_status.status" : [ "[2.0, 2.0]" ] }, "keysExamined" : 59503675, "dupsTested" : 46794377, "dupsDropped" : 50, "seenInvalidated" : 0, "matchTested" : 0 } } }, "allPlansExecution" : [ { "nReturned" : 0, "executionTimeMillisEstimate" : 10, "totalKeysExamined" : 135, "totalDocsExamined" : 101, "executionStages" : { "stage" : "PROJECTION", "nReturned" : 0, "executionTimeMillisEstimate" : 10, "works" : 135, "advanced" : 0, "needTime" : 135, "needFetch" : 0, "saveState" : 465102, "restoreState" : 465102, "isEOF" : 0, "invalidates" : 0, "transformBy" : { "_id" : 0, "order_id" : 1, "buyers.uid" : 1 }, "inputStage" : { "stage" : "FETCH", "filter" : { "order_status" : { "$elemMatch" : { "$and" : [ { "update_time" : { "$gte" : ISODate("2015-11-17T08:00:00Z") } }, { "status" : { "$eq" : 2 } }, { "update_time" : { "$lt" : ISODate("2015-11-17T09:00:00Z") } } ] } } }, "nReturned" : 0, "executionTimeMillisEstimate" : 10, "works" : 135, "advanced" : 0, "needTime" : 135, "needFetch" : 0, "saveState" : 465102, "restoreState" : 465102, "isEOF" : 0, "invalidates" : 0, "docsExamined" : 101, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 101, "executionTimeMillisEstimate" : 0, "works" : 135, "advanced" : 101, "needTime" : 34, "needFetch" : 0, "saveState" : 465102, "restoreState" : 465102, "isEOF" : 0, "invalidates" : 0, "keyPattern" : { "order_status.update_time" : -1, "order_status.status" : -1 }, "indexName" : "order_status.update_time_-1_order_status.status_-1", "isMultiKey" : true, "direction" : "forward", "indexBounds" : { "order_status.update_time" : [ "[new Date(9223372036854775807), new Date(1447747200000)]" ], "order_status.status" : [ "[2.0, 2.0]" ] }, "keysExamined" : 135, "dupsTested" : 101, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 0 } } } }, { "nReturned" : 101, "executionTimeMillisEstimate" : 0, "totalKeysExamined" : 135, "totalDocsExamined" : 101, "executionStages" : { "stage" : "PROJECTION", "nReturned" : 101, "executionTimeMillisEstimate" : 0, "works" : 135, "advanced" : 101, "needTime" : 34, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "transformBy" : { "_id" : 0, "order_id" : 1, "buyers.uid" : 1 }, "inputStage" : { "stage" : "FETCH", "filter" : { "order_status" : { "$elemMatch" : { "$and" : [ { "update_time" : { "$lt" : ISODate("2015-11-17T09:00:00Z") } }, { "status" : { "$eq" : 2 } }, { "update_time" : { "$gte" : ISODate("2015-11-17T08:00:00Z") } } ] } } }, "nReturned" : 101, "executionTimeMillisEstimate" : 0, "works" : 135, "advanced" : 101, "needTime" : 34, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "docsExamined" : 101, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 101, "executionTimeMillisEstimate" : 0, "works" : 135, "advanced" : 101, "needTime" : 34, "needFetch" : 0, "saveState" : 2, "restoreState" : 2, "isEOF" : 0, "invalidates" : 0, "keyPattern" : { "order_status.update_time" : -1, "order_status.status" : -1 }, "indexName" : "order_status.update_time_-1_order_status.status_-1", "isMultiKey" : true, "direction" : "forward", "indexBounds" : { "order_status.update_time" : [ "(new Date(1447750800000), true)" ], "order_status.status" : [ "[2.0, 2.0]" ] }, "keysExamined" : 135, "dupsTested" : 101, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 0 } } } } ] }, "serverInfo" : { "host" : "ll-001006015-mongo.bi.prod.bj1", "port" : 31502, "version" : "3.0.7", "gitVersion" : "6ce7cbe8c6b899552dadd907604559806aa2e9bd modules: enterprise" }, "ok" : 1 } birs0:SECONDARY> db.version(); 3.0.7