API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 17th, 2023
135
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 39.01 KB | None | 0 0
raw download clone embed print report
  1. QUERY PLAN
  2. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  3. Delete on t_status (cost=215029.18..85572821.89 rows=5158570390 width=12) (actual time=165465.776..165465.860 rows=0 loops=1)
  4. Delete on t_status_137000000_138000000 t_status_1
  5. Delete on t_status_138000000_139000000 t_status_2
  6. Delete on t_status_139000000_140000000 t_status_3
  7. Delete on t_status_140000000_141000000 t_status_4
  8. Delete on t_status_141000000_142000000 t_status_5
  9. Delete on t_status_142000000_143000000 t_status_6
  10. Delete on t_status_143000000_144000000 t_status_7
  11. Delete on t_status_144000000_145000000 t_status_8
  12. Delete on t_status_145000000_146000000 t_status_9
  13. Delete on t_status_146000000_147000000 t_status_10
  14. Delete on t_status_147000000_148000000 t_status_11
  15. Delete on t_status_148000000_149000000 t_status_12
  16. Delete on t_status_149000000_150000000 t_status_13
  17. Delete on t_status_150000000_151000000 t_status_14
  18. Delete on t_status_151000000_152000000 t_status_15
  19. Delete on t_status_152000000_153000000 t_status_16
  20. Delete on t_status_153000000_154000000 t_status_17
  21. Delete on t_status_154000000_155000000 t_status_18
  22. Delete on t_status_155000000_156000000 t_status_19
  23. Delete on t_status_156000000_157000000 t_status_20
  24. Delete on t_status_157000000_158000000 t_status_21
  25. Delete on t_status_158000000_159000000 t_status_22
  26. Delete on t_status_159000000_160000000 t_status_23
  27. Delete on t_status_160000000_161000000 t_status_24
  28. Delete on t_status_161000000_162000000 t_status_25
  29. Delete on t_status_162000000_163000000 t_status_26
  30. Delete on t_status_163000000_164000000 t_status_27
  31. Delete on t_status_164000000_165000000 t_status_28
  32. Delete on t_status_165000000_166000000 t_status_29
  33. Delete on t_status_166000000_167000000 t_status_30
  34. Delete on t_status_167000000_168000000 t_status_31
  35. Delete on t_status_168000000_169000000 t_status_32
  36. Delete on t_status_169000000_170000000 t_status_33
  37. Delete on t_status_170000000_171000000 t_status_34
  38. Delete on t_status_171000000_172000000 t_status_35
  39. Delete on t_status_172000000_173000000 t_status_36
  40. Delete on t_status_173000000_174000000 t_status_37
  41. Delete on t_status_174000000_175000000 t_status_38
  42. Delete on t_status_175000000_176000000 t_status_39
  43. Delete on t_status_176000000_177000000 t_status_40
  44. Delete on t_status_177000000_178000000 t_status_41
  45. Delete on t_status_178000000_179000000 t_status_42
  46. -> Merge Join (cost=215029.18..1974957.08 rows=117076627 width=12) (actual time=4193.222..4193.226 rows=0 loops=1)
  47. Merge Cond: (t_temp_streams_to_delete.id = t_status_1.stream_id)
  48. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.034..5.692 rows=33509 loops=1)
  49. -> Materialize (cost=215028.89..219172.18 rows=828658 width=10) (actual time=3954.340..4119.585 rows=828766 loops=1)
  50. -> Sort (cost=215028.89..217100.54 rows=828658 width=10) (actual time=3954.336..4033.252 rows=828766 loops=1)
  51. Sort Key: t_status_1.stream_id
  52. Sort Method: external merge Disk: 17912kB
  53. -> Seq Scan on t_status_137000000_138000000 t_status_1 (cost=0.00..119405.58 rows=828658 width=10) (actual time=0.375..3787.920 rows=828766 loops=1)
  54. -> Merge Join (cost=227506.87..2453134.40 rows=148115551 width=12) (actual time=4395.581..4435.585 rows=5 loops=1)
  55. Merge Cond: (t_temp_streams_to_delete.id = t_status_2.stream_id)
  56. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.011..5.129 rows=33795 loops=1)
  57. -> Materialize (cost=227506.58..231881.42 rows=874968 width=10) (actual time=4181.111..4357.894 rows=874563 loops=1)
  58. -> Sort (cost=227506.58..229694.00 rows=874968 width=10) (actual time=4181.108..4265.937 rows=874563 loops=1)
  59. Sort Key: t_status_2.stream_id
  60. Sort Method: external merge Disk: 18896kB
  61. -> Seq Scan on t_status_138000000_139000000 t_status_2 (cost=0.00..126196.68 rows=874968 width=10) (actual time=0.485..4004.789 rows=874563 loops=1)
  62. -> Merge Join (cost=203753.19..1796440.16 rows=105934128 width=12) (actual time=4153.477..4153.479 rows=0 loops=1)
  63. Merge Cond: (t_temp_streams_to_delete.id = t_status_3.stream_id)
  64. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.018..5.558 rows=34278 loops=1)
  65. -> Materialize (cost=203752.90..207689.31 rows=787282 width=10) (actual time=3925.294..4083.287 rows=786878 loops=1)
  66. -> Sort (cost=203752.90..205721.10 rows=787282 width=10) (actual time=3925.292..4001.253 rows=786878 loops=1)
  67. Sort Key: t_status_3.stream_id
  68. Sort Method: external merge Disk: 17008kB
  69. -> Seq Scan on t_status_139000000_140000000 t_status_3 (cost=0.00..113194.82 rows=787282 width=10) (actual time=0.474..3754.877 rows=786878 loops=1)
  70. -> Merge Join (cost=225998.62..2625952.21 rows=159738166 width=12) (actual time=4647.508..4647.510 rows=0 loops=1)
  71. Merge Cond: (t_temp_streams_to_delete.id = t_status_4.stream_id)
  72. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.012..5.223 rows=34428 loops=1)
  73. -> Materialize (cost=225998.33..230346.84 rows=869702 width=10) (actual time=4365.411..4563.534 rows=869081 loops=1)
  74. -> Sort (cost=225998.33..228172.58 rows=869702 width=10) (actual time=4365.409..4457.921 rows=869081 loops=1)
  75. Sort Key: t_status_4.stream_id
  76. Sort Method: external merge Disk: 18776kB
  77. -> Seq Scan on t_status_140000000_141000000 t_status_4 (cost=0.00..125337.02 rows=869702 width=10) (actual time=0.408..4186.561 rows=869081 loops=1)
  78. -> Merge Join (cost=209658.83..1756111.97 rows=102848695 width=12) (actual time=4589.338..4589.339 rows=0 loops=1)
  79. Merge Cond: (t_temp_streams_to_delete.id = t_status_5.stream_id)
  80. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.012..11.292 rows=34940 loops=1)
  81. -> Materialize (cost=209658.54..213690.28 rows=806349 width=10) (actual time=4081.455..4429.979 rows=806881 loops=1)
  82. -> Sort (cost=209658.54..211674.41 rows=806349 width=10) (actual time=4081.452..4246.135 rows=806881 loops=1)
  83. Sort Key: t_status_5.stream_id
  84. Sort Method: external merge Disk: 17440kB
  85. -> Seq Scan on t_status_141000000_142000000 t_status_5 (cost=0.00..116768.49 rows=806349 width=10) (actual time=1.572..3891.591 rows=806881 loops=1)
  86. -> Merge Join (cost=211241.51..2454944.05 rows=149330873 width=12) (actual time=4528.688..4528.691 rows=0 loops=1)
  87. Merge Cond: (t_temp_streams_to_delete.id = t_status_6.stream_id)
  88. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.016..5.447 rows=35041 loops=1)
  89. -> Materialize (cost=211241.22..215306.42 rows=813039 width=10) (actual time=4257.952..4444.349 rows=812991 loops=1)
  90. -> Sort (cost=211241.22..213273.82 rows=813039 width=10) (actual time=4257.948..4348.895 rows=812991 loops=1)
  91. Sort Key: t_status_6.stream_id
  92. Sort Method: external merge Disk: 17568kB
  93. -> Seq Scan on t_status_142000000_143000000 t_status_6 (cost=0.00..117534.39 rows=813039 width=10) (actual time=0.470..4068.222 rows=812991 loops=1)
  94. -> Merge Join (cost=49699.07..499926.79 rows=29868190 width=12) (actual time=1127.611..1127.613 rows=0 loops=1)
  95. Merge Cond: (t_temp_streams_to_delete.id = t_status_7.stream_id)
  96. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.010..5.305 rows=35102 loops=1)
  97. -> Materialize (cost=49698.78..50694.82 rows=199208 width=10) (actual time=1064.157..1103.747 rows=200012 loops=1)
  98. -> Sort (cost=49698.78..50196.80 rows=199208 width=10) (actual time=1064.153..1082.558 rows=200012 loops=1)
  99. Sort Key: t_status_7.stream_id
  100. Sort Method: external merge Disk: 4320kB
  101. -> Seq Scan on t_status_143000000_144000000 t_status_7 (cost=0.00..28759.08 rows=199208 width=10) (actual time=0.456..1018.552 rows=200012 loops=1)
  102. -> Merge Join (cost=197233.81..1906766.16 rows=113728614 width=12) (actual time=4133.514..4133.515 rows=0 loops=1)
  103. Merge Cond: (t_temp_streams_to_delete.id = t_status_8.stream_id)
  104. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.011..8.475 rows=35742 loops=1)
  105. -> Materialize (cost=197233.52..201026.12 rows=758521 width=10) (actual time=3815.631..4039.000 rows=763428 loops=1)
  106. -> Sort (cost=197233.52..199129.82 rows=758521 width=10) (actual time=3815.628..3930.723 rows=763428 loops=1)
  107. Sort Key: t_status_8.stream_id
  108. Sort Method: external merge Disk: 16496kB
  109. -> Seq Scan on t_status_144000000_145000000 t_status_8 (cost=0.00..110189.21 rows=758521 width=10) (actual time=0.440..3646.179 rows=763428 loops=1)
  110. -> Merge Join (cost=241443.41..2778003.26 rows=168836994 width=12) (actual time=5063.640..5063.641 rows=0 loops=1)
  111. Merge Cond: (t_temp_streams_to_delete.id = t_status_9.stream_id)
  112. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.011..5.454 rows=35876 loops=1)
  113. -> Materialize (cost=241443.12..246039.32 rows=919241 width=10) (actual time=4794.108..4980.682 rows=919283 loops=1)
  114. -> Sort (cost=241443.12..243741.22 rows=919241 width=10) (actual time=4794.105..4884.878 rows=919283 loops=1)
  115. Sort Key: t_status_9.stream_id
  116. Sort Method: external merge Disk: 19864kB
  117. -> Seq Scan on t_status_145000000_146000000 t_status_9 (cost=0.00..134680.41 rows=919241 width=10) (actual time=0.453..4597.372 rows=919283 loops=1)
  118. -> Merge Join (cost=220555.50..2545749.16 rows=154758689 width=12) (actual time=4710.933..4710.934 rows=0 loops=1)
  119. Merge Cond: (t_temp_streams_to_delete.id = t_status_10.stream_id)
  120. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.011..6.916 rows=36181 loops=1)
  121. -> Materialize (cost=220555.21..224768.16 rows=842591 width=10) (actual time=4312.626..4594.235 rows=842595 loops=1)
  122. -> Sort (cost=220555.21..222661.69 rows=842591 width=10) (actual time=4312.622..4451.712 rows=842595 loops=1)
  123. Sort Key: t_status_10.stream_id
  124. Sort Method: external merge Disk: 18208kB
  125. -> Seq Scan on t_status_146000000_147000000 t_status_10 (cost=0.00..123222.91 rows=842591 width=10) (actual time=0.499..4138.668 rows=842595 loops=1)
  126. -> Merge Join (cost=225138.44..2242995.17 rows=134266834 width=12) (actual time=4413.301..4567.324 rows=13 loops=1)
  127. Merge Cond: (t_temp_streams_to_delete.id = t_status_11.stream_id)
  128. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.013..6.294 rows=36435 loops=1)
  129. -> Materialize (cost=225138.15..229432.90 rows=858951 width=10) (actual time=4316.558..4490.431 rows=858278 loops=1)
  130. -> Sort (cost=225138.15..227285.53 rows=858951 width=10) (actual time=4316.555..4400.172 rows=858278 loops=1)
  131. Sort Key: t_status_11.stream_id
  132. Sort Method: external merge Disk: 18544kB
  133. -> Seq Scan on t_status_147000000_148000000 t_status_11 (cost=0.00..125796.51 rows=858951 width=10) (actual time=0.450..4129.036 rows=858278 loops=1)
  134. -> Merge Join (cost=241041.22..2768440.51 rows=168226843 width=12) (actual time=4793.500..4793.501 rows=0 loops=1)
  135. Merge Cond: (t_temp_streams_to_delete.id = t_status_12.stream_id)
  136. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.010..5.524 rows=36435 loops=1)
  137. -> Materialize (cost=241040.93..245620.53 rows=915919 width=10) (actual time=4529.755..4713.088 rows=915680 loops=1)
  138. -> Sort (cost=241040.93..243330.73 rows=915919 width=10) (actual time=4529.752..4617.774 rows=915680 loops=1)
  139. Sort Key: t_status_12.stream_id
  140. Sort Method: external merge Disk: 19784kB
  141. -> Seq Scan on t_status_148000000_149000000 t_status_12 (cost=0.00..134687.19 rows=915919 width=10) (actual time=0.432..4331.702 rows=915680 loops=1)
  142. -> Merge Join (cost=230226.97..2390463.61 rows=143755885 width=12) (actual time=4606.847..4606.849 rows=0 loops=1)
  143. Merge Cond: (t_temp_streams_to_delete.id = t_status_13.stream_id)
  144. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.012..5.463 rows=36435 loops=1)
  145. -> Materialize (cost=230226.68..234609.72 rows=876608 width=10) (actual time=4352.369..4528.845 rows=877401 loops=1)
  146. -> Sort (cost=230226.68..232418.20 rows=876608 width=10) (actual time=4352.365..4436.458 rows=877401 loops=1)
  147. Sort Key: t_status_13.stream_id
  148. Sort Method: external merge Disk: 18960kB
  149. -> Seq Scan on t_status_149000000_150000000 t_status_13 (cost=0.00..128715.08 rows=876608 width=10) (actual time=0.515..4160.582 rows=877401 loops=1)
  150. -> Merge Join (cost=237871.72..2734739.40 rows=166193248 width=12) (actual time=4854.334..4854.336 rows=0 loops=1)
  151. Merge Cond: (t_temp_streams_to_delete.id = t_status_14.stream_id)
  152. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.012..5.502 rows=36435 loops=1)
  153. -> Materialize (cost=237871.43..242395.67 rows=904847 width=10) (actual time=4584.073..4773.080 rows=904116 loops=1)
  154. -> Sort (cost=237871.43..240133.55 rows=904847 width=10) (actual time=4584.069..4671.366 rows=904116 loops=1)
  155. Sort Key: t_status_14.stream_id
  156. Sort Method: external merge Disk: 19536kB
  157. -> Seq Scan on t_status_150000000_151000000 t_status_14 (cost=0.00..132882.47 rows=904847 width=10) (actual time=0.782..4377.241 rows=904116 loops=1)
  158. -> Merge Join (cost=254257.54..2848202.02 rows=172659167 width=12) (actual time=5166.230..5166.232 rows=0 loops=1)
  159. Merge Cond: (t_temp_streams_to_delete.id = t_status_15.stream_id)
  160. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.021..5.547 rows=36435 loops=1)
  161. -> Materialize (cost=254257.25..258957.51 rows=940051 width=10) (actual time=4888.243..5081.709 rows=952655 loops=1)
  162. -> Sort (cost=254257.25..256607.38 rows=940051 width=10) (actual time=4888.241..4980.256 rows=952655 loops=1)
  163. Sort Key: t_status_15.stream_id
  164. Sort Method: external merge Disk: 20576kB
  165. -> Seq Scan on t_status_151000000_152000000 t_status_15 (cost=0.00..144924.51 rows=940051 width=10) (actual time=0.459..4679.632 rows=952655 loops=1)
  166. -> Merge Join (cost=219296.12..2135873.42 rows=127519173 width=12) (actual time=4400.455..4432.169 rows=2 loops=1)
  167. Merge Cond: (t_temp_streams_to_delete.id = t_status_16.stream_id)
  168. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.011..5.522 rows=36435 loops=1)
  169. -> Materialize (cost=219295.83..223461.54 rows=833141 width=10) (actual time=4188.074..4357.140 rows=832990 loops=1)
  170. -> Sort (cost=219295.83..221378.69 rows=833141 width=10) (actual time=4188.072..4269.046 rows=832990 loops=1)
  171. Sort Key: t_status_16.stream_id
  172. Sort Method: external merge Disk: 18000kB
  173. -> Seq Scan on t_status_152000000_153000000 t_status_16 (cost=0.00..123122.41 rows=833141 width=10) (actual time=0.685..4022.782 rows=832990 loops=1)
  174. -> Merge Join (cost=222457.49..2204829.26 rows=131902494 width=12) (actual time=4450.990..4450.991 rows=0 loops=1)
  175. Merge Cond: (t_temp_streams_to_delete.id = t_status_17.stream_id)
  176. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.011..5.670 rows=36439 loops=1)
  177. -> Materialize (cost=222457.20..226712.24 rows=851007 width=10) (actual time=4205.371..4375.503 rows=852015 loops=1)
  178. -> Sort (cost=222457.20..224584.72 rows=851007 width=10) (actual time=4205.359..4286.836 rows=852015 loops=1)
  179. Sort Key: t_status_17.stream_id
  180. Sort Method: external merge Disk: 18408kB
  181. -> Seq Scan on t_status_153000000_154000000 t_status_17 (cost=0.00..124092.07 rows=851007 width=10) (actual time=0.499..4005.388 rows=852015 loops=1)
  182. -> Merge Join (cost=232560.04..2685169.06 rows=163245345 width=12) (actual time=5199.269..5199.271 rows=0 loops=1)
  183. Merge Cond: (t_temp_streams_to_delete.id = t_status_18.stream_id)
  184. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.013..5.553 rows=36443 loops=1)
  185. -> Materialize (cost=232559.75..237003.74 rows=888797 width=10) (actual time=4940.722..5120.041 rows=888373 loops=1)
  186. -> Sort (cost=232559.75..234781.75 rows=888797 width=10) (actual time=4940.720..5026.743 rows=888373 loops=1)
  187. Sort Key: t_status_18.stream_id
  188. Sort Method: external merge Disk: 19192kB
  189. -> Seq Scan on t_status_154000000_155000000 t_status_18 (cost=0.00..129549.97 rows=888797 width=10) (actual time=0.443..4747.177 rows=888373 loops=1)
  190. -> Merge Join (cost=222612.70..1960261.78 rows=115587885 width=12) (actual time=4586.822..4619.691 rows=1 loops=1)
  191. Merge Cond: (t_temp_streams_to_delete.id = t_status_19.stream_id)
  192. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.019..5.572 rows=36443 loops=1)
  193. -> Materialize (cost=222612.41..226860.34 rows=849587 width=10) (actual time=4374.468..4544.524 rows=849352 loops=1)
  194. -> Sort (cost=222612.41..224736.37 rows=849587 width=10) (actual time=4374.465..4455.944 rows=849352 loops=1)
  195. Sort Key: t_status_19.stream_id
  196. Sort Method: external merge Disk: 18352kB
  197. -> Seq Scan on t_status_155000000_156000000 t_status_19 (cost=0.00..124421.87 rows=849587 width=10) (actual time=0.527..4179.975 rows=849352 loops=1)
  198. -> Merge Join (cost=239899.93..2760435.67 rows=167769688 width=12) (actual time=5221.010..5221.012 rows=0 loops=1)
  199. Merge Cond: (t_temp_streams_to_delete.id = t_status_20.stream_id)
  200. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.011..5.530 rows=36443 loops=1)
  201. -> Materialize (cost=239899.64..244466.79 rows=913430 width=10) (actual time=4944.418..5136.812 rows=913365 loops=1)
  202. -> Sort (cost=239899.64..242183.21 rows=913430 width=10) (actual time=4944.414..5037.773 rows=913365 loops=1)
  203. Sort Key: t_status_20.stream_id
  204. Sort Method: external merge Disk: 19736kB
  205. -> Seq Scan on t_status_156000000_157000000 t_status_20 (cost=0.00..133852.30 rows=913430 width=10) (actual time=0.533..4749.942 rows=913365 loops=1)
  206. -> Merge Join (cost=225843.92..2303042.51 rows=138222503 width=12) (actual time=4639.320..4639.321 rows=0 loops=1)
  207. Merge Cond: (t_temp_streams_to_delete.id = t_status_21.stream_id)
  208. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.012..5.706 rows=36443 loops=1)
  209. -> Materialize (cost=225843.63..230152.03 rows=861680 width=10) (actual time=4386.328..4562.579 rows=861256 loops=1)
  210. -> Sort (cost=225843.63..227997.83 rows=861680 width=10) (actual time=4386.325..4472.298 rows=861256 loops=1)
  211. Sort Key: t_status_21.stream_id
  212. Sort Method: external merge Disk: 18608kB
  213. -> Seq Scan on t_status_157000000_158000000 t_status_21 (cost=0.00..126167.80 rows=861680 width=10) (actual time=0.421..4207.868 rows=861256 loops=1)
  214. -> Merge Join (cost=208322.29..2137755.27 rows=128382269 width=12) (actual time=4369.982..4369.983 rows=0 loops=1)
  215. Merge Cond: (t_temp_streams_to_delete.id = t_status_22.stream_id)
  216. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.012..6.102 rows=36646 loops=1)
  217. -> Materialize (cost=208322.00..212306.20 rows=796841 width=10) (actual time=4134.752..4297.478 rows=796728 loops=1)
  218. -> Sort (cost=208322.00..210314.10 rows=796841 width=10) (actual time=4134.750..4210.757 rows=796728 loops=1)
  219. Sort Key: t_status_22.stream_id
  220. Sort Method: external merge Disk: 17216kB
  221. -> Seq Scan on t_status_158000000_159000000 t_status_22 (cost=0.00..116597.41 rows=796841 width=10) (actual time=0.618..3978.529 rows=796728 loops=1)
  222. -> Merge Join (cost=246089.93..2828234.85 rows=171873243 width=12) (actual time=5346.014..5346.016 rows=0 loops=1)
  223. Merge Cond: (t_temp_streams_to_delete.id = t_status_23.stream_id)
  224. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.012..5.852 rows=36646 loops=1)
  225. -> Materialize (cost=246089.64..250768.50 rows=935772 width=10) (actual time=5069.339..5261.877 rows=935719 loops=1)
  226. -> Sort (cost=246089.64..248429.07 rows=935772 width=10) (actual time=5069.336..5162.450 rows=935719 loops=1)
  227. Sort Key: t_status_23.stream_id
  228. Sort Method: external merge Disk: 20216kB
  229. -> Seq Scan on t_status_159000000_160000000 t_status_23 (cost=0.00..137285.72 rows=935772 width=10) (actual time=0.426..4870.534 rows=935719 loops=1)
  230. -> Merge Join (cost=224688.30..2148756.70 rows=128014556 width=12) (actual time=4490.768..4490.770 rows=0 loops=1)
  231. Merge Cond: (t_temp_streams_to_delete.id = t_status_24.stream_id)
  232. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.012..5.704 rows=36655 loops=1)
  233. -> Materialize (cost=224688.01..228974.45 rows=857287 width=10) (actual time=4243.141..4414.718 rows=856581 loops=1)
  234. -> Sort (cost=224688.01..226831.23 rows=857287 width=10) (actual time=4243.139..4325.348 rows=856581 loops=1)
  235. Sort Key: t_status_24.stream_id
  236. Sort Method: external merge Disk: 18512kB
  237. -> Seq Scan on t_status_160000000_161000000 t_status_24 (cost=0.00..125553.87 rows=857287 width=10) (actual time=0.503..4052.834 rows=856581 loops=1)
  238. -> Merge Join (cost=239114.43..2755687.57 rows=167505754 width=12) (actual time=5284.522..5284.524 rows=0 loops=1)
  239. Merge Cond: (t_temp_streams_to_delete.id = t_status_25.stream_id)
  240. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.013..5.712 rows=36655 loops=1)
  241. -> Materialize (cost=239114.14..243674.11 rows=911993 width=10) (actual time=5017.712..5203.870 rows=911636 loops=1)
  242. -> Sort (cost=239114.14..241394.12 rows=911993 width=10) (actual time=5017.710..5108.513 rows=911636 loops=1)
  243. Sort Key: t_status_25.stream_id
  244. Sort Method: external merge Disk: 19696kB
  245. -> Seq Scan on t_status_161000000_162000000 t_status_25 (cost=0.00..133243.93 rows=911993 width=10) (actual time=0.479..4827.783 rows=911636 loops=1)
  246. -> Merge Join (cost=250514.47..2879898.99 rows=175019694 width=12) (actual time=5045.663..5045.665 rows=0 loops=1)
  247. Merge Cond: (t_temp_streams_to_delete.id = t_status_26.stream_id)
  248. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.019..5.961 rows=36655 loops=1)
  249. -> Materialize (cost=250514.18..255278.70 rows=952903 width=10) (actual time=4766.416..4960.276 rows=955360 loops=1)
  250. -> Sort (cost=250514.18..252896.44 rows=952903 width=10) (actual time=4766.413..4859.634 rows=955360 loops=1)
  251. Sort Key: t_status_26.stream_id
  252. Sort Method: external merge Disk: 20632kB
  253. -> Seq Scan on t_status_162000000_163000000 t_status_26 (cost=0.00..139596.03 rows=952903 width=10) (actual time=0.480..4553.819 rows=955360 loops=1)
  254. -> Merge Join (cost=231728.15..2672465.91 rows=162454646 width=12) (actual time=4639.315..4639.317 rows=0 loops=1)
  255. Merge Cond: (t_temp_streams_to_delete.id = t_status_27.stream_id)
  256. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.010..5.736 rows=36733 loops=1)
  257. -> Materialize (cost=231727.86..236150.32 rows=884492 width=10) (actual time=4377.103..4557.191 rows=884629 loops=1)
  258. -> Sort (cost=231727.86..233939.09 rows=884492 width=10) (actual time=4377.100..4463.508 rows=884629 loops=1)
  259. Sort Key: t_status_27.stream_id
  260. Sort Method: external merge Disk: 19112kB
  261. -> Seq Scan on t_status_163000000_164000000 t_status_27 (cost=0.00..129247.92 rows=884492 width=10) (actual time=0.604..4187.983 rows=884629 loops=1)
  262. -> Merge Join (cost=248266.74..2855927.28 rows=173572742 width=12) (actual time=4902.440..4902.441 rows=0 loops=1)
  263. Merge Cond: (t_temp_streams_to_delete.id = t_status_28.stream_id)
  264. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.011..5.697 rows=36733 loops=1)
  265. -> Materialize (cost=248266.45..252991.57 rows=945025 width=10) (actual time=4565.136..4802.500 rows=947678 loops=1)
  266. -> Sort (cost=248266.45..250629.01 rows=945025 width=10) (actual time=4565.132..4681.711 rows=947678 loops=1)
  267. Sort Key: t_status_28.stream_id
  268. Sort Method: external merge Disk: 20472kB
  269. -> Seq Scan on t_status_164000000_165000000 t_status_28 (cost=0.00..138320.25 rows=945025 width=10) (actual time=0.597..4369.098 rows=947678 loops=1)
  270. -> Merge Join (cost=237984.99..2742764.09 rows=166720198 width=12) (actual time=4801.197..4801.198 rows=0 loops=1)
  271. Merge Cond: (t_temp_streams_to_delete.id = t_status_29.stream_id)
  272. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.012..10.945 rows=36733 loops=1)
  273. -> Materialize (cost=237984.70..242523.28 rows=907716 width=10) (actual time=4506.714..4705.027 rows=907229 loops=1)
  274. -> Sort (cost=237984.70..240253.99 rows=907716 width=10) (actual time=4506.709..4601.562 rows=907229 loops=1)
  275. Sort Key: t_status_29.stream_id
  276. Sort Method: external merge Disk: 19600kB
  277. -> Seq Scan on t_status_165000000_166000000 t_status_29 (cost=0.00..132642.16 rows=907716 width=10) (actual time=0.857..4305.883 rows=907229 loops=1)
  278. -> Merge Join (cost=227119.07..2203078.79 rows=131472504 width=12) (actual time=4506.095..4506.096 rows=0 loops=1)
  279. Merge Cond: (t_temp_streams_to_delete.id = t_status_30.stream_id)
  280. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.015..5.790 rows=36734 loops=1)
  281. -> Materialize (cost=227118.78..231449.42 rows=866128 width=10) (actual time=4253.694..4428.757 rows=865521 loops=1)
  282. -> Sort (cost=227118.78..229284.10 rows=866128 width=10) (actual time=4253.688..4337.907 rows=865521 loops=1)
  283. Sort Key: t_status_30.stream_id
  284. Sort Method: external merge Disk: 18712kB
  285. -> Seq Scan on t_status_166000000_167000000 t_status_30 (cost=0.00..126895.28 rows=866128 width=10) (actual time=0.426..4072.579 rows=865990 loops=1)
  286. -> Merge Join (cost=244656.62..2811083.50 rows=170826324 width=12) (actual time=4956.916..4956.918 rows=0 loops=1)
  287. Merge Cond: (t_temp_streams_to_delete.id = t_status_31.stream_id)
  288. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.011..5.763 rows=36734 loops=1)
  289. -> Materialize (cost=244656.33..249306.69 rows=930072 width=10) (actual time=4687.654..4874.826 rows=929507 loops=1)
  290. -> Sort (cost=244656.33..246981.51 rows=930072 width=10) (actual time=4687.650..4777.443 rows=929507 loops=1)
  291. Sort Key: t_status_31.stream_id
  292. Sort Method: external merge Disk: 20088kB
  293. -> Seq Scan on t_status_167000000_168000000 t_status_31 (cost=0.00..136556.72 rows=930072 width=10) (actual time=0.465..4476.388 rows=929668 loops=1)
  294. -> Merge Join (cost=223094.14..2228196.38 rows=133418045 width=12) (actual time=4522.390..4522.391 rows=0 loops=1)
  295. Merge Cond: (t_temp_streams_to_delete.id = t_status_32.stream_id)
  296. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.012..5.780 rows=36734 loops=1)
  297. -> Materialize (cost=223093.85..227343.29 rows=849889 width=10) (actual time=4275.182..4446.068 rows=848853 loops=1)
  298. -> Sort (cost=223093.85..225218.57 rows=849889 width=10) (actual time=4275.179..4357.339 rows=848853 loops=1)
  299. Sort Key: t_status_32.stream_id
  300. Sort Method: external merge Disk: 18352kB
  301. -> Seq Scan on t_status_168000000_169000000 t_status_32 (cost=0.00..124867.89 rows=849889 width=10) (actual time=0.466..4095.450 rows=849375 loops=1)
  302. -> Merge Join (cost=226017.76..2180536.81 rows=130044104 width=12) (actual time=4541.967..4541.968 rows=0 loops=1)
  303. Merge Cond: (t_temp_streams_to_delete.id = t_status_33.stream_id)
  304. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.012..5.681 rows=36734 loops=1)
  305. -> Materialize (cost=226017.47..230318.76 rows=860258 width=10) (actual time=4289.217..4463.600 rows=859510 loops=1)
  306. -> Sort (cost=226017.47..228168.12 rows=860258 width=10) (actual time=4289.213..4372.659 rows=859510 loops=1)
  307. Sort Key: t_status_33.stream_id
  308. Sort Method: external merge Disk: 18584kB
  309. -> Seq Scan on t_status_169000000_170000000 t_status_33 (cost=0.00..126516.58 rows=860258 width=10) (actual time=0.486..4097.159 rows=859919 loops=1)
  310. -> Merge Join (cost=245357.48..2815774.55 rows=171092095 width=12) (actual time=4893.187..4893.188 rows=0 loops=1)
  311. Merge Cond: (t_temp_streams_to_delete.id = t_status_34.stream_id)
  312. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.012..5.754 rows=36734 loops=1)
  313. -> Materialize (cost=245357.19..250014.79 rows=931519 width=10) (actual time=4612.341..4807.198 rows=931445 loops=1)
  314. -> Sort (cost=245357.19..247685.99 rows=931519 width=10) (actual time=4612.338..4706.170 rows=931445 loops=1)
  315. Sort Key: t_status_34.stream_id
  316. Sort Method: external merge Disk: 20128kB
  317. -> Seq Scan on t_status_170000000_171000000 t_status_34 (cost=0.00..137079.19 rows=931519 width=10) (actual time=0.481..4413.987 rows=931535 loops=1)
  318. -> Merge Join (cost=228794.62..2255822.92 rows=134876398 width=12) (actual time=4671.804..4671.806 rows=0 loops=1)
  319. Merge Cond: (t_temp_streams_to_delete.id = t_status_35.stream_id)
  320. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.019..5.786 rows=36734 loops=1)
  321. -> Materialize (cost=228794.33..233145.30 rows=870194 width=10) (actual time=4417.515..4593.195 rows=869351 loops=1)
  322. -> Sort (cost=228794.33..230969.82 rows=870194 width=10) (actual time=4417.510..4501.493 rows=869351 loops=1)
  323. Sort Key: t_status_35.stream_id
  324. Sort Method: external merge Disk: 18800kB
  325. -> Seq Scan on t_status_171000000_172000000 t_status_35 (cost=0.00..128073.94 rows=870194 width=10) (actual time=0.455..4235.653 rows=870067 loops=1)
  326. -> Merge Join (cost=210999.92..2214122.49 rows=133293456 width=12) (actual time=4359.071..4359.072 rows=0 loops=1)
  327. Merge Cond: (t_temp_streams_to_delete.id = t_status_36.stream_id)
  328. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (actual time=0.011..5.763 rows=36734 loops=1)
  329. -> Materialize (cost=210999.63..215027.39 rows=805552 width=10) (actual time=4126.060..4287.241 rows=804268 loops=1)
  330. -> Sort (cost=210999.63..213013.51 rows=805552 width=10) (actual time=4126.056..4203.228 rows=804268 loops=1)
  331. Sort Key: t_status_36.stream_id
  332. Sort Method: external merge Disk: 17400kB
  333. -> Seq Scan on t_status_172000000_173000000 t_status_36 (cost=0.00..118207.52 rows=805552 width=10) (actual time=0.623..3946.861 rows=805272 loops=1)
  334. -> Merge Join (cost=0.44..2713.02 rows=69795 width=12) (actual time=0.011..0.012 rows=0 loops=1)
  335. Merge Cond: (t_status_37.stream_id = t_temp_streams_to_delete.id)
  336. -> Index Scan using t_status_173000000_174000000_stream_id_idx on t_status_173000000_174000000 t_status_37 (cost=0.15..49.85 rows=380 width=10) (actual time=0.010..0.010 rows=0 loops=1)
  337. -> Materialize (cost=0.29..1707.14 rows=36734 width=10) (never executed)
  338. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (never executed)
  339. -> Merge Join (cost=0.44..2713.02 rows=69795 width=12) (actual time=0.007..0.008 rows=0 loops=1)
  340. Merge Cond: (t_status_38.stream_id = t_temp_streams_to_delete.id)
  341. -> Index Scan using t_status_174000000_175000000_stream_id_idx on t_status_174000000_175000000 t_status_38 (cost=0.15..49.85 rows=380 width=10) (actual time=0.006..0.006 rows=0 loops=1)
  342. -> Materialize (cost=0.29..1707.14 rows=36734 width=10) (never executed)
  343. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (never executed)
  344. -> Merge Join (cost=0.44..2713.02 rows=69795 width=12) (actual time=0.006..0.006 rows=0 loops=1)
  345. Merge Cond: (t_status_39.stream_id = t_temp_streams_to_delete.id)
  346. -> Index Scan using t_status_175000000_176000000_stream_id_idx on t_status_175000000_176000000 t_status_39 (cost=0.15..49.85 rows=380 width=10) (actual time=0.005..0.005 rows=0 loops=1)
  347. -> Materialize (cost=0.29..1707.14 rows=36734 width=10) (never executed)
  348. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (never executed)
  349. -> Merge Join (cost=0.44..2713.02 rows=69795 width=12) (actual time=0.005..0.005 rows=0 loops=1)
  350. Merge Cond: (t_status_40.stream_id = t_temp_streams_to_delete.id)
  351. -> Index Scan using t_status_176000000_177000000_stream_id_idx on t_status_176000000_177000000 t_status_40 (cost=0.15..49.85 rows=380 width=10) (actual time=0.004..0.004 rows=0 loops=1)
  352. -> Materialize (cost=0.29..1707.14 rows=36734 width=10) (never executed)
  353. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (never executed)
  354. -> Merge Join (cost=0.44..2713.02 rows=69795 width=12) (actual time=0.004..0.005 rows=0 loops=1)
  355. Merge Cond: (t_status_41.stream_id = t_temp_streams_to_delete.id)
  356. -> Index Scan using t_status_177000000_178000000_stream_id_idx on t_status_177000000_178000000 t_status_41 (cost=0.15..49.85 rows=380 width=10) (actual time=0.003..0.004 rows=0 loops=1)
  357. -> Materialize (cost=0.29..1707.14 rows=36734 width=10) (never executed)
  358. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (never executed)
  359. -> Merge Join (cost=0.44..2713.02 rows=69795 width=12) (actual time=0.005..0.006 rows=0 loops=1)
  360. Merge Cond: (t_status_42.stream_id = t_temp_streams_to_delete.id)
  361. -> Index Scan using t_status_178000000_179000000_stream_id_idx on t_status_178000000_179000000 t_status_42 (cost=0.15..49.85 rows=380 width=10) (actual time=0.004..0.004 rows=0 loops=1)
  362. -> Materialize (cost=0.29..1707.14 rows=36734 width=10) (never executed)
  363. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..1615.30 rows=36734 width=10) (never executed)
  364. Planning Time: 193.030 ms
  365. Execution Time: 165495.960 ms
  366. (363 rows)
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!