API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 28th, 2015
269
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.44 KB | None | 0 0
raw download clone embed print report
  1. mongos> db.fs_files.find({ platform: "iOS", group_id: "active_users", group_number: 1428192000000, app_id: "muffinquest", key: "level" }).explain()
  2. {
  3. "queryPlanner" : {
  4. "mongosPlannerVersion" : 1,
  5. "winningPlan" : {
  6. "stage" : "SHARD_MERGE",
  7. "shards" : [
  8. {
  9. "shardName" : "xsf_shard_00",
  10. "connectionString" : "xsf_shard_00/xsf-db-01.xsf.local:27017,xsf-db-02.xsf.local:27017,xsf-db-03.xsf.local:27017",
  11. "serverInfo" : {
  12. "host" : "xsf-db-03",
  13. "port" : 27017,
  14. "version" : "3.0.2",
  15. "gitVersion" : "6201872043ecbbc0a4cc169b5482dcf385fc464f"
  16. },
  17. "plannerVersion" : 1,
  18. "namespace" : "xsf-content-analytics.fs_files",
  19. "indexFilterSet" : false,
  20. "parsedQuery" : {
  21. "$and" : [
  22. {
  23. "app_id" : {
  24. "$eq" : "muffinquest"
  25. }
  26. },
  27. {
  28. "group_id" : {
  29. "$eq" : "active_users"
  30. }
  31. },
  32. {
  33. "group_number" : {
  34. "$eq" : 1428192000000
  35. }
  36. },
  37. {
  38. "key" : {
  39. "$eq" : "level"
  40. }
  41. },
  42. {
  43. "platform" : {
  44. "$eq" : "iOS"
  45. }
  46. }
  47. ]
  48. },
  49. "winningPlan" : {
  50. "stage" : "SHARDING_FILTER",
  51. "inputStage" : {
  52. "stage" : "FETCH",
  53. "filter" : {
  54. "key" : {
  55. "$eq" : "level"
  56. }
  57. },
  58. "inputStage" : {
  59. "stage" : "IXSCAN",
  60. "keyPattern" : {
  61. "group_number" : 1,
  62. "group_id" : 1,
  63. "key_id" : 1,
  64. "platform" : 1,
  65. "app_id" : 1,
  66. "scale" : 1,
  67. "date" : 1
  68. },
  69. "indexName" : "group_number_group_id_key_platform_app_id_scale_date",
  70. "isMultiKey" : false,
  71. "direction" : "forward",
  72. "indexBounds" : {
  73. "group_number" : [
  74. "[1428192000000.0, 1428192000000.0]"
  75. ],
  76. "group_id" : [
  77. "[\"active_users\", \"active_users\"]"
  78. ],
  79. "key_id" : [
  80. "[MinKey, MaxKey]"
  81. ],
  82. "platform" : [
  83. "[\"iOS\", \"iOS\"]"
  84. ],
  85. "app_id" : [
  86. "[\"muffinquest\", \"muffinquest\"]"
  87. ],
  88. "scale" : [
  89. "[MinKey, MaxKey]"
  90. ],
  91. "date" : [
  92. "[MinKey, MaxKey]"
  93. ]
  94. }
  95. }
  96. }
  97. },
  98. "rejectedPlans" : [
  99. {
  100. "stage" : "SHARDING_FILTER",
  101. "inputStage" : {
  102. "stage" : "FETCH",
  103. "filter" : {
  104. "$and" : [
  105. {
  106. "group_id" : {
  107. "$eq" : "active_users"
  108. }
  109. },
  110. {
  111. "group_number" : {
  112. "$eq" : 1428192000000
  113. }
  114. }
  115. ]
  116. },
  117. "inputStage" : {
  118. "stage" : "IXSCAN",
  119. "keyPattern" : {
  120. "platform" : 1,
  121. "period" : 1,
  122. "key" : 1,
  123. "app_id" : 1
  124. },
  125. "indexName" : "platform_period_key_app_id",
  126. "isMultiKey" : false,
  127. "direction" : "forward",
  128. "indexBounds" : {
  129. "platform" : [
  130. "[\"iOS\", \"iOS\"]"
  131. ],
  132. "period" : [
  133. "[MinKey, MaxKey]"
  134. ],
  135. "key" : [
  136. "[\"level\", \"level\"]"
  137. ],
  138. "app_id" : [
  139. "[\"muffinquest\", \"muffinquest\"]"
  140. ]
  141. }
  142. }
  143. }
  144. },
  145. {
  146. "stage" : "SHARDING_FILTER",
  147. "inputStage" : {
  148. "stage" : "FETCH",
  149. "filter" : {
  150. "$and" : [
  151. {
  152. "group_id" : {
  153. "$eq" : "active_users"
  154. }
  155. },
  156. {
  157. "group_number" : {
  158. "$eq" : 1428192000000
  159. }
  160. }
  161. ]
  162. },
  163. "inputStage" : {
  164. "stage" : "IXSCAN",
  165. "keyPattern" : {
  166. "key" : 1,
  167. "platform" : 1,
  168. "app_id" : 1,
  169. "scale" : 1,
  170. "date" : 1
  171. },
  172. "indexName" : "key_platform_app_id_scale_date",
  173. "isMultiKey" : false,
  174. "direction" : "forward",
  175. "indexBounds" : {
  176. "key" : [
  177. "[\"level\", \"level\"]"
  178. ],
  179. "platform" : [
  180. "[\"iOS\", \"iOS\"]"
  181. ],
  182. "app_id" : [
  183. "[\"muffinquest\", \"muffinquest\"]"
  184. ],
  185. "scale" : [
  186. "[MinKey, MaxKey]"
  187. ],
  188. "date" : [
  189. "[MinKey, MaxKey]"
  190. ]
  191. }
  192. }
  193. }
  194. }
  195. ]
  196. },
  197. {
  198. "shardName" : "xsf_shard_01",
  199. "connectionString" : "xsf_shard_01/xsf-db-04.xsf.local:27017,xsf-db-05.xsf.local:27017,xsf-db-06.xsf.local:27017",
  200. "serverInfo" : {
  201. "host" : "xsf-db-04",
  202. "port" : 27017,
  203. "version" : "3.0.2",
  204. "gitVersion" : "6201872043ecbbc0a4cc169b5482dcf385fc464f"
  205. },
  206. "plannerVersion" : 1,
  207. "namespace" : "xsf-content-analytics.fs_files",
  208. "indexFilterSet" : false,
  209. "parsedQuery" : {
  210. "$and" : [
  211. {
  212. "app_id" : {
  213. "$eq" : "muffinquest"
  214. }
  215. },
  216. {
  217. "group_id" : {
  218. "$eq" : "active_users"
  219. }
  220. },
  221. {
  222. "group_number" : {
  223. "$eq" : 1428192000000
  224. }
  225. },
  226. {
  227. "key" : {
  228. "$eq" : "level"
  229. }
  230. },
  231. {
  232. "platform" : {
  233. "$eq" : "iOS"
  234. }
  235. }
  236. ]
  237. },
  238. "winningPlan" : {
  239. "stage" : "SHARDING_FILTER",
  240. "inputStage" : {
  241. "stage" : "FETCH",
  242. "filter" : {
  243. "key" : {
  244. "$eq" : "level"
  245. }
  246. },
  247. "inputStage" : {
  248. "stage" : "IXSCAN",
  249. "keyPattern" : {
  250. "group_number" : 1,
  251. "group_id" : 1,
  252. "key_id" : 1,
  253. "platform" : 1,
  254. "app_id" : 1,
  255. "scale" : 1,
  256. "date" : 1
  257. },
  258. "indexName" : "group_number_group_id_key_platform_app_id_scale_date",
  259. "isMultiKey" : false,
  260. "direction" : "forward",
  261. "indexBounds" : {
  262. "group_number" : [
  263. "[1428192000000.0, 1428192000000.0]"
  264. ],
  265. "group_id" : [
  266. "[\"active_users\", \"active_users\"]"
  267. ],
  268. "key_id" : [
  269. "[MinKey, MaxKey]"
  270. ],
  271. "platform" : [
  272. "[\"iOS\", \"iOS\"]"
  273. ],
  274. "app_id" : [
  275. "[\"muffinquest\", \"muffinquest\"]"
  276. ],
  277. "scale" : [
  278. "[MinKey, MaxKey]"
  279. ],
  280. "date" : [
  281. "[MinKey, MaxKey]"
  282. ]
  283. }
  284. }
  285. }
  286. },
  287. "rejectedPlans" : [
  288. {
  289. "stage" : "SHARDING_FILTER",
  290. "inputStage" : {
  291. "stage" : "FETCH",
  292. "filter" : {
  293. "$and" : [
  294. {
  295. "group_id" : {
  296. "$eq" : "active_users"
  297. }
  298. },
  299. {
  300. "group_number" : {
  301. "$eq" : 1428192000000
  302. }
  303. }
  304. ]
  305. },
  306. "inputStage" : {
  307. "stage" : "IXSCAN",
  308. "keyPattern" : {
  309. "platform" : 1,
  310. "period" : 1,
  311. "key" : 1,
  312. "app_id" : 1
  313. },
  314. "indexName" : "platform_period_key_app_id",
  315. "isMultiKey" : false,
  316. "direction" : "forward",
  317. "indexBounds" : {
  318. "platform" : [
  319. "[\"iOS\", \"iOS\"]"
  320. ],
  321. "period" : [
  322. "[MinKey, MaxKey]"
  323. ],
  324. "key" : [
  325. "[\"level\", \"level\"]"
  326. ],
  327. "app_id" : [
  328. "[\"muffinquest\", \"muffinquest\"]"
  329. ]
  330. }
  331. }
  332. }
  333. },
  334. {
  335. "stage" : "SHARDING_FILTER",
  336. "inputStage" : {
  337. "stage" : "FETCH",
  338. "filter" : {
  339. "$and" : [
  340. {
  341. "group_id" : {
  342. "$eq" : "active_users"
  343. }
  344. },
  345. {
  346. "group_number" : {
  347. "$eq" : 1428192000000
  348. }
  349. }
  350. ]
  351. },
  352. "inputStage" : {
  353. "stage" : "IXSCAN",
  354. "keyPattern" : {
  355. "key" : 1,
  356. "platform" : 1,
  357. "app_id" : 1,
  358. "scale" : 1,
  359. "date" : 1
  360. },
  361. "indexName" : "key_platform_app_id_scale_date",
  362. "isMultiKey" : false,
  363. "direction" : "forward",
  364. "indexBounds" : {
  365. "key" : [
  366. "[\"level\", \"level\"]"
  367. ],
  368. "platform" : [
  369. "[\"iOS\", \"iOS\"]"
  370. ],
  371. "app_id" : [
  372. "[\"muffinquest\", \"muffinquest\"]"
  373. ],
  374. "scale" : [
  375. "[MinKey, MaxKey]"
  376. ],
  377. "date" : [
  378. "[MinKey, MaxKey]"
  379. ]
  380. }
  381. }
  382. }
  383. }
  384. ]
  385. },
  386. {
  387. "shardName" : "xsf_shard_02",
  388. "connectionString" : "xsf_shard_02/xsf-db-07.xsf.local:27017,xsf-db-08.xsf.local:27017,xsf-db-09.xsf.local:27017",
  389. "serverInfo" : {
  390. "host" : "xsf-db-07",
  391. "port" : 27017,
  392. "version" : "3.0.2",
  393. "gitVersion" : "6201872043ecbbc0a4cc169b5482dcf385fc464f"
  394. },
  395. "plannerVersion" : 1,
  396. "namespace" : "xsf-content-analytics.fs_files",
  397. "indexFilterSet" : false,
  398. "parsedQuery" : {
  399. "$and" : [
  400. {
  401. "app_id" : {
  402. "$eq" : "muffinquest"
  403. }
  404. },
  405. {
  406. "group_id" : {
  407. "$eq" : "active_users"
  408. }
  409. },
  410. {
  411. "group_number" : {
  412. "$eq" : 1428192000000
  413. }
  414. },
  415. {
  416. "key" : {
  417. "$eq" : "level"
  418. }
  419. },
  420. {
  421. "platform" : {
  422. "$eq" : "iOS"
  423. }
  424. }
  425. ]
  426. },
  427. "winningPlan" : {
  428. "stage" : "SHARDING_FILTER",
  429. "inputStage" : {
  430. "stage" : "FETCH",
  431. "filter" : {
  432. "key" : {
  433. "$eq" : "level"
  434. }
  435. },
  436. "inputStage" : {
  437. "stage" : "IXSCAN",
  438. "keyPattern" : {
  439. "group_number" : 1,
  440. "group_id" : 1,
  441. "key_id" : 1,
  442. "platform" : 1,
  443. "app_id" : 1,
  444. "scale" : 1,
  445. "date" : 1
  446. },
  447. "indexName" : "group_number_group_id_key_platform_app_id_scale_date",
  448. "isMultiKey" : false,
  449. "direction" : "forward",
  450. "indexBounds" : {
  451. "group_number" : [
  452. "[1428192000000.0, 1428192000000.0]"
  453. ],
  454. "group_id" : [
  455. "[\"active_users\", \"active_users\"]"
  456. ],
  457. "key_id" : [
  458. "[MinKey, MaxKey]"
  459. ],
  460. "platform" : [
  461. "[\"iOS\", \"iOS\"]"
  462. ],
  463. "app_id" : [
  464. "[\"muffinquest\", \"muffinquest\"]"
  465. ],
  466. "scale" : [
  467. "[MinKey, MaxKey]"
  468. ],
  469. "date" : [
  470. "[MinKey, MaxKey]"
  471. ]
  472. }
  473. }
  474. }
  475. },
  476. "rejectedPlans" : [
  477. {
  478. "stage" : "SHARDING_FILTER",
  479. "inputStage" : {
  480. "stage" : "FETCH",
  481. "filter" : {
  482. "$and" : [
  483. {
  484. "group_id" : {
  485. "$eq" : "active_users"
  486. }
  487. },
  488. {
  489. "group_number" : {
  490. "$eq" : 1428192000000
  491. }
  492. }
  493. ]
  494. },
  495. "inputStage" : {
  496. "stage" : "IXSCAN",
  497. "keyPattern" : {
  498. "platform" : 1,
  499. "period" : 1,
  500. "key" : 1,
  501. "app_id" : 1
  502. },
  503. "indexName" : "platform_period_key_app_id",
  504. "isMultiKey" : false,
  505. "direction" : "forward",
  506. "indexBounds" : {
  507. "platform" : [
  508. "[\"iOS\", \"iOS\"]"
  509. ],
  510. "period" : [
  511. "[MinKey, MaxKey]"
  512. ],
  513. "key" : [
  514. "[\"level\", \"level\"]"
  515. ],
  516. "app_id" : [
  517. "[\"muffinquest\", \"muffinquest\"]"
  518. ]
  519. }
  520. }
  521. }
  522. },
  523. {
  524. "stage" : "SHARDING_FILTER",
  525. "inputStage" : {
  526. "stage" : "FETCH",
  527. "filter" : {
  528. "$and" : [
  529. {
  530. "group_id" : {
  531. "$eq" : "active_users"
  532. }
  533. },
  534. {
  535. "group_number" : {
  536. "$eq" : 1428192000000
  537. }
  538. }
  539. ]
  540. },
  541. "inputStage" : {
  542. "stage" : "IXSCAN",
  543. "keyPattern" : {
  544. "key" : 1,
  545. "platform" : 1,
  546. "app_id" : 1,
  547. "scale" : 1,
  548. "date" : 1
  549. },
  550. "indexName" : "key_platform_app_id_scale_date",
  551. "isMultiKey" : false,
  552. "direction" : "forward",
  553. "indexBounds" : {
  554. "key" : [
  555. "[\"level\", \"level\"]"
  556. ],
  557. "platform" : [
  558. "[\"iOS\", \"iOS\"]"
  559. ],
  560. "app_id" : [
  561. "[\"muffinquest\", \"muffinquest\"]"
  562. ],
  563. "scale" : [
  564. "[MinKey, MaxKey]"
  565. ],
  566. "date" : [
  567. "[MinKey, MaxKey]"
  568. ]
  569. }
  570. }
  571. }
  572. }
  573. ]
  574. }
  575. ]
  576. }
  577. },
  578. "ok" : 1
  579. }
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!