Guest User

Untitled

a guest
Feb 23rd, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.71 KB | None | 0 0
  1. db.listings.count({
  2. dated: {
  3. $in: [ISODate("2018-02-17T00:00:00Z"), ISODate("2018-02-16T00:00:00Z"),ISODate("2018-02-10T00:00:00Z")]
  4. },
  5. causelist_type: {$ne: -1}
  6. })
  7.  
  8. {
  9. "plannerVersion" : 1,
  10. "namespace" : "provakil.listings",
  11. "indexFilterSet" : false,
  12. "parsedQuery" : {
  13. "$and" : [
  14. {
  15. "dated" : {
  16. "$in" : [
  17. ISODate("2018-02-10T00:00:00Z"),
  18. ISODate("2018-02-16T00:00:00Z"),
  19. ISODate("2018-02-17T00:00:00Z")
  20. ]
  21. }
  22. },
  23. {
  24. "$nor" : [{
  25. "causelist_type" : {
  26. "$eq" : -1
  27. }
  28. }]
  29. }
  30. ]
  31. },
  32. "winningPlan" : {
  33. "stage" : "FETCH",
  34. "filter" : {
  35. "$nor" : [{
  36. "causelist_type" : {
  37. "$eq" : -1
  38. }
  39. }]
  40. },
  41. "inputStage" : {
  42. "stage" : "IXSCAN",
  43. "keyPattern" : {
  44. "dated" : 1
  45. },
  46. "indexName" : "dated_1",
  47. "isMultiKey" : false,
  48. "isUnique" : false,
  49. "isSparse" : false,
  50. "isPartial" : false,
  51. "indexVersion" : 1,
  52. "direction" : "forward",
  53. "indexBounds" : {
  54. "dated" : [
  55. "[new Date(1518220800000), new Date(1518220800000)]",
  56. "[new Date(1518739200000), new Date(1518739200000)]",
  57. "[new Date(1518825600000), new Date(1518825600000)]"
  58. ]
  59. }
  60. }
  61. },
  62. "rejectedPlans" : [{
  63. "stage" : "FETCH",
  64. "filter" : {
  65. "dated" : {
  66. "$in" : [
  67. ISODate("2018-02-10T00:00:00Z"),
  68. ISODate("2018-02-16T00:00:00Z"),
  69. ISODate("2018-02-17T00:00:00Z")
  70. ]
  71. }
  72. },
  73. "inputStage" : {
  74. "stage" : "IXSCAN",
  75. "keyPattern" : {
  76. "causelist_type" : 1
  77. },
  78. "indexName" : "causelist_type_1",
  79. "isMultiKey" : false,
  80. "isUnique" : false,
  81. "isSparse" : false,
  82. "isPartial" : false,
  83. "indexVersion" : 1,
  84. "direction" : "forward",
  85. "indexBounds" : {
  86. "causelist_type" : [
  87. "[MinKey, -1.0)",
  88. "(-1.0, MaxKey]"
  89. ]
  90. }
  91. }
  92. }]
  93. }
  94.  
  95. {
  96. "plannerVersion" : 1,
  97. "namespace" : "provakil.listings",
  98. "indexFilterSet" : false,
  99. "parsedQuery" : {
  100. "dated" : {
  101. "$in" : [
  102. ISODate("2018-02-10T00:00:00Z"),
  103. ISODate("2018-02-16T00:00:00Z"),
  104. ISODate("2018-02-17T00:00:00Z")
  105. ]
  106. }
  107. },
  108. "winningPlan" : {
  109. "stage" : "COUNT",
  110. "inputStage" : {
  111. "stage" : "IXSCAN",
  112. "keyPattern" : {
  113. "dated" : 1
  114. },
  115. "indexName" : "dated_1",
  116. "isMultiKey" : false,
  117. "isUnique" : false,
  118. "isSparse" : false,
  119. "isPartial" : false,
  120. "indexVersion" : 1,
  121. "direction" : "forward",
  122. "indexBounds" : {
  123. "dated" : [
  124. "[new Date(1518220800000), new Date(1518220800000)]",
  125. "[new Date(1518739200000), new Date(1518739200000)]",
  126. "[new Date(1518825600000), new Date(1518825600000)]"
  127. ]
  128. }
  129. }
  130. },
  131. "rejectedPlans" : [ ]
  132. }
Add Comment
Please, Sign In to add comment