complete

Created Diff never expires
31 removals
Lines
Total
Removed
Words
Total
Removed
To continue using this feature, upgrade to
Diffchecker logo
Diffchecker Pro
118 lines
31 additions
Lines
Total
Added
Words
Total
Added
To continue using this feature, upgrade to
Diffchecker logo
Diffchecker Pro
118 lines
{
{
"queryPlanner" : {
"queryPlanner" : {
"plannerVersion" : 1,
"plannerVersion" : 1,
"namespace" : "mydb.mycollection",
"namespace" : "mydb.mycollection",
"indexFilterSet" : false,
"indexFilterSet" : false,
"parsedQuery" : {
"parsedQuery" : {
"w.d" : {
"w.em" : {
"$regex" : "^firstname.lastname",
"$regex" : "^firstname.lastname",
"$options" : "i"
"$options" : "i"
}
}
},
},
"winningPlan" : {
"winningPlan" : {
"stage" : "FETCH",
"stage" : "FETCH",
"inputStage" : {
"inputStage" : {
"stage" : "IXSCAN",
"stage" : "IXSCAN",
"filter" : {
"filter" : {
"w.d" : {
"w.em" : {
"$regex" : "^firstname.lastname",
"$regex" : "^firstname.lastname",
"$options" : "i"
"$options" : "i"
}
}
},
},
"keyPattern" : {
"keyPattern" : {
"w.d" : 1
"w.em" : 1
},
},
"indexName" : "w.d_1",
"indexName" : "w.em_1",
"isMultiKey" : false,
"isMultiKey" : false,
"multiKeyPaths" : {
"multiKeyPaths" : {
"w.d" : [ ]
"w.em" : [ ]
},
},
"isUnique" : false,
"isUnique" : false,
"isSparse" : false,
"isSparse" : false,
"isPartial" : false,
"isPartial" : false,
"indexVersion" : 2,
"indexVersion" : 2,
"direction" : "forward",
"direction" : "forward",
"indexBounds" : {
"indexBounds" : {
"w.d" : [
"w.em" : [
"[\"\", {})",
"[\"\", {})",
"[/^firstname.lastname/i, /^firstname.lastname/i]"
"[/^firstname.lastname/i, /^firstname.lastname/i]"
]
]
}
}
}
}
},
},
"rejectedPlans" : [ ]
"rejectedPlans" : [ ]
},
},
"executionStats" : {
"executionStats" : {
"executionSuccess" : true,
"executionSuccess" : true,
"nReturned" : 0,
"nReturned" : 581,
"executionTimeMillis" : 18483,
"executionTimeMillis" : 16806,
"totalKeysExamined" : 22031332,
"totalKeysExamined" : 22032049,
"totalDocsExamined" : 0,
"totalDocsExamined" : 581,
"executionStages" : {
"executionStages" : {
"stage" : "FETCH",
"stage" : "FETCH",
"nReturned" : 0,
"nReturned" : 581,
"executionTimeMillisEstimate" : 16530,
"executionTimeMillisEstimate" : 15860,
"works" : 22031333,
"works" : 22032050,
"advanced" : 0,
"advanced" : 581,
"needTime" : 22031332,
"needTime" : 22031468,
"needYield" : 0,
"needYield" : 0,
"saveState" : 172119,
"saveState" : 172125,
"restoreState" : 172119,
"restoreState" : 172125,
"isEOF" : 1,
"isEOF" : 1,
"invalidates" : 0,
"invalidates" : 0,
"docsExamined" : 0,
"docsExamined" : 581,
"alreadyHasObj" : 0,
"alreadyHasObj" : 0,
"inputStage" : {
"inputStage" : {
"stage" : "IXSCAN",
"stage" : "IXSCAN",
"filter" : {
"filter" : {
"w.d" : {
"w.em" : {
"$regex" : "^firstname.lastname",
"$regex" : "^firstname.lastname",
"$options" : "i"
"$options" : "i"
}
}
},
},
"nReturned" : 0,
"nReturned" : 581,
"executionTimeMillisEstimate" : 15860,
"executionTimeMillisEstimate" : 15190,
"works" : 22031333,
"works" : 22032050,
"advanced" : 0,
"advanced" : 581,
"needTime" : 22031332,
"needTime" : 22031468,
"needYield" : 0,
"needYield" : 0,
"saveState" : 172119,
"saveState" : 172125,
"restoreState" : 172119,
"restoreState" : 172125,
"isEOF" : 1,
"isEOF" : 1,
"invalidates" : 0,
"invalidates" : 0,
"keyPattern" : {
"keyPattern" : {
"w.d" : 1
"w.em" : 1
},
},
"indexName" : "w.d_1",
"indexName" : "w.em_1",
"isMultiKey" : false,
"isMultiKey" : false,
"multiKeyPaths" : {
"multiKeyPaths" : {
"w.d" : [ ]
"w.em" : [ ]
},
},
"isUnique" : false,
"isUnique" : false,
"isSparse" : false,
"isSparse" : false,
"isPartial" : false,
"isPartial" : false,
"indexVersion" : 2,
"indexVersion" : 2,
"direction" : "forward",
"direction" : "forward",
"indexBounds" : {
"indexBounds" : {
"w.d" : [
"w.em" : [
"[\"\", {})",
"[\"\", {})",
"[/^firstname.lastname/i, /^firstname.lastname/i]"
"[/^firstname.lastname/i, /^firstname.lastname/i]"
]
]
},
},
"keysExamined" : 22031332,
"keysExamined" : 22032049,
"seeks" : 1,
"seeks" : 1,
"dupsTested" : 0,
"dupsTested" : 0,
"dupsDropped" : 0,
"dupsDropped" : 0,
"seenInvalidated" : 0
"seenInvalidated" : 0
}
}
}
}
},
},
"serverInfo" : {
"serverInfo" : {
"host" : "mongo-pnl",
"host" : "mongo-pnl",
"port" : 27017,
"port" : 27017,
"version" : "3.4.23",
"version" : "3.4.23",
"gitVersion" : "324017ede1dbb1c9554dd2dceb15f8da3c59d0e8"
"gitVersion" : "324017ede1dbb1c9554dd2dceb15f8da3c59d0e8"
},
},
"ok" : 1
"ok" : 1
}
}