API tools faq
paste
Advertisement
arzillesh

flioz explain

arzillesh
Feb 8th, 2016
101
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 49.33 KB | None | 0 0
raw download clone embed print report
  1. {"queryPlanner"=>
  2. {"plannerVersion"=>1,
  3. "namespace"=>"mongoid_flioz_backend_development.daily_data",
  4. "indexFilterSet"=>false,
  5. "parsedQuery"=>
  6. {"stock_id"=>{"$eq"=>BSON::ObjectId('56541658551adb1dfc0053ee')}},
  7. "winningPlan"=>
  8. {"stage"=>"FETCH",
  9. "inputStage"=>
  10. {"stage"=>"IXSCAN",
  11. "keyPattern"=>{"stock_id"=>1},
  12. "indexName"=>"stock_id_1",
  13. "isMultiKey"=>false,
  14. "direction"=>"forward",
  15. "indexBounds"=>
  16. {"stock_id"=>
  17. ["[ObjectId('56541658551adb1dfc0053ee'), ObjectId('56541658551adb1dfc0053ee')]"]}}},
  18. "rejectedPlans"=>
  19. [{"stage"=>"FETCH",
  20. "inputStage"=>
  21. {"stage"=>"IXSCAN",
  22. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  23. "indexName"=>"stock_id_1_datetime_1",
  24. "isMultiKey"=>false,
  25. "direction"=>"forward",
  26. "indexBounds"=>
  27. {"stock_id"=>
  28. ["[ObjectId('56541658551adb1dfc0053ee'), ObjectId('56541658551adb1dfc0053ee')]"],
  29. "datetime"=>["[MinKey, MaxKey]"]}}}]},
  30. "executionStats"=>
  31. {"executionSuccess"=>true,
  32. "nReturned"=>2,
  33. "executionTimeMillis"=>0,
  34. "totalKeysExamined"=>2,
  35. "totalDocsExamined"=>2,
  36. "executionStages"=>
  37. {"stage"=>"FETCH",
  38. "nReturned"=>2,
  39. "executionTimeMillisEstimate"=>0,
  40. "works"=>4,
  41. "advanced"=>2,
  42. "needTime"=>0,
  43. "needFetch"=>0,
  44. "saveState"=>0,
  45. "restoreState"=>0,
  46. "isEOF"=>1,
  47. "invalidates"=>0,
  48. "docsExamined"=>2,
  49. "alreadyHasObj"=>0,
  50. "inputStage"=>
  51. {"stage"=>"IXSCAN",
  52. "nReturned"=>2,
  53. "executionTimeMillisEstimate"=>0,
  54. "works"=>3,
  55. "advanced"=>2,
  56. "needTime"=>0,
  57. "needFetch"=>0,
  58. "saveState"=>0,
  59. "restoreState"=>0,
  60. "isEOF"=>1,
  61. "invalidates"=>0,
  62. "keyPattern"=>{"stock_id"=>1},
  63. "indexName"=>"stock_id_1",
  64. "isMultiKey"=>false,
  65. "direction"=>"forward",
  66. "indexBounds"=>
  67. {"stock_id"=>
  68. ["[ObjectId('56541658551adb1dfc0053ee'), ObjectId('56541658551adb1dfc0053ee')]"]},
  69. "keysExamined"=>2,
  70. "dupsTested"=>0,
  71. "dupsDropped"=>0,
  72. "seenInvalidated"=>0,
  73. "matchTested"=>0}},
  74. "allPlansExecution"=>
  75. [{"nReturned"=>2,
  76. "executionTimeMillisEstimate"=>0,
  77. "totalKeysExamined"=>2,
  78. "totalDocsExamined"=>2,
  79. "executionStages"=>
  80. {"stage"=>"FETCH",
  81. "nReturned"=>2,
  82. "executionTimeMillisEstimate"=>0,
  83. "works"=>3,
  84. "advanced"=>2,
  85. "needTime"=>0,
  86. "needFetch"=>0,
  87. "saveState"=>0,
  88. "restoreState"=>0,
  89. "isEOF"=>1,
  90. "invalidates"=>0,
  91. "docsExamined"=>2,
  92. "alreadyHasObj"=>0,
  93. "inputStage"=>
  94. {"stage"=>"IXSCAN",
  95. "nReturned"=>2,
  96. "executionTimeMillisEstimate"=>0,
  97. "works"=>3,
  98. "advanced"=>2,
  99. "needTime"=>0,
  100. "needFetch"=>0,
  101. "saveState"=>0,
  102. "restoreState"=>0,
  103. "isEOF"=>1,
  104. "invalidates"=>0,
  105. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  106. "indexName"=>"stock_id_1_datetime_1",
  107. "isMultiKey"=>false,
  108. "direction"=>"forward",
  109. "indexBounds"=>
  110. {"stock_id"=>
  111. ["[ObjectId('56541658551adb1dfc0053ee'), ObjectId('56541658551adb1dfc0053ee')]"],
  112. "datetime"=>["[MinKey, MaxKey]"]},
  113. "keysExamined"=>2,
  114. "dupsTested"=>0,
  115. "dupsDropped"=>0,
  116. "seenInvalidated"=>0,
  117. "matchTested"=>0}}},
  118. {"nReturned"=>2,
  119. "executionTimeMillisEstimate"=>0,
  120. "totalKeysExamined"=>2,
  121. "totalDocsExamined"=>2,
  122. "executionStages"=>
  123. {"stage"=>"FETCH",
  124. "nReturned"=>2,
  125. "executionTimeMillisEstimate"=>0,
  126. "works"=>3,
  127. "advanced"=>2,
  128. "needTime"=>0,
  129. "needFetch"=>0,
  130. "saveState"=>0,
  131. "restoreState"=>0,
  132. "isEOF"=>1,
  133. "invalidates"=>0,
  134. "docsExamined"=>2,
  135. "alreadyHasObj"=>0,
  136. "inputStage"=>
  137. {"stage"=>"IXSCAN",
  138. "nReturned"=>2,
  139. "executionTimeMillisEstimate"=>0,
  140. "works"=>3,
  141. "advanced"=>2,
  142. "needTime"=>0,
  143. "needFetch"=>0,
  144. "saveState"=>0,
  145. "restoreState"=>0,
  146. "isEOF"=>1,
  147. "invalidates"=>0,
  148. "keyPattern"=>{"stock_id"=>1},
  149. "indexName"=>"stock_id_1",
  150. "isMultiKey"=>false,
  151. "direction"=>"forward",
  152. "indexBounds"=>
  153. {"stock_id"=>
  154. ["[ObjectId('56541658551adb1dfc0053ee'), ObjectId('56541658551adb1dfc0053ee')]"]},
  155. "keysExamined"=>2,
  156. "dupsTested"=>0,
  157. "dupsDropped"=>0,
  158. "seenInvalidated"=>0,
  159. "matchTested"=>0}}}]},
  160. "serverInfo"=>
  161. {"host"=>"Jegan.local",
  162. "port"=>27017,
  163. "version"=>"3.0.7",
  164. "gitVersion"=>"nogitversion"}}
  165. {"queryPlanner"=>
  166. {"plannerVersion"=>1,
  167. "namespace"=>"mongoid_flioz_backend_development.daily_data",
  168. "indexFilterSet"=>false,
  169. "parsedQuery"=>
  170. {"stock_id"=>{"$eq"=>BSON::ObjectId('5654142b551adb1dfc000760')}},
  171. "winningPlan"=>
  172. {"stage"=>"FETCH",
  173. "inputStage"=>
  174. {"stage"=>"IXSCAN",
  175. "keyPattern"=>{"stock_id"=>1},
  176. "indexName"=>"stock_id_1",
  177. "isMultiKey"=>false,
  178. "direction"=>"forward",
  179. "indexBounds"=>
  180. {"stock_id"=>
  181. ["[ObjectId('5654142b551adb1dfc000760'), ObjectId('5654142b551adb1dfc000760')]"]}}},
  182. "rejectedPlans"=>
  183. [{"stage"=>"FETCH",
  184. "inputStage"=>
  185. {"stage"=>"IXSCAN",
  186. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  187. "indexName"=>"stock_id_1_datetime_1",
  188. "isMultiKey"=>false,
  189. "direction"=>"forward",
  190. "indexBounds"=>
  191. {"stock_id"=>
  192. ["[ObjectId('5654142b551adb1dfc000760'), ObjectId('5654142b551adb1dfc000760')]"],
  193. "datetime"=>["[MinKey, MaxKey]"]}}}]},
  194. "executionStats"=>
  195. {"executionSuccess"=>true,
  196. "nReturned"=>2,
  197. "executionTimeMillis"=>1,
  198. "totalKeysExamined"=>2,
  199. "totalDocsExamined"=>2,
  200. "executionStages"=>
  201. {"stage"=>"FETCH",
  202. "nReturned"=>2,
  203. "executionTimeMillisEstimate"=>0,
  204. "works"=>4,
  205. "advanced"=>2,
  206. "needTime"=>0,
  207. "needFetch"=>0,
  208. "saveState"=>0,
  209. "restoreState"=>0,
  210. "isEOF"=>1,
  211. "invalidates"=>0,
  212. "docsExamined"=>2,
  213. "alreadyHasObj"=>0,
  214. "inputStage"=>
  215. {"stage"=>"IXSCAN",
  216. "nReturned"=>2,
  217. "executionTimeMillisEstimate"=>0,
  218. "works"=>3,
  219. "advanced"=>2,
  220. "needTime"=>0,
  221. "needFetch"=>0,
  222. "saveState"=>0,
  223. "restoreState"=>0,
  224. "isEOF"=>1,
  225. "invalidates"=>0,
  226. "keyPattern"=>{"stock_id"=>1},
  227. "indexName"=>"stock_id_1",
  228. "isMultiKey"=>false,
  229. "direction"=>"forward",
  230. "indexBounds"=>
  231. {"stock_id"=>
  232. ["[ObjectId('5654142b551adb1dfc000760'), ObjectId('5654142b551adb1dfc000760')]"]},
  233. "keysExamined"=>2,
  234. "dupsTested"=>0,
  235. "dupsDropped"=>0,
  236. "seenInvalidated"=>0,
  237. "matchTested"=>0}},
  238. "allPlansExecution"=>
  239. [{"nReturned"=>2,
  240. "executionTimeMillisEstimate"=>0,
  241. "totalKeysExamined"=>2,
  242. "totalDocsExamined"=>2,
  243. "executionStages"=>
  244. {"stage"=>"FETCH",
  245. "nReturned"=>2,
  246. "executionTimeMillisEstimate"=>0,
  247. "works"=>3,
  248. "advanced"=>2,
  249. "needTime"=>0,
  250. "needFetch"=>0,
  251. "saveState"=>0,
  252. "restoreState"=>0,
  253. "isEOF"=>1,
  254. "invalidates"=>0,
  255. "docsExamined"=>2,
  256. "alreadyHasObj"=>0,
  257. "inputStage"=>
  258. {"stage"=>"IXSCAN",
  259. "nReturned"=>2,
  260. "executionTimeMillisEstimate"=>0,
  261. "works"=>3,
  262. "advanced"=>2,
  263. "needTime"=>0,
  264. "needFetch"=>0,
  265. "saveState"=>0,
  266. "restoreState"=>0,
  267. "isEOF"=>1,
  268. "invalidates"=>0,
  269. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  270. "indexName"=>"stock_id_1_datetime_1",
  271. "isMultiKey"=>false,
  272. "direction"=>"forward",
  273. "indexBounds"=>
  274. {"stock_id"=>
  275. ["[ObjectId('5654142b551adb1dfc000760'), ObjectId('5654142b551adb1dfc000760')]"],
  276. "datetime"=>["[MinKey, MaxKey]"]},
  277. "keysExamined"=>2,
  278. "dupsTested"=>0,
  279. "dupsDropped"=>0,
  280. "seenInvalidated"=>0,
  281. "matchTested"=>0}}},
  282. {"nReturned"=>2,
  283. "executionTimeMillisEstimate"=>0,
  284. "totalKeysExamined"=>2,
  285. "totalDocsExamined"=>2,
  286. "executionStages"=>
  287. {"stage"=>"FETCH",
  288. "nReturned"=>2,
  289. "executionTimeMillisEstimate"=>0,
  290. "works"=>3,
  291. "advanced"=>2,
  292. "needTime"=>0,
  293. "needFetch"=>0,
  294. "saveState"=>0,
  295. "restoreState"=>0,
  296. "isEOF"=>1,
  297. "invalidates"=>0,
  298. "docsExamined"=>2,
  299. "alreadyHasObj"=>0,
  300. "inputStage"=>
  301. {"stage"=>"IXSCAN",
  302. "nReturned"=>2,
  303. "executionTimeMillisEstimate"=>0,
  304. "works"=>3,
  305. "advanced"=>2,
  306. "needTime"=>0,
  307. "needFetch"=>0,
  308. "saveState"=>0,
  309. "restoreState"=>0,
  310. "isEOF"=>1,
  311. "invalidates"=>0,
  312. "keyPattern"=>{"stock_id"=>1},
  313. "indexName"=>"stock_id_1",
  314. "isMultiKey"=>false,
  315. "direction"=>"forward",
  316. "indexBounds"=>
  317. {"stock_id"=>
  318. ["[ObjectId('5654142b551adb1dfc000760'), ObjectId('5654142b551adb1dfc000760')]"]},
  319. "keysExamined"=>2,
  320. "dupsTested"=>0,
  321. "dupsDropped"=>0,
  322. "seenInvalidated"=>0,
  323. "matchTested"=>0}}}]},
  324. "serverInfo"=>
  325. {"host"=>"Jegan.local",
  326. "port"=>27017,
  327. "version"=>"3.0.7",
  328. "gitVersion"=>"nogitversion"}}
  329. {"queryPlanner"=>
  330. {"plannerVersion"=>1,
  331. "namespace"=>"mongoid_flioz_backend_development.daily_data",
  332. "indexFilterSet"=>false,
  333. "parsedQuery"=>
  334. {"stock_id"=>{"$eq"=>BSON::ObjectId('5654150b551adb1dfc002862')}},
  335. "winningPlan"=>
  336. {"stage"=>"FETCH",
  337. "inputStage"=>
  338. {"stage"=>"IXSCAN",
  339. "keyPattern"=>{"stock_id"=>1},
  340. "indexName"=>"stock_id_1",
  341. "isMultiKey"=>false,
  342. "direction"=>"forward",
  343. "indexBounds"=>
  344. {"stock_id"=>
  345. ["[ObjectId('5654150b551adb1dfc002862'), ObjectId('5654150b551adb1dfc002862')]"]}}},
  346. "rejectedPlans"=>
  347. [{"stage"=>"FETCH",
  348. "inputStage"=>
  349. {"stage"=>"IXSCAN",
  350. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  351. "indexName"=>"stock_id_1_datetime_1",
  352. "isMultiKey"=>false,
  353. "direction"=>"forward",
  354. "indexBounds"=>
  355. {"stock_id"=>
  356. ["[ObjectId('5654150b551adb1dfc002862'), ObjectId('5654150b551adb1dfc002862')]"],
  357. "datetime"=>["[MinKey, MaxKey]"]}}}]},
  358. "executionStats"=>
  359. {"executionSuccess"=>true,
  360. "nReturned"=>0,
  361. "executionTimeMillis"=>0,
  362. "totalKeysExamined"=>0,
  363. "totalDocsExamined"=>0,
  364. "executionStages"=>
  365. {"stage"=>"FETCH",
  366. "nReturned"=>0,
  367. "executionTimeMillisEstimate"=>0,
  368. "works"=>2,
  369. "advanced"=>0,
  370. "needTime"=>0,
  371. "needFetch"=>0,
  372. "saveState"=>0,
  373. "restoreState"=>0,
  374. "isEOF"=>1,
  375. "invalidates"=>0,
  376. "docsExamined"=>0,
  377. "alreadyHasObj"=>0,
  378. "inputStage"=>
  379. {"stage"=>"IXSCAN",
  380. "nReturned"=>0,
  381. "executionTimeMillisEstimate"=>0,
  382. "works"=>1,
  383. "advanced"=>0,
  384. "needTime"=>0,
  385. "needFetch"=>0,
  386. "saveState"=>0,
  387. "restoreState"=>0,
  388. "isEOF"=>1,
  389. "invalidates"=>0,
  390. "keyPattern"=>{"stock_id"=>1},
  391. "indexName"=>"stock_id_1",
  392. "isMultiKey"=>false,
  393. "direction"=>"forward",
  394. "indexBounds"=>
  395. {"stock_id"=>
  396. ["[ObjectId('5654150b551adb1dfc002862'), ObjectId('5654150b551adb1dfc002862')]"]},
  397. "keysExamined"=>0,
  398. "dupsTested"=>0,
  399. "dupsDropped"=>0,
  400. "seenInvalidated"=>0,
  401. "matchTested"=>0}},
  402. "allPlansExecution"=>
  403. [{"nReturned"=>0,
  404. "executionTimeMillisEstimate"=>0,
  405. "totalKeysExamined"=>0,
  406. "totalDocsExamined"=>0,
  407. "executionStages"=>
  408. {"stage"=>"FETCH",
  409. "nReturned"=>0,
  410. "executionTimeMillisEstimate"=>0,
  411. "works"=>1,
  412. "advanced"=>0,
  413. "needTime"=>0,
  414. "needFetch"=>0,
  415. "saveState"=>0,
  416. "restoreState"=>0,
  417. "isEOF"=>1,
  418. "invalidates"=>0,
  419. "docsExamined"=>0,
  420. "alreadyHasObj"=>0,
  421. "inputStage"=>
  422. {"stage"=>"IXSCAN",
  423. "nReturned"=>0,
  424. "executionTimeMillisEstimate"=>0,
  425. "works"=>1,
  426. "advanced"=>0,
  427. "needTime"=>0,
  428. "needFetch"=>0,
  429. "saveState"=>0,
  430. "restoreState"=>0,
  431. "isEOF"=>1,
  432. "invalidates"=>0,
  433. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  434. "indexName"=>"stock_id_1_datetime_1",
  435. "isMultiKey"=>false,
  436. "direction"=>"forward",
  437. "indexBounds"=>
  438. {"stock_id"=>
  439. ["[ObjectId('5654150b551adb1dfc002862'), ObjectId('5654150b551adb1dfc002862')]"],
  440. "datetime"=>["[MinKey, MaxKey]"]},
  441. "keysExamined"=>0,
  442. "dupsTested"=>0,
  443. "dupsDropped"=>0,
  444. "seenInvalidated"=>0,
  445. "matchTested"=>0}}},
  446. {"nReturned"=>0,
  447. "executionTimeMillisEstimate"=>0,
  448. "totalKeysExamined"=>0,
  449. "totalDocsExamined"=>0,
  450. "executionStages"=>
  451. {"stage"=>"FETCH",
  452. "nReturned"=>0,
  453. "executionTimeMillisEstimate"=>0,
  454. "works"=>1,
  455. "advanced"=>0,
  456. "needTime"=>0,
  457. "needFetch"=>0,
  458. "saveState"=>0,
  459. "restoreState"=>0,
  460. "isEOF"=>1,
  461. "invalidates"=>0,
  462. "docsExamined"=>0,
  463. "alreadyHasObj"=>0,
  464. "inputStage"=>
  465. {"stage"=>"IXSCAN",
  466. "nReturned"=>0,
  467. "executionTimeMillisEstimate"=>0,
  468. "works"=>1,
  469. "advanced"=>0,
  470. "needTime"=>0,
  471. "needFetch"=>0,
  472. "saveState"=>0,
  473. "restoreState"=>0,
  474. "isEOF"=>1,
  475. "invalidates"=>0,
  476. "keyPattern"=>{"stock_id"=>1},
  477. "indexName"=>"stock_id_1",
  478. "isMultiKey"=>false,
  479. "direction"=>"forward",
  480. "indexBounds"=>
  481. {"stock_id"=>
  482. ["[ObjectId('5654150b551adb1dfc002862'), ObjectId('5654150b551adb1dfc002862')]"]},
  483. "keysExamined"=>0,
  484. "dupsTested"=>0,
  485. "dupsDropped"=>0,
  486. "seenInvalidated"=>0,
  487. "matchTested"=>0}}}]},
  488. "serverInfo"=>
  489. {"host"=>"Jegan.local",
  490. "port"=>27017,
  491. "version"=>"3.0.7",
  492. "gitVersion"=>"nogitversion"}}
  493. {"queryPlanner"=>
  494. {"plannerVersion"=>1,
  495. "namespace"=>"mongoid_flioz_backend_development.daily_data",
  496. "indexFilterSet"=>false,
  497. "parsedQuery"=>
  498. {"stock_id"=>{"$eq"=>BSON::ObjectId('56541696551adb1dfc005cda')}},
  499. "winningPlan"=>
  500. {"stage"=>"FETCH",
  501. "inputStage"=>
  502. {"stage"=>"IXSCAN",
  503. "keyPattern"=>{"stock_id"=>1},
  504. "indexName"=>"stock_id_1",
  505. "isMultiKey"=>false,
  506. "direction"=>"forward",
  507. "indexBounds"=>
  508. {"stock_id"=>
  509. ["[ObjectId('56541696551adb1dfc005cda'), ObjectId('56541696551adb1dfc005cda')]"]}}},
  510. "rejectedPlans"=>
  511. [{"stage"=>"FETCH",
  512. "inputStage"=>
  513. {"stage"=>"IXSCAN",
  514. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  515. "indexName"=>"stock_id_1_datetime_1",
  516. "isMultiKey"=>false,
  517. "direction"=>"forward",
  518. "indexBounds"=>
  519. {"stock_id"=>
  520. ["[ObjectId('56541696551adb1dfc005cda'), ObjectId('56541696551adb1dfc005cda')]"],
  521. "datetime"=>["[MinKey, MaxKey]"]}}}]},
  522. "executionStats"=>
  523. {"executionSuccess"=>true,
  524. "nReturned"=>2,
  525. "executionTimeMillis"=>0,
  526. "totalKeysExamined"=>2,
  527. "totalDocsExamined"=>2,
  528. "executionStages"=>
  529. {"stage"=>"FETCH",
  530. "nReturned"=>2,
  531. "executionTimeMillisEstimate"=>0,
  532. "works"=>4,
  533. "advanced"=>2,
  534. "needTime"=>0,
  535. "needFetch"=>0,
  536. "saveState"=>0,
  537. "restoreState"=>0,
  538. "isEOF"=>1,
  539. "invalidates"=>0,
  540. "docsExamined"=>2,
  541. "alreadyHasObj"=>0,
  542. "inputStage"=>
  543. {"stage"=>"IXSCAN",
  544. "nReturned"=>2,
  545. "executionTimeMillisEstimate"=>0,
  546. "works"=>3,
  547. "advanced"=>2,
  548. "needTime"=>0,
  549. "needFetch"=>0,
  550. "saveState"=>0,
  551. "restoreState"=>0,
  552. "isEOF"=>1,
  553. "invalidates"=>0,
  554. "keyPattern"=>{"stock_id"=>1},
  555. "indexName"=>"stock_id_1",
  556. "isMultiKey"=>false,
  557. "direction"=>"forward",
  558. "indexBounds"=>
  559. {"stock_id"=>
  560. ["[ObjectId('56541696551adb1dfc005cda'), ObjectId('56541696551adb1dfc005cda')]"]},
  561. "keysExamined"=>2,
  562. "dupsTested"=>0,
  563. "dupsDropped"=>0,
  564. "seenInvalidated"=>0,
  565. "matchTested"=>0}},
  566. "allPlansExecution"=>
  567. [{"nReturned"=>2,
  568. "executionTimeMillisEstimate"=>0,
  569. "totalKeysExamined"=>2,
  570. "totalDocsExamined"=>2,
  571. "executionStages"=>
  572. {"stage"=>"FETCH",
  573. "nReturned"=>2,
  574. "executionTimeMillisEstimate"=>0,
  575. "works"=>3,
  576. "advanced"=>2,
  577. "needTime"=>0,
  578. "needFetch"=>0,
  579. "saveState"=>0,
  580. "restoreState"=>0,
  581. "isEOF"=>1,
  582. "invalidates"=>0,
  583. "docsExamined"=>2,
  584. "alreadyHasObj"=>0,
  585. "inputStage"=>
  586. {"stage"=>"IXSCAN",
  587. "nReturned"=>2,
  588. "executionTimeMillisEstimate"=>0,
  589. "works"=>3,
  590. "advanced"=>2,
  591. "needTime"=>0,
  592. "needFetch"=>0,
  593. "saveState"=>0,
  594. "restoreState"=>0,
  595. "isEOF"=>1,
  596. "invalidates"=>0,
  597. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  598. "indexName"=>"stock_id_1_datetime_1",
  599. "isMultiKey"=>false,
  600. "direction"=>"forward",
  601. "indexBounds"=>
  602. {"stock_id"=>
  603. ["[ObjectId('56541696551adb1dfc005cda'), ObjectId('56541696551adb1dfc005cda')]"],
  604. "datetime"=>["[MinKey, MaxKey]"]},
  605. "keysExamined"=>2,
  606. "dupsTested"=>0,
  607. "dupsDropped"=>0,
  608. "seenInvalidated"=>0,
  609. "matchTested"=>0}}},
  610. {"nReturned"=>2,
  611. "executionTimeMillisEstimate"=>0,
  612. "totalKeysExamined"=>2,
  613. "totalDocsExamined"=>2,
  614. "executionStages"=>
  615. {"stage"=>"FETCH",
  616. "nReturned"=>2,
  617. "executionTimeMillisEstimate"=>0,
  618. "works"=>3,
  619. "advanced"=>2,
  620. "needTime"=>0,
  621. "needFetch"=>0,
  622. "saveState"=>0,
  623. "restoreState"=>0,
  624. "isEOF"=>1,
  625. "invalidates"=>0,
  626. "docsExamined"=>2,
  627. "alreadyHasObj"=>0,
  628. "inputStage"=>
  629. {"stage"=>"IXSCAN",
  630. "nReturned"=>2,
  631. "executionTimeMillisEstimate"=>0,
  632. "works"=>3,
  633. "advanced"=>2,
  634. "needTime"=>0,
  635. "needFetch"=>0,
  636. "saveState"=>0,
  637. "restoreState"=>0,
  638. "isEOF"=>1,
  639. "invalidates"=>0,
  640. "keyPattern"=>{"stock_id"=>1},
  641. "indexName"=>"stock_id_1",
  642. "isMultiKey"=>false,
  643. "direction"=>"forward",
  644. "indexBounds"=>
  645. {"stock_id"=>
  646. ["[ObjectId('56541696551adb1dfc005cda'), ObjectId('56541696551adb1dfc005cda')]"]},
  647. "keysExamined"=>2,
  648. "dupsTested"=>0,
  649. "dupsDropped"=>0,
  650. "seenInvalidated"=>0,
  651. "matchTested"=>0}}}]},
  652. "serverInfo"=>
  653. {"host"=>"Jegan.local",
  654. "port"=>27017,
  655. "version"=>"3.0.7",
  656. "gitVersion"=>"nogitversion"}}
  657. {"queryPlanner"=>
  658. {"plannerVersion"=>1,
  659. "namespace"=>"mongoid_flioz_backend_development.daily_data",
  660. "indexFilterSet"=>false,
  661. "parsedQuery"=>
  662. {"stock_id"=>{"$eq"=>BSON::ObjectId('56541696551adb1dfc005cf0')}},
  663. "winningPlan"=>
  664. {"stage"=>"FETCH",
  665. "inputStage"=>
  666. {"stage"=>"IXSCAN",
  667. "keyPattern"=>{"stock_id"=>1},
  668. "indexName"=>"stock_id_1",
  669. "isMultiKey"=>false,
  670. "direction"=>"forward",
  671. "indexBounds"=>
  672. {"stock_id"=>
  673. ["[ObjectId('56541696551adb1dfc005cf0'), ObjectId('56541696551adb1dfc005cf0')]"]}}},
  674. "rejectedPlans"=>
  675. [{"stage"=>"FETCH",
  676. "inputStage"=>
  677. {"stage"=>"IXSCAN",
  678. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  679. "indexName"=>"stock_id_1_datetime_1",
  680. "isMultiKey"=>false,
  681. "direction"=>"forward",
  682. "indexBounds"=>
  683. {"stock_id"=>
  684. ["[ObjectId('56541696551adb1dfc005cf0'), ObjectId('56541696551adb1dfc005cf0')]"],
  685. "datetime"=>["[MinKey, MaxKey]"]}}}]},
  686. "executionStats"=>
  687. {"executionSuccess"=>true,
  688. "nReturned"=>0,
  689. "executionTimeMillis"=>0,
  690. "totalKeysExamined"=>0,
  691. "totalDocsExamined"=>0,
  692. "executionStages"=>
  693. {"stage"=>"FETCH",
  694. "nReturned"=>0,
  695. "executionTimeMillisEstimate"=>0,
  696. "works"=>2,
  697. "advanced"=>0,
  698. "needTime"=>0,
  699. "needFetch"=>0,
  700. "saveState"=>0,
  701. "restoreState"=>0,
  702. "isEOF"=>1,
  703. "invalidates"=>0,
  704. "docsExamined"=>0,
  705. "alreadyHasObj"=>0,
  706. "inputStage"=>
  707. {"stage"=>"IXSCAN",
  708. "nReturned"=>0,
  709. "executionTimeMillisEstimate"=>0,
  710. "works"=>1,
  711. "advanced"=>0,
  712. "needTime"=>0,
  713. "needFetch"=>0,
  714. "saveState"=>0,
  715. "restoreState"=>0,
  716. "isEOF"=>1,
  717. "invalidates"=>0,
  718. "keyPattern"=>{"stock_id"=>1},
  719. "indexName"=>"stock_id_1",
  720. "isMultiKey"=>false,
  721. "direction"=>"forward",
  722. "indexBounds"=>
  723. {"stock_id"=>
  724. ["[ObjectId('56541696551adb1dfc005cf0'), ObjectId('56541696551adb1dfc005cf0')]"]},
  725. "keysExamined"=>0,
  726. "dupsTested"=>0,
  727. "dupsDropped"=>0,
  728. "seenInvalidated"=>0,
  729. "matchTested"=>0}},
  730. "allPlansExecution"=>
  731. [{"nReturned"=>0,
  732. "executionTimeMillisEstimate"=>0,
  733. "totalKeysExamined"=>0,
  734. "totalDocsExamined"=>0,
  735. "executionStages"=>
  736. {"stage"=>"FETCH",
  737. "nReturned"=>0,
  738. "executionTimeMillisEstimate"=>0,
  739. "works"=>1,
  740. "advanced"=>0,
  741. "needTime"=>0,
  742. "needFetch"=>0,
  743. "saveState"=>0,
  744. "restoreState"=>0,
  745. "isEOF"=>1,
  746. "invalidates"=>0,
  747. "docsExamined"=>0,
  748. "alreadyHasObj"=>0,
  749. "inputStage"=>
  750. {"stage"=>"IXSCAN",
  751. "nReturned"=>0,
  752. "executionTimeMillisEstimate"=>0,
  753. "works"=>1,
  754. "advanced"=>0,
  755. "needTime"=>0,
  756. "needFetch"=>0,
  757. "saveState"=>0,
  758. "restoreState"=>0,
  759. "isEOF"=>1,
  760. "invalidates"=>0,
  761. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  762. "indexName"=>"stock_id_1_datetime_1",
  763. "isMultiKey"=>false,
  764. "direction"=>"forward",
  765. "indexBounds"=>
  766. {"stock_id"=>
  767. ["[ObjectId('56541696551adb1dfc005cf0'), ObjectId('56541696551adb1dfc005cf0')]"],
  768. "datetime"=>["[MinKey, MaxKey]"]},
  769. "keysExamined"=>0,
  770. "dupsTested"=>0,
  771. "dupsDropped"=>0,
  772. "seenInvalidated"=>0,
  773. "matchTested"=>0}}},
  774. {"nReturned"=>0,
  775. "executionTimeMillisEstimate"=>0,
  776. "totalKeysExamined"=>0,
  777. "totalDocsExamined"=>0,
  778. "executionStages"=>
  779. {"stage"=>"FETCH",
  780. "nReturned"=>0,
  781. "executionTimeMillisEstimate"=>0,
  782. "works"=>1,
  783. "advanced"=>0,
  784. "needTime"=>0,
  785. "needFetch"=>0,
  786. "saveState"=>0,
  787. "restoreState"=>0,
  788. "isEOF"=>1,
  789. "invalidates"=>0,
  790. "docsExamined"=>0,
  791. "alreadyHasObj"=>0,
  792. "inputStage"=>
  793. {"stage"=>"IXSCAN",
  794. "nReturned"=>0,
  795. "executionTimeMillisEstimate"=>0,
  796. "works"=>1,
  797. "advanced"=>0,
  798. "needTime"=>0,
  799. "needFetch"=>0,
  800. "saveState"=>0,
  801. "restoreState"=>0,
  802. "isEOF"=>1,
  803. "invalidates"=>0,
  804. "keyPattern"=>{"stock_id"=>1},
  805. "indexName"=>"stock_id_1",
  806. "isMultiKey"=>false,
  807. "direction"=>"forward",
  808. "indexBounds"=>
  809. {"stock_id"=>
  810. ["[ObjectId('56541696551adb1dfc005cf0'), ObjectId('56541696551adb1dfc005cf0')]"]},
  811. "keysExamined"=>0,
  812. "dupsTested"=>0,
  813. "dupsDropped"=>0,
  814. "seenInvalidated"=>0,
  815. "matchTested"=>0}}}]},
  816. "serverInfo"=>
  817. {"host"=>"Jegan.local",
  818. "port"=>27017,
  819. "version"=>"3.0.7",
  820. "gitVersion"=>"nogitversion"}}
  821. {"queryPlanner"=>
  822. {"plannerVersion"=>1,
  823. "namespace"=>"mongoid_flioz_backend_development.daily_data",
  824. "indexFilterSet"=>false,
  825. "parsedQuery"=>
  826. {"stock_id"=>{"$eq"=>BSON::ObjectId('56541546551adb1dfc0030b4')}},
  827. "winningPlan"=>
  828. {"stage"=>"FETCH",
  829. "inputStage"=>
  830. {"stage"=>"IXSCAN",
  831. "keyPattern"=>{"stock_id"=>1},
  832. "indexName"=>"stock_id_1",
  833. "isMultiKey"=>false,
  834. "direction"=>"forward",
  835. "indexBounds"=>
  836. {"stock_id"=>
  837. ["[ObjectId('56541546551adb1dfc0030b4'), ObjectId('56541546551adb1dfc0030b4')]"]}}},
  838. "rejectedPlans"=>
  839. [{"stage"=>"FETCH",
  840. "inputStage"=>
  841. {"stage"=>"IXSCAN",
  842. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  843. "indexName"=>"stock_id_1_datetime_1",
  844. "isMultiKey"=>false,
  845. "direction"=>"forward",
  846. "indexBounds"=>
  847. {"stock_id"=>
  848. ["[ObjectId('56541546551adb1dfc0030b4'), ObjectId('56541546551adb1dfc0030b4')]"],
  849. "datetime"=>["[MinKey, MaxKey]"]}}}]},
  850. "executionStats"=>
  851. {"executionSuccess"=>true,
  852. "nReturned"=>0,
  853. "executionTimeMillis"=>0,
  854. "totalKeysExamined"=>0,
  855. "totalDocsExamined"=>0,
  856. "executionStages"=>
  857. {"stage"=>"FETCH",
  858. "nReturned"=>0,
  859. "executionTimeMillisEstimate"=>0,
  860. "works"=>2,
  861. "advanced"=>0,
  862. "needTime"=>0,
  863. "needFetch"=>0,
  864. "saveState"=>0,
  865. "restoreState"=>0,
  866. "isEOF"=>1,
  867. "invalidates"=>0,
  868. "docsExamined"=>0,
  869. "alreadyHasObj"=>0,
  870. "inputStage"=>
  871. {"stage"=>"IXSCAN",
  872. "nReturned"=>0,
  873. "executionTimeMillisEstimate"=>0,
  874. "works"=>1,
  875. "advanced"=>0,
  876. "needTime"=>0,
  877. "needFetch"=>0,
  878. "saveState"=>0,
  879. "restoreState"=>0,
  880. "isEOF"=>1,
  881. "invalidates"=>0,
  882. "keyPattern"=>{"stock_id"=>1},
  883. "indexName"=>"stock_id_1",
  884. "isMultiKey"=>false,
  885. "direction"=>"forward",
  886. "indexBounds"=>
  887. {"stock_id"=>
  888. ["[ObjectId('56541546551adb1dfc0030b4'), ObjectId('56541546551adb1dfc0030b4')]"]},
  889. "keysExamined"=>0,
  890. "dupsTested"=>0,
  891. "dupsDropped"=>0,
  892. "seenInvalidated"=>0,
  893. "matchTested"=>0}},
  894. "allPlansExecution"=>
  895. [{"nReturned"=>0,
  896. "executionTimeMillisEstimate"=>0,
  897. "totalKeysExamined"=>0,
  898. "totalDocsExamined"=>0,
  899. "executionStages"=>
  900. {"stage"=>"FETCH",
  901. "nReturned"=>0,
  902. "executionTimeMillisEstimate"=>0,
  903. "works"=>1,
  904. "advanced"=>0,
  905. "needTime"=>0,
  906. "needFetch"=>0,
  907. "saveState"=>0,
  908. "restoreState"=>0,
  909. "isEOF"=>1,
  910. "invalidates"=>0,
  911. "docsExamined"=>0,
  912. "alreadyHasObj"=>0,
  913. "inputStage"=>
  914. {"stage"=>"IXSCAN",
  915. "nReturned"=>0,
  916. "executionTimeMillisEstimate"=>0,
  917. "works"=>1,
  918. "advanced"=>0,
  919. "needTime"=>0,
  920. "needFetch"=>0,
  921. "saveState"=>0,
  922. "restoreState"=>0,
  923. "isEOF"=>1,
  924. "invalidates"=>0,
  925. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  926. "indexName"=>"stock_id_1_datetime_1",
  927. "isMultiKey"=>false,
  928. "direction"=>"forward",
  929. "indexBounds"=>
  930. {"stock_id"=>
  931. ["[ObjectId('56541546551adb1dfc0030b4'), ObjectId('56541546551adb1dfc0030b4')]"],
  932. "datetime"=>["[MinKey, MaxKey]"]},
  933. "keysExamined"=>0,
  934. "dupsTested"=>0,
  935. "dupsDropped"=>0,
  936. "seenInvalidated"=>0,
  937. "matchTested"=>0}}},
  938. {"nReturned"=>0,
  939. "executionTimeMillisEstimate"=>0,
  940. "totalKeysExamined"=>0,
  941. "totalDocsExamined"=>0,
  942. "executionStages"=>
  943. {"stage"=>"FETCH",
  944. "nReturned"=>0,
  945. "executionTimeMillisEstimate"=>0,
  946. "works"=>1,
  947. "advanced"=>0,
  948. "needTime"=>0,
  949. "needFetch"=>0,
  950. "saveState"=>0,
  951. "restoreState"=>0,
  952. "isEOF"=>1,
  953. "invalidates"=>0,
  954. "docsExamined"=>0,
  955. "alreadyHasObj"=>0,
  956. "inputStage"=>
  957. {"stage"=>"IXSCAN",
  958. "nReturned"=>0,
  959. "executionTimeMillisEstimate"=>0,
  960. "works"=>1,
  961. "advanced"=>0,
  962. "needTime"=>0,
  963. "needFetch"=>0,
  964. "saveState"=>0,
  965. "restoreState"=>0,
  966. "isEOF"=>1,
  967. "invalidates"=>0,
  968. "keyPattern"=>{"stock_id"=>1},
  969. "indexName"=>"stock_id_1",
  970. "isMultiKey"=>false,
  971. "direction"=>"forward",
  972. "indexBounds"=>
  973. {"stock_id"=>
  974. ["[ObjectId('56541546551adb1dfc0030b4'), ObjectId('56541546551adb1dfc0030b4')]"]},
  975. "keysExamined"=>0,
  976. "dupsTested"=>0,
  977. "dupsDropped"=>0,
  978. "seenInvalidated"=>0,
  979. "matchTested"=>0}}}]},
  980. "serverInfo"=>
  981. {"host"=>"Jegan.local",
  982. "port"=>27017,
  983. "version"=>"3.0.7",
  984. "gitVersion"=>"nogitversion"}}
  985. {"queryPlanner"=>
  986. {"plannerVersion"=>1,
  987. "namespace"=>"mongoid_flioz_backend_development.daily_data",
  988. "indexFilterSet"=>false,
  989. "parsedQuery"=>
  990. {"stock_id"=>{"$eq"=>BSON::ObjectId('565416d6551adb1dfc00659d')}},
  991. "winningPlan"=>
  992. {"stage"=>"FETCH",
  993. "inputStage"=>
  994. {"stage"=>"IXSCAN",
  995. "keyPattern"=>{"stock_id"=>1},
  996. "indexName"=>"stock_id_1",
  997. "isMultiKey"=>false,
  998. "direction"=>"forward",
  999. "indexBounds"=>
  1000. {"stock_id"=>
  1001. ["[ObjectId('565416d6551adb1dfc00659d'), ObjectId('565416d6551adb1dfc00659d')]"]}}},
  1002. "rejectedPlans"=>
  1003. [{"stage"=>"FETCH",
  1004. "inputStage"=>
  1005. {"stage"=>"IXSCAN",
  1006. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  1007. "indexName"=>"stock_id_1_datetime_1",
  1008. "isMultiKey"=>false,
  1009. "direction"=>"forward",
  1010. "indexBounds"=>
  1011. {"stock_id"=>
  1012. ["[ObjectId('565416d6551adb1dfc00659d'), ObjectId('565416d6551adb1dfc00659d')]"],
  1013. "datetime"=>["[MinKey, MaxKey]"]}}}]},
  1014. "executionStats"=>
  1015. {"executionSuccess"=>true,
  1016. "nReturned"=>0,
  1017. "executionTimeMillis"=>0,
  1018. "totalKeysExamined"=>0,
  1019. "totalDocsExamined"=>0,
  1020. "executionStages"=>
  1021. {"stage"=>"FETCH",
  1022. "nReturned"=>0,
  1023. "executionTimeMillisEstimate"=>0,
  1024. "works"=>2,
  1025. "advanced"=>0,
  1026. "needTime"=>0,
  1027. "needFetch"=>0,
  1028. "saveState"=>0,
  1029. "restoreState"=>0,
  1030. "isEOF"=>1,
  1031. "invalidates"=>0,
  1032. "docsExamined"=>0,
  1033. "alreadyHasObj"=>0,
  1034. "inputStage"=>
  1035. {"stage"=>"IXSCAN",
  1036. "nReturned"=>0,
  1037. "executionTimeMillisEstimate"=>0,
  1038. "works"=>1,
  1039. "advanced"=>0,
  1040. "needTime"=>0,
  1041. "needFetch"=>0,
  1042. "saveState"=>0,
  1043. "restoreState"=>0,
  1044. "isEOF"=>1,
  1045. "invalidates"=>0,
  1046. "keyPattern"=>{"stock_id"=>1},
  1047. "indexName"=>"stock_id_1",
  1048. "isMultiKey"=>false,
  1049. "direction"=>"forward",
  1050. "indexBounds"=>
  1051. {"stock_id"=>
  1052. ["[ObjectId('565416d6551adb1dfc00659d'), ObjectId('565416d6551adb1dfc00659d')]"]},
  1053. "keysExamined"=>0,
  1054. "dupsTested"=>0,
  1055. "dupsDropped"=>0,
  1056. "seenInvalidated"=>0,
  1057. "matchTested"=>0}},
  1058. "allPlansExecution"=>
  1059. [{"nReturned"=>0,
  1060. "executionTimeMillisEstimate"=>0,
  1061. "totalKeysExamined"=>0,
  1062. "totalDocsExamined"=>0,
  1063. "executionStages"=>
  1064. {"stage"=>"FETCH",
  1065. "nReturned"=>0,
  1066. "executionTimeMillisEstimate"=>0,
  1067. "works"=>1,
  1068. "advanced"=>0,
  1069. "needTime"=>0,
  1070. "needFetch"=>0,
  1071. "saveState"=>0,
  1072. "restoreState"=>0,
  1073. "isEOF"=>1,
  1074. "invalidates"=>0,
  1075. "docsExamined"=>0,
  1076. "alreadyHasObj"=>0,
  1077. "inputStage"=>
  1078. {"stage"=>"IXSCAN",
  1079. "nReturned"=>0,
  1080. "executionTimeMillisEstimate"=>0,
  1081. "works"=>1,
  1082. "advanced"=>0,
  1083. "needTime"=>0,
  1084. "needFetch"=>0,
  1085. "saveState"=>0,
  1086. "restoreState"=>0,
  1087. "isEOF"=>1,
  1088. "invalidates"=>0,
  1089. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  1090. "indexName"=>"stock_id_1_datetime_1",
  1091. "isMultiKey"=>false,
  1092. "direction"=>"forward",
  1093. "indexBounds"=>
  1094. {"stock_id"=>
  1095. ["[ObjectId('565416d6551adb1dfc00659d'), ObjectId('565416d6551adb1dfc00659d')]"],
  1096. "datetime"=>["[MinKey, MaxKey]"]},
  1097. "keysExamined"=>0,
  1098. "dupsTested"=>0,
  1099. "dupsDropped"=>0,
  1100. "seenInvalidated"=>0,
  1101. "matchTested"=>0}}},
  1102. {"nReturned"=>0,
  1103. "executionTimeMillisEstimate"=>0,
  1104. "totalKeysExamined"=>0,
  1105. "totalDocsExamined"=>0,
  1106. "executionStages"=>
  1107. {"stage"=>"FETCH",
  1108. "nReturned"=>0,
  1109. "executionTimeMillisEstimate"=>0,
  1110. "works"=>1,
  1111. "advanced"=>0,
  1112. "needTime"=>0,
  1113. "needFetch"=>0,
  1114. "saveState"=>0,
  1115. "restoreState"=>0,
  1116. "isEOF"=>1,
  1117. "invalidates"=>0,
  1118. "docsExamined"=>0,
  1119. "alreadyHasObj"=>0,
  1120. "inputStage"=>
  1121. {"stage"=>"IXSCAN",
  1122. "nReturned"=>0,
  1123. "executionTimeMillisEstimate"=>0,
  1124. "works"=>1,
  1125. "advanced"=>0,
  1126. "needTime"=>0,
  1127. "needFetch"=>0,
  1128. "saveState"=>0,
  1129. "restoreState"=>0,
  1130. "isEOF"=>1,
  1131. "invalidates"=>0,
  1132. "keyPattern"=>{"stock_id"=>1},
  1133. "indexName"=>"stock_id_1",
  1134. "isMultiKey"=>false,
  1135. "direction"=>"forward",
  1136. "indexBounds"=>
  1137. {"stock_id"=>
  1138. ["[ObjectId('565416d6551adb1dfc00659d'), ObjectId('565416d6551adb1dfc00659d')]"]},
  1139. "keysExamined"=>0,
  1140. "dupsTested"=>0,
  1141. "dupsDropped"=>0,
  1142. "seenInvalidated"=>0,
  1143. "matchTested"=>0}}}]},
  1144. "serverInfo"=>
  1145. {"host"=>"Jegan.local",
  1146. "port"=>27017,
  1147. "version"=>"3.0.7",
  1148. "gitVersion"=>"nogitversion"}}
  1149. {"queryPlanner"=>
  1150. {"plannerVersion"=>1,
  1151. "namespace"=>"mongoid_flioz_backend_development.daily_data",
  1152. "indexFilterSet"=>false,
  1153. "parsedQuery"=>
  1154. {"stock_id"=>{"$eq"=>BSON::ObjectId('565416e2551adb1dfc006781')}},
  1155. "winningPlan"=>
  1156. {"stage"=>"FETCH",
  1157. "inputStage"=>
  1158. {"stage"=>"IXSCAN",
  1159. "keyPattern"=>{"stock_id"=>1},
  1160. "indexName"=>"stock_id_1",
  1161. "isMultiKey"=>false,
  1162. "direction"=>"forward",
  1163. "indexBounds"=>
  1164. {"stock_id"=>
  1165. ["[ObjectId('565416e2551adb1dfc006781'), ObjectId('565416e2551adb1dfc006781')]"]}}},
  1166. "rejectedPlans"=>
  1167. [{"stage"=>"FETCH",
  1168. "inputStage"=>
  1169. {"stage"=>"IXSCAN",
  1170. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  1171. "indexName"=>"stock_id_1_datetime_1",
  1172. "isMultiKey"=>false,
  1173. "direction"=>"forward",
  1174. "indexBounds"=>
  1175. {"stock_id"=>
  1176. ["[ObjectId('565416e2551adb1dfc006781'), ObjectId('565416e2551adb1dfc006781')]"],
  1177. "datetime"=>["[MinKey, MaxKey]"]}}}]},
  1178. "executionStats"=>
  1179. {"executionSuccess"=>true,
  1180. "nReturned"=>0,
  1181. "executionTimeMillis"=>0,
  1182. "totalKeysExamined"=>0,
  1183. "totalDocsExamined"=>0,
  1184. "executionStages"=>
  1185. {"stage"=>"FETCH",
  1186. "nReturned"=>0,
  1187. "executionTimeMillisEstimate"=>0,
  1188. "works"=>2,
  1189. "advanced"=>0,
  1190. "needTime"=>0,
  1191. "needFetch"=>0,
  1192. "saveState"=>0,
  1193. "restoreState"=>0,
  1194. "isEOF"=>1,
  1195. "invalidates"=>0,
  1196. "docsExamined"=>0,
  1197. "alreadyHasObj"=>0,
  1198. "inputStage"=>
  1199. {"stage"=>"IXSCAN",
  1200. "nReturned"=>0,
  1201. "executionTimeMillisEstimate"=>0,
  1202. "works"=>1,
  1203. "advanced"=>0,
  1204. "needTime"=>0,
  1205. "needFetch"=>0,
  1206. "saveState"=>0,
  1207. "restoreState"=>0,
  1208. "isEOF"=>1,
  1209. "invalidates"=>0,
  1210. "keyPattern"=>{"stock_id"=>1},
  1211. "indexName"=>"stock_id_1",
  1212. "isMultiKey"=>false,
  1213. "direction"=>"forward",
  1214. "indexBounds"=>
  1215. {"stock_id"=>
  1216. ["[ObjectId('565416e2551adb1dfc006781'), ObjectId('565416e2551adb1dfc006781')]"]},
  1217. "keysExamined"=>0,
  1218. "dupsTested"=>0,
  1219. "dupsDropped"=>0,
  1220. "seenInvalidated"=>0,
  1221. "matchTested"=>0}},
  1222. "allPlansExecution"=>
  1223. [{"nReturned"=>0,
  1224. "executionTimeMillisEstimate"=>0,
  1225. "totalKeysExamined"=>0,
  1226. "totalDocsExamined"=>0,
  1227. "executionStages"=>
  1228. {"stage"=>"FETCH",
  1229. "nReturned"=>0,
  1230. "executionTimeMillisEstimate"=>0,
  1231. "works"=>1,
  1232. "advanced"=>0,
  1233. "needTime"=>0,
  1234. "needFetch"=>0,
  1235. "saveState"=>0,
  1236. "restoreState"=>0,
  1237. "isEOF"=>1,
  1238. "invalidates"=>0,
  1239. "docsExamined"=>0,
  1240. "alreadyHasObj"=>0,
  1241. "inputStage"=>
  1242. {"stage"=>"IXSCAN",
  1243. "nReturned"=>0,
  1244. "executionTimeMillisEstimate"=>0,
  1245. "works"=>1,
  1246. "advanced"=>0,
  1247. "needTime"=>0,
  1248. "needFetch"=>0,
  1249. "saveState"=>0,
  1250. "restoreState"=>0,
  1251. "isEOF"=>1,
  1252. "invalidates"=>0,
  1253. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  1254. "indexName"=>"stock_id_1_datetime_1",
  1255. "isMultiKey"=>false,
  1256. "direction"=>"forward",
  1257. "indexBounds"=>
  1258. {"stock_id"=>
  1259. ["[ObjectId('565416e2551adb1dfc006781'), ObjectId('565416e2551adb1dfc006781')]"],
  1260. "datetime"=>["[MinKey, MaxKey]"]},
  1261. "keysExamined"=>0,
  1262. "dupsTested"=>0,
  1263. "dupsDropped"=>0,
  1264. "seenInvalidated"=>0,
  1265. "matchTested"=>0}}},
  1266. {"nReturned"=>0,
  1267. "executionTimeMillisEstimate"=>0,
  1268. "totalKeysExamined"=>0,
  1269. "totalDocsExamined"=>0,
  1270. "executionStages"=>
  1271. {"stage"=>"FETCH",
  1272. "nReturned"=>0,
  1273. "executionTimeMillisEstimate"=>0,
  1274. "works"=>1,
  1275. "advanced"=>0,
  1276. "needTime"=>0,
  1277. "needFetch"=>0,
  1278. "saveState"=>0,
  1279. "restoreState"=>0,
  1280. "isEOF"=>1,
  1281. "invalidates"=>0,
  1282. "docsExamined"=>0,
  1283. "alreadyHasObj"=>0,
  1284. "inputStage"=>
  1285. {"stage"=>"IXSCAN",
  1286. "nReturned"=>0,
  1287. "executionTimeMillisEstimate"=>0,
  1288. "works"=>1,
  1289. "advanced"=>0,
  1290. "needTime"=>0,
  1291. "needFetch"=>0,
  1292. "saveState"=>0,
  1293. "restoreState"=>0,
  1294. "isEOF"=>1,
  1295. "invalidates"=>0,
  1296. "keyPattern"=>{"stock_id"=>1},
  1297. "indexName"=>"stock_id_1",
  1298. "isMultiKey"=>false,
  1299. "direction"=>"forward",
  1300. "indexBounds"=>
  1301. {"stock_id"=>
  1302. ["[ObjectId('565416e2551adb1dfc006781'), ObjectId('565416e2551adb1dfc006781')]"]},
  1303. "keysExamined"=>0,
  1304. "dupsTested"=>0,
  1305. "dupsDropped"=>0,
  1306. "seenInvalidated"=>0,
  1307. "matchTested"=>0}}}]},
  1308. "serverInfo"=>
  1309. {"host"=>"Jegan.local",
  1310. "port"=>27017,
  1311. "version"=>"3.0.7",
  1312. "gitVersion"=>"nogitversion"}}
  1313. {"queryPlanner"=>
  1314. {"plannerVersion"=>1,
  1315. "namespace"=>"mongoid_flioz_backend_development.daily_data",
  1316. "indexFilterSet"=>false,
  1317. "parsedQuery"=>
  1318. {"stock_id"=>{"$eq"=>BSON::ObjectId('565414c5551adb1dfc001d20')}},
  1319. "winningPlan"=>
  1320. {"stage"=>"FETCH",
  1321. "inputStage"=>
  1322. {"stage"=>"IXSCAN",
  1323. "keyPattern"=>{"stock_id"=>1},
  1324. "indexName"=>"stock_id_1",
  1325. "isMultiKey"=>false,
  1326. "direction"=>"forward",
  1327. "indexBounds"=>
  1328. {"stock_id"=>
  1329. ["[ObjectId('565414c5551adb1dfc001d20'), ObjectId('565414c5551adb1dfc001d20')]"]}}},
  1330. "rejectedPlans"=>
  1331. [{"stage"=>"FETCH",
  1332. "inputStage"=>
  1333. {"stage"=>"IXSCAN",
  1334. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  1335. "indexName"=>"stock_id_1_datetime_1",
  1336. "isMultiKey"=>false,
  1337. "direction"=>"forward",
  1338. "indexBounds"=>
  1339. {"stock_id"=>
  1340. ["[ObjectId('565414c5551adb1dfc001d20'), ObjectId('565414c5551adb1dfc001d20')]"],
  1341. "datetime"=>["[MinKey, MaxKey]"]}}}]},
  1342. "executionStats"=>
  1343. {"executionSuccess"=>true,
  1344. "nReturned"=>0,
  1345. "executionTimeMillis"=>0,
  1346. "totalKeysExamined"=>0,
  1347. "totalDocsExamined"=>0,
  1348. "executionStages"=>
  1349. {"stage"=>"FETCH",
  1350. "nReturned"=>0,
  1351. "executionTimeMillisEstimate"=>0,
  1352. "works"=>2,
  1353. "advanced"=>0,
  1354. "needTime"=>0,
  1355. "needFetch"=>0,
  1356. "saveState"=>0,
  1357. "restoreState"=>0,
  1358. "isEOF"=>1,
  1359. "invalidates"=>0,
  1360. "docsExamined"=>0,
  1361. "alreadyHasObj"=>0,
  1362. "inputStage"=>
  1363. {"stage"=>"IXSCAN",
  1364. "nReturned"=>0,
  1365. "executionTimeMillisEstimate"=>0,
  1366. "works"=>1,
  1367. "advanced"=>0,
  1368. "needTime"=>0,
  1369. "needFetch"=>0,
  1370. "saveState"=>0,
  1371. "restoreState"=>0,
  1372. "isEOF"=>1,
  1373. "invalidates"=>0,
  1374. "keyPattern"=>{"stock_id"=>1},
  1375. "indexName"=>"stock_id_1",
  1376. "isMultiKey"=>false,
  1377. "direction"=>"forward",
  1378. "indexBounds"=>
  1379. {"stock_id"=>
  1380. ["[ObjectId('565414c5551adb1dfc001d20'), ObjectId('565414c5551adb1dfc001d20')]"]},
  1381. "keysExamined"=>0,
  1382. "dupsTested"=>0,
  1383. "dupsDropped"=>0,
  1384. "seenInvalidated"=>0,
  1385. "matchTested"=>0}},
  1386. "allPlansExecution"=>
  1387. [{"nReturned"=>0,
  1388. "executionTimeMillisEstimate"=>0,
  1389. "totalKeysExamined"=>0,
  1390. "totalDocsExamined"=>0,
  1391. "executionStages"=>
  1392. {"stage"=>"FETCH",
  1393. "nReturned"=>0,
  1394. "executionTimeMillisEstimate"=>0,
  1395. "works"=>1,
  1396. "advanced"=>0,
  1397. "needTime"=>0,
  1398. "needFetch"=>0,
  1399. "saveState"=>0,
  1400. "restoreState"=>0,
  1401. "isEOF"=>1,
  1402. "invalidates"=>0,
  1403. "docsExamined"=>0,
  1404. "alreadyHasObj"=>0,
  1405. "inputStage"=>
  1406. {"stage"=>"IXSCAN",
  1407. "nReturned"=>0,
  1408. "executionTimeMillisEstimate"=>0,
  1409. "works"=>1,
  1410. "advanced"=>0,
  1411. "needTime"=>0,
  1412. "needFetch"=>0,
  1413. "saveState"=>0,
  1414. "restoreState"=>0,
  1415. "isEOF"=>1,
  1416. "invalidates"=>0,
  1417. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  1418. "indexName"=>"stock_id_1_datetime_1",
  1419. "isMultiKey"=>false,
  1420. "direction"=>"forward",
  1421. "indexBounds"=>
  1422. {"stock_id"=>
  1423. ["[ObjectId('565414c5551adb1dfc001d20'), ObjectId('565414c5551adb1dfc001d20')]"],
  1424. "datetime"=>["[MinKey, MaxKey]"]},
  1425. "keysExamined"=>0,
  1426. "dupsTested"=>0,
  1427. "dupsDropped"=>0,
  1428. "seenInvalidated"=>0,
  1429. "matchTested"=>0}}},
  1430. {"nReturned"=>0,
  1431. "executionTimeMillisEstimate"=>0,
  1432. "totalKeysExamined"=>0,
  1433. "totalDocsExamined"=>0,
  1434. "executionStages"=>
  1435. {"stage"=>"FETCH",
  1436. "nReturned"=>0,
  1437. "executionTimeMillisEstimate"=>0,
  1438. "works"=>1,
  1439. "advanced"=>0,
  1440. "needTime"=>0,
  1441. "needFetch"=>0,
  1442. "saveState"=>0,
  1443. "restoreState"=>0,
  1444. "isEOF"=>1,
  1445. "invalidates"=>0,
  1446. "docsExamined"=>0,
  1447. "alreadyHasObj"=>0,
  1448. "inputStage"=>
  1449. {"stage"=>"IXSCAN",
  1450. "nReturned"=>0,
  1451. "executionTimeMillisEstimate"=>0,
  1452. "works"=>1,
  1453. "advanced"=>0,
  1454. "needTime"=>0,
  1455. "needFetch"=>0,
  1456. "saveState"=>0,
  1457. "restoreState"=>0,
  1458. "isEOF"=>1,
  1459. "invalidates"=>0,
  1460. "keyPattern"=>{"stock_id"=>1},
  1461. "indexName"=>"stock_id_1",
  1462. "isMultiKey"=>false,
  1463. "direction"=>"forward",
  1464. "indexBounds"=>
  1465. {"stock_id"=>
  1466. ["[ObjectId('565414c5551adb1dfc001d20'), ObjectId('565414c5551adb1dfc001d20')]"]},
  1467. "keysExamined"=>0,
  1468. "dupsTested"=>0,
  1469. "dupsDropped"=>0,
  1470. "seenInvalidated"=>0,
  1471. "matchTested"=>0}}}]},
  1472. "serverInfo"=>
  1473. {"host"=>"Jegan.local",
  1474. "port"=>27017,
  1475. "version"=>"3.0.7",
  1476. "gitVersion"=>"nogitversion"}}
  1477. {"queryPlanner"=>
  1478. {"plannerVersion"=>1,
  1479. "namespace"=>"mongoid_flioz_backend_development.daily_data",
  1480. "indexFilterSet"=>false,
  1481. "parsedQuery"=>
  1482. {"stock_id"=>{"$eq"=>BSON::ObjectId('56541578551adb1dfc003838')}},
  1483. "winningPlan"=>
  1484. {"stage"=>"FETCH",
  1485. "inputStage"=>
  1486. {"stage"=>"IXSCAN",
  1487. "keyPattern"=>{"stock_id"=>1},
  1488. "indexName"=>"stock_id_1",
  1489. "isMultiKey"=>false,
  1490. "direction"=>"forward",
  1491. "indexBounds"=>
  1492. {"stock_id"=>
  1493. ["[ObjectId('56541578551adb1dfc003838'), ObjectId('56541578551adb1dfc003838')]"]}}},
  1494. "rejectedPlans"=>
  1495. [{"stage"=>"FETCH",
  1496. "inputStage"=>
  1497. {"stage"=>"IXSCAN",
  1498. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  1499. "indexName"=>"stock_id_1_datetime_1",
  1500. "isMultiKey"=>false,
  1501. "direction"=>"forward",
  1502. "indexBounds"=>
  1503. {"stock_id"=>
  1504. ["[ObjectId('56541578551adb1dfc003838'), ObjectId('56541578551adb1dfc003838')]"],
  1505. "datetime"=>["[MinKey, MaxKey]"]}}}]},
  1506. "executionStats"=>
  1507. {"executionSuccess"=>true,
  1508. "nReturned"=>0,
  1509. "executionTimeMillis"=>0,
  1510. "totalKeysExamined"=>0,
  1511. "totalDocsExamined"=>0,
  1512. "executionStages"=>
  1513. {"stage"=>"FETCH",
  1514. "nReturned"=>0,
  1515. "executionTimeMillisEstimate"=>0,
  1516. "works"=>2,
  1517. "advanced"=>0,
  1518. "needTime"=>0,
  1519. "needFetch"=>0,
  1520. "saveState"=>0,
  1521. "restoreState"=>0,
  1522. "isEOF"=>1,
  1523. "invalidates"=>0,
  1524. "docsExamined"=>0,
  1525. "alreadyHasObj"=>0,
  1526. "inputStage"=>
  1527. {"stage"=>"IXSCAN",
  1528. "nReturned"=>0,
  1529. "executionTimeMillisEstimate"=>0,
  1530. "works"=>1,
  1531. "advanced"=>0,
  1532. "needTime"=>0,
  1533. "needFetch"=>0,
  1534. "saveState"=>0,
  1535. "restoreState"=>0,
  1536. "isEOF"=>1,
  1537. "invalidates"=>0,
  1538. "keyPattern"=>{"stock_id"=>1},
  1539. "indexName"=>"stock_id_1",
  1540. "isMultiKey"=>false,
  1541. "direction"=>"forward",
  1542. "indexBounds"=>
  1543. {"stock_id"=>
  1544. ["[ObjectId('56541578551adb1dfc003838'), ObjectId('56541578551adb1dfc003838')]"]},
  1545. "keysExamined"=>0,
  1546. "dupsTested"=>0,
  1547. "dupsDropped"=>0,
  1548. "seenInvalidated"=>0,
  1549. "matchTested"=>0}},
  1550. "allPlansExecution"=>
  1551. [{"nReturned"=>0,
  1552. "executionTimeMillisEstimate"=>0,
  1553. "totalKeysExamined"=>0,
  1554. "totalDocsExamined"=>0,
  1555. "executionStages"=>
  1556. {"stage"=>"FETCH",
  1557. "nReturned"=>0,
  1558. "executionTimeMillisEstimate"=>0,
  1559. "works"=>1,
  1560. "advanced"=>0,
  1561. "needTime"=>0,
  1562. "needFetch"=>0,
  1563. "saveState"=>0,
  1564. "restoreState"=>0,
  1565. "isEOF"=>1,
  1566. "invalidates"=>0,
  1567. "docsExamined"=>0,
  1568. "alreadyHasObj"=>0,
  1569. "inputStage"=>
  1570. {"stage"=>"IXSCAN",
  1571. "nReturned"=>0,
  1572. "executionTimeMillisEstimate"=>0,
  1573. "works"=>1,
  1574. "advanced"=>0,
  1575. "needTime"=>0,
  1576. "needFetch"=>0,
  1577. "saveState"=>0,
  1578. "restoreState"=>0,
  1579. "isEOF"=>1,
  1580. "invalidates"=>0,
  1581. "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
  1582. "indexName"=>"stock_id_1_datetime_1",
  1583. "isMultiKey"=>false,
  1584. "direction"=>"forward",
  1585. "indexBounds"=>
  1586. {"stock_id"=>
  1587. ["[ObjectId('56541578551adb1dfc003838'), ObjectId('56541578551adb1dfc003838')]"],
  1588. "datetime"=>["[MinKey, MaxKey]"]},
  1589. "keysExamined"=>0,
  1590. "dupsTested"=>0,
  1591. "dupsDropped"=>0,
  1592. "seenInvalidated"=>0,
  1593. "matchTested"=>0}}},
  1594. {"nReturned"=>0,
  1595. "executionTimeMillisEstimate"=>0,
  1596. "totalKeysExamined"=>0,
  1597. "totalDocsExamined"=>0,
  1598. "executionStages"=>
  1599. {"stage"=>"FETCH",
  1600. "nReturned"=>0,
  1601. "executionTimeMillisEstimate"=>0,
  1602. "works"=>1,
  1603. "advanced"=>0,
  1604. "needTime"=>0,
  1605. "needFetch"=>0,
  1606. "saveState"=>0,
  1607. "restoreState"=>0,
  1608. "isEOF"=>1,
  1609. "invalidates"=>0,
  1610. "docsExamined"=>0,
  1611. "alreadyHasObj"=>0,
  1612. "inputStage"=>
  1613. {"stage"=>"IXSCAN",
  1614. "nReturned"=>0,
  1615. "executionTimeMillisEstimate"=>0,
  1616. "works"=>1,
  1617. "advanced"=>0,
  1618. "needTime"=>0,
  1619. "needFetch"=>0,
  1620. "saveState"=>0,
  1621. "restoreState"=>0,
  1622. "isEOF"=>1,
  1623. "invalidates"=>0,
  1624. "keyPattern"=>{"stock_id"=>1},
  1625. "indexName"=>"stock_id_1",
  1626. "isMultiKey"=>false,
  1627. "direction"=>"forward",
  1628. "indexBounds"=>
  1629. {"stock_id"=>
  1630. ["[ObjectId('56541578551adb1dfc003838'), ObjectId('56541578551adb1dfc003838')]"]},
  1631. "keysExamined"=>0,
  1632. "dupsTested"=>0,
  1633. "dupsDropped"=>0,
  1634. "seenInvalidated"=>0,
  1635. "matchTested"=>0}}}]},
  1636. "serverInfo"=>
  1637. {"host"=>"Jegan.local",
  1638. "port"=>27017,
  1639. "version"=>"3.0.7",
  1640. "gitVersion"=>"nogitversion"}}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!