Advertisement
Guest User

Untitled

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