Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.90 KB | None | 0 0
  1. > db.users.find({"lastName": "S", "firstName": "w"}).explain()
  2. {
  3. "queryPlanner" : {
  4. "plannerVersion" : 1,
  5. "namespace" : "fetchData.users",
  6. "indexFilterSet" : false,
  7. "parsedQuery" : {
  8. "$and" : [
  9. {
  10. "firstName" : {
  11. "$eq" : "w"
  12. }
  13. },
  14. {
  15. "lastName" : {
  16. "$eq" : "S"
  17. }
  18. }
  19. ]
  20. },
  21. "winningPlan" : {
  22. "stage" : "FETCH",
  23. "filter" : {
  24. "firstName" : {
  25. "$eq" : "w"
  26. }
  27. },
  28. "inputStage" : {
  29. "stage" : "IXSCAN",
  30. "keyPattern" : {
  31. "lastName" : 1
  32. },
  33. "indexName" : "lastName_1",
  34. "isMultiKey" : false,
  35. "multiKeyPaths" : {
  36. "lastName" : [ ]
  37. },
  38. "isUnique" : false,
  39. "isSparse" : false,
  40. "isPartial" : false,
  41. "indexVersion" : 2,
  42. "direction" : "forward",
  43. "indexBounds" : {
  44. "lastName" : [
  45. "[\"S\", \"S\"]"
  46. ]
  47. }
  48. }
  49. },
  50. "rejectedPlans" : [
  51. {
  52. "stage" : "FETCH",
  53. "filter" : {
  54. "lastName" : {
  55. "$eq" : "S"
  56. }
  57. },
  58. "inputStage" : {
  59. "stage" : "IXSCAN",
  60. "keyPattern" : {
  61. "firstName" : 1
  62. },
  63. "indexName" : "firstName_1",
  64. "isMultiKey" : false,
  65. "multiKeyPaths" : {
  66. "firstName" : [ ]
  67. },
  68. "isUnique" : false,
  69. "isSparse" : false,
  70. "isPartial" : false,
  71. "indexVersion" : 2,
  72. "direction" : "forward",
  73. "indexBounds" : {
  74. "firstName" : [
  75. "[\"w\", \"w\"]"
  76. ]
  77. }
  78. }
  79. },
  80. {
  81. "stage" : "FETCH",
  82. "filter" : {
  83. "$and" : [
  84. {
  85. "lastName" : {
  86. "$eq" : "S"
  87. }
  88. },
  89. {
  90. "firstName" : {
  91. "$eq" : "w"
  92. }
  93. }
  94. ]
  95. },
  96. "inputStage" : {
  97. "stage" : "AND_SORTED",
  98. "inputStages" : [
  99. {
  100. "stage" : "IXSCAN",
  101. "keyPattern" : {
  102. "lastName" : 1
  103. },
  104. "indexName" : "lastName_1",
  105. "isMultiKey" : false,
  106. "multiKeyPaths" : {
  107. "lastName" : [ ]
  108. },
  109. "isUnique" : false,
  110. "isSparse" : false,
  111. "isPartial" : false,
  112. "indexVersion" : 2,
  113. "direction" : "forward",
  114. "indexBounds" : {
  115. "lastName" : [
  116. "[\"S\", \"S\"]"
  117. ]
  118. }
  119. },
  120. {
  121. "stage" : "IXSCAN",
  122. "keyPattern" : {
  123. "firstName" : 1
  124. },
  125. "indexName" : "firstName_1",
  126. "isMultiKey" : false,
  127. "multiKeyPaths" : {
  128. "firstName" : [ ]
  129. },
  130. "isUnique" : false,
  131. "isSparse" : false,
  132. "isPartial" : false,
  133. "indexVersion" : 2,
  134. "direction" : "forward",
  135. "indexBounds" : {
  136. "firstName" : [
  137. "[\"w\", \"w\"]"
  138. ]
  139. }
  140. }
  141. ]
  142. }
  143. }
  144. ]
  145. },
  146. "serverInfo" : {
  147. "host" : "laptop",
  148. "port" : 27017,
  149. "version" : "3.4.1",
  150. "gitVersion" : "5e103c4f5583e2566a45d740225dc250baacfbd7"
  151. },
  152. "ok" : 1
  153. }
  154. >
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement