API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2019
205
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 30.79 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "queryPlanner" : {
  3. "plannerVersion" : 1,
  4. "namespace" : "adapti.users",
  5. "indexFilterSet" : false,
  6. "parsedQuery" : {
  7. "$and" : [
  8. {
  9. "sessions.webInstanceId" : {
  10. "$eq" : 123456873.0
  11. }
  12. },
  13. {
  14. "sessions.timeStart" : {
  15. "$gt" : 1500940800.0
  16. }
  17. }
  18. ]
  19. },
  20. "winningPlan" : {
  21. "stage" : "LIMIT",
  22. "limitAmount" : 10000,
  23. "inputStage" : {
  24. "stage" : "FETCH",
  25. "filter" : {
  26. "sessions.webInstanceId" : {
  27. "$eq" : 123456873.0
  28. }
  29. },
  30. "inputStage" : {
  31. "stage" : "IXSCAN",
  32. "keyPattern" : {
  33. "sessions.timeStart" : 1,
  34. "sessions.webInstanceId" : 1,
  35. "sessions.pageViews.adaptation_events.type" : 1
  36. },
  37. "indexName" : "timeStart + wI + adaptation_events type",
  38. "isMultiKey" : true,
  39. "multiKeyPaths" : {
  40. "sessions.timeStart" : [
  41. "sessions"
  42. ],
  43. "sessions.webInstanceId" : [
  44. "sessions"
  45. ],
  46. "sessions.pageViews.adaptation_events.type" : [
  47. "sessions",
  48. "sessions.pageViews",
  49. "sessions.pageViews.adaptation_events"
  50. ]
  51. },
  52. "isUnique" : false,
  53. "isSparse" : false,
  54. "isPartial" : false,
  55. "indexVersion" : 2,
  56. "direction" : "forward",
  57. "indexBounds" : {
  58. "sessions.timeStart" : [
  59. "(1500940800.0, inf.0]"
  60. ],
  61. "sessions.webInstanceId" : [
  62. "[MinKey, MaxKey]"
  63. ],
  64. "sessions.pageViews.adaptation_events.type" : [
  65. "[MinKey, MaxKey]"
  66. ]
  67. }
  68. }
  69. }
  70. },
  71. "rejectedPlans" : [
  72. {
  73. "stage" : "LIMIT",
  74. "limitAmount" : 10000,
  75. "inputStage" : {
  76. "stage" : "FETCH",
  77. "filter" : {
  78. "sessions.timeStart" : {
  79. "$gt" : 1500940800.0
  80. }
  81. },
  82. "inputStage" : {
  83. "stage" : "IXSCAN",
  84. "keyPattern" : {
  85. "sessions.webInstanceId" : 1
  86. },
  87. "indexName" : "sessions",
  88. "isMultiKey" : true,
  89. "multiKeyPaths" : {
  90. "sessions.webInstanceId" : [
  91. "sessions"
  92. ]
  93. },
  94. "isUnique" : false,
  95. "isSparse" : false,
  96. "isPartial" : false,
  97. "indexVersion" : 2,
  98. "direction" : "forward",
  99. "indexBounds" : {
  100. "sessions.webInstanceId" : [
  101. "[123456873.0, 123456873.0]"
  102. ]
  103. }
  104. }
  105. }
  106. },
  107. {
  108. "stage" : "LIMIT",
  109. "limitAmount" : 10000,
  110. "inputStage" : {
  111. "stage" : "FETCH",
  112. "filter" : {
  113. "sessions.timeStart" : {
  114. "$gt" : 1500940800.0
  115. }
  116. },
  117. "inputStage" : {
  118. "stage" : "IXSCAN",
  119. "keyPattern" : {
  120. "sessions.webInstanceId" : 1,
  121. "sessions.timeStart" : 1
  122. },
  123. "indexName" : "web_instance_id_and_time_start",
  124. "isMultiKey" : true,
  125. "multiKeyPaths" : {
  126. "sessions.webInstanceId" : [
  127. "sessions"
  128. ],
  129. "sessions.timeStart" : [
  130. "sessions"
  131. ]
  132. },
  133. "isUnique" : false,
  134. "isSparse" : false,
  135. "isPartial" : false,
  136. "indexVersion" : 2,
  137. "direction" : "forward",
  138. "indexBounds" : {
  139. "sessions.webInstanceId" : [
  140. "[123456873.0, 123456873.0]"
  141. ],
  142. "sessions.timeStart" : [
  143. "[MinKey, MaxKey]"
  144. ]
  145. }
  146. }
  147. }
  148. },
  149. {
  150. "stage" : "LIMIT",
  151. "limitAmount" : 10000,
  152. "inputStage" : {
  153. "stage" : "FETCH",
  154. "filter" : {
  155. "sessions.webInstanceId" : {
  156. "$eq" : 123456873.0
  157. }
  158. },
  159. "inputStage" : {
  160. "stage" : "IXSCAN",
  161. "keyPattern" : {
  162. "sessions.timeStart" : 1
  163. },
  164. "indexName" : "timeStart_index",
  165. "isMultiKey" : true,
  166. "multiKeyPaths" : {
  167. "sessions.timeStart" : [
  168. "sessions"
  169. ]
  170. },
  171. "isUnique" : false,
  172. "isSparse" : false,
  173. "isPartial" : false,
  174. "indexVersion" : 2,
  175. "direction" : "forward",
  176. "indexBounds" : {
  177. "sessions.timeStart" : [
  178. "(1500940800.0, inf.0]"
  179. ]
  180. }
  181. }
  182. }
  183. },
  184. {
  185. "stage" : "LIMIT",
  186. "limitAmount" : 10000,
  187. "inputStage" : {
  188. "stage" : "FETCH",
  189. "filter" : {
  190. "sessions.webInstanceId" : {
  191. "$eq" : 123456873.0
  192. }
  193. },
  194. "inputStage" : {
  195. "stage" : "IXSCAN",
  196. "keyPattern" : {
  197. "sessions.timeStart" : 1,
  198. "sessions.webInstanceId" : 1
  199. },
  200. "indexName" : "timespan users count",
  201. "isMultiKey" : true,
  202. "multiKeyPaths" : {
  203. "sessions.timeStart" : [
  204. "sessions"
  205. ],
  206. "sessions.webInstanceId" : [
  207. "sessions"
  208. ]
  209. },
  210. "isUnique" : false,
  211. "isSparse" : false,
  212. "isPartial" : false,
  213. "indexVersion" : 2,
  214. "direction" : "forward",
  215. "indexBounds" : {
  216. "sessions.timeStart" : [
  217. "(1500940800.0, inf.0]"
  218. ],
  219. "sessions.webInstanceId" : [
  220. "[MinKey, MaxKey]"
  221. ]
  222. }
  223. }
  224. }
  225. }
  226. ]
  227. },
  228. "executionStats" : {
  229. "executionSuccess" : true,
  230. "nReturned" : 10000,
  231. "executionTimeMillis" : 72458,
  232. "totalKeysExamined" : 76196,
  233. "totalDocsExamined" : 57864,
  234. "executionStages" : {
  235. "stage" : "LIMIT",
  236. "nReturned" : 10000,
  237. "executionTimeMillisEstimate" : 72342,
  238. "works" : 76197,
  239. "advanced" : 10000,
  240. "needTime" : 66196,
  241. "needYield" : 0,
  242. "saveState" : 2518,
  243. "restoreState" : 2518,
  244. "isEOF" : 1,
  245. "invalidates" : 0,
  246. "limitAmount" : 10000,
  247. "inputStage" : {
  248. "stage" : "FETCH",
  249. "filter" : {
  250. "sessions.webInstanceId" : {
  251. "$eq" : 123456873.0
  252. }
  253. },
  254. "nReturned" : 10000,
  255. "executionTimeMillisEstimate" : 72342,
  256. "works" : 76196,
  257. "advanced" : 10000,
  258. "needTime" : 66196,
  259. "needYield" : 0,
  260. "saveState" : 2518,
  261. "restoreState" : 2518,
  262. "isEOF" : 0,
  263. "invalidates" : 0,
  264. "docsExamined" : 57864,
  265. "alreadyHasObj" : 0,
  266. "inputStage" : {
  267. "stage" : "IXSCAN",
  268. "nReturned" : 57864,
  269. "executionTimeMillisEstimate" : 120,
  270. "works" : 76196,
  271. "advanced" : 57864,
  272. "needTime" : 18332,
  273. "needYield" : 0,
  274. "saveState" : 2518,
  275. "restoreState" : 2518,
  276. "isEOF" : 0,
  277. "invalidates" : 0,
  278. "keyPattern" : {
  279. "sessions.timeStart" : 1,
  280. "sessions.webInstanceId" : 1,
  281. "sessions.pageViews.adaptation_events.type" : 1
  282. },
  283. "indexName" : "timeStart + wI + adaptation_events type",
  284. "isMultiKey" : true,
  285. "multiKeyPaths" : {
  286. "sessions.timeStart" : [
  287. "sessions"
  288. ],
  289. "sessions.webInstanceId" : [
  290. "sessions"
  291. ],
  292. "sessions.pageViews.adaptation_events.type" : [
  293. "sessions",
  294. "sessions.pageViews",
  295. "sessions.pageViews.adaptation_events"
  296. ]
  297. },
  298. "isUnique" : false,
  299. "isSparse" : false,
  300. "isPartial" : false,
  301. "indexVersion" : 2,
  302. "direction" : "forward",
  303. "indexBounds" : {
  304. "sessions.timeStart" : [
  305. "(1500940800.0, inf.0]"
  306. ],
  307. "sessions.webInstanceId" : [
  308. "[MinKey, MaxKey]"
  309. ],
  310. "sessions.pageViews.adaptation_events.type" : [
  311. "[MinKey, MaxKey]"
  312. ]
  313. },
  314. "keysExamined" : 76196,
  315. "seeks" : 1,
  316. "dupsTested" : 76196,
  317. "dupsDropped" : 18332,
  318. "seenInvalidated" : 0
  319. }
  320. }
  321. },
  322. "allPlansExecution" : [
  323. {
  324. "nReturned" : 101,
  325. "executionTimeMillisEstimate" : 10,
  326. "totalKeysExamined" : 507,
  327. "totalDocsExamined" : 422,
  328. "executionStages" : {
  329. "stage" : "LIMIT",
  330. "nReturned" : 101,
  331. "executionTimeMillisEstimate" : 10,
  332. "works" : 507,
  333. "advanced" : 101,
  334. "needTime" : 406,
  335. "needYield" : 0,
  336. "saveState" : 19,
  337. "restoreState" : 19,
  338. "isEOF" : 0,
  339. "invalidates" : 0,
  340. "limitAmount" : 10000,
  341. "inputStage" : {
  342. "stage" : "FETCH",
  343. "filter" : {
  344. "sessions.webInstanceId" : {
  345. "$eq" : 123456873.0
  346. }
  347. },
  348. "nReturned" : 101,
  349. "executionTimeMillisEstimate" : 10,
  350. "works" : 507,
  351. "advanced" : 101,
  352. "needTime" : 406,
  353. "needYield" : 0,
  354. "saveState" : 19,
  355. "restoreState" : 19,
  356. "isEOF" : 0,
  357. "invalidates" : 0,
  358. "docsExamined" : 422,
  359. "alreadyHasObj" : 0,
  360. "inputStage" : {
  361. "stage" : "IXSCAN",
  362. "nReturned" : 422,
  363. "executionTimeMillisEstimate" : 0,
  364. "works" : 507,
  365. "advanced" : 422,
  366. "needTime" : 85,
  367. "needYield" : 0,
  368. "saveState" : 19,
  369. "restoreState" : 19,
  370. "isEOF" : 0,
  371. "invalidates" : 0,
  372. "keyPattern" : {
  373. "sessions.timeStart" : 1,
  374. "sessions.webInstanceId" : 1,
  375. "sessions.pageViews.adaptation_events.type" : 1
  376. },
  377. "indexName" : "timeStart + wI + adaptation_events type",
  378. "isMultiKey" : true,
  379. "multiKeyPaths" : {
  380. "sessions.timeStart" : [
  381. "sessions"
  382. ],
  383. "sessions.webInstanceId" : [
  384. "sessions"
  385. ],
  386. "sessions.pageViews.adaptation_events.type" : [
  387. "sessions",
  388. "sessions.pageViews",
  389. "sessions.pageViews.adaptation_events"
  390. ]
  391. },
  392. "isUnique" : false,
  393. "isSparse" : false,
  394. "isPartial" : false,
  395. "indexVersion" : 2,
  396. "direction" : "forward",
  397. "indexBounds" : {
  398. "sessions.timeStart" : [
  399. "(1500940800.0, inf.0]"
  400. ],
  401. "sessions.webInstanceId" : [
  402. "[MinKey, MaxKey]"
  403. ],
  404. "sessions.pageViews.adaptation_events.type" : [
  405. "[MinKey, MaxKey]"
  406. ]
  407. },
  408. "keysExamined" : 507,
  409. "seeks" : 1,
  410. "dupsTested" : 507,
  411. "dupsDropped" : 85,
  412. "seenInvalidated" : 0
  413. }
  414. }
  415. }
  416. },
  417. {
  418. "nReturned" : 18,
  419. "executionTimeMillisEstimate" : 0,
  420. "totalKeysExamined" : 507,
  421. "totalDocsExamined" : 507,
  422. "executionStages" : {
  423. "stage" : "LIMIT",
  424. "nReturned" : 18,
  425. "executionTimeMillisEstimate" : 0,
  426. "works" : 507,
  427. "advanced" : 18,
  428. "needTime" : 489,
  429. "needYield" : 0,
  430. "saveState" : 2518,
  431. "restoreState" : 2518,
  432. "isEOF" : 0,
  433. "invalidates" : 0,
  434. "limitAmount" : 10000,
  435. "inputStage" : {
  436. "stage" : "FETCH",
  437. "filter" : {
  438. "sessions.timeStart" : {
  439. "$gt" : 1500940800.0
  440. }
  441. },
  442. "nReturned" : 18,
  443. "executionTimeMillisEstimate" : 0,
  444. "works" : 507,
  445. "advanced" : 18,
  446. "needTime" : 489,
  447. "needYield" : 0,
  448. "saveState" : 2518,
  449. "restoreState" : 2518,
  450. "isEOF" : 0,
  451. "invalidates" : 0,
  452. "docsExamined" : 507,
  453. "alreadyHasObj" : 0,
  454. "inputStage" : {
  455. "stage" : "IXSCAN",
  456. "nReturned" : 507,
  457. "executionTimeMillisEstimate" : 0,
  458. "works" : 507,
  459. "advanced" : 507,
  460. "needTime" : 0,
  461. "needYield" : 0,
  462. "saveState" : 2518,
  463. "restoreState" : 2518,
  464. "isEOF" : 0,
  465. "invalidates" : 0,
  466. "keyPattern" : {
  467. "sessions.webInstanceId" : 1
  468. },
  469. "indexName" : "sessions",
  470. "isMultiKey" : true,
  471. "multiKeyPaths" : {
  472. "sessions.webInstanceId" : [
  473. "sessions"
  474. ]
  475. },
  476. "isUnique" : false,
  477. "isSparse" : false,
  478. "isPartial" : false,
  479. "indexVersion" : 2,
  480. "direction" : "forward",
  481. "indexBounds" : {
  482. "sessions.webInstanceId" : [
  483. "[123456873.0, 123456873.0]"
  484. ]
  485. },
  486. "keysExamined" : 507,
  487. "seeks" : 1,
  488. "dupsTested" : 507,
  489. "dupsDropped" : 0,
  490. "seenInvalidated" : 0
  491. }
  492. }
  493. }
  494. },
  495. {
  496. "nReturned" : 0,
  497. "executionTimeMillisEstimate" : 10,
  498. "totalKeysExamined" : 507,
  499. "totalDocsExamined" : 406,
  500. "executionStages" : {
  501. "stage" : "LIMIT",
  502. "nReturned" : 0,
  503. "executionTimeMillisEstimate" : 10,
  504. "works" : 507,
  505. "advanced" : 0,
  506. "needTime" : 507,
  507. "needYield" : 0,
  508. "saveState" : 2518,
  509. "restoreState" : 2518,
  510. "isEOF" : 0,
  511. "invalidates" : 0,
  512. "limitAmount" : 10000,
  513. "inputStage" : {
  514. "stage" : "FETCH",
  515. "filter" : {
  516. "sessions.timeStart" : {
  517. "$gt" : 1500940800.0
  518. }
  519. },
  520. "nReturned" : 0,
  521. "executionTimeMillisEstimate" : 10,
  522. "works" : 507,
  523. "advanced" : 0,
  524. "needTime" : 507,
  525. "needYield" : 0,
  526. "saveState" : 2518,
  527. "restoreState" : 2518,
  528. "isEOF" : 0,
  529. "invalidates" : 0,
  530. "docsExamined" : 406,
  531. "alreadyHasObj" : 0,
  532. "inputStage" : {
  533. "stage" : "IXSCAN",
  534. "nReturned" : 406,
  535. "executionTimeMillisEstimate" : 0,
  536. "works" : 507,
  537. "advanced" : 406,
  538. "needTime" : 101,
  539. "needYield" : 0,
  540. "saveState" : 2518,
  541. "restoreState" : 2518,
  542. "isEOF" : 0,
  543. "invalidates" : 0,
  544. "keyPattern" : {
  545. "sessions.webInstanceId" : 1,
  546. "sessions.timeStart" : 1
  547. },
  548. "indexName" : "web_instance_id_and_time_start",
  549. "isMultiKey" : true,
  550. "multiKeyPaths" : {
  551. "sessions.webInstanceId" : [
  552. "sessions"
  553. ],
  554. "sessions.timeStart" : [
  555. "sessions"
  556. ]
  557. },
  558. "isUnique" : false,
  559. "isSparse" : false,
  560. "isPartial" : false,
  561. "indexVersion" : 2,
  562. "direction" : "forward",
  563. "indexBounds" : {
  564. "sessions.webInstanceId" : [
  565. "[123456873.0, 123456873.0]"
  566. ],
  567. "sessions.timeStart" : [
  568. "[MinKey, MaxKey]"
  569. ]
  570. },
  571. "keysExamined" : 507,
  572. "seeks" : 1,
  573. "dupsTested" : 507,
  574. "dupsDropped" : 101,
  575. "seenInvalidated" : 0
  576. }
  577. }
  578. }
  579. },
  580. {
  581. "nReturned" : 101,
  582. "executionTimeMillisEstimate" : 0,
  583. "totalKeysExamined" : 507,
  584. "totalDocsExamined" : 422,
  585. "executionStages" : {
  586. "stage" : "LIMIT",
  587. "nReturned" : 101,
  588. "executionTimeMillisEstimate" : 0,
  589. "works" : 507,
  590. "advanced" : 101,
  591. "needTime" : 406,
  592. "needYield" : 0,
  593. "saveState" : 2518,
  594. "restoreState" : 2518,
  595. "isEOF" : 0,
  596. "invalidates" : 0,
  597. "limitAmount" : 10000,
  598. "inputStage" : {
  599. "stage" : "FETCH",
  600. "filter" : {
  601. "sessions.webInstanceId" : {
  602. "$eq" : 123456873.0
  603. }
  604. },
  605. "nReturned" : 101,
  606. "executionTimeMillisEstimate" : 0,
  607. "works" : 507,
  608. "advanced" : 101,
  609. "needTime" : 406,
  610. "needYield" : 0,
  611. "saveState" : 2518,
  612. "restoreState" : 2518,
  613. "isEOF" : 0,
  614. "invalidates" : 0,
  615. "docsExamined" : 422,
  616. "alreadyHasObj" : 0,
  617. "inputStage" : {
  618. "stage" : "IXSCAN",
  619. "nReturned" : 422,
  620. "executionTimeMillisEstimate" : 0,
  621. "works" : 507,
  622. "advanced" : 422,
  623. "needTime" : 85,
  624. "needYield" : 0,
  625. "saveState" : 2518,
  626. "restoreState" : 2518,
  627. "isEOF" : 0,
  628. "invalidates" : 0,
  629. "keyPattern" : {
  630. "sessions.timeStart" : 1
  631. },
  632. "indexName" : "timeStart_index",
  633. "isMultiKey" : true,
  634. "multiKeyPaths" : {
  635. "sessions.timeStart" : [
  636. "sessions"
  637. ]
  638. },
  639. "isUnique" : false,
  640. "isSparse" : false,
  641. "isPartial" : false,
  642. "indexVersion" : 2,
  643. "direction" : "forward",
  644. "indexBounds" : {
  645. "sessions.timeStart" : [
  646. "(1500940800.0, inf.0]"
  647. ]
  648. },
  649. "keysExamined" : 507,
  650. "seeks" : 1,
  651. "dupsTested" : 507,
  652. "dupsDropped" : 85,
  653. "seenInvalidated" : 0
  654. }
  655. }
  656. }
  657. },
  658. {
  659. "nReturned" : 101,
  660. "executionTimeMillisEstimate" : 0,
  661. "totalKeysExamined" : 507,
  662. "totalDocsExamined" : 422,
  663. "executionStages" : {
  664. "stage" : "LIMIT",
  665. "nReturned" : 101,
  666. "executionTimeMillisEstimate" : 0,
  667. "works" : 507,
  668. "advanced" : 101,
  669. "needTime" : 406,
  670. "needYield" : 0,
  671. "saveState" : 2518,
  672. "restoreState" : 2518,
  673. "isEOF" : 0,
  674. "invalidates" : 0,
  675. "limitAmount" : 10000,
  676. "inputStage" : {
  677. "stage" : "FETCH",
  678. "filter" : {
  679. "sessions.webInstanceId" : {
  680. "$eq" : 123456873.0
  681. }
  682. },
  683. "nReturned" : 101,
  684. "executionTimeMillisEstimate" : 0,
  685. "works" : 507,
  686. "advanced" : 101,
  687. "needTime" : 406,
  688. "needYield" : 0,
  689. "saveState" : 2518,
  690. "restoreState" : 2518,
  691. "isEOF" : 0,
  692. "invalidates" : 0,
  693. "docsExamined" : 422,
  694. "alreadyHasObj" : 0,
  695. "inputStage" : {
  696. "stage" : "IXSCAN",
  697. "nReturned" : 422,
  698. "executionTimeMillisEstimate" : 0,
  699. "works" : 507,
  700. "advanced" : 422,
  701. "needTime" : 85,
  702. "needYield" : 0,
  703. "saveState" : 2518,
  704. "restoreState" : 2518,
  705. "isEOF" : 0,
  706. "invalidates" : 0,
  707. "keyPattern" : {
  708. "sessions.timeStart" : 1,
  709. "sessions.webInstanceId" : 1
  710. },
  711. "indexName" : "timespan users count",
  712. "isMultiKey" : true,
  713. "multiKeyPaths" : {
  714. "sessions.timeStart" : [
  715. "sessions"
  716. ],
  717. "sessions.webInstanceId" : [
  718. "sessions"
  719. ]
  720. },
  721. "isUnique" : false,
  722. "isSparse" : false,
  723. "isPartial" : false,
  724. "indexVersion" : 2,
  725. "direction" : "forward",
  726. "indexBounds" : {
  727. "sessions.timeStart" : [
  728. "(1500940800.0, inf.0]"
  729. ],
  730. "sessions.webInstanceId" : [
  731. "[MinKey, MaxKey]"
  732. ]
  733. },
  734. "keysExamined" : 507,
  735. "seeks" : 1,
  736. "dupsTested" : 507,
  737. "dupsDropped" : 85,
  738. "seenInvalidated" : 0
  739. }
  740. }
  741. }
  742. }
  743. ]
  744. },
  745. "serverInfo" : {
  746. "host" : "adapti-prod-mongo-2",
  747. "port" : 27017,
  748. "version" : "4.0.3",
  749. "gitVersion" : "7ea530946fa7880364d88c8d8b6026bbc9ffa48c"
  750. },
  751. "ok" : 1.0
  752. }
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!