Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- > db.eos.find({$or:[{to:"eospokerwins"},{from: "eospokerwins"}]}).limit(10).sort( { blockNumber: -1 } ).explain("executionStats")
- {
- "queryPlanner" : {
- "plannerVersion" : 1,
- "namespace" : "test.eos",
- "indexFilterSet" : false,
- "parsedQuery" : {
- "$or" : [
- {
- "from" : {
- "$eq" : "eospokerwins"
- }
- },
- {
- "to" : {
- "$eq" : "eospokerwins"
- }
- }
- ]
- },
- "winningPlan" : {
- "stage" : "SUBPLAN",
- "inputStage" : {
- "stage" : "LIMIT",
- "limitAmount" : 10,
- "inputStage" : {
- "stage" : "FETCH",
- "filter" : {
- "$or" : [
- {
- "from" : {
- "$eq" : "eospokerwins"
- }
- },
- {
- "to" : {
- "$eq" : "eospokerwins"
- }
- }
- ]
- },
- "inputStage" : {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "blockNumber" : -1,
- "from" : 1,
- "to" : 1
- },
- "indexName" : "blockNumber_-1_from_1_to_1",
- "isMultiKey" : false,
- "multiKeyPaths" : {
- "blockNumber" : [ ],
- "from" : [ ],
- "to" : [ ]
- },
- "isUnique" : false,
- "isSparse" : false,
- "isPartial" : false,
- "indexVersion" : 2,
- "direction" : "forward",
- "indexBounds" : {
- "blockNumber" : [
- "[MaxKey, MinKey]"
- ],
- "from" : [
- "[MinKey, MaxKey]"
- ],
- "to" : [
- "[MinKey, MaxKey]"
- ]
- }
- }
- }
- }
- },
- "rejectedPlans" : [ ]
- },
- "executionStats" : {
- "executionSuccess" : true,
- "nReturned" : 10,
- "executionTimeMillis" : 337169,
- "totalKeysExamined" : 4136346,
- "totalDocsExamined" : 4136346,
- "executionStages" : {
- "stage" : "SUBPLAN",
- "nReturned" : 10,
- "executionTimeMillisEstimate" : 335428,
- "works" : 4136347,
- "advanced" : 10,
- "needTime" : 4136336,
- "needYield" : 0,
- "saveState" : 35220,
- "restoreState" : 35220,
- "isEOF" : 1,
- "invalidates" : 0,
- "inputStage" : {
- "stage" : "LIMIT",
- "nReturned" : 10,
- "executionTimeMillisEstimate" : 334878,
- "works" : 4136346,
- "advanced" : 10,
- "needTime" : 4136336,
- "needYield" : 0,
- "saveState" : 35220,
- "restoreState" : 35220,
- "isEOF" : 1,
- "invalidates" : 0,
- "limitAmount" : 10,
- "inputStage" : {
- "stage" : "FETCH",
- "filter" : {
- "$or" : [
- {
- "from" : {
- "$eq" : "eospokerwins"
- }
- },
- {
- "to" : {
- "$eq" : "eospokerwins"
- }
- }
- ]
- },
- "nReturned" : 10,
- "executionTimeMillisEstimate" : 334408,
- "works" : 4136346,
- "advanced" : 10,
- "needTime" : 4136336,
- "needYield" : 0,
- "saveState" : 35220,
- "restoreState" : 35220,
- "isEOF" : 0,
- "invalidates" : 0,
- "docsExamined" : 4136346,
- "alreadyHasObj" : 0,
- "inputStage" : {
- "stage" : "IXSCAN",
- "nReturned" : 4136346,
- "executionTimeMillisEstimate" : 4529,
- "works" : 4136346,
- "advanced" : 4136346,
- "needTime" : 0,
- "needYield" : 0,
- "saveState" : 35220,
- "restoreState" : 35220,
- "isEOF" : 0,
- "invalidates" : 0,
- "keyPattern" : {
- "blockNumber" : -1,
- "from" : 1,
- "to" : 1
- },
- "indexName" : "blockNumber_-1_from_1_to_1",
- "isMultiKey" : false,
- "multiKeyPaths" : {
- "blockNumber" : [ ],
- "from" : [ ],
- "to" : [ ]
- },
- "isUnique" : false,
- "isSparse" : false,
- "isPartial" : false,
- "indexVersion" : 2,
- "direction" : "forward",
- "indexBounds" : {
- "blockNumber" : [
- "[MaxKey, MinKey]"
- ],
- "from" : [
- "[MinKey, MaxKey]"
- ],
- "to" : [
- "[MinKey, MaxKey]"
- ]
- },
- "keysExamined" : 4136346,
- "seeks" : 1,
- "dupsTested" : 0,
- "dupsDropped" : 0,
- "seenInvalidated" : 0
- }
- }
- }
- }
- },
- "serverInfo" : {
- "host" : "ip-172-31-11-142",
- "port" : 27017,
- "version" : "4.0.7",
- "gitVersion" : "1b82c812a9c0bbf6dc79d5400de9ea99e6ffa025"
- },
- "ok" : 1
- }
- >
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement