{
"cursor" : "Complex Plan",
"n" : 1,
"nscannedObjects" : 0,
"nscanned" : 10003,
"nChunkSkips" : 0
},
{
"cursor" : "Complex Plan",
"n" : 1,
"nscannedObjects" : 0,
"nscanned" : 10003,
"nChunkSkips" : 0
},
{
"cursor" : "Complex Plan",
"n" : 1,
"nscannedObjects" : 0,
"nscanned" : 10003,
"nChunkSkips" : 0
}
],
--To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/b840891e-3683-4c93-ad4a-0c5e73bee1bf%40googlegroups.com.
You received this message because you are subscribed to the Google Groups "mongodb-user"
group.
For other MongoDB technical support options, see: http://www.mongodb.org/about/support/.
---
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user...@googlegroups.com.
To post to this group, send email to mongod...@googlegroups.com.
Visit this group at http://groups.google.com/group/mongodb-user.
--
You received this message because you are subscribed to the Google Groups "mongodb-user"
group.
For other MongoDB technical support options, see: http://www.mongodb.org/about/support/.
---
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user...@googlegroups.com.
To post to this group, send email to mongod...@googlegroups.com.
Visit this group at http://groups.google.com/group/mongodb-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/9fd4ae29-0c50-40c7-a496-d10d87112688%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/e79e10bb-0e2a-4cc6-910c-42ea2ddfd6d0%40googlegroups.com.
> db.xxx.find({'byUser._id': {$gt: ObjectId("53bf75898de2fb8790ef7f0b")}, activityId: {$gt: ObjectId("53bf75898de2fb8790ef83b6")}, 'activityType': 'SHEET' }).explain(true)
{
"cursor":"BtreeCursor byUser._id_1",
"isMultiKey":false,
"n":2271416,
"nscannedObjects":2272000,
"nscanned":2272000,
"nscannedObjectsAllPlans":2272404,
"nscannedAllPlans":2273021,
"scanAndOrder":false,
"indexOnly":false,
"nYields":54736,
"nChunkSkips":0,
"millis":438548,
"indexBounds":{
"byUser._id":[
[
ObjectId("53bf75898de2fb8790ef7f0b"),
ObjectId("ffffffffffffffffffffffff")
]
]
},
"allPlans":[
{
"cursor":"BtreeCursor byUser._id_1",
"isMultiKey":false,
"n":2271416,
"nscannedObjects":2272000,
"nscanned":2272000,
"scanAndOrder":false,
"indexOnly":false,
"nChunkSkips":0,
"indexBounds":{
"byUser._id":[
[
ObjectId("53bf75898de2fb8790ef7f0b"),
ObjectId("ffffffffffffffffffffffff")
]
]
}
},
{
"cursor":"BtreeCursor activityId_1",
"isMultiKey":false,
"n":0,
"nscannedObjects":202,
"nscanned":203,
"scanAndOrder":false,
"indexOnly":false,
"nChunkSkips":0,
"indexBounds":{
"activityId":[
[
ObjectId("53bf75898de2fb8790ef83b6"),
ObjectId("ffffffffffffffffffffffff")
]
]
}
},
{
"cursor":"BtreeCursor activityType_1",
"isMultiKey":false,
"n":0,
"nscannedObjects":202,
"nscanned":203,
"scanAndOrder":false,
"indexOnly":false,
"nChunkSkips":0,
"indexBounds":{
"activityType":[
[
"SHEET",
"SHEET"
]
]
}
},
{
"cursor":"Complex Plan",
"n":0,
"nscannedObjects":0,
"nscanned":205,
"nChunkSkips":0
},
{
"cursor":"Complex Plan",
"n":0,
"nscannedObjects":0,
"nscanned":205,
"nChunkSkips":0
},
{
"cursor":"Complex Plan",
"n":0,
"nscannedObjects":0,
"nscanned":205,
"nChunkSkips":0
}
],
"server":"admins-MacBook-Pro.local:27017",
"filterSet":false,
"stats":{
"type":"KEEP_MUTATIONS",
"works":2309234,
"yields":54736,
"unyields":54736,
"invalidates":0,
"advanced":2271416,
"needTime":584,
"needFetch":37233,
"isEOF":1,
"children":[
{
"type":"FETCH",
"works":2309234,
"yields":54736,
"unyields":54736,
"invalidates":0,
"advanced":2271416,
"needTime":584,
"needFetch":37233,
"isEOF":1,
"alreadyHasObj":0,
"forcedFetches":0,
"matchTested":2271416,
"children":[
{
"type":"IXSCAN",
"works":2272000,
"yields":54736,
"unyields":54736,
"invalidates":0,
"advanced":2272000,
"needTime":0,
"needFetch":0,
"isEOF":1,
"keyPattern":"{ byUser._id: 1 }",
"boundsVerbose":"field #0['byUser._id']: (ObjectId('53bf75898de2fb8790ef7f0b'), ObjectId('ffffffffffffffffffffffff')]",
"isMultiKey":0,
"yieldMovedCursor":0,
"dupsTested":0,
"dupsDropped":0,
"seenInvalidated":0,
"matchTested":0,
"keysExamined":2272000,
"children":[
]
}
]
}
]
}
}
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/e0ae3645-fdf1-4e5a-befd-e91f98fd12c1%40googlegroups.com.
You received this message because you are subscribed to a topic in the Google Groups "mongodb-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mongodb-user/AN6GePLJVEg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mongodb-user...@googlegroups.com.
To post to this group, send email to mongod...@googlegroups.com.
Visit this group at http://groups.google.com/group/mongodb-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/CAOe6dJC2cninOxWPWw_i%3DGsdD1rzO-FYFe%2BxxwK_FD70Y_17JA%40mail.gmail.com.