Guest User

Untitled

a guest
Jul 15th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. > db.foo.ensureIndex({a:1})
  2. > db.foo.ensureIndex({b:1})
  3. > db.foo.insert({a:1})
  4. > db.foo.insert({b:1})
  5. > db.foo.insert({a:1, b:1})
  6. > db.foo.find({$or:[{a:1}, {b:1}]}).explain()
  7. {
  8. "clauses" : [
  9. {
  10. "cursor" : "BtreeCursor a_1",
  11. "nscanned" : 2,
  12. "nscannedObjects" : 2,
  13. "n" : 2,
  14. "millis" : 0,
  15. "nYields" : 0,
  16. "nChunkSkips" : 0,
  17. "isMultiKey" : false,
  18. "indexOnly" : false,
  19. "indexBounds" : {
  20. "a" : [
  21. [
  22. 1,
  23. 1
  24. ]
  25. ]
  26. },
  27. "allPlans" : [
  28. {
  29. "cursor" : "BtreeCursor a_1",
  30. "indexBounds" : {
  31. "a" : [
  32. [
  33. 1,
  34. 1
  35. ]
  36. ]
  37. }
  38. }
  39. ]
  40. },
  41. {
  42. "cursor" : "BtreeCursor b_1",
  43. "nscanned" : 2,
  44. "nscannedObjects" : 2,
  45. "n" : 1,
  46. "millis" : 0,
  47. "nYields" : 0,
  48. "nChunkSkips" : 0,
  49. "isMultiKey" : false,
  50. "indexOnly" : false,
  51. "indexBounds" : {
  52. "b" : [
  53. [
  54. 1,
  55. 1
  56. ]
  57. ]
  58. },
  59. "allPlans" : [
  60. {
  61. "cursor" : "BtreeCursor b_1",
  62. "indexBounds" : {
  63. "b" : [
  64. [
  65. 1,
  66. 1
  67. ]
  68. ]
  69. }
  70. }
  71. ]
  72. }
  73. ],
  74. "nscanned" : 4,
  75. "nscannedObjects" : 4,
  76. "n" : 3,
  77. "millis" : 0
  78. }
Add Comment
Please, Sign In to add comment