|
Okay, this is going to be somewhat long. I am going to provide 3 explain() outputs.
Testing data is made up from total of 60 records in the collection. The 'lots_of_friend_ids' in this case is 8 distinct ids.
First one is the explain() output from the query stated in the ticket:
db.stream.find(
|
{$or: [
|
{owner: my_id },
|
{owner: {$in: [lots_of_friend_ids]}, permission: {$in: ['public', 'friend']}},
|
{designate: my_id}
|
]}
|
).limit(10).sort({create_time: -1})
|
2nd one is the same query without the sort():
db.stream.find(
|
{$or: [
|
{owner: my_id },
|
{owner: {$in: [lots_of_friend_ids]}, permission: {$in: ['public', 'friend']}},
|
{designate: my_id}
|
]}
|
).limit(10)
|
3rd one is my current work around by 'flattening' owner: $in: lots_of_friend_ids into multiple top level $or clauses:
db.stream.find(
|
{$or: [
|
{owner: my_id },
|
{owner: '1st_id', permission: {$in: ['public', 'friend']}},
|
{owner: '2nd_id', permission: {$in: ['public', 'friend']}},
|
{owner: '3rd_id', permission: {$in: ['public', 'friend']}},
|
{...},
|
{designate: my_id}
|
]}
|
).limit(10).sort({create_time: -1})
|
So, the first explain() output:
{
|
"clauses": [
|
{
|
"clauses": [
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 29,
|
"nscannedObjects": 29,
|
"nscanned": 32,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd476347b1b8",
|
"52ddd476347b1b8"
|
],
|
[
|
"52ddd4783b635c3",
|
"52ddd4783b635c3"
|
],
|
[
|
"52ddd479eab21d8",
|
"52ddd479eab21d8"
|
],
|
[
|
"531e84d1713f6be",
|
"531e84d1713f6be"
|
],
|
[
|
"531e84d39af5400",
|
"531e84d39af5400"
|
],
|
[
|
"531e84d58833772",
|
"531e84d58833772"
|
],
|
[
|
"531e85792aaefa3",
|
"531e85792aaefa3"
|
],
|
[
|
"531e94d8e0c3a62",
|
"531e94d8e0c3a62"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 29,
|
"nscannedObjects": 29,
|
"nscanned": 29,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
{
|
"$minElement": 1
|
},
|
{
|
"$maxElement": 1
|
}
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor designate_1_ca_-1",
|
"isMultiKey": true,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 1,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"designate": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
]
|
}
|
}
|
],
|
"cursor": "QueryOptimizerCursor",
|
"n": 10,
|
"nscannedObjects": 59,
|
"nscanned": 62,
|
"scanAndOrder": true,
|
"nChunkSkips": 0
|
},
|
{
|
"clauses": [
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 29,
|
"nscannedObjects": 29,
|
"nscanned": 32,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd476347b1b8",
|
"52ddd476347b1b8"
|
],
|
[
|
"52ddd4783b635c3",
|
"52ddd4783b635c3"
|
],
|
[
|
"52ddd479eab21d8",
|
"52ddd479eab21d8"
|
],
|
[
|
"531e84d1713f6be",
|
"531e84d1713f6be"
|
],
|
[
|
"531e84d39af5400",
|
"531e84d39af5400"
|
],
|
[
|
"531e84d58833772",
|
"531e84d58833772"
|
],
|
[
|
"531e85792aaefa3",
|
"531e85792aaefa3"
|
],
|
[
|
"531e94d8e0c3a62",
|
"531e94d8e0c3a62"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 29,
|
"nscannedObjects": 29,
|
"nscanned": 29,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
{
|
"$minElement": 1
|
},
|
{
|
"$maxElement": 1
|
}
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor designate_1_ca_-1",
|
"isMultiKey": true,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 1,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"designate": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
]
|
}
|
}
|
],
|
"cursor": "QueryOptimizerCursor",
|
"n": 59,
|
"nscannedObjects": 59,
|
"nscanned": 62,
|
"scanAndOrder": true,
|
"nChunkSkips": 0
|
}
|
],
|
"cursor": "QueryOptimizerCursor",
|
"n": 10,
|
"nscannedObjects": 118,
|
"nscanned": 124,
|
"nscannedObjectsAllPlans": 118,
|
"nscannedAllPlans": 124,
|
"scanAndOrder": false,
|
"nYields": 1,
|
"nChunkSkips": 0,
|
"millis": 2,
|
"allPlans": [
|
{
|
"clauses": [
|
{
|
"clauses": [
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 29,
|
"nscannedObjects": 29,
|
"nscanned": 32,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd476347b1b8",
|
"52ddd476347b1b8"
|
],
|
[
|
"52ddd4783b635c3",
|
"52ddd4783b635c3"
|
],
|
[
|
"52ddd479eab21d8",
|
"52ddd479eab21d8"
|
],
|
[
|
"531e84d1713f6be",
|
"531e84d1713f6be"
|
],
|
[
|
"531e84d39af5400",
|
"531e84d39af5400"
|
],
|
[
|
"531e84d58833772",
|
"531e84d58833772"
|
],
|
[
|
"531e85792aaefa3",
|
"531e85792aaefa3"
|
],
|
[
|
"531e94d8e0c3a62",
|
"531e94d8e0c3a62"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 29,
|
"nscannedObjects": 29,
|
"nscanned": 29,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
{
|
"$minElement": 1
|
},
|
{
|
"$maxElement": 1
|
}
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor designate_1_ca_-1",
|
"isMultiKey": true,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 1,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"designate": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
]
|
}
|
}
|
],
|
"cursor": "QueryOptimizerCursor",
|
"n": 10,
|
"nscannedObjects": 59,
|
"nscanned": 62,
|
"scanAndOrder": true,
|
"nChunkSkips": 0
|
},
|
{
|
"clauses": [
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 29,
|
"nscannedObjects": 29,
|
"nscanned": 32,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd476347b1b8",
|
"52ddd476347b1b8"
|
],
|
[
|
"52ddd4783b635c3",
|
"52ddd4783b635c3"
|
],
|
[
|
"52ddd479eab21d8",
|
"52ddd479eab21d8"
|
],
|
[
|
"531e84d1713f6be",
|
"531e84d1713f6be"
|
],
|
[
|
"531e84d39af5400",
|
"531e84d39af5400"
|
],
|
[
|
"531e84d58833772",
|
"531e84d58833772"
|
],
|
[
|
"531e85792aaefa3",
|
"531e85792aaefa3"
|
],
|
[
|
"531e94d8e0c3a62",
|
"531e94d8e0c3a62"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 29,
|
"nscannedObjects": 29,
|
"nscanned": 29,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
{
|
"$minElement": 1
|
},
|
{
|
"$maxElement": 1
|
}
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor designate_1_ca_-1",
|
"isMultiKey": true,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 1,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"designate": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
]
|
}
|
}
|
],
|
"cursor": "QueryOptimizerCursor",
|
"n": 59,
|
"nscannedObjects": 59,
|
"nscanned": 62,
|
"scanAndOrder": true,
|
"nChunkSkips": 0
|
}
|
],
|
"cursor": "QueryOptimizerCursor",
|
"n": 59,
|
"nscannedObjects": 118,
|
"nscanned": 124,
|
"scanAndOrder": false,
|
"nChunkSkips": 0
|
}
|
],
|
"server": "Xres:27017",
|
"filterSet": false,
|
"stats": {
|
"type": "KEEP_MUTATIONS",
|
"works": 197,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 59,
|
"needTime": 137,
|
"needFetch": 0,
|
"isEOF": 1,
|
"children": [
|
{
|
"type": "OR",
|
"works": 197,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 59,
|
"needTime": 137,
|
"needFetch": 0,
|
"isEOF": 1,
|
"dupsTested": 69,
|
"dupsDropped": 10,
|
"locsForgotten": 0,
|
"matchTested_0": 0,
|
"matchTested_1": 0,
|
"children": [
|
{
|
"type": "SORT",
|
"works": 74,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 10,
|
"needTime": 62,
|
"needFetch": 0,
|
"isEOF": 1,
|
"forcedFetches": 0,
|
"memUsage": 4331,
|
"memLimit": 33554432,
|
"children": [
|
{
|
"type": "FETCH",
|
"works": 62,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 59,
|
"needTime": 2,
|
"needFetch": 0,
|
"isEOF": 1,
|
"alreadyHasObj": 0,
|
"forcedFetches": 0,
|
"matchTested": 0,
|
"children": [
|
{
|
"type": "OR",
|
"works": 62,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 59,
|
"needTime": 2,
|
"needFetch": 0,
|
"isEOF": 1,
|
"dupsTested": 59,
|
"dupsDropped": 0,
|
"locsForgotten": 0,
|
"matchTested_0": 0,
|
"matchTested_1": 0,
|
"matchTested_2": 0,
|
"children": [
|
{
|
"type": "IXSCAN",
|
"works": 30,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 29,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"52ddd476347b1b8\", \"52ddd476347b1b8\"], [\"52ddd4783b635c3\", \"52ddd4783b635c3\"], [\"52ddd479eab21d8\", \"52ddd479eab21d8\"], [\"531e84d1713f6be\", \"531e84d1713f6be\"], [\"531e84d39af5400\", \"531e84d39af5400\"], [\"531e84d58833772\", \"531e84d58833772\"], [\"531e85792aaefa3\", \"531e85792aaefa3\"], [\"531e94d8e0c3a62\", \"531e94d8e0c3a62\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"F\", \"F\"], [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 32,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 30,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 29,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"52ddd47ba6c59d4\", \"52ddd47ba6c59d4\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [MinKey, MaxKey]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 29,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 2,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 1,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"keyPattern": "{ designate: 1, ca: -1 }",
|
"boundsVerbose": "field #0['designate']: [\"52ddd47ba6c59d4\", \"52ddd47ba6c59d4\"], field #1['ca']: [MaxKey, MinKey]",
|
"isMultiKey": 1,
|
"yieldMovedCursor": 0,
|
"dupsTested": 1,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 1,
|
"children": [
|
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
},
|
{
|
"type": "SORT",
|
"works": 123,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 59,
|
"needTime": 62,
|
"needFetch": 0,
|
"isEOF": 1,
|
"forcedFetches": 0,
|
"memUsage": 29388,
|
"memLimit": 33554432,
|
"children": [
|
{
|
"type": "FETCH",
|
"works": 62,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 59,
|
"needTime": 2,
|
"needFetch": 0,
|
"isEOF": 1,
|
"alreadyHasObj": 0,
|
"forcedFetches": 0,
|
"matchTested": 0,
|
"children": [
|
{
|
"type": "OR",
|
"works": 62,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 59,
|
"needTime": 2,
|
"needFetch": 0,
|
"isEOF": 1,
|
"dupsTested": 59,
|
"dupsDropped": 0,
|
"locsForgotten": 0,
|
"matchTested_0": 0,
|
"matchTested_1": 0,
|
"matchTested_2": 0,
|
"children": [
|
{
|
"type": "IXSCAN",
|
"works": 30,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 29,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"52ddd476347b1b8\", \"52ddd476347b1b8\"], [\"52ddd4783b635c3\", \"52ddd4783b635c3\"], [\"52ddd479eab21d8\", \"52ddd479eab21d8\"], [\"531e84d1713f6be\", \"531e84d1713f6be\"], [\"531e84d39af5400\", \"531e84d39af5400\"], [\"531e84d58833772\", \"531e84d58833772\"], [\"531e85792aaefa3\", \"531e85792aaefa3\"], [\"531e94d8e0c3a62\", \"531e94d8e0c3a62\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"F\", \"F\"], [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 32,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 30,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 29,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"52ddd47ba6c59d4\", \"52ddd47ba6c59d4\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [MinKey, MaxKey]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 29,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 2,
|
"yields": 1,
|
"unyields": 1,
|
"invalidates": 0,
|
"advanced": 1,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"keyPattern": "{ designate: 1, ca: -1 }",
|
"boundsVerbose": "field #0['designate']: [\"52ddd47ba6c59d4\", \"52ddd47ba6c59d4\"], field #1['ca']: [MaxKey, MinKey]",
|
"isMultiKey": 1,
|
"yieldMovedCursor": 0,
|
"dupsTested": 1,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 1,
|
"children": [
|
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
}
|
2nd explain() output:
{
|
"clauses": [
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 10,
|
"nscannedObjects": 10,
|
"nscanned": 12,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd476347b1b8",
|
"52ddd476347b1b8"
|
],
|
[
|
"52ddd4783b635c3",
|
"52ddd4783b635c3"
|
],
|
[
|
"52ddd479eab21d8",
|
"52ddd479eab21d8"
|
],
|
[
|
"531e84d1713f6be",
|
"531e84d1713f6be"
|
],
|
[
|
"531e84d39af5400",
|
"531e84d39af5400"
|
],
|
[
|
"531e84d58833772",
|
"531e84d58833772"
|
],
|
[
|
"531e85792aaefa3",
|
"531e85792aaefa3"
|
],
|
[
|
"531e94d8e0c3a62",
|
"531e94d8e0c3a62"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor ",
|
"isMultiKey": false,
|
"n": 0,
|
"nscannedObjects": 0,
|
"nscanned": 0,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
{
|
"$minElement": 1
|
},
|
{
|
"$maxElement": 1
|
}
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor ",
|
"isMultiKey": false,
|
"n": 0,
|
"nscannedObjects": 0,
|
"nscanned": 0,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"designate": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
]
|
}
|
}
|
],
|
"cursor": "QueryOptimizerCursor",
|
"n": 10,
|
"nscannedObjects": 10,
|
"nscanned": 12,
|
"nscannedObjectsAllPlans": 10,
|
"nscannedAllPlans": 12,
|
"scanAndOrder": false,
|
"nYields": 0,
|
"nChunkSkips": 0,
|
"millis": 0,
|
"allPlans": [
|
{
|
"clauses": [
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 10,
|
"nscannedObjects": 10,
|
"nscanned": 12,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd476347b1b8",
|
"52ddd476347b1b8"
|
],
|
[
|
"52ddd4783b635c3",
|
"52ddd4783b635c3"
|
],
|
[
|
"52ddd479eab21d8",
|
"52ddd479eab21d8"
|
],
|
[
|
"531e84d1713f6be",
|
"531e84d1713f6be"
|
],
|
[
|
"531e84d39af5400",
|
"531e84d39af5400"
|
],
|
[
|
"531e84d58833772",
|
"531e84d58833772"
|
],
|
[
|
"531e85792aaefa3",
|
"531e85792aaefa3"
|
],
|
[
|
"531e94d8e0c3a62",
|
"531e94d8e0c3a62"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor ",
|
"isMultiKey": false,
|
"n": 0,
|
"nscannedObjects": 0,
|
"nscanned": 0,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
{
|
"$minElement": 1
|
},
|
{
|
"$maxElement": 1
|
}
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor ",
|
"isMultiKey": false,
|
"n": 0,
|
"nscannedObjects": 0,
|
"nscanned": 0,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"designate": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
]
|
}
|
}
|
],
|
"cursor": "QueryOptimizerCursor",
|
"n": 10,
|
"nscannedObjects": 10,
|
"nscanned": 12,
|
"scanAndOrder": false,
|
"nChunkSkips": 0
|
}
|
],
|
"server": "Xres:27017",
|
"filterSet": false,
|
"stats": {
|
"type": "LIMIT",
|
"works": 11,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 10,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"children": [
|
{
|
"type": "FETCH",
|
"works": 10,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 10,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 0,
|
"alreadyHasObj": 0,
|
"forcedFetches": 0,
|
"matchTested": 0,
|
"children": [
|
{
|
"type": "OR",
|
"works": 10,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 10,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 0,
|
"dupsTested": 10,
|
"dupsDropped": 0,
|
"locsForgotten": 0,
|
"matchTested_0": 0,
|
"matchTested_1": 0,
|
"matchTested_2": 0,
|
"children": [
|
{
|
"type": "IXSCAN",
|
"works": 10,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 10,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 0,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"52ddd476347b1b8\", \"52ddd476347b1b8\"], [\"52ddd4783b635c3\", \"52ddd4783b635c3\"], [\"52ddd479eab21d8\", \"52ddd479eab21d8\"], [\"531e84d1713f6be\", \"531e84d1713f6be\"], [\"531e84d39af5400\", \"531e84d39af5400\"], [\"531e84d58833772\", \"531e84d58833772\"], [\"531e85792aaefa3\", \"531e85792aaefa3\"], [\"531e94d8e0c3a62\", \"531e94d8e0c3a62\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"F\", \"F\"], [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 12,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 0,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 0,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 0,
|
"keyPattern": "{}",
|
"boundsVerbose": "field #0['owner']: [\"52ddd47ba6c59d4\", \"52ddd47ba6c59d4\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [MinKey, MaxKey]",
|
"isMultiKey": 0,
|
"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": "{}",
|
"boundsVerbose": "field #0['designate']: [\"52ddd47ba6c59d4\", \"52ddd47ba6c59d4\"], field #1['ca']: [MaxKey, MinKey]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 0,
|
"children": [
|
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
}
|
3rd explain() output (current work around):
{
|
"clauses": [
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 2,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd476347b1b8",
|
"52ddd476347b1b8"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 2,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd479eab21d8",
|
"52ddd479eab21d8"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 2,
|
"nscannedObjects": 2,
|
"nscanned": 3,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd476347b1b8",
|
"52ddd476347b1b8"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 2,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd4783b635c3",
|
"52ddd4783b635c3"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 2,
|
"nscannedObjects": 2,
|
"nscanned": 3,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd479eab21d8",
|
"52ddd479eab21d8"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 3,
|
"nscannedObjects": 3,
|
"nscanned": 3,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"531e84d1713f6be",
|
"531e84d1713f6be"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 1,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"531e84d39af5400",
|
"531e84d39af5400"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 1,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"531e84d58833772",
|
"531e84d58833772"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 1,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"531e85792aaefa3",
|
"531e85792aaefa3"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 2,
|
"nscannedObjects": 2,
|
"nscanned": 3,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"531e94d8e0c3a62",
|
"531e94d8e0c3a62"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 6,
|
"nscannedObjects": 6,
|
"nscanned": 7,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
{
|
"$minElement": 1
|
},
|
{
|
"$maxElement": 1
|
}
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor designate_1_ca_-1",
|
"isMultiKey": true,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 1,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"designate": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
]
|
}
|
}
|
],
|
"cursor": "QueryOptimizerCursor",
|
"n": 10,
|
"nscannedObjects": 22,
|
"nscanned": 29,
|
"nscannedObjectsAllPlans": 22,
|
"nscannedAllPlans": 29,
|
"scanAndOrder": false,
|
"nYields": 0,
|
"nChunkSkips": 0,
|
"millis": 2,
|
"allPlans": [
|
{
|
"clauses": [
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 2,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd476347b1b8",
|
"52ddd476347b1b8"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 2,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd479eab21d8",
|
"52ddd479eab21d8"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 2,
|
"nscannedObjects": 2,
|
"nscanned": 3,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd476347b1b8",
|
"52ddd476347b1b8"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 2,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd4783b635c3",
|
"52ddd4783b635c3"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 2,
|
"nscannedObjects": 2,
|
"nscanned": 3,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd479eab21d8",
|
"52ddd479eab21d8"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 3,
|
"nscannedObjects": 3,
|
"nscanned": 3,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"531e84d1713f6be",
|
"531e84d1713f6be"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 1,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"531e84d39af5400",
|
"531e84d39af5400"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 1,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"531e84d58833772",
|
"531e84d58833772"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 1,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"531e85792aaefa3",
|
"531e85792aaefa3"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 2,
|
"nscannedObjects": 2,
|
"nscanned": 3,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"531e94d8e0c3a62",
|
"531e94d8e0c3a62"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
"F",
|
"F"
|
],
|
[
|
"P",
|
"P"
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor owner_1_ca_-1_permission_1",
|
"isMultiKey": false,
|
"n": 6,
|
"nscannedObjects": 6,
|
"nscanned": 7,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"owner": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
],
|
"permission": [
|
[
|
{
|
"$minElement": 1
|
},
|
{
|
"$maxElement": 1
|
}
|
]
|
]
|
}
|
},
|
{
|
"cursor": "BtreeCursor designate_1_ca_-1",
|
"isMultiKey": true,
|
"n": 1,
|
"nscannedObjects": 1,
|
"nscanned": 1,
|
"scanAndOrder": false,
|
"indexOnly": false,
|
"nChunkSkips": 0,
|
"indexBounds": {
|
"designate": [
|
[
|
"52ddd47ba6c59d4",
|
"52ddd47ba6c59d4"
|
]
|
],
|
"ca": [
|
[
|
{
|
"$maxElement": 1
|
},
|
{
|
"$minElement": 1
|
}
|
]
|
]
|
}
|
}
|
],
|
"cursor": "QueryOptimizerCursor",
|
"n": 10,
|
"nscannedObjects": 22,
|
"nscanned": 29,
|
"scanAndOrder": false,
|
"nChunkSkips": 0
|
}
|
],
|
"server": "Xres:27017",
|
"filterSet": false,
|
"stats": {
|
"type": "LIMIT",
|
"works": 34,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 10,
|
"needTime": 23,
|
"needFetch": 0,
|
"isEOF": 1,
|
"children": [
|
{
|
"type": "FETCH",
|
"works": 33,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 10,
|
"needTime": 23,
|
"needFetch": 0,
|
"isEOF": 0,
|
"alreadyHasObj": 0,
|
"forcedFetches": 0,
|
"matchTested": 0,
|
"children": [
|
{
|
"type": "SORT_MERGE",
|
"works": 33,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 10,
|
"needTime": 23,
|
"needFetch": 0,
|
"isEOF": 0,
|
"dupsTested": 22,
|
"dupsDropped": 2,
|
"forcedFetches": 0,
|
"children": [
|
{
|
"type": "IXSCAN",
|
"works": 1,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 1,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 0,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"52ddd476347b1b8\", \"52ddd476347b1b8\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 2,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 1,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 1,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 0,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"52ddd479eab21d8\", \"52ddd479eab21d8\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 2,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 2,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 2,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 0,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"52ddd476347b1b8\", \"52ddd476347b1b8\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"F\", \"F\"], [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 3,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 1,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 1,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 0,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"52ddd4783b635c3\", \"52ddd4783b635c3\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"F\", \"F\"], [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 2,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 2,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 2,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 0,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"52ddd479eab21d8\", \"52ddd479eab21d8\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"F\", \"F\"], [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 3,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 3,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 3,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"531e84d1713f6be\", \"531e84d1713f6be\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"F\", \"F\"], [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 3,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 1,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 1,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"531e84d39af5400\", \"531e84d39af5400\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"F\", \"F\"], [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 1,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 1,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 1,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"531e84d58833772\", \"531e84d58833772\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"F\", \"F\"], [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 1,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 1,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 1,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"531e85792aaefa3\", \"531e85792aaefa3\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"F\", \"F\"], [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 1,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 2,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 2,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"531e94d8e0c3a62\", \"531e94d8e0c3a62\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [\"F\", \"F\"], [\"P\", \"P\"]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 3,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 6,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 6,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 0,
|
"keyPattern": "{ owner: 1, ca: -1, permission: 1 }",
|
"boundsVerbose": "field #0['owner']: [\"52ddd47ba6c59d4\", \"52ddd47ba6c59d4\"], field #1['ca']: [MaxKey, MinKey], field #2['permission']: [MinKey, MaxKey]",
|
"isMultiKey": 0,
|
"yieldMovedCursor": 0,
|
"dupsTested": 0,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 7,
|
"children": [
|
|
]
|
},
|
{
|
"type": "IXSCAN",
|
"works": 2,
|
"yields": 0,
|
"unyields": 0,
|
"invalidates": 0,
|
"advanced": 1,
|
"needTime": 0,
|
"needFetch": 0,
|
"isEOF": 1,
|
"keyPattern": "{ designate: 1, ca: -1 }",
|
"boundsVerbose": "field #0['designate']: [\"52ddd47ba6c59d4\", \"52ddd47ba6c59d4\"], field #1['ca']: [MaxKey, MinKey]",
|
"isMultiKey": 1,
|
"yieldMovedCursor": 0,
|
"dupsTested": 1,
|
"dupsDropped": 0,
|
"seenInvalidated": 0,
|
"matchTested": 0,
|
"keysExamined": 1,
|
"children": [
|
|
]
|
}
|
]
|
}
|
]
|
}
|
]
|
}
|
}
|
|