Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "queryPlanner" : {
- "plannerVersion" : 1,
- "namespace" : "imessage.conversations",
- "indexFilterSet" : false,
- "parsedQuery" : {
- "$and" : [
- {
- "users" : {
- "$eq" : "5942328"
- }
- },
- {
- "users" : {
- "$eq" : "9082468"
- }
- }
- ]
- },
- "winningPlan" : {
- "stage" : "FETCH",
- "filter" : {
- "users" : {
- "$eq" : "9082468"
- }
- },
- "inputStage" : {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "users" : 1
- },
- "indexName" : "users_1",
- "isMultiKey" : true,
- "isUnique" : false,
- "isSparse" : false,
- "isPartial" : false,
- "indexVersion" : 1,
- "direction" : "forward",
- "indexBounds" : {
- "users" : [
- "[\"5942328\", \"5942328\"]"
- ]
- }
- }
- },
- "rejectedPlans" : [
- {
- "stage" : "FETCH",
- "filter" : {
- "users" : {
- "$eq" : "5942328"
- }
- },
- "inputStage" : {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "users" : 1
- },
- "indexName" : "users_1",
- "isMultiKey" : true,
- "isUnique" : false,
- "isSparse" : false,
- "isPartial" : false,
- "indexVersion" : 1,
- "direction" : "forward",
- "indexBounds" : {
- "users" : [
- "[\"9082468\", \"9082468\"]"
- ]
- }
- }
- },
- {
- "stage" : "FETCH",
- "filter" : {
- "$and" : [
- {
- "users" : {
- "$eq" : "5942328"
- }
- },
- {
- "users" : {
- "$eq" : "9082468"
- }
- }
- ]
- },
- "inputStage" : {
- "stage" : "AND_SORTED",
- "inputStages" : [
- {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "users" : 1
- },
- "indexName" : "users_1",
- "isMultiKey" : true,
- "isUnique" : false,
- "isSparse" : false,
- "isPartial" : false,
- "indexVersion" : 1,
- "direction" : "forward",
- "indexBounds" : {
- "users" : [
- "[\"5942328\", \"5942328\"]"
- ]
- }
- },
- {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "users" : 1
- },
- "indexName" : "users_1",
- "isMultiKey" : true,
- "isUnique" : false,
- "isSparse" : false,
- "isPartial" : false,
- "indexVersion" : 1,
- "direction" : "forward",
- "indexBounds" : {
- "users" : [
- "[\"9082468\", \"9082468\"]"
- ]
- }
- }
- ]
- }
- }
- ]
- },
- "executionStats" : {
- "executionSuccess" : true,
- "nReturned" : 1,
- "executionTimeMillis" : 664,
- "totalKeysExamined" : 153,
- "totalDocsExamined" : 153,
- "executionStages" : {
- "stage" : "FETCH",
- "filter" : {
- "users" : {
- "$eq" : "9082468"
- }
- },
- "nReturned" : 1,
- "executionTimeMillisEstimate" : 560,
- "works" : 155,
- "advanced" : 1,
- "needTime" : 152,
- "needYield" : 0,
- "saveState" : 30,
- "restoreState" : 30,
- "isEOF" : 1,
- "invalidates" : 0,
- "docsExamined" : 153,
- "alreadyHasObj" : 0,
- "inputStage" : {
- "stage" : "IXSCAN",
- "nReturned" : 153,
- "executionTimeMillisEstimate" : 0,
- "works" : 154,
- "advanced" : 153,
- "needTime" : 0,
- "needYield" : 0,
- "saveState" : 30,
- "restoreState" : 30,
- "isEOF" : 1,
- "invalidates" : 0,
- "keyPattern" : {
- "users" : 1
- },
- "indexName" : "users_1",
- "isMultiKey" : true,
- "isUnique" : false,
- "isSparse" : false,
- "isPartial" : false,
- "indexVersion" : 1,
- "direction" : "forward",
- "indexBounds" : {
- "users" : [
- "[\"5942328\", \"5942328\"]"
- ]
- },
- "keysExamined" : 153,
- "dupsTested" : 153,
- "dupsDropped" : 0,
- "seenInvalidated" : 0
- }
- }
- },
- "serverInfo" : {
- "host" : "***",
- "port" : ***,
- "version" : "3.2.11",
- "gitVersion" : "009580ad490190ba33d1c6253ebd8d91808923e4"
- },
- "ok" : 1.0
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement