|
Note sure which node in the cluster this died at, so using a mongos for now...
mongos> db.PathAlias.getIndexes()
|
[
|
{
|
"v" : 1,
|
"name" : "_id_",
|
"key" : {
|
"_id" : 1
|
},
|
"ns" : "jerome5.PathAlias"
|
},
|
{
|
"v" : 1,
|
"name" : "p_1_l_1",
|
"key" : {
|
"p" : 1,
|
"l" : 1
|
},
|
"unique" : true,
|
"ns" : "jerome5.PathAlias"
|
},
|
{
|
"v" : 1,
|
"name" : "r_hashed",
|
"key" : {
|
"r" : "hashed"
|
},
|
"ns" : "jerome5.PathAlias"
|
},
|
{
|
"v" : 1,
|
"name" : "kodoId_1",
|
"key" : {
|
"kodoId" : 1
|
},
|
"ns" : "jerome5.PathAlias"
|
},
|
{
|
"v" : 1,
|
"name" : "l_1_r_1",
|
"key" : {
|
"l" : 1,
|
"r" : 1
|
},
|
"ns" : "jerome5.PathAlias"
|
},
|
{
|
"v" : 1,
|
"name" : "r_1_cd_-1",
|
"key" : {
|
"r" : 1,
|
"cd" : -1
|
},
|
"ns" : "jerome5.PathAlias"
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"p" : "hashed"
|
},
|
"name" : "p_hashed",
|
"ns" : "jerome5.PathAlias"
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"pl" : "hashed"
|
},
|
"name" : "pl_hashed",
|
"ns" : "jerome5.PathAlias"
|
}
|
]
|
find({pl: 1, l: 1}).sort({cd: -1}).itcount()
|
0
|
db.PathAlias.getPlanCache().getPlansByQuery({pl: 1, l: 1}, {}, {cd: -1})
|
[
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf { l: 1.0, r: 1.0 }, pos: 0\n---Leaf { pl: \"hashed\" }, pos: 0\n)"
|
},
|
"reason" : {
|
"score" : 1.0000999999999998,
|
"stats" : {
|
"type" : "KEEP_MUTATIONS",
|
"works" : 6,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 5,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "OR",
|
"works" : 6,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 5,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"locsForgotten" : 0,
|
"matchTested_0" : 0,
|
"matchTested_1" : 0,
|
"children" : [
|
{
|
"type" : "SORT",
|
"works" : 3,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"forcedFetches" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "SHARDING_FILTER",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"chunkSkips" : 0,
|
"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" : "AND_HASH",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"flaggedButPassed" : 0,
|
"flaggedInProgress" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 2,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ l: 1.0, r: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['l']: [\"eng_US\", \"eng_US\"], field #1['r']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
},
|
{
|
"type" : "IXSCAN",
|
"works" : 0,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{}",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['pl']: [3158721823503437376, 3158721823503437376]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
},
|
{
|
"type" : "SORT",
|
"works" : 3,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"forcedFetches" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "SHARDING_FILTER",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"chunkSkips" : 0,
|
"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" : "AND_HASH",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"flaggedButPassed" : 0,
|
"flaggedInProgress" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 2,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ l: 1.0, r: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['l']: [\"eng_US\", \"eng_US\"], field #1['r']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
},
|
{
|
"type" : "IXSCAN",
|
"works" : 0,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{}",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['pl']: [3158721823503437376, 3158721823503437376]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
"nfeedback" : 20,
|
"averageScore" : 1.0001,
|
"stdDevScore" : 0,
|
"scores" : [
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
},
|
{
|
"score" : 1.0001
|
}
|
]
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf { l: 1.0, r: 1.0 }, pos: 0\n---Leaf \n)"
|
},
|
"reason" : {
|
"score" : 1.0002,
|
"stats" : {
|
"type" : "KEEP_MUTATIONS",
|
"works" : 6,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 6,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "OR",
|
"works" : 6,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 6,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"locsForgotten" : 0,
|
"matchTested_0" : 0,
|
"matchTested_1" : 0,
|
"children" : [
|
{
|
"type" : "SORT",
|
"works" : 4,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 2,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"forcedFetches" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "SHARDING_FILTER",
|
"works" : 2,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"chunkSkips" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ l: 1.0, r: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['l']: [\"eng_US\", \"eng_US\"], field #1['r']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
},
|
{
|
"type" : "SORT",
|
"works" : 2,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"forcedFetches" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "SHARDING_FILTER",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"chunkSkips" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ l: 1.0, r: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['l']: [\"eng_US\", \"eng_US\"], field #1['r']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf \n---Leaf { pl: \"hashed\" }, pos: 0\n)"
|
},
|
"reason" : {
|
"score" : 1.0002,
|
"stats" : {
|
"type" : "KEEP_MUTATIONS",
|
"works" : 6,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 6,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "OR",
|
"works" : 6,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 6,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"locsForgotten" : 0,
|
"matchTested_0" : 0,
|
"matchTested_1" : 0,
|
"children" : [
|
{
|
"type" : "SORT",
|
"works" : 6,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 4,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"forcedFetches" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "SHARDING_FILTER",
|
"works" : 4,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 3,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"chunkSkips" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 3,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 3,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 3,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 2,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ pl: \"hashed\" }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['pl']: [3158721823503437376, 3158721823503437376]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 2,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
},
|
{
|
"type" : "SORT",
|
"works" : 0,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"forcedFetches" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "SHARDING_FILTER",
|
"works" : 0,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"chunkSkips" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 0,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 0,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{}",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['pl']: [3158721823503437376, 3158721823503437376]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
}
|
]
|
mongos> db.PathAlias.find({pl: 1, l: 1}).sort({cd: -1}).explain(true)
|
{
|
"clusteredType" : "ParallelSort",
|
"shards" : {
|
"sprawk/bruyere.sprawk.com:27018,n4-rs1.mongo.sprawk.com:27018" : [
|
{
|
"cursor" : "BtreeCursor l_1_r_1",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"nscannedObjectsAllPlans" : 0,
|
"nscannedAllPlans" : 0,
|
"scanAndOrder" : true,
|
"indexOnly" : false,
|
"nYields" : 0,
|
"nChunkSkips" : 0,
|
"millis" : 0,
|
"indexBounds" : {
|
"l" : [
|
[
|
1,
|
1
|
]
|
],
|
"r" : [
|
[
|
{
|
"$minElement" : 1
|
},
|
{
|
"$maxElement" : 1
|
}
|
]
|
]
|
},
|
"allPlans" : [
|
{
|
"cursor" : "BtreeCursor l_1_r_1",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"scanAndOrder" : true,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"l" : [
|
[
|
1,
|
1
|
]
|
],
|
"r" : [
|
[
|
{
|
"$minElement" : 1
|
},
|
{
|
"$maxElement" : 1
|
}
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor pl_hashed",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"scanAndOrder" : true,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"pl" : [
|
[
|
NumberLong("5902408780260971510"),
|
NumberLong("5902408780260971510")
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "Complex Plan",
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"nChunkSkips" : 0
|
}
|
],
|
"server" : "bruyere.sprawk.com:27018",
|
"filterSet" : false,
|
"stats" : {
|
"type" : "SORT",
|
"works" : 4,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 2,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"forcedFetches" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 2,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "SHARDING_FILTER",
|
"works" : 2,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"chunkSkips" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ l: 1.0, r: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['l']: [1.0, 1.0], field #1['r']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
}
|
],
|
"sprawk2/n1-rs2.mongo.sprawk.com:27018,n3-rs2.mongo.sprawk.com:27018" : [
|
{
|
"cursor" : "BtreeCursor l_1_r_1",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"nscannedObjectsAllPlans" : 0,
|
"nscannedAllPlans" : 0,
|
"scanAndOrder" : true,
|
"indexOnly" : false,
|
"nYields" : 0,
|
"nChunkSkips" : 0,
|
"millis" : 0,
|
"indexBounds" : {
|
"l" : [
|
[
|
1,
|
1
|
]
|
],
|
"r" : [
|
[
|
{
|
"$minElement" : 1
|
},
|
{
|
"$maxElement" : 1
|
}
|
]
|
]
|
},
|
"allPlans" : [
|
{
|
"cursor" : "BtreeCursor l_1_r_1",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"scanAndOrder" : true,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"l" : [
|
[
|
1,
|
1
|
]
|
],
|
"r" : [
|
[
|
{
|
"$minElement" : 1
|
},
|
{
|
"$maxElement" : 1
|
}
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor pl_hashed",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"scanAndOrder" : true,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"pl" : [
|
[
|
NumberLong("5902408780260971510"),
|
NumberLong("5902408780260971510")
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "Complex Plan",
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"nChunkSkips" : 0
|
}
|
],
|
"server" : "tor:27018",
|
"filterSet" : false,
|
"stats" : {
|
"type" : "SORT",
|
"works" : 4,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 2,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"forcedFetches" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 2,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "SHARDING_FILTER",
|
"works" : 2,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"chunkSkips" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ l: 1.0, r: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['l']: [1.0, 1.0], field #1['r']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
}
|
],
|
"sprawk3/n1-rs3.mongo.sprawk.com:27018,navarin:27018" : [
|
{
|
"cursor" : "BtreeCursor l_1_r_1",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"nscannedObjectsAllPlans" : 0,
|
"nscannedAllPlans" : 0,
|
"scanAndOrder" : true,
|
"indexOnly" : false,
|
"nYields" : 0,
|
"nChunkSkips" : 0,
|
"millis" : 0,
|
"indexBounds" : {
|
"l" : [
|
[
|
1,
|
1
|
]
|
],
|
"r" : [
|
[
|
{
|
"$minElement" : 1
|
},
|
{
|
"$maxElement" : 1
|
}
|
]
|
]
|
},
|
"allPlans" : [
|
{
|
"cursor" : "BtreeCursor l_1_r_1",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"scanAndOrder" : true,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"l" : [
|
[
|
1,
|
1
|
]
|
],
|
"r" : [
|
[
|
{
|
"$minElement" : 1
|
},
|
{
|
"$maxElement" : 1
|
}
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor pl_hashed",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"scanAndOrder" : true,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"pl" : [
|
[
|
NumberLong("5902408780260971510"),
|
NumberLong("5902408780260971510")
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "Complex Plan",
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"nChunkSkips" : 0
|
}
|
],
|
"server" : "navarin:27018",
|
"filterSet" : false,
|
"stats" : {
|
"type" : "SORT",
|
"works" : 4,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 2,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"forcedFetches" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 2,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "SHARDING_FILTER",
|
"works" : 2,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"chunkSkips" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 0,
|
"unyields" : 0,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ l: 1.0, r: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['l']: [1.0, 1.0], field #1['r']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
}
|
]
|
},
|
"cursor" : "BtreeCursor l_1_r_1",
|
"n" : 0,
|
"nChunkSkips" : 0,
|
"nYields" : 0,
|
"nscanned" : 0,
|
"nscannedAllPlans" : 0,
|
"nscannedObjects" : 0,
|
"nscannedObjectsAllPlans" : 0,
|
"millisShardTotal" : 0,
|
"millisShardAvg" : 0,
|
"numQueries" : 3,
|
"numShards" : 3,
|
"millis" : 2
|
}
|
|