Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- > db.leaf.v2.page.find({ 'A':'52bb11f8fd029a6b138b4588', 'B':'article', 'C': { $gt : 200 } }).sort({ D: -1 }).limit(10).explain(true);
- {
- "cursor" : "BtreeCursor C_-1",
- "isMultiKey" : false,
- "n" : 0,
- "nscannedObjects" : 235,
- "nscanned" : 235,
- "nscannedObjectsAllPlans" : 954,
- "nscannedAllPlans" : 1194,
- "scanAndOrder" : true,
- "indexOnly" : false,
- "nYields" : 0,
- "nChunkSkips" : 0,
- "millis" : 3,
- "indexBounds" : {
- "C" : [
- [
- 1.7976931348623157e+308,
- 200
- ]
- ]
- },
- "allPlans" : [
- {
- "cursor" : "BtreeCursor D_-1",
- "n" : 0,
- "nscannedObjects" : 236,
- "nscanned" : 236,
- "indexBounds" : {
- "D" : [
- [
- {
- "$maxElement" : 1
- },
- {
- "$minElement" : 1
- }
- ]
- ]
- }
- },
- {
- "cursor" : "BtreeCursor A_1",
- "n" : 0,
- "nscannedObjects" : 236,
- "nscanned" : 236,
- "indexBounds" : {
- "A" : [
- [
- "52bb11f8fd029a6b138b4588",
- "52bb11f8fd029a6b138b4588"
- ]
- ]
- }
- },
- {
- "cursor" : "BtreeCursor C_-1",
- "n" : 0,
- "nscannedObjects" : 235,
- "nscanned" : 235,
- "indexBounds" : {
- "C" : [
- [
- 1.7976931348623157e+308,
- 200
- ]
- ]
- }
- },
- {
- "cursor" : "BtreeCursor A_1_B_1_D_-1_C_-1",
- "n" : 0,
- "nscannedObjects" : 12,
- "nscanned" : 252,
- "indexBounds" : {
- "A" : [
- [
- "52bb11f8fd029a6b138b4588",
- "52bb11f8fd029a6b138b4588"
- ]
- ],
- "B" : [
- [
- "article",
- "article"
- ]
- ],
- "D" : [
- [
- {
- "$maxElement" : 1
- },
- {
- "$minElement" : 1
- }
- ]
- ],
- "C" : [
- [
- 1.7976931348623157e+308,
- 200
- ]
- ]
- }
- },
- {
- "cursor" : "BasicCursor",
- "n" : 0,
- "nscannedObjects" : 235,
- "nscanned" : 235,
- "indexBounds" : {
- }
- }
- ],
- "oldPlan" : {
- "cursor" : "BtreeCursor C_-1",
- "indexBounds" : {
- "C" : [
- [
- 1.7976931348623157e+308,
- 200
- ]
- ]
- }
- },
- "server" : "leaf:27017"
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement