> db.version();
|
2.6.0-rc2
|
> db.config.users.find({$or:[{un: /cailin/},{pe:/cailin/}]},{un:1}).sort({cre:-1}).limit(10).skip(0).explain(true)
|
{
|
"cursor" : "BtreeCursor createdIdx reverse",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 1,
|
"nscannedObjectsAllPlans" : 0,
|
"nscannedAllPlans" : 1,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nYields" : 0,
|
"nChunkSkips" : 0,
|
"millis" : 0,
|
"indexBounds" : {
|
"cre" : [
|
[
|
/cailin/,
|
/cailin/
|
],
|
[
|
{
|
|
},
|
""
|
]
|
]
|
},
|
"allPlans" : [
|
{
|
"cursor" : "BtreeCursor createdIdx reverse",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 1,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"cre" : [
|
[
|
/cailin/,
|
/cailin/
|
],
|
[
|
{
|
|
},
|
""
|
]
|
]
|
}
|
}
|
],
|
"server" : "cailinmac:27017",
|
"filterSet" : false,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 2,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "PROJECTION",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ cre: 1 }",
|
"boundsVerbose" : "field #0['cre']: [/cailin/, /cailin/], ({}, \"\"]",
|
"isMultiKey" : 0,
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 1,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
}
|
> db.config.users.find({$or:[{un: /cailin/},{pe:/cailin/}]},{un:1}).limit(10).skip(0).explain(true)
|
{
|
"clauses" : [
|
{
|
"cursor" : "BtreeCursor usernameIdx",
|
"isMultiKey" : false,
|
"n" : 3,
|
"nscannedObjects" : 3,
|
"nscanned" : 3,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"un" : [
|
[
|
"",
|
{
|
|
}
|
],
|
[
|
/cailin/,
|
/cailin/
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor primaryEmailIdx",
|
"isMultiKey" : false,
|
"n" : 3,
|
"nscannedObjects" : 3,
|
"nscanned" : 3,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"pe" : [
|
[
|
"",
|
{
|
|
}
|
],
|
[
|
/cailin/,
|
/cailin/
|
]
|
]
|
}
|
}
|
],
|
"cursor" : "QueryOptimizerCursor",
|
"n" : 3,
|
"nscannedObjects" : 6,
|
"nscanned" : 6,
|
"nscannedObjectsAllPlans" : 6,
|
"nscannedAllPlans" : 6,
|
"scanAndOrder" : false,
|
"nYields" : 0,
|
"nChunkSkips" : 0,
|
"millis" : 0,
|
"allPlans" : [
|
{
|
"clauses" : [
|
{
|
"cursor" : "BtreeCursor usernameIdx",
|
"isMultiKey" : false,
|
"n" : 3,
|
"nscannedObjects" : 3,
|
"nscanned" : 3,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"un" : [
|
[
|
"",
|
{
|
|
}
|
],
|
[
|
/cailin/,
|
/cailin/
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor primaryEmailIdx",
|
"isMultiKey" : false,
|
"n" : 3,
|
"nscannedObjects" : 3,
|
"nscanned" : 3,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"pe" : [
|
[
|
"",
|
{
|
|
}
|
],
|
[
|
/cailin/,
|
/cailin/
|
]
|
]
|
}
|
}
|
],
|
"cursor" : "QueryOptimizerCursor",
|
"n" : 3,
|
"nscannedObjects" : 6,
|
"nscanned" : 6,
|
"scanAndOrder" : false,
|
"nChunkSkips" : 0
|
}
|
],
|
"server" : "cailinmac:27017",
|
"filterSet" : false,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 8,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 3,
|
"needTime" : 4,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "PROJECTION",
|
"works" : 8,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 3,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 8,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 3,
|
"needTime" : 4,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "OR",
|
"works" : 8,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 3,
|
"needTime" : 4,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"dupsTested" : 6,
|
"dupsDropped" : 3,
|
"locsForgotten" : 0,
|
"matchTested_0" : 0,
|
"matchTested_1" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 4,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 3,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ un: 1 }",
|
"boundsVerbose" : "field #0['un']: [\"\", {}), [/cailin/, /cailin/]",
|
"isMultiKey" : 0,
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 3,
|
"keysExamined" : 3,
|
"children" : [ ]
|
},
|
{
|
"type" : "IXSCAN",
|
"works" : 4,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 3,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ pe: 1 }",
|
"boundsVerbose" : "field #0['pe']: [\"\", {}), [/cailin/, /cailin/]",
|
"isMultiKey" : 0,
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 3,
|
"keysExamined" : 3,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
}
|
> db.config.users.find({$or:[{un: /cailin/},{pe:/cailin/}]}).sort({cre:-1}).limit(10).skip(0).explain(true)
|
{
|
"cursor" : "BtreeCursor createdIdx reverse",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 1,
|
"nscannedObjectsAllPlans" : 0,
|
"nscannedAllPlans" : 1,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nYields" : 0,
|
"nChunkSkips" : 0,
|
"millis" : 0,
|
"indexBounds" : {
|
"cre" : [
|
[
|
/cailin/,
|
/cailin/
|
],
|
[
|
{
|
|
},
|
""
|
]
|
]
|
},
|
"allPlans" : [
|
{
|
"cursor" : "BtreeCursor createdIdx reverse",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 1,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"cre" : [
|
[
|
/cailin/,
|
/cailin/
|
],
|
[
|
{
|
|
},
|
""
|
]
|
]
|
}
|
}
|
],
|
"server" : "cailinmac:27017",
|
"filterSet" : false,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 2,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ cre: 1 }",
|
"boundsVerbose" : "field #0['cre']: [/cailin/, /cailin/], ({}, \"\"]",
|
"isMultiKey" : 0,
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 1,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
}
|
> db.config.users.find({$or:[{un: /cailin/},{pe:/cailin/}]}).limit(10).skip(0).explain(true)
|
{
|
"clauses" : [
|
{
|
"cursor" : "BtreeCursor usernameIdx",
|
"isMultiKey" : false,
|
"n" : 3,
|
"nscannedObjects" : 3,
|
"nscanned" : 3,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"un" : [
|
[
|
"",
|
{
|
|
}
|
],
|
[
|
/cailin/,
|
/cailin/
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor primaryEmailIdx",
|
"isMultiKey" : false,
|
"n" : 3,
|
"nscannedObjects" : 3,
|
"nscanned" : 3,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"pe" : [
|
[
|
"",
|
{
|
|
}
|
],
|
[
|
/cailin/,
|
/cailin/
|
]
|
]
|
}
|
}
|
],
|
"cursor" : "QueryOptimizerCursor",
|
"n" : 3,
|
"nscannedObjects" : 6,
|
"nscanned" : 6,
|
"nscannedObjectsAllPlans" : 6,
|
"nscannedAllPlans" : 6,
|
"scanAndOrder" : false,
|
"nYields" : 0,
|
"nChunkSkips" : 0,
|
"millis" : 0,
|
"allPlans" : [
|
{
|
"clauses" : [
|
{
|
"cursor" : "BtreeCursor usernameIdx",
|
"isMultiKey" : false,
|
"n" : 3,
|
"nscannedObjects" : 3,
|
"nscanned" : 3,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"un" : [
|
[
|
"",
|
{
|
|
}
|
],
|
[
|
/cailin/,
|
/cailin/
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor primaryEmailIdx",
|
"isMultiKey" : false,
|
"n" : 3,
|
"nscannedObjects" : 3,
|
"nscanned" : 3,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"pe" : [
|
[
|
"",
|
{
|
|
}
|
],
|
[
|
/cailin/,
|
/cailin/
|
]
|
]
|
}
|
}
|
],
|
"cursor" : "QueryOptimizerCursor",
|
"n" : 3,
|
"nscannedObjects" : 6,
|
"nscanned" : 6,
|
"scanAndOrder" : false,
|
"nChunkSkips" : 0
|
}
|
],
|
"server" : "cailinmac:27017",
|
"filterSet" : false,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 8,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 3,
|
"needTime" : 4,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 8,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 3,
|
"needTime" : 4,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "OR",
|
"works" : 8,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 3,
|
"needTime" : 4,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"dupsTested" : 6,
|
"dupsDropped" : 3,
|
"locsForgotten" : 0,
|
"matchTested_0" : 0,
|
"matchTested_1" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 4,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 3,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ un: 1 }",
|
"boundsVerbose" : "field #0['un']: [\"\", {}), [/cailin/, /cailin/]",
|
"isMultiKey" : 0,
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 3,
|
"keysExamined" : 3,
|
"children" : [ ]
|
},
|
{
|
"type" : "IXSCAN",
|
"works" : 4,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 3,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ pe: 1 }",
|
"boundsVerbose" : "field #0['pe']: [\"\", {}), [/cailin/, /cailin/]",
|
"isMultiKey" : 0,
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 3,
|
"keysExamined" : 3,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
}
|
>
|
|