|
Hi Ramon,
Here's the output .
var oldLogLevel = db.adminCommand({getParameter:1, logLevel:1}).logLevel
|
db.adminCommand( { setParameter: 1, logLevel: 2 } )
|
|
db.RadiusAccount.getPlanCache().listQueryShapes()
|
|
[
|
{
|
"query" : {
|
"acctsessionid" : "1667b808571ec14596566644c87647f07104c7791b2fb9ec164f4cef210dacb22ef0728cbd10529b8431bd07a73017ec"
|
},
|
"sort" : {
|
"_id" : -1
|
},
|
"projection" : {
|
|
}
|
},
|
{
|
"query" : {
|
"username" : "13611755230",
|
"stoptime" : {
|
"$exists" : false
|
}
|
},
|
"sort" : {
|
|
},
|
"projection" : {
|
|
}
|
},
|
{
|
"query" : {
|
"acctsessionid" : "7C-1D-D9-75-52-D9-DF627B4D",
|
"$and" : [
|
{
|
"starttime" : {
|
"$gte" : ISODate("2015-05-25T01:29:53.941Z")
|
}
|
},
|
{
|
"starttime" : {
|
"$lte" : ISODate("2015-05-25T01:31:53.941Z")
|
}
|
}
|
]
|
},
|
"sort" : {
|
"_id" : -1
|
},
|
"projection" : {
|
|
}
|
}
|
]
|
|
db.RadiusAccount.find({ acctsessionid: "90-3C-92-C2-EA-38-9659892E" }).sort({ _id: -1 }).explain(true)
|
{
|
"queryPlanner" : {
|
"plannerVersion" : 1,
|
"namespace" : "Radius.RadiusAccount",
|
"indexFilterSet" : false,
|
"parsedQuery" : {
|
"acctsessionid" : {
|
"$eq" : "90-3C-92-C2-EA-38-9659892E"
|
}
|
},
|
"winningPlan" : {
|
"stage" : "SORT",
|
"sortPattern" : {
|
"_id" : -1
|
},
|
"inputStage" : {
|
"stage" : "FETCH",
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"keyPattern" : {
|
"acctsessionid" : 1
|
},
|
"indexName" : "acctsessionid_1",
|
"isMultiKey" : false,
|
"direction" : "forward",
|
"indexBounds" : {
|
"acctsessionid" : [
|
"[\"90-3C-92-C2-EA-38-9659892E\", \"90-3C-92-C2-EA-38-9659892E\"]"
|
]
|
}
|
}
|
}
|
},
|
"rejectedPlans" : [
|
{
|
"stage" : "FETCH",
|
"filter" : {
|
"acctsessionid" : {
|
"$eq" : "90-3C-92-C2-EA-38-9659892E"
|
}
|
},
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"keyPattern" : {
|
"_id" : 1
|
},
|
"indexName" : "_id_",
|
"isMultiKey" : false,
|
"direction" : "backward",
|
"indexBounds" : {
|
"_id" : [
|
"[MaxKey, MinKey]"
|
]
|
}
|
}
|
}
|
]
|
},
|
"executionStats" : {
|
"executionSuccess" : true,
|
"nReturned" : 1,
|
"executionTimeMillis" : 0,
|
"totalKeysExamined" : 1,
|
"totalDocsExamined" : 1,
|
"executionStages" : {
|
"stage" : "SORT",
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 6,
|
"advanced" : 1,
|
"needTime" : 2,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"sortPattern" : {
|
"_id" : -1
|
},
|
"memUsage" : 848,
|
"memLimit" : 33554432,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 1,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"docsExamined" : 1,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 1,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"acctsessionid" : 1
|
},
|
"indexName" : "acctsessionid_1",
|
"isMultiKey" : false,
|
"direction" : "forward",
|
"indexBounds" : {
|
"acctsessionid" : [
|
"[\"90-3C-92-C2-EA-38-9659892E\", \"90-3C-92-C2-EA-38-9659892E\"]"
|
]
|
},
|
"keysExamined" : 1,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0
|
}
|
}
|
},
|
"allPlansExecution" : [
|
{
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"totalKeysExamined" : 5,
|
"totalDocsExamined" : 5,
|
"executionStages" : {
|
"stage" : "FETCH",
|
"filter" : {
|
"acctsessionid" : {
|
"$eq" : "90-3C-92-C2-EA-38-9659892E"
|
}
|
},
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 5,
|
"advanced" : 0,
|
"needTime" : 5,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 0,
|
"invalidates" : 0,
|
"docsExamined" : 5,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 5,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 5,
|
"advanced" : 5,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 0,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"_id" : 1
|
},
|
"indexName" : "_id_",
|
"isMultiKey" : false,
|
"direction" : "backward",
|
"indexBounds" : {
|
"_id" : [
|
"[MaxKey, MinKey]"
|
]
|
},
|
"keysExamined" : 5,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0
|
}
|
}
|
},
|
{
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"totalKeysExamined" : 1,
|
"totalDocsExamined" : 1,
|
"executionStages" : {
|
"stage" : "SORT",
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 5,
|
"advanced" : 1,
|
"needTime" : 2,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"sortPattern" : {
|
"_id" : -1
|
},
|
"memUsage" : 848,
|
"memLimit" : 33554432,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 1,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"docsExamined" : 1,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 1,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"acctsessionid" : 1
|
},
|
"indexName" : "acctsessionid_1",
|
"isMultiKey" : false,
|
"direction" : "forward",
|
"indexBounds" : {
|
"acctsessionid" : [
|
"[\"90-3C-92-C2-EA-38-9659892E\", \"90-3C-92-C2-EA-38-9659892E\"]"
|
]
|
},
|
"keysExamined" : 1,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0
|
}
|
}
|
}
|
}
|
]
|
},
|
"serverInfo" : {
|
"host" : "iSHGQSvrDB002",
|
"port" : 40001,
|
"version" : "3.0.3",
|
"gitVersion" : "b40106b36eecd1b4407eb1ad1af6bc60593c6105 modules: enterprise"
|
},
|
"ok" : 1
|
}
|
db.RadiusAccount.getPlanCache().getPlansByQuery({ acctsessionid: "90-3C-92-C2-EA-38-9659892E" }, {}, { _id : -1})
|
|
[
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Leaf { acctsessionid: 1.0 }, pos: 0\n)"
|
},
|
"reason" : {
|
"score" : 1.2502,
|
"stats" : {
|
"stage" : "SORT",
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 4,
|
"advanced" : 1,
|
"needTime" : 2,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"sortPattern" : {
|
"_id" : -1
|
},
|
"memUsage" : 767,
|
"memLimit" : 33554432,
|
"limitAmount" : 1,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 1,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"docsExamined" : 1,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 1,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"acctsessionid" : 1
|
},
|
"indexName" : "acctsessionid_1",
|
"isMultiKey" : false,
|
"direction" : "forward",
|
"indexBounds" : {
|
"acctsessionid" : [
|
"[\"00-61-71-0F-45-FB-BA627338\", \"00-61-71-0F-45-FB-BA627338\"]"
|
]
|
},
|
"keysExamined" : 1,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0
|
}
|
}
|
}
|
},
|
"feedback" : {
|
"nfeedback" : 20,
|
"averageScore" : 1.1543666666666663,
|
"stdDevScore" : 0.11870093630928842,
|
"scores" : [
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.1668666666666667
|
},
|
{
|
"score" : 1.1668666666666667
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.0002
|
}
|
]
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(whole index scan solution: dir=-1; tree=Leaf { _id: 1 }, pos: 0\n)"
|
},
|
"reason" : {
|
"score" : 1.0003,
|
"stats" : {
|
"stage" : "LIMIT",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 4,
|
"advanced" : 0,
|
"needTime" : 4,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 0,
|
"invalidates" : 0,
|
"limitAmount" : 1,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"filter" : {
|
"acctsessionid" : {
|
"$eq" : "00-61-71-0F-45-FB-BA627338"
|
}
|
},
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 4,
|
"advanced" : 0,
|
"needTime" : 4,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 0,
|
"invalidates" : 0,
|
"docsExamined" : 4,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 4,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 4,
|
"advanced" : 4,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 0,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"_id" : 1
|
},
|
"indexName" : "_id_",
|
"isMultiKey" : false,
|
"direction" : "backward",
|
"indexBounds" : {
|
"_id" : [
|
"[MaxKey, MinKey]"
|
]
|
},
|
"keysExamined" : 4,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0
|
}
|
}
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
}
|
]
|
db.RadiusAccount.find({ acctsessionid: "090de21e9375571fece70d267c3e79a705e60cca2b751a64" }).sort({ _id: -1 }).explain(true)
|
|
{
|
"queryPlanner" : {
|
"plannerVersion" : 1,
|
"namespace" : "Radius.RadiusAccount",
|
"indexFilterSet" : false,
|
"parsedQuery" : {
|
"acctsessionid" : {
|
"$eq" : "090de21e9375571fece70d267c3e79a705e60cca2b751a64"
|
}
|
},
|
"winningPlan" : {
|
"stage" : "SORT",
|
"sortPattern" : {
|
"_id" : -1
|
},
|
"inputStage" : {
|
"stage" : "FETCH",
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"keyPattern" : {
|
"acctsessionid" : 1
|
},
|
"indexName" : "acctsessionid_1",
|
"isMultiKey" : false,
|
"direction" : "forward",
|
"indexBounds" : {
|
"acctsessionid" : [
|
"[\"090de21e9375571fece70d267c3e79a705e60cca2b751a64\", \"090de21e9375571fece70d267c3e79a705e60cca2b751a64\"]"
|
]
|
}
|
}
|
}
|
},
|
"rejectedPlans" : [ ]
|
},
|
"executionStats" : {
|
"executionSuccess" : true,
|
"nReturned" : 0,
|
"executionTimeMillis" : 13,
|
"totalKeysExamined" : 0,
|
"totalDocsExamined" : 0,
|
"executionStages" : {
|
"stage" : "SORT",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 10,
|
"works" : 4,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"sortPattern" : {
|
"_id" : -1
|
},
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 10,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"docsExamined" : 0,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 10,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"acctsessionid" : 1
|
},
|
"indexName" : "acctsessionid_1",
|
"isMultiKey" : false,
|
"direction" : "forward",
|
"indexBounds" : {
|
"acctsessionid" : [
|
"[\"090de21e9375571fece70d267c3e79a705e60cca2b751a64\", \"090de21e9375571fece70d267c3e79a705e60cca2b751a64\"]"
|
]
|
},
|
"keysExamined" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0
|
}
|
}
|
},
|
"allPlansExecution" : [
|
{
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 10,
|
"totalKeysExamined" : 0,
|
"totalDocsExamined" : 0,
|
"executionStages" : {
|
"stage" : "SORT",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 10,
|
"works" : 3,
|
"advanced" : 0,
|
"needTime" : 1,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"sortPattern" : {
|
"_id" : -1
|
},
|
"memUsage" : 0,
|
"memLimit" : 33554432,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 10,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"docsExamined" : 0,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 10,
|
"works" : 1,
|
"advanced" : 0,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"acctsessionid" : 1
|
},
|
"indexName" : "acctsessionid_1",
|
"isMultiKey" : false,
|
"direction" : "forward",
|
"indexBounds" : {
|
"acctsessionid" : [
|
"[\"090de21e9375571fece70d267c3e79a705e60cca2b751a64\", \"090de21e9375571fece70d267c3e79a705e60cca2b751a64\"]"
|
]
|
},
|
"keysExamined" : 0,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0
|
}
|
}
|
}
|
}
|
]
|
},
|
"serverInfo" : {
|
"host" : "iSHGQSvrDB002",
|
"port" : 40001,
|
"version" : "3.0.3",
|
"gitVersion" : "b40106b36eecd1b4407eb1ad1af6bc60593c6105 modules: enterprise"
|
},
|
"ok" : 1
|
}
|
db.RadiusAccount.getPlanCache().getPlansByQuery({acctsessionid: "090de21e9375571fece70d267c3e79a705e60cca2b751a64"}, {}, { _id : -1})
|
|
[
|
{
|
"details" : {
|
"solution" : "(index-tagged expression tree: tree=Leaf { acctsessionid: 1.0 }, pos: 0\n)"
|
},
|
"reason" : {
|
"score" : 1.2502,
|
"stats" : {
|
"stage" : "SORT",
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 4,
|
"advanced" : 1,
|
"needTime" : 2,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"sortPattern" : {
|
"_id" : -1
|
},
|
"memUsage" : 622,
|
"memLimit" : 33554432,
|
"limitAmount" : 1,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 1,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"docsExamined" : 1,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 1,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 2,
|
"advanced" : 1,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"acctsessionid" : 1
|
},
|
"indexName" : "acctsessionid_1",
|
"isMultiKey" : false,
|
"direction" : "forward",
|
"indexBounds" : {
|
"acctsessionid" : [
|
"[\"c1d350d83d11d79711f8101d9a54e2c069442c59ce1d29c5a1764b8c4fb198d38255c93d49d9a16e\", \"c1d350d83d11d79711f8101d9a54e2c069442c59ce1d29c5a1764b8c4fb198d38255c93d49d9a16e\"]"
|
]
|
},
|
"keysExamined" : 1,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0
|
}
|
}
|
}
|
},
|
"feedback" : {
|
"nfeedback" : 20,
|
"averageScore" : 1.0876999999999997,
|
"stdDevScore" : 0.12234012123239821,
|
"scores" : [
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.0002
|
},
|
{
|
"score" : 1.2502
|
},
|
{
|
"score" : 1.0002
|
}
|
]
|
},
|
"filterSet" : false
|
},
|
{
|
"details" : {
|
"solution" : "(whole index scan solution: dir=-1; tree=Leaf { _id: 1 }, pos: 0\n)"
|
},
|
"reason" : {
|
"score" : 1.0003,
|
"stats" : {
|
"stage" : "LIMIT",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 4,
|
"advanced" : 0,
|
"needTime" : 4,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 0,
|
"invalidates" : 0,
|
"limitAmount" : 1,
|
"inputStage" : {
|
"stage" : "FETCH",
|
"filter" : {
|
"acctsessionid" : {
|
"$eq" : "c1d350d83d11d79711f8101d9a54e2c069442c59ce1d29c5a1764b8c4fb198d38255c93d49d9a16e"
|
}
|
},
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 4,
|
"advanced" : 0,
|
"needTime" : 4,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 0,
|
"invalidates" : 0,
|
"docsExamined" : 4,
|
"alreadyHasObj" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 4,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 4,
|
"advanced" : 4,
|
"needTime" : 0,
|
"needFetch" : 0,
|
"saveState" : 0,
|
"restoreState" : 0,
|
"isEOF" : 0,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"_id" : 1
|
},
|
"indexName" : "_id_",
|
"isMultiKey" : false,
|
"direction" : "backward",
|
"indexBounds" : {
|
"_id" : [
|
"[MaxKey, MinKey]"
|
]
|
},
|
"keysExamined" : 4,
|
"dupsTested" : 0,
|
"dupsDropped" : 0,
|
"seenInvalidated" : 0,
|
"matchTested" : 0
|
}
|
}
|
}
|
},
|
"feedback" : {
|
|
},
|
"filterSet" : false
|
}
|
]
|
|