API tools faq
paste
Guest User

Untitled

a guest
Jul 17th, 2018
74
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.19 KB | None | 0 0
raw download clone embed print report
  1. # Overall: 22.96k total, 433 unique, 0.04 QPS, 0.00x concurrency _________
  2. # Attribute total min max avg 95% stddev median
  3. # ============ ======= ======= ======= ======= ======= ======= =======
  4. # Exec time 784s 52us 28s 34ms 198ms 244ms 424us
  5. # Lock time 10s 0 925ms 429us 194us 7ms 44us
  6. # Rows sent 9.68M 0 71.18k 442.23 14.52 4.83k 0
  7. # Rows examine 151.17M 0 516.10k 6.74k 25.99k 24.76k 19.46
  8. # Query size 125.44M 6 563.66k 5.59k 1.33k 40.57k 136.99
  9.  
  10. # Profile
  11. # Rank Query ID Response time Calls R/Call Apdx V/M Item
  12. # ==== ================== ============== ===== ====== ==== ===== =========
  13. # 1 0xB39D3CED27CFF1AD 102.3351 13.1% 422 0.2425 1.00 0.04 SELECT people profiles contacts
  14. # 2 0x2A390B910A254AFB 75.0424 9.6% 425 0.1766 1.00 0.06 SELECT posts
  15. # 3 0x4F370509201BEC75 60.3600 7.7% 156 0.3869 1.00 0.07 SELECT posts
  16. # 4 0x55F5DABE726A411A 55.3889 7.1% 94 0.5892 0.91 0.73 INSERT posts
  17. # 5 0x98BB16225DF2A1B4 53.3509 6.8% 65 0.8208 0.86 0.56 INSERT likes
  18. # 6 0x428B826F833F48F3 48.0580 6.1% 241 0.1994 0.99 2.79 SELECT posts
  19. # 7 0x26865BDDC8C8B6C0 28.1996 3.6% 10 2.8200 0.90 23.90 SELECT comments
  20. # 8 0x191C89287CB8E414 27.6889 3.5% 88 0.3146 0.99 0.13 SELECT posts taggings tags share_visibilities contacts
  21. # 9 0x80644FA471280AD5 26.6154 3.4% 132 0.2016 1.00 0.07 SELECT likes
  22. # 10 0x652B370C61C9FCD7 26.2715 3.4% 59 0.4453 0.97 0.70 SELECT posts taggings tags share_visibilities contacts
  23. # 11 0x527E495912360F9A 25.1979 3.2% 4502 0.0056 1.00 0.83 SELECT UNION posts share_visibilities contacts aspect_memberships posts aspect_visibilities
  24. # 12 0xD3149537461D9595 21.6611 2.8% 34 0.6371 0.90 0.39 INSERT comments
  25. # 13 0x4BD1440BDB2C0413 15.9888 2.0% 66 0.2423 0.98 1.67 SELECT posts taggings tags
  26. # 14 0xB0EBE079358088EF 12.8246 1.6% 530 0.0242 1.00 0.00 SELECT photos
  27. # 15 0x844C544D7D21495E 11.3475 1.4% 437 0.0260 1.00 0.00 SELECT photos
  28. # 16 0x7B4BB4BFFC566BD1 11.1310 1.4% 64 0.1739 1.00 0.02 SELECT posts
  29. # 17 0xB18ED384CA72F01B 11.0483 1.4% 52 0.2125 1.00 0.08 SELECT comments
  30. # 18 0xB82E18E031119E4F 8.8950 1.1% 11 0.8086 0.86 1.44 SELECT posts
  31. # 19 0xA790557D1869F6F6 7.7972 1.0% 1220 0.0064 1.00 0.03 SELECT photos
  32. # 20 0x19C8068B5C1997CD 5.7597 0.7% 4 1.4399 0.75 0.61 ROLLBACK
  33. # MISC 0xMISC 148.9911 19.0% 14352 0.0104 NS 0.0 <413 ITEMS>
  34.  
  35. # Query 1: 0.00 QPS, 0.00x concurrency, ID 0xB39D3CED27CFF1AD at byte 139694818
  36. # Attribute pct total min max avg 95% stddev median
  37. # ============ === ======= ======= ======= ======= ======= ======= =======
  38. # Count 1 422
  39. # Exec time 13 102s 170ms 1s 242ms 279ms 99ms 230ms
  40. # Lock time 0 64ms 91us 474us 151us 176us 30us 159us
  41. # Rows sent 0 735 0 15 1.74 4.96 2.69 0
  42. # Rows examine 16 24.81M 59.77k 64.80k 60.19k 59.57k 209.48 59.57k
  43. # Query size 0 515.56k 1.20k 1.33k 1.22k 1.20k 8.86 1.20k
  44. SELECT `people`.`id` AS t0_r0, `people`.`guid` AS t0_r1, `people`.`url` AS t0_r2, `people`.`diaspora_handle` AS t0_r3, `people`.`serialized_public_key` AS t0_r4, `people`.`owner_id` AS t0_r5, `people`.`created_at` AS t0_r6, `people`.`updated_at` AS t0_r7, `people`.`closed_account` AS t0_r8, `profiles`.`id` AS t1_r0, `profiles`.`diaspora_handle` AS t1_r1, `profiles`.`first_name` AS t1_r2, `profiles`.`last_name` AS t1_r3, `profiles`.`image_url` AS t1_r4, `profiles`.`image_url_small` AS t1_r5, `profiles`.`image_url_medium` AS t1_r6, `profiles`.`birthday` AS t1_r7, `profiles`.`gender` AS t1_r8, `profiles`.`bio` AS t1_r9, `profiles`.`searchable` AS t1_r10, `profiles`.`person_id` AS t1_r11, `profiles`.`created_at` AS t1_r12, `profiles`.`updated_at` AS t1_r13, `profiles`.`location` AS t1_r14, `profiles`.`full_name` AS t1_r15, `profiles`.`nsfw` AS t1_r16 FROM `people` INNER JOIN `profiles` ON `profiles`.`person_id` = `people`.`id` LEFT OUTER JOIN contacts ON contacts.user_id = xx AND contacts.person_id = people.id WHERE `profiles`.`searchable` = 1 AND ( profiles.full_name LIKE '%xx%' OR
  45. people.diaspora_handle LIKE 'xx%'
  46. ) ORDER BY contacts.user_id DESC, profiles.last_name ASC, profiles.first_name ASC LIMIT 4\G
  47.  
  48. # Query 2: 0.00 QPS, 0.00x concurrency, ID 0x2A390B910A254AFB at byte 96208352
  49. # Attribute pct total min max avg 95% stddev median
  50. # ============ === ======= ======= ======= ======= ======= ======= =======
  51. # Count 1 425
  52. # Exec time 9 75s 104ms 473ms 177ms 374ms 104ms 116ms
  53. # Lock time 30 3s 3ms 21ms 7ms 16ms 4ms 5ms
  54. # Rows sent 0 6.23k 15 15 15 15 0 15
  55. # Rows examine 4 6.34M 8.16k 34.71k 15.29k 33.17k 8.82k 10.29k
  56. # Query size 37 47.25M 61.66k 255.65k 113.85k 245.21k 63.79k 79.83k
  57. SELECT `posts`.* FROM `posts` WHERE `posts`.`id` IN (xx, xx, xx, xx, xx, xx /*... omitted 34920 items ...*/) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (posts.created_at < '2012-03-26 15:52:56') AND (posts.author_id NOT IN (xx,xx)) AND (posts.id NOT IN ('xx','xx','xx'/*... omitted 8 items ...*/)) ORDER BY posts.created_at desc LIMIT 15\G
  58.  
  59. # Query 3: 0.00 QPS, 0.00x concurrency, ID 0x4F370509201BEC75 at byte 106316791
  60. # Attribute pct total min max avg 95% stddev median
  61. # ============ === ======= ======= ======= ======= ======= ======= =======
  62. # Count 0 156
  63. # Exec time 7 60s 106ms 791ms 387ms 580ms 165ms 477ms
  64. # Lock time 34 3s 5ms 38ms 22ms 33ms 8ms 24ms
  65. # Rows sent 0 2.29k 15 15 15 15 0 15
  66. # Rows examine 5 8.72M 11.10k 214.32k 57.24k 68.96k 35.30k 68.96k
  67. # Query size 49 62.35M 78.51k 563.66k 409.28k 562.03k 181.10k 535.27k
  68. SELECT `posts`.* FROM `posts` WHERE `posts`.`id` IN (xx, xx, xx, xx, /*... omitted 72594 items ...*/) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (posts.created_at < '2012-03-26 21:06:35') ORDER BY posts.created_at desc LIMIT 15\G
  69.  
  70. # Query 4: 0.00 QPS, 0.00x concurrency, ID 0x55F5DABE726A411A at byte 140342547
  71. # Attribute pct total min max avg 95% stddev median
  72. # ============ === ======= ======= ======= ======= ======= ======= =======
  73. # Count 0 94
  74. # Exec time 7 55s 100ms 4s 589ms 2s 656ms 230ms
  75. # Lock time 0 6ms 43us 189us 66us 93us 21us 63us
  76. # Rows sent 0 0 0 0 0 0 0 0
  77. # Rows examine 0 0 0 0 0 0 0 0
  78. # Query size 0 91.54k 698 4.04k 997.17 1.33k 410.96 833.10
  79. INSERT INTO `posts` (`actor_url`, `author_id`, `comments_count`, `created_at`, `diaspora_handle`, `guid`, `image_height`, `image_url`, `image_width`, `interacted_at`, `likes_count`, `o_embed_cache_id`, `objectId`, `object_url`, `pending`, `processed_image`, `provider_display_name`, `public`, `random_string`, `remote_photo_name`, `remote_photo_path`, `reshares_count`, `root_guid`, `status_message_guid`, `text`, `type`, `unprocessed_image`, `updated_at`) VALUES (NULL, xx, 0, '2012-03-23 15:40:04', 'xx', 'xx', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, 0, NULL, NULL, 'xx', 'StatusMessage', NULL, '2012-03-23 15:40:33')\G
  80.  
  81. # Query 5: 0.00 QPS, 0.00x concurrency, ID 0x98BB16225DF2A1B4 at byte 132464126
  82. # Attribute pct total min max avg 95% stddev median
  83. # ============ === ======= ======= ======= ======= ======= ======= =======
  84. # Count 0 65
  85. # Exec time 6 53s 106ms 3s 821ms 2s 677ms 640ms
  86. # Lock time 0 3ms 35us 128us 49us 66us 14us 42us
  87. # Rows sent 0 0 0 0 0 0 0 0
  88. # Rows examine 0 0 0 0 0 0 0 0
  89. # Query size 0 96.91k 949 1.59k 1.49k 1.53k 235.40 1.53k
  90. INSERT INTO `likes` (`author_id`, `author_signature`, `created_at`, `guid`, `parent_author_signature`, `positive`, `target_id`, `target_type`, `updated_at`) VALUES (xx, 'xx', 1, xx, 'Post', '2012-03-24 20:50:33')\G
  91.  
  92. # Query 6: 0.00 QPS, 0.00x concurrency, ID 0x428B826F833F48F3 at byte 109274152
  93. # Attribute pct total min max avg 95% stddev median
  94. # ============ === ======= ======= ======= ======= ======= ======= =======
  95. # Count 1 241
  96. # Exec time 6 48s 185us 11s 199ms 279ms 746ms 116ms
  97. # Lock time 0 20ms 35us 459us 82us 152us 44us 63us
  98. # Rows sent 77 7.47M 0 71.18k 31.73k 68.96k 31.77k 25.99k
  99. # Rows examine 20 31.51M 0 285.87k 133.90k 283.86k 132.78k 54.03k
  100. # Query size 0 159.16k 347 4.88k 676.26 1.26k 576.44 685.39
  101. SELECT DISTINCT posts.id, posts.updated_at AS updated_at, posts.created_at AS created_at FROM `posts` WHERE `posts`.`author_id` IN (xx, xx, xx, xx, /*... omitted 133 items ...*/) AND `posts`.`public` = 1 AND `posts`.`pending` = 0 AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (`posts`.`created_at` < '2012-03-26 23:39:17') ORDER BY posts.created_at DESC\G
  102.  
  103. # Query 7: 0.00 QPS, 0.00x concurrency, ID 0x26865BDDC8C8B6C0 at byte 89489315
  104. # Attribute pct total min max avg 95% stddev median
  105. # ============ === ======= ======= ======= ======= ======= ======= =======
  106. # Count 0 10
  107. # Exec time 3 28s 112us 28s 3s 128ms 8s 152us
  108. # Lock time 0 393us 31us 59us 39us 47us 8us 38us
  109. # Rows sent 0 10 1 1 1 1 0 1
  110. # Rows examine 0 347.63k 0 173.82k 34.76k 165.97k 66.39k 0
  111. # Query size 0 1.16k 119 120 119.20 118.34 0 118.34
  112. SELECT COUNT(*) FROM `comments` WHERE (`comments`.`created_at` BETWEEN '2012-03-23 22:00:00' AND '2012-03-24 22:00:00')\G
  113.  
  114. # Query 8: 0.00 QPS, 0.00x concurrency, ID 0x191C89287CB8E414 at byte 134369587
  115. # Attribute pct total min max avg 95% stddev median
  116. # ============ === ======= ======= ======= ======= ======= ======= =======
  117. # Count 0 88
  118. # Exec time 3 28s 109ms 1s 315ms 580ms 203ms 293ms
  119. # Lock time 0 26ms 94us 13ms 291us 167us 1ms 144us
  120. # Rows sent 0 1.29k 15 15 15 15 0 15
  121. # Rows examine 1 1.61M 7.67k 38.37k 18.77k 27.29k 7.11k 18.47k
  122. # Query size 0 69.67k 740 1000 810.74 964.41 64.20 793.42
  123. SELECT DISTINCT posts.* FROM `posts` INNER JOIN `taggings` ON `taggings`.`taggable_id` = `posts`.`id` AND taggings.tagger_id IS NULL AND taggings.context = 'tags' AND `taggings`.`taggable_type` = 'Post' INNER JOIN `tags` ON `tags`.`id` = `taggings`.`tag_id` LEFT OUTER JOIN share_visibilities ON share_visibilities.shareable_id = posts.id AND share_visibilities.shareable_type = 'Post' LEFT OUTER JOIN contacts ON contacts.id = share_visibilities.contact_id WHERE `tags`.`id` IN (xx, xx, xx, xx, xx) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND ((`contacts`.`user_id` = xx OR (`posts`.`public` = 1 OR `posts`.`author_id` = xx))) AND (posts.created_at < '2012-03-23 05:22:24') ORDER BY posts.created_at desc LIMIT 15\G
  124.  
  125. # Query 9: 0.00 QPS, 0.00x concurrency, ID 0x80644FA471280AD5 at byte 131905376
  126. # Attribute pct total min max avg 95% stddev median
  127. # ============ === ======= ======= ======= ======= ======= ======= =======
  128. # Count 0 132
  129. # Exec time 3 27s 100ms 739ms 202ms 412ms 120ms 148ms
  130. # Lock time 0 5ms 25us 109us 39us 63us 13us 33us
  131. # Rows sent 0 132 1 1 1 1 0 1
  132. # Rows examine 0 3.50k 2 113 27.17 54.21 19.19 23.65
  133. # Query size 0 16.21k 124 126 125.78 124.25 0.72 124.25
  134. SELECT COUNT(*) FROM `likes` WHERE `likes`.`target_id` = xx AND `likes`.`target_type` = 'Post' AND `likes`.`positive` = 1\G
  135.  
  136. # Query 10: 0.00 QPS, 0.00x concurrency, ID 0x652B370C61C9FCD7 at byte 131364161
  137. # Attribute pct total min max avg 95% stddev median
  138. # ============ === ======= ======= ======= ======= ======= ======= =======
  139. # Count 0 59
  140. # Exec time 3 26s 106ms 4s 445ms 705ms 560ms 348ms
  141. # Lock time 0 9ms 93us 314us 156us 214us 38us 159us
  142. # Rows sent 0 885 15 15 15 15 0 15
  143. # Rows examine 0 1.47M 1.50k 93.68k 25.45k 40.32k 16.54k 20.37k
  144. # Query size 0 64.15k 842 2.96k 1.09k 2.27k 437.15 964.41
  145. SELECT DISTINCT posts.* FROM `posts` INNER JOIN `taggings` ON `taggings`.`taggable_id` = `posts`.`id` AND taggings.tagger_id IS NULL AND taggings.context = 'tags' AND `taggings`.`taggable_type` = 'Post' INNER JOIN `tags` ON `tags`.`id` = `taggings`.`tag_id` LEFT OUTER JOIN share_visibilities ON share_visibilities.shareable_id = posts.id AND share_visibilities.shareable_type = 'Post' LEFT OUTER JOIN contacts ON contacts.id = share_visibilities.contact_id WHERE `tags`.`id` IN (xx, xx, xx, /*... omitted 56 items ...*/) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND ((`contacts`.`user_id` = xx OR (`posts`.`public` = 1 OR `posts`.`author_id` = xx))) AND (posts.created_at < '2012-03-24 19:29:22') AND (posts.author_id NOT IN (xx,xx,xx,xx)) AND (posts.id NOT IN ('xx','xx','xx','xx')) ORDER BY posts.created_at desc LIMIT 15\G
  146.  
  147. # Query 11: 0.01 QPS, 0.00x concurrency, ID 0x527E495912360F9A at byte 109272213
  148. # Attribute pct total min max avg 95% stddev median
  149. # ============ === ======= ======= ======= ======= ======= ======= =======
  150. # Count 19 4502
  151. # Exec time 3 25s 532us 5s 6ms 17ms 68ms 1ms
  152. # Lock time 7 757ms 95us 9ms 168us 204us 126us 167us
  153. # Rows sent 0 41.25k 0 15 9.38 14.52 6.19 14.52
  154. # Rows examine 7 12.08M 0 81.72k 2.75k 14.47k 6.00k 223.14
  155. # Query size 4 5.84M 1.28k 1.61k 1.33k 1.33k 41.19 1.26k
  156. (SELECT DISTINCT posts.id, posts.updated_at AS updated_at, posts.created_at AS created_at FROM `posts` INNER JOIN `share_visibilities` ON `share_visibilities`.`shareable_id` = `posts`.`id` AND `share_visibilities`.`shareable_type` = 'Post' INNER JOIN `contacts` ON `contacts`.`id` = `share_visibilities`.`contact_id` INNER JOIN `aspect_memberships` ON `aspect_memberships`.`contact_id` = `contacts`.`id` WHERE `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND `share_visibilities`.`hidden` = 0 AND `posts`.`pending` = 0 AND `contacts`.`user_id` = 1 AND `contacts`.`receiving` = 1 AND `aspect_memberships`.`aspect_id` IN (xx, xx, xx, xx, xx) AND (`posts`.`created_at` < '2012-03-26 23:39:17') ORDER BY posts.created_at DESC LIMIT 15) UNION ALL (SELECT DISTINCT posts.id, posts.updated_at AS updated_at, posts.created_at AS created_at FROM `posts` INNER JOIN `aspect_visibilities` ON `aspect_visibilities`.`shareable_id` = `posts`.`id` AND `aspect_visibilities`.`shareable_type` = 'Post' WHERE `posts`.`author_id` = xx AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND `posts`.`pending` = 0 AND `aspect_visibilities`.`aspect_id` IN (xx, xx, xx, xx, xx) AND (`posts`.`created_at` < '2012-03-26 23:39:17') ORDER BY posts.created_at DESC LIMIT 15) ORDER BY created_at DESC LIMIT 15\G
  157.  
  158. # Query 12: 0.00 QPS, 0.00x concurrency, ID 0xD3149537461D9595 at byte 126453066
  159. # Attribute pct total min max avg 95% stddev median
  160. # ============ === ======= ======= ======= ======= ======= ======= =======
  161. # Count 0 34
  162. # Exec time 2 22s 104ms 2s 637ms 1s 496ms 539ms
  163. # Lock time 0 2ms 43us 100us 58us 76us 11us 57us
  164. # Rows sent 0 0 0 0 0 0 0 0
  165. # Rows examine 0 0 0 0 0 0 0 0
  166. # Query size 0 58.15k 1.02k 2.54k 1.71k 1.86k 213.73 1.61k
  167. INSERT INTO `comments` (`author_id`, `author_signature`, `commentable_id`, `commentable_type`, `created_at`, `guid`, `likes_count`, `parent_author_signature`, `text`, `updated_at`) VALUES (xx, 'xx', 0, 'xx', 'xx', '2012-03-24 03:15:31')\G
  168.  
  169. # Query 13: 0.00 QPS, 0.00x concurrency, ID 0x4BD1440BDB2C0413 at byte 109275603
  170. # Attribute pct total min max avg 95% stddev median
  171. # ============ === ======= ======= ======= ======= ======= ======= =======
  172. # Count 0 66
  173. # Exec time 2 16s 100ms 5s 242ms 241ms 636ms 134ms
  174. # Lock time 0 8ms 53us 224us 123us 176us 34us 119us
  175. # Rows sent 0 990 15 15 15 15 0 15
  176. # Rows examine 2 4.48M 1.78k 109.15k 69.58k 106.99k 32.58k 83.83k
  177. # Query size 0 55.37k 515 1.04k 859.03 1012.63 161.94 874.75
  178. SELECT posts.id FROM `posts` INNER JOIN `taggings` ON `taggings`.`taggable_id` = `posts`.`id` AND taggings.tagger_id IS NULL AND taggings.context = 'tags' AND `taggings`.`taggable_type` = 'Post' INNER JOIN `tags` ON `tags`.`id` = `taggings`.`tag_id` WHERE `posts`.`public` = 1 AND `posts`.`pending` = 0 AND `tags`.`id` IN (xx, xx, xx, ...) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (posts.created_at < '2012-03-26 23:39:17') ORDER BY posts.created_at desc LIMIT 15\G
  179.  
  180. # Query 14: 0.00 QPS, 0.00x concurrency, ID 0xB0EBE079358088EF at byte 91104911
  181. # Attribute pct total min max avg 95% stddev median
  182. # ============ === ======= ======= ======= ======= ======= ======= =======
  183. # Count 2 530
  184. # Exec time 1 13s 84us 126ms 24ms 31ms 10ms 23ms
  185. # Lock time 0 22ms 22us 124us 42us 54us 9us 42us
  186. # Rows sent 0 193 0 1 0.36 0.99 0.48 0
  187. # Rows examine 5 7.74M 0 16.35k 14.96k 15.96k 3.47k 15.20k
  188. # Query size 0 43.43k 83 84 83.91 80.10 0 80.10
  189. SELECT `photos`.* FROM `photos` WHERE `photos`.`guid` = 'xx' LIMIT 1\G
  190.  
  191. # Query 15: 0.00 QPS, 0.00x concurrency, ID 0x844C544D7D21495E at byte 91216261
  192. # Attribute pct total min max avg 95% stddev median
  193. # ============ === ======= ======= ======= ======= ======= ======= =======
  194. # Count 1 437
  195. # Exec time 1 11s 20ms 120ms 26ms 33ms 9ms 23ms
  196. # Lock time 0 19ms 25us 103us 43us 60us 12us 40us
  197. # Rows sent 0 0 0 0 0 0 0 0
  198. # Rows examine 4 6.75M 15.26k 16.33k 15.81k 15.96k 379.33 15.20k
  199. # Query size 0 49.85k 116 117 116.81 112.70 0.00 112.70
  200. SELECT `photos`.* FROM `photos` WHERE `photos`.`guid` = 'xx' AND `photos`.`author_id` = xx LIMIT 1\G
  201.  
  202. # Query 16: 0.00 QPS, 0.00x concurrency, ID 0x7B4BB4BFFC566BD1 at byte 124409211
  203. # Attribute pct total min max avg 95% stddev median
  204. # ============ === ======= ======= ======= ======= ======= ======= =======
  205. # Count 0 64
  206. # Exec time 1 11s 101ms 376ms 174ms 230ms 53ms 180ms
  207. # Lock time 0 10ms 63us 436us 151us 224us 60us 144us
  208. # Rows sent 19 1.90M 8.32k 38.53k 30.47k 33.17k 5.81k 33.17k
  209. # Rows examine 7 10.77M 17.89k 248.64k 172.40k 233.54k 89.24k 233.54k
  210. # Query size 0 92.98k 531 4.88k 1.45k 2.16k 851.03 1.26k
  211. SELECT DISTINCT posts.id, posts.updated_at AS updated_at, posts.created_at AS created_at FROM `posts` WHERE `posts`.`public` = 1 AND `posts`.`pending` = 0 AND `posts`.`author_id` IN (xx, xx, xx, /*... omitted 133 items ...*/) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (`posts`.`created_at` < '2012-03-25 19:34:58') ORDER BY posts.created_at DESC\G
  212.  
  213. # Query 17: 0.00 QPS, 0.00x concurrency, ID 0xB18ED384CA72F01B at byte 121953552
  214. # Attribute pct total min max avg 95% stddev median
  215. # ============ === ======= ======= ======= ======= ======= ======= =======
  216. # Count 0 52
  217. # Exec time 1 11s 101ms 656ms 212ms 501ms 131ms 163ms
  218. # Lock time 0 2ms 28us 77us 41us 57us 10us 40us
  219. # Rows sent 0 144 1 3 2.77 2.90 0.55 2.90
  220. # Rows examine 0 1.95k 2 266 38.33 183.58 59.16 13.83
  221. # Query size 0 7.89k 152 156 155.42 151.03 0 151.03
  222. SELECT `comments`.* FROM `comments` WHERE `comments`.`commentable_id` = xx AND `comments`.`commentable_type` = 'Post' ORDER BY created_at DESC LIMIT 3\G
  223.  
  224. # Query 18: 0.00 QPS, 0.00x concurrency, ID 0xB82E18E031119E4F at byte 98860030
  225. # Attribute pct total min max avg 95% stddev median
  226. # ============ === ======= ======= ======= ======= ======= ======= =======
  227. # Count 0 11
  228. # Exec time 1 9s 105ms 3s 809ms 3s 1s 138ms
  229. # Lock time 0 81ms 125us 30ms 7ms 22ms 10ms 1ms
  230. # Rows sent 0 165 15 15 15 15 0 15
  231. # Rows examine 0 191.05k 89 59.42k 17.37k 56.74k 24.58k 2.38k
  232. # Query size 1 1.49M 831 475.53k 138.56k 462.39k 200.76k 17.59k
  233. SELECT DISTINCT posts.* FROM `posts` WHERE `posts`.`pending` = 0 AND `posts`.`id` IN (xx, xx, xx, /*... omitted 60815 items ...*/) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (posts.created_at < '2012-03-26 18:54:28') ORDER BY posts.created_at DESC, posts.created_at desc LIMIT 15\G
  234.  
  235. # Query 19: 0.00 QPS, 0.00x concurrency, ID 0xA790557D1869F6F6 at byte 109911724
  236. # Attribute pct total min max avg 95% stddev median
  237. # ============ === ======= ======= ======= ======= ======= ======= =======
  238. # Count 5 1220
  239. # Exec time 0 8s 4ms 475ms 6ms 8ms 13ms 5ms
  240. # Lock time 0 71ms 27us 193us 58us 69us 10us 54us
  241. # Rows sent 0 0 0 0 0 0 0 0
  242. # Rows examine 12 18.83M 15.24k 16.35k 15.80k 15.96k 375.42 15.20k
  243. # Query size 0 96.85k 66 82 81.29 80.10 2.92 80.10
  244. SELECT 1 FROM `photos` WHERE `photos`.`guid` = BINARY 'xx' LIMIT 1\G
  245.  
  246. # Query 20: 0.00 QPS, 0.00x concurrency, ID 0x19C8068B5C1997CD at byte 148726654
  247. # Attribute pct total min max avg 95% stddev median
  248. # ============ === ======= ======= ======= ======= ======= ======= =======
  249. # Count 0 4
  250. # Exec time 0 6s 427ms 3s 1s 3s 939ms 2s
  251. # Lock time 0 0 0 0 0 0 0 0
  252. # Rows sent 0 0 0 0 0 0 0 0
  253. # Rows examine 0 0 0 0 0 0 0 0
  254. # Query size 0 32 8 8 8 8 0 8
  255. ROLLBACK\G
Add Comment
Please, Sign In to add comment
Public Pastes
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!