Advertisement
Guest User

Untitled

a guest
Dec 30th, 2013
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.17 KB | None | 0 0
  1. > db.leaf.v2.page.find({ 'A':'52bb11f8fd029a6b138b4588', 'B':'article', 'C': { $gt : 200 } }).sort({ D: -1 }).limit(10).explain(true);
  2. {
  3. "cursor" : "BtreeCursor A_1_B_1_D_-1_C_-1",
  4. "isMultiKey" : true,
  5. "n" : 10,
  6. "nscannedObjects" : 10,
  7. "nscanned" : 10,
  8. "nscannedObjectsAllPlans" : 49,
  9. "nscannedAllPlans" : 49,
  10. "scanAndOrder" : false,
  11. "indexOnly" : false,
  12. "nYields" : 0,
  13. "nChunkSkips" : 0,
  14. "millis" : 135,
  15. "indexBounds" : {
  16. "A" : [
  17. [
  18. "52bb11f8fd029a6b138b4588",
  19. "52bb11f8fd029a6b138b4588"
  20. ]
  21. ],
  22. "B" : [
  23. [
  24. "article",
  25. "article"
  26. ]
  27. ],
  28. "D" : [
  29. [
  30. {
  31. "$maxElement" : 1
  32. },
  33. {
  34. "$minElement" : 1
  35. }
  36. ]
  37. ],
  38. "C" : [
  39. [
  40. 1.7976931348623157e+308,
  41. 200
  42. ]
  43. ]
  44. },
  45. "allPlans" : [
  46. {
  47. "cursor" : "BtreeCursor D_-1",
  48. "n" : 0,
  49. "nscannedObjects" : 10,
  50. "nscanned" : 10,
  51. "indexBounds" : {
  52. "D" : [
  53. [
  54. {
  55. "$maxElement" : 1
  56. },
  57. {
  58. "$minElement" : 1
  59. }
  60. ]
  61. ]
  62. }
  63. },
  64. {
  65. "cursor" : "BtreeCursor A_1",
  66. "n" : 7,
  67. "nscannedObjects" : 10,
  68. "nscanned" : 10,
  69. "indexBounds" : {
  70. "A" : [
  71. [
  72. "52bb11f8fd029a6b138b4588",
  73. "52bb11f8fd029a6b138b4588"
  74. ]
  75. ]
  76. }
  77. },
  78. {
  79. "cursor" : "BtreeCursor C_-1",
  80. "n" : 4,
  81. "nscannedObjects" : 10,
  82. "nscanned" : 10,
  83. "indexBounds" : {
  84. "C" : [
  85. [
  86. 1.7976931348623157e+308,
  87. 200
  88. ]
  89. ]
  90. }
  91. },
  92. {
  93. "cursor" : "BtreeCursor A_1_B_1_D_-1_C_-1",
  94. "n" : 10,
  95. "nscannedObjects" : 10,
  96. "nscanned" : 10,
  97. "indexBounds" : {
  98. "A" : [
  99. [
  100. "52bb11f8fd029a6b138b4588",
  101. "52bb11f8fd029a6b138b4588"
  102. ]
  103. ],
  104. "B" : [
  105. [
  106. "article",
  107. "article"
  108. ]
  109. ],
  110. "D" : [
  111. [
  112. {
  113. "$maxElement" : 1
  114. },
  115. {
  116. "$minElement" : 1
  117. }
  118. ]
  119. ],
  120. "C" : [
  121. [
  122. 1.7976931348623157e+308,
  123. 200
  124. ]
  125. ]
  126. }
  127. },
  128. {
  129. "cursor" : "BasicCursor",
  130. "n" : 4,
  131. "nscannedObjects" : 9,
  132. "nscanned" : 9,
  133. "indexBounds" : {
  134.  
  135. }
  136. }
  137. ],
  138. "server" : "leaf:27017"
  139. }
  140. >
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement