Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 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. "serverInfo" : {
  53. "host" : "laptop",
  54. "port" : 27017,
  55. "version" : "3.4.1",
  56. "gitVersion" : "5e103c4f5583e2566a45d740225dc250baacfbd7"
  57. },
  58. "ok" : 1
  59. }
  60. >
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement