Skip to content

Instantly share code, notes, and snippets.

@namannigam
Created January 26, 2021 14:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save namannigam/1885e37dae87fd7b67355805eefff461 to your computer and use it in GitHub Desktop.
Save namannigam/1885e37dae87fd7b67355805eefff461 to your computer and use it in GitHub Desktop.
{
"queryPlanner": {
"plannerVersion": 1,
"namespace": "mongo_experiments.product_snapshot_composite_index",
"indexFilterSet": false,
"parsedQuery": {
"uIdHash": {
"$eq": "2lgys2yxouhug5xj3ms45mluxw5hsweu"
}
},
"winningPlan": {
"stage": "LIMIT",
"limitAmount": 10,
"inputStage": {
"stage": "FETCH",
"inputStage": {
"stage": "IXSCAN",
"keyPattern": {
"uIdHash": 1,
"userTS": -1
},
"indexName": "uIdHash_1_userTS_-1",
"isMultiKey": false,
"multiKeyPaths": {
"uIdHash": [],
"userTS": []
},
"isUnique": false,
"isSparse": false,
"isPartial": false,
"indexVersion": 2,
"direction": "forward",
"indexBounds": {
"uIdHash": [
"[\"2lgys2yxouhug5xj3ms45mluxw5hsweu\", \"2lgys2yxouhug5xj3ms45mluxw5hsweu\"]"
],
"userTS": [
"[MaxKey, MinKey]"
]
}
}
}
},
"rejectedPlans": [
{
"stage": "SORT",
"sortPattern": {
"userTS": -1
},
"memLimit": 104857600,
"limitAmount": 10,
"type": "simple",
"inputStage": {
"stage": "FETCH",
"filter": {
"uIdHash": {
"$eq": "2lgys2yxouhug5xj3ms45mluxw5hsweu"
}
},
"inputStage": {
"stage": "IXSCAN",
"keyPattern": {
"uIdHash": "hashed"
},
"indexName": "uIdHash_hashed",
"isMultiKey": false,
"isUnique": false,
"isSparse": false,
"isPartial": false,
"indexVersion": 2,
"direction": "forward",
"indexBounds": {
"uIdHash": [
"[6360747226755201771, 6360747226755201771]"
]
}
}
}
}
]
},
"executionStats": {
"executionSuccess": true,
"nReturned": 10,
"executionTimeMillis": 0,
"totalKeysExamined": 10,
"totalDocsExamined": 10,
"executionStages": {
"stage": "LIMIT",
"nReturned": 10,
"executionTimeMillisEstimate": 0,
"works": 11,
"advanced": 10,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 1,
"limitAmount": 10,
"inputStage": {
"stage": "FETCH",
"nReturned": 10,
"executionTimeMillisEstimate": 0,
"works": 10,
"advanced": 10,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"docsExamined": 10,
"alreadyHasObj": 0,
"inputStage": {
"stage": "IXSCAN",
"nReturned": 10,
"executionTimeMillisEstimate": 0,
"works": 10,
"advanced": 10,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"keyPattern": {
"uIdHash": 1,
"userTS": -1
},
"indexName": "uIdHash_1_userTS_-1",
"isMultiKey": false,
"multiKeyPaths": {
"uIdHash": [],
"userTS": []
},
"isUnique": false,
"isSparse": false,
"isPartial": false,
"indexVersion": 2,
"direction": "forward",
"indexBounds": {
"uIdHash": [
"[\"2lgys2yxouhug5xj3ms45mluxw5hsweu\", \"2lgys2yxouhug5xj3ms45mluxw5hsweu\"]"
],
"userTS": [
"[MaxKey, MinKey]"
]
},
"keysExamined": 10,
"seeks": 1,
"dupsTested": 0,
"dupsDropped": 0
}
}
}
},
"serverInfo": {
"host": ".local",
"port": 27017,
"version": "4.4.3",
"gitVersion": "913d6b62acfbb344dde1b116f4161360acd8fd13"
},
"ok": 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment