|
Hi Kelsey, thanks for the response.
db.customer.getIndexes()
Have this index along with a couple of other indexes:
{
|
"v" : 2,
|
"key" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"name" : "idx_dd_rk_hs_id",
|
"ns" : "app-customerDB.customer",
|
"background" : true
|
}
|
I am not able to edit the original description.
Substitute "dd" with "dataDomain" and "com.x" with "com.pdc" please
db.customer.find({"dataDomain":"com.pdc"}).sort({"dataDomain": 1, "refKey": 1, "hashSum": 1, "_id": 1})
|
Error: error: {
|
"ok" : 0,
|
"errmsg" : "errmsg: \"Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit.\"",
|
"code" : 96,
|
"codeName" : "OperationFailed",
|
"operationTime" : Timestamp(1519073916, 1)
|
}
|
Unfortunately not able to get an explain plan with the same issue:
db.customer.find({"dataDomain":"com.pdc"}).sort({"dataDomain": 1, "refKey": 1, "hashSum": 1, "_id": 1}).explain(true)
|
2018-02-19T15:59:40.534-0500 E QUERY [thread1] Error: explain failed: {
|
"ok" : 0,
|
"errmsg" : "errmsg: \"Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit.\"",
|
"code" : 96,
|
"codeName" : "OperationFailed",
|
"operationTime" : Timestamp(1519073976, 1)
|
} :
|
_getErrorWithCode@src/mongo/shell/utils.js:25:13
|
throwOrReturn@src/mongo/shell/explainable.js:31:1
|
constructor/this.finish@src/mongo/shell/explain_query.js:172:24
|
DBQuery.prototype.explain@src/mongo/shell/query.js:521:12
|
@(shell):1:1
|
Most of the records are with "dataDomain" = "com.pdc"
However if i try to do an explain plan with "dataDomain" as "com.y"
then this is the result:
db.customer.find({"dataDomain":"com.y"}).sort({"dataDomain": 1, "refKey": 1, "hashSum": 1, "_id": 1}).explain(true)
|
{
|
"queryPlanner" : {
|
"plannerVersion" : 1,
|
"namespace" : "app-customerDB.customer",
|
"indexFilterSet" : false,
|
"parsedQuery" : {
|
"dataDomain" : {
|
"$eq" : "com.y"
|
}
|
},
|
"winningPlan" : {
|
"stage" : "SORT",
|
"sortPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"inputStage" : {
|
"stage" : "SORT_KEY_GENERATOR",
|
"inputStage" : {
|
"stage" : "FETCH",
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"keyPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"indexName" : "idx_dd_rk_hs_id",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"dataDomain" : [
|
"dataDomain"
|
],
|
"refKey" : [ ],
|
"hashSum" : [ ],
|
"_id" : [ ]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"dataDomain" : [
|
"[\"com.y\", \"com.y\"]"
|
],
|
"refKey" : [
|
"[MinKey, MaxKey]"
|
],
|
"hashSum" : [
|
"[MinKey, MaxKey]"
|
],
|
"_id" : [
|
"[MinKey, MaxKey]"
|
]
|
}
|
}
|
}
|
}
|
},
|
"rejectedPlans" : [
|
{
|
"stage" : "SORT",
|
"sortPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"inputStage" : {
|
"stage" : "SORT_KEY_GENERATOR",
|
"inputStage" : {
|
"stage" : "FETCH",
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"keyPattern" : {
|
"dataDomain" : 1,
|
"refName" : 1
|
},
|
"indexName" : "dataDomain_1_refName_1",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"dataDomain" : [
|
"dataDomain"
|
],
|
"refName" : [ ]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"dataDomain" : [
|
"[\"com.y\", \"com.y\"]"
|
],
|
"refName" : [
|
"[MinKey, MaxKey]"
|
]
|
}
|
}
|
}
|
}
|
},
|
{
|
"stage" : "SORT",
|
"sortPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"inputStage" : {
|
"stage" : "SORT_KEY_GENERATOR",
|
"inputStage" : {
|
"stage" : "FETCH",
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"keyPattern" : {
|
"dataDomain" : 1,
|
"customerNumber" : 1
|
},
|
"indexName" : "dataDomain_1_customerNumber_1",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"dataDomain" : [
|
"dataDomain"
|
],
|
"customerNumber" : [ ]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"dataDomain" : [
|
"[\"com.y\", \"com.y\"]"
|
],
|
"customerNumber" : [
|
"[MinKey, MaxKey]"
|
]
|
}
|
}
|
}
|
}
|
},
|
{
|
"stage" : "SORT",
|
"sortPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"inputStage" : {
|
"stage" : "SORT_KEY_GENERATOR",
|
"inputStage" : {
|
"stage" : "FETCH",
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"keyPattern" : {
|
"dataDomain" : 1,
|
"name.lastName" : -1
|
},
|
"indexName" : "idx_dd_nm_lst",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"dataDomain" : [
|
"dataDomain"
|
],
|
"name.lastName" : [ ]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"dataDomain" : [
|
"[\"com.y\", \"com.y\"]"
|
],
|
"name.lastName" : [
|
"[MaxKey, MinKey]"
|
]
|
}
|
}
|
}
|
}
|
},
|
{
|
"stage" : "SORT",
|
"sortPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"inputStage" : {
|
"stage" : "SORT_KEY_GENERATOR",
|
"inputStage" : {
|
"stage" : "FETCH",
|
"filter" : {
|
"dataDomain" : {
|
"$eq" : "com.y"
|
}
|
},
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"keyPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"indexName" : "idx_dd_rk_hs_id",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"dataDomain" : [
|
"dataDomain"
|
],
|
"refKey" : [ ],
|
"hashSum" : [ ],
|
"_id" : [ ]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"dataDomain" : [
|
"[MinKey, MaxKey]"
|
],
|
"refKey" : [
|
"[MinKey, MaxKey]"
|
],
|
"hashSum" : [
|
"[MinKey, MaxKey]"
|
],
|
"_id" : [
|
"[MinKey, MaxKey]"
|
]
|
}
|
}
|
}
|
}
|
}
|
]
|
},
|
"executionStats" : {
|
"executionSuccess" : true,
|
"nReturned" : 0,
|
"executionTimeMillis" : 0,
|
"totalKeysExamined" : 0,
|
"totalDocsExamined" : 0,
|
"executionStages" : {
|
"stage" : "SORT",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 4,
|
"advanced" : 0,
|
"needTime" : 2,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"sortPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"inputStage" : {
|
"stage" : "SORT_KEY_GENERATOR",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"docsExamined" : 0,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"indexName" : "idx_dd_rk_hs_id",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"dataDomain" : [
|
"dataDomain"
|
],
|
"refKey" : [ ],
|
"hashSum" : [ ],
|
"_id" : [ ]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"dataDomain" : [
|
"[\"com.y\", \"com.y\"]"
|
],
|
"refKey" : [
|
"[MinKey, MaxKey]"
|
],
|
"hashSum" : [
|
"[MinKey, MaxKey]"
|
],
|
"_id" : [
|
"[MinKey, MaxKey]"
|
]
|
},
|
"keysExamined" : 0,
|
"seeks" : 1,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0
|
}
|
}
|
}
|
},
|
"allPlansExecution" : [
|
{
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"totalKeysExamined" : 0,
|
"totalDocsExamined" : 0,
|
"executionStages" : {
|
"stage" : "SORT",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 3,
|
"advanced" : 0,
|
"needTime" : 2,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"sortPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"inputStage" : {
|
"stage" : "SORT_KEY_GENERATOR",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"docsExamined" : 0,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"dataDomain" : 1,
|
"refName" : 1
|
},
|
"indexName" : "dataDomain_1_refName_1",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"dataDomain" : [
|
"dataDomain"
|
],
|
"refName" : [ ]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"dataDomain" : [
|
"[\"com.y\", \"com.y\"]"
|
],
|
"refName" : [
|
"[MinKey, MaxKey]"
|
]
|
},
|
"keysExamined" : 0,
|
"seeks" : 1,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0
|
}
|
}
|
}
|
}
|
},
|
{
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"totalKeysExamined" : 0,
|
"totalDocsExamined" : 0,
|
"executionStages" : {
|
"stage" : "SORT",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 3,
|
"advanced" : 0,
|
"needTime" : 2,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"sortPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"inputStage" : {
|
"stage" : "SORT_KEY_GENERATOR",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"docsExamined" : 0,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"dataDomain" : 1,
|
"customerNumber" : 1
|
},
|
"indexName" : "dataDomain_1_customerNumber_1",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"dataDomain" : [
|
"dataDomain"
|
],
|
"customerNumber" : [ ]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"dataDomain" : [
|
"[\"com.y\", \"com.y\"]"
|
],
|
"customerNumber" : [
|
"[MinKey, MaxKey]"
|
]
|
},
|
"keysExamined" : 0,
|
"seeks" : 1,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0
|
}
|
}
|
}
|
}
|
},
|
{
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"totalKeysExamined" : 0,
|
"totalDocsExamined" : 0,
|
"executionStages" : {
|
"stage" : "SORT",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 3,
|
"advanced" : 0,
|
"needTime" : 2,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"sortPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"inputStage" : {
|
"stage" : "SORT_KEY_GENERATOR",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"docsExamined" : 0,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"dataDomain" : 1,
|
"name.lastName" : -1
|
},
|
"indexName" : "idx_dd_nm_lst",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"dataDomain" : [
|
"dataDomain"
|
],
|
"name.lastName" : [ ]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"dataDomain" : [
|
"[\"com.y\", \"com.y\"]"
|
],
|
"name.lastName" : [
|
"[MaxKey, MinKey]"
|
]
|
},
|
"keysExamined" : 0,
|
"seeks" : 1,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0
|
}
|
}
|
}
|
}
|
},
|
{
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"totalKeysExamined" : 2,
|
"totalDocsExamined" : 2,
|
"executionStages" : {
|
"stage" : "SORT",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 3,
|
"advanced" : 0,
|
"needTime" : 3,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 0,
|
"invalidates" : 0,
|
"sortPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"inputStage" : {
|
"stage" : "SORT_KEY_GENERATOR",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 3,
|
"advanced" : 0,
|
"needTime" : 3,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 0,
|
"invalidates" : 0,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"filter" : {
|
"dataDomain" : {
|
"$eq" : "com.y"
|
}
|
},
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 0,
|
"needTime" : 2,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 0,
|
"invalidates" : 0,
|
"docsExamined" : 2,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 2,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 2,
|
"needTime" : 0,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 0,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"indexName" : "idx_dd_rk_hs_id",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"dataDomain" : [
|
"dataDomain"
|
],
|
"refKey" : [ ],
|
"hashSum" : [ ],
|
"_id" : [ ]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"dataDomain" : [
|
"[MinKey, MaxKey]"
|
],
|
"refKey" : [
|
"[MinKey, MaxKey]"
|
],
|
"hashSum" : [
|
"[MinKey, MaxKey]"
|
],
|
"_id" : [
|
"[MinKey, MaxKey]"
|
]
|
},
|
"keysExamined" : 2,
|
"seeks" : 1,
|
"dupsTested" : 2,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0
|
}
|
}
|
}
|
}
|
},
|
{
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"totalKeysExamined" : 0,
|
"totalDocsExamined" : 0,
|
"executionStages" : {
|
"stage" : "SORT",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 3,
|
"advanced" : 0,
|
"needTime" : 2,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"sortPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"inputStage" : {
|
"stage" : "SORT_KEY_GENERATOR",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"docsExamined" : 0,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needYield" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"dataDomain" : 1,
|
"refKey" : 1,
|
"hashSum" : 1,
|
"_id" : 1
|
},
|
"indexName" : "idx_dd_rk_hs_id",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"dataDomain" : [
|
"dataDomain"
|
],
|
"refKey" : [ ],
|
"hashSum" : [ ],
|
"_id" : [ ]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"dataDomain" : [
|
"[\"com.y\", \"com.y\"]"
|
],
|
"refKey" : [
|
"[MinKey, MaxKey]"
|
],
|
"hashSum" : [
|
"[MinKey, MaxKey]"
|
],
|
"_id" : [
|
"[MinKey, MaxKey]"
|
]
|
},
|
"keysExamined" : 0,
|
"seeks" : 1,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0
|
}
|
}
|
}
|
}
|
}
|
]
|
},
|
"serverInfo" : {
|
"host" : "qa36-shard-00-00-fpaqn.mongodb.net",
|
"port" : 27017,
|
"version" : "3.6.2",
|
"gitVersion" : "489d177dbd0f0420a8ca04d39fd78d0a2c539420"
|
},
|
"ok" : 1,
|
"operationTime" : Timestamp(1519074126, 1)
|
}
|
|