|
@Jason - thanks and here are the results... (Since there are no matches on itcount(), the
{clExists:1,tLcLeft:1}
index would give zero matches, so strange that it would need to intersect anything - could stop right there)...
sprawk2:PRIMARY> var q = {clExists: true, lc: "eng", trans: "ara", tLcLeft: "conference", textLc: "conference", pattern: false, group: "all"};
|
sprawk2:PRIMARY> db.Example.find(q).explain(true);
|
{
|
"cursor" : "Complex Plan",
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 2,
|
"nscannedObjectsAllPlans" : 0,
|
"nscannedAllPlans" : 11,
|
"nYields" : 2,
|
"nChunkSkips" : 0,
|
"millis" : 229,
|
"allPlans" : [
|
{
|
"cursor" : "Complex Plan",
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 2,
|
"nChunkSkips" : 0
|
},
|
{
|
"cursor" : "Complex Plan",
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 2,
|
"nChunkSkips" : 0
|
},
|
{
|
"cursor" : "BtreeCursor lc_1_group_1_tLcLeft_1",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"lc" : [
|
[
|
"eng",
|
"eng"
|
]
|
],
|
"group" : [
|
[
|
"all",
|
"all"
|
]
|
],
|
"tLcLeft" : [
|
[
|
"conference",
|
"conference"
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor tLcLeft_1_group_1_trans_1",
|
"isMultiKey" : true,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"tLcLeft" : [
|
[
|
"conference",
|
"conference"
|
]
|
],
|
"group" : [
|
[
|
"all",
|
"all"
|
]
|
],
|
"trans" : [
|
[
|
"ara",
|
"ara"
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor lc_1_group_1_trans_1_wordCount_1_pattern_1",
|
"isMultiKey" : true,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 1,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"lc" : [
|
[
|
"eng",
|
"eng"
|
]
|
],
|
"group" : [
|
[
|
"all",
|
"all"
|
]
|
],
|
"trans" : [
|
[
|
"ara",
|
"ara"
|
]
|
],
|
"wordCount" : [
|
[
|
{
|
"$minElement" : 1
|
},
|
{
|
"$maxElement" : 1
|
}
|
]
|
],
|
"pattern" : [
|
[
|
false,
|
false
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor group_1_pass_1",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 1,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"group" : [
|
[
|
"all",
|
"all"
|
]
|
],
|
"pass" : [
|
[
|
{
|
"$minElement" : 1
|
},
|
{
|
"$maxElement" : 1
|
}
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor clExists_1_tLcLeft_1",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"clExists" : [
|
[
|
true,
|
true
|
]
|
],
|
"tLcLeft" : [
|
[
|
"conference",
|
"conference"
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor trans_1_tLcLeft_1_group_1_lc_1",
|
"isMultiKey" : true,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"trans" : [
|
[
|
"ara",
|
"ara"
|
]
|
],
|
"tLcLeft" : [
|
[
|
"conference",
|
"conference"
|
]
|
],
|
"group" : [
|
[
|
"all",
|
"all"
|
]
|
],
|
"lc" : [
|
[
|
"eng",
|
"eng"
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "BtreeCursor textLc_hashed",
|
"isMultiKey" : false,
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 1,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nChunkSkips" : 0,
|
"indexBounds" : {
|
"textLc" : [
|
[
|
NumberLong("6337680983347079397"),
|
NumberLong("6337680983347079397")
|
]
|
]
|
}
|
},
|
{
|
"cursor" : "Complex Plan",
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 4,
|
"nChunkSkips" : 0
|
},
|
{
|
"cursor" : "Complex Plan",
|
"n" : 0,
|
"nscannedObjects" : 0,
|
"nscanned" : 0,
|
"nChunkSkips" : 0
|
}
|
],
|
"server" : "tor:27018",
|
"filterSet" : false,
|
"stats" : {
|
"type" : "KEEP_MUTATIONS",
|
"works" : 2,
|
"yields" : 2,
|
"unyields" : 2,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 2,
|
"unyields" : 2,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "AND_HASH",
|
"works" : 1,
|
"yields" : 2,
|
"unyields" : 2,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"flaggedButPassed" : 0,
|
"flaggedInProgress" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 2,
|
"yields" : 2,
|
"unyields" : 2,
|
"invalidates" : 0,
|
"advanced" : 1,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ group: 1.0, lastModified: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['group']: [\"all\", \"all\"], field #1['lastModified']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 2,
|
"children" : [ ]
|
},
|
{
|
"type" : "IXSCAN",
|
"works" : 2,
|
"yields" : 2,
|
"unyields" : 2,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ clExists: 1.0, tLcLeft: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['clExists']: [true, true], field #1['tLcLeft']: [\"conference\", \"conference\"]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
}
|
sprawk2:PRIMARY> db.Example.find(q).itcount();
|
|
0
|
sprawk2:PRIMARY> db.Example.getPlanCache().getPlansByQuery(q);
|
[
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf \n---Leaf { group: 1.0, lastModified: 1.0 }, pos: 0\n---Leaf \n---Leaf \n---Leaf \n---Leaf { textLc: \"hashed\" }, pos: 0\n---Leaf \n)"
|
},
|
"reason" : {
|
"score" : 1.0002,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "AND_HASH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"flaggedButPassed" : 0,
|
"flaggedInProgress" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 2,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 1,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ group: 1.0, lastModified: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['group']: [\"cn\", \"cn\"], field #1['lastModified']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 2,
|
"children" : [ ]
|
},
|
{
|
"type" : "IXSCAN",
|
"works" : 2,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ textLc: \"hashed\" }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['textLc']: [-3202514460983226863, -3202514460983226863]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
"nfeedback" : 20,
|
"averageScore" : 1.0001999999999998,
|
"stdDevScore" : 2.278129578503827e-16,
|
"scores" : [
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
}
|
]
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf \n---Leaf { group: 1.0, lastModified: 1.0 }, pos: 0\n---Leaf \n---Leaf \n---Leaf \n---Leaf \n---Leaf \n)"
|
},
|
"reason" : {
|
"score" : 1.0003,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ group: 1.0, lastModified: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['group']: [\"cn\", \"cn\"], field #1['lastModified']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 1,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf \n---Leaf { lc: 1.0, group: 1.0, tLcLeft: 1.0 }, pos: 1\n---Leaf { lc: 1.0, group: 1.0, tLcLeft: 1.0 }, pos: 0\n---Leaf \n---Leaf { lc: 1.0, group: 1.0, tLcLeft: 1.0 }, pos: 2\n---Leaf \n---Leaf \n)"
|
},
|
"reason" : {
|
"score" : 1.0003,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ lc: 1.0, group: 1.0, tLcLeft: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['lc']: [\"eng\", \"eng\"], field #1['group']: [\"cn\", \"cn\"], field #2['tLcLeft']: [\"the national ass\", \"the national ass\"]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 1,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf \n---Leaf { tLcLeft: 1, group: 1, trans: 1 }, pos: 1\n---Leaf \n---Leaf \n---Leaf { tLcLeft: 1, group: 1, trans: 1 }, pos: 0\n---Leaf \n---Leaf { tLcLeft: 1, group: 1, trans: 1 }, pos: 2\n)"
|
},
|
"reason" : {
|
"score" : 1.0003,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ tLcLeft: 1, group: 1, trans: 1 }",
|
"isMultiKey" : 1,
|
"boundsVerbose" : "field #0['tLcLeft']: [\"the national ass\", \"the national ass\"], field #1['group']: [\"cn\", \"cn\"], field #2['trans']: [\"esl\", \"esl\"]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 1,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf \n---Leaf { lc: 1.0, group: 1.0, trans: 1.0, wordCount: 1.0, pattern: 1.0 }, pos: 1\n---Leaf { lc: 1.0, group: 1.0, trans: 1.0, wordCount: 1.0, pattern: 1.0 }, pos: 0\n---Leaf { lc: 1.0, group: 1.0, trans: 1.0, wordCount: 1.0, pattern: 1.0 }, pos: 4\n---Leaf \n---Leaf \n---Leaf { lc: 1.0, group: 1.0, trans: 1.0, wordCount: 1.0, pattern: 1.0 }, pos: 2\n)"
|
},
|
"reason" : {
|
"score" : 1.0003,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ lc: 1.0, group: 1.0, trans: 1.0, wordCount: 1.0, pattern: 1.0 }",
|
"isMultiKey" : 1,
|
"boundsVerbose" : "field #0['lc']: [\"eng\", \"eng\"], field #1['group']: [\"cn\", \"cn\"], field #2['trans']: [\"esl\", \"esl\"], field #3['wordCount']: [MinKey, MaxKey], field #4['pattern']: [false, false]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 1,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf \n---Leaf { group: 1.0, pass: 1.0 }, pos: 0\n---Leaf \n---Leaf \n---Leaf \n---Leaf \n---Leaf \n)"
|
},
|
"reason" : {
|
"score" : 1.0003,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ group: 1.0, pass: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['group']: [\"cn\", \"cn\"], field #1['pass']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 1,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf { clExists: 1.0, tLcLeft: 1.0 }, pos: 0\n---Leaf \n---Leaf \n---Leaf \n---Leaf { clExists: 1.0, tLcLeft: 1.0 }, pos: 1\n---Leaf \n---Leaf \n)"
|
},
|
"reason" : {
|
"score" : 1.0003,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ clExists: 1.0, tLcLeft: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['clExists']: [true, true], field #1['tLcLeft']: [\"the national ass\", \"the national ass\"]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 1,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf \n---Leaf { trans: 1.0, tLcLeft: 1.0, group: 1.0, lc: 1.0 }, pos: 2\n---Leaf { trans: 1.0, tLcLeft: 1.0, group: 1.0, lc: 1.0 }, pos: 3\n---Leaf \n---Leaf { trans: 1.0, tLcLeft: 1.0, group: 1.0, lc: 1.0 }, pos: 1\n---Leaf \n---Leaf { trans: 1.0, tLcLeft: 1.0, group: 1.0, lc: 1.0 }, pos: 0\n)"
|
},
|
"reason" : {
|
"score" : 1.0003,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ trans: 1.0, tLcLeft: 1.0, group: 1.0, lc: 1.0 }",
|
"isMultiKey" : 1,
|
"boundsVerbose" : "field #0['trans']: [\"esl\", \"esl\"], field #1['tLcLeft']: [\"the national ass\", \"the national ass\"], field #2['group']: [\"cn\", \"cn\"], field #3['lc']: [\"eng\", \"eng\"]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 1,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf \n---Leaf \n---Leaf \n---Leaf \n---Leaf \n---Leaf { textLc: \"hashed\" }, pos: 0\n---Leaf \n)"
|
},
|
"reason" : {
|
"score" : 1.0003,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 1,
|
"keyPattern" : "{ textLc: \"hashed\" }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['textLc']: [-3202514460983226863, -3202514460983226863]",
|
"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 { clExists: 1.0, tLcLeft: 1.0 }, pos: 0\n---Leaf { group: 1.0, lastModified: 1.0 }, pos: 0\n---Leaf \n---Leaf \n---Leaf { clExists: 1.0, tLcLeft: 1.0 }, pos: 1\n---Leaf \n---Leaf \n)"
|
},
|
"reason" : {
|
"score" : 1.0002,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "AND_HASH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"flaggedButPassed" : 0,
|
"flaggedInProgress" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 2,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 1,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ group: 1.0, lastModified: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['group']: [\"cn\", \"cn\"], field #1['lastModified']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 2,
|
"children" : [ ]
|
},
|
{
|
"type" : "IXSCAN",
|
"works" : 2,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 1,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ clExists: 1.0, tLcLeft: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['clExists']: [true, true], field #1['tLcLeft']: [\"the national ass\", \"the national ass\"]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 2,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf { clExists: 1.0, tLcLeft: 1.0 }, pos: 0\n---Leaf { lc: 1.0, group: 1.0, tLcLeft: 1.0 }, pos: 1\n---Leaf { lc: 1.0, group: 1.0, tLcLeft: 1.0 }, pos: 0\n---Leaf \n---Leaf { clExists: 1.0, tLcLeft: 1.0 }, pos: 1\n---Leaf \n---Leaf \n)"
|
},
|
"reason" : {
|
"score" : 1.0002,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "AND_HASH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"flaggedButPassed" : 0,
|
"flaggedInProgress" : 0,
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 2,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 1,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ lc: 1.0, group: 1.0, tLcLeft: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['lc']: [\"eng\", \"eng\"], field #1['group']: [\"cn\", \"cn\"], field #2['tLcLeft']: [MinKey, MaxKey]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 2,
|
"children" : [ ]
|
},
|
{
|
"type" : "IXSCAN",
|
"works" : 2,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 1,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ clExists: 1.0, tLcLeft: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['clExists']: [true, true], field #1['tLcLeft']: [\"the national ass\", \"the national ass\"]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 2,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Node\n---Leaf \n---Leaf { lc: 1.0, group: 1.0, tLcLeft: 1.0 }, pos: 1\n---Leaf { lc: 1.0, group: 1.0, tLcLeft: 1.0 }, pos: 0\n---Leaf \n---Leaf { lc: 1.0, group: 1.0, tLcLeft: 1.0 }, pos: 2\n---Leaf { textLc: \"hashed\" }, pos: 0\n---Leaf \n)"
|
},
|
"reason" : {
|
"score" : 1.0002,
|
"stats" : {
|
"type" : "LIMIT",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "KEEP_MUTATIONS",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"children" : [
|
{
|
"type" : "FETCH",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"alreadyHasObj" : 0,
|
"forcedFetches" : 0,
|
"matchTested" : 0,
|
"children" : [
|
{
|
"type" : "AND_SORTED",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"flagged" : 0,
|
"matchTested" : 0,
|
"failedAnd_0" : 0,
|
"failedAnd_1" : 0,
|
"children" : [
|
{
|
"type" : "IXSCAN",
|
"works" : 1,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{ lc: 1.0, group: 1.0, tLcLeft: 1.0 }",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['lc']: [\"eng\", \"eng\"], field #1['group']: [\"cn\", \"cn\"], field #2['tLcLeft']: [\"the national ass\", \"the national ass\"]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 1,
|
"children" : [ ]
|
},
|
{
|
"type" : "IXSCAN",
|
"works" : 0,
|
"yields" : 1,
|
"unyields" : 1,
|
"invalidates" : 0,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"isEOF" : 0,
|
"keyPattern" : "{}",
|
"isMultiKey" : 0,
|
"boundsVerbose" : "field #0['textLc']: [-3202514460983226863, -3202514460983226863]",
|
"yieldMovedCursor" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0,
|
"keysExamined" : 0,
|
"children" : [ ]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
}
|
]
|
sprawk2:PRIMARY> db.Example.getIndexes();
|
[
|
{
|
"v" : 1,
|
"key" : {
|
"_id" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "_id_"
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"terms.text" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "terms.text_1"
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"createDate" : -1,
|
"group" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "createDate_-1_group_1",
|
"background" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"date" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "date_1",
|
"background" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"topics" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "topics_1",
|
"sparse" : true,
|
"background" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"random" : 1,
|
"lc" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "random_1_lc_1",
|
"background" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"group" : 1,
|
"lastModified" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "group_1_lastModified_1",
|
"background" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"lc" : 1,
|
"group" : 1,
|
"tLcLeft" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "lc_1_group_1_tLcLeft_1",
|
"background" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"indicesSize" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "indicesSize_1",
|
"background" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"sig" : 1,
|
"lc" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "sig_1_lc_1",
|
"background" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"tLcLeft" : 1,
|
"group" : 1,
|
"trans" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "tLcLeft_1_group_1_trans_1"
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"lc" : 1,
|
"group" : 1,
|
"trans" : 1,
|
"wordCount" : 1,
|
"pattern" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "lc_1_group_1_trans_1_wordCount_1_pattern_1",
|
"sparse" : true,
|
"background" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"indices.textLc" : 1,
|
"group" : 1,
|
"lc" : 1,
|
"clExists" : 1,
|
"wordCount" : 1,
|
"pattern" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "indices.textLc_1_group_1_lc_1_clExists_1_wordCount_1_pattern_1",
|
"background" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"u" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "u_1",
|
"background" : true,
|
"sparse" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"tIds" : 1,
|
"lc" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "tIds_1_lc_1",
|
"sparse" : true,
|
"background" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"group" : 1,
|
"pass" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "group_1_pass_1",
|
"background" : true,
|
"sparse" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"tLcHash2" : 1,
|
"lc" : 1,
|
"group" : 1,
|
"clExists" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "tLcHash2_1_lc_1_group_1_clExists_1"
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"length" : 1,
|
"lc" : 1,
|
"tLcHash2" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "length_1_lc_1_tLcHash2_1"
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"kodoId" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "kodoId_1",
|
"sparse" : true,
|
"background" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"cl" : 1,
|
"lc" : 1,
|
"group" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "cl_1_lc_1_group_1",
|
"sparse" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"v" : 1,
|
"wrongLanguage" : 1,
|
"group" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "v_1_wrongLanguage_1_group_1"
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"indices.text" : 1,
|
"lc" : 1,
|
"group" : 1,
|
"cl" : 1
|
},
|
"ns" : "jerome5.Example",
|
"name" : "indices.text_1_lc_1_group_1_cl_1"
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"clExists" : 1,
|
"tLcLeft" : 1
|
},
|
"name" : "clExists_1_tLcLeft_1",
|
"ns" : "jerome5.Example",
|
"sparse" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"wl" : 1,
|
"group" : 1
|
},
|
"name" : "wl_1_group_1",
|
"ns" : "jerome5.Example",
|
"sparse" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"trans" : 1,
|
"tLcLeft" : 1,
|
"group" : 1,
|
"lc" : 1
|
},
|
"name" : "trans_1_tLcLeft_1_group_1_lc_1",
|
"ns" : "jerome5.Example",
|
"sparse" : true
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"textLc" : "hashed"
|
},
|
"name" : "textLc_hashed",
|
"ns" : "jerome5.Example"
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"text" : "hashed"
|
},
|
"name" : "text_hashed",
|
"ns" : "jerome5.Example"
|
},
|
{
|
"v" : 1,
|
"key" : {
|
"lb" : 1
|
},
|
"name" : "lb_1",
|
"ns" : "jerome5.Example"
|
}
|
]
|
|
|