I expected/wanted to see the sort spec when running this:
db.temp.find( {a:1} ).limit(3).sort( {b:1, _id:1} ).explain(true)
...
"stats" : {
"type" : "SORT",
"works" : 11,
"yields" : 0,
"unyields" : 0,
"invalidates" : 0,
"advanced" : 3,
"needTime" : 7,
"needFetch" : 0,
"isEOF" : 1,
"forcedFetches" : 0,
"children" : [
{
"type" : "FETCH",
...
- related to
-
SERVER-10472 find(a).sort(b,_id) doesn't use index(a,b) to minimize scans
-
- Backlog
-
-
SERVER-10448 Revamp explain() formatting
-
- Closed
-