Skip to content

Instantly share code, notes, and snippets.

@ys

ys/explain

Created March 22, 2013 23:52
Show Gist options
  • Save ys/5225651 to your computer and use it in GitHub Desktop.
Save ys/5225651 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
explain
{"cursor"=>"BtreeCursor _id_ reverse",
"nscanned"=>897,
"nscannedObjects"=>897,
"n"=>10,
"millis"=>442,
"nYields"=>0,
"nChunkSkips"=>0,
"isMultiKey"=>false,
"indexOnly"=>false,
"indexBounds"=>{"_id"=>[[{"$maxElement"=>1}, {"$minElement"=>1}]]},
"allPlans"=>
[{"cursor"=>"BtreeCursor _id_ reverse",
"indexBounds"=>{"_id"=>[[{"$maxElement"=>1}, {"$minElement"=>1}]]}},
{"cursor"=>"BtreeCursor mobile_1",
"indexBounds"=>{"mobile"=>[[true, true]]}},
{"cursor"=>
"BtreeCursor mobile_1_status_1_privacy_1_featured_1__id_-1_created_at_-1",
"indexBounds"=>
{"mobile"=>[[true, true]],
"status"=>[[{"$minElement"=>1}, {"$maxElement"=>1}]],
"privacy"=>[[{"$minElement"=>1}, {"$maxElement"=>1}]],
"featured"=>[[{"$minElement"=>1}, {"$maxElement"=>1}]],
"_id"=>[[{"$maxElement"=>1}, {"$minElement"=>1}]],
"created_at"=>[[{"$maxElement"=>1}, {"$minElement"=>1}]]}},
{"cursor"=>
"BtreeCursor mobile_1_status_1_privacy_1__id_-1_created_at_-1_owner_id_1",
"indexBounds"=>
{"mobile"=>[[true, true]],
"status"=>[[{"$minElement"=>1}, {"$maxElement"=>1}]],
"privacy"=>[[{"$minElement"=>1}, {"$maxElement"=>1}]],
"_id"=>[[{"$maxElement"=>1}, {"$minElement"=>1}]],
"created_at"=>[[{"$maxElement"=>1}, {"$minElement"=>1}]],
"owner_id"=>[[{"$minElement"=>1}, {"$maxElement"=>1}]]}},
{"cursor"=>"BtreeCursor mobile_1_status_1_owner_id_1__id_-1",
"indexBounds"=>
{"mobile"=>[[true, true]],
"status"=>[[{"$minElement"=>1}, {"$maxElement"=>1}]],
"owner_id"=>[[{"$minElement"=>1}, {"$maxElement"=>1}]],
"_id"=>[[{"$maxElement"=>1}, {"$minElement"=>1}]]}},
{"cursor"=>"BtreeCursor mobile_1_status_1_featured_1__id_-1",
"indexBounds"=>
{"mobile"=>[[true, true]],
"status"=>[[{"$minElement"=>1}, {"$maxElement"=>1}]],
"featured"=>[[{"$minElement"=>1}, {"$maxElement"=>1}]],
"_id"=>[[{"$maxElement"=>1}, {"$minElement"=>1}]]}},
{"cursor"=>"BasicCursor", "indexBounds"=>{}}],
"oldPlan"=>
{"cursor"=>"BtreeCursor _id_ reverse",
"indexBounds"=>{"_id"=>[[{"$maxElement"=>1}, {"$minElement"=>1}]]}}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment