-
Type: Improvement
-
Resolution: Done
-
Priority: Minor - P4
-
Affects Version/s: None
-
Component/s: Querying
-
Environment:1.8.1
I know this may be difficult or require a query to be double run, but it would be great to have the plan in the profiler. Especially the nYields field.
> db.contact.find(
{userid:"000020862072"}).explain()
{
"cursor" : "BasicCursor",
"nscanned" : 299073,
"nscannedObjects" : 299073,
"n" : 6,
"millis" : 606,
"nYields" : 1,
"nChunkSkips" : 0,
"isMultiKey" : false,
"indexOnly" : false,
"indexBounds" : {
}
}
- is duplicated by
-
SERVER-5578 Have profiler capture which index was used
- Closed
- is related to
-
SERVER-7754 add index/query plan to currentOp and slow query log
- Closed