API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 17th, 2023
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.75 KB | None | 0 0
raw download clone embed print report
  1. QUERY PLAN
  2.  
  3. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  4. ----------------
  5. Delete on t_status (cost=17.73..1009103430.69 rows=0 width=0) (actual time=2536111.245..2536111.265 rows=0 loops=1)
  6. Delete on t_status_137000000_138000000 t_status_1
  7. Delete on t_status_138000000_139000000 t_status_2
  8. Delete on t_status_139000000_140000000 t_status_3
  9. Delete on t_status_140000000_141000000 t_status_4
  10. Delete on t_status_141000000_142000000 t_status_5
  11. Delete on t_status_142000000_143000000 t_status_6
  12. Delete on t_status_143000000_144000000 t_status_7
  13. Delete on t_status_144000000_145000000 t_status_8
  14. Delete on t_status_145000000_146000000 t_status_9
  15. Delete on t_status_146000000_147000000 t_status_10
  16. Delete on t_status_147000000_148000000 t_status_11
  17. Delete on t_status_148000000_149000000 t_status_12
  18. Delete on t_status_149000000_150000000 t_status_13
  19. Delete on t_status_150000000_151000000 t_status_14
  20. Delete on t_status_151000000_152000000 t_status_15
  21. Delete on t_status_152000000_153000000 t_status_16
  22. Delete on t_status_153000000_154000000 t_status_17
  23. Delete on t_status_154000000_155000000 t_status_18
  24. Delete on t_status_155000000_156000000 t_status_19
  25. Delete on t_status_156000000_157000000 t_status_20
  26. Delete on t_status_157000000_158000000 t_status_21
  27. Delete on t_status_158000000_159000000 t_status_22
  28. Delete on t_status_159000000_160000000 t_status_23
  29. Delete on t_status_160000000_161000000 t_status_24
  30. Delete on t_status_161000000_162000000 t_status_25
  31. Delete on t_status_162000000_163000000 t_status_26
  32. Delete on t_status_163000000_164000000 t_status_27
  33. Delete on t_status_164000000_165000000 t_status_28
  34. Delete on t_status_165000000_166000000 t_status_29
  35. Delete on t_status_166000000_167000000 t_status_30
  36. Delete on t_status_167000000_168000000 t_status_31
  37. Delete on t_status_168000000_169000000 t_status_32
  38. Delete on t_status_169000000_170000000 t_status_33
  39. Delete on t_status_170000000_171000000 t_status_34
  40. Delete on t_status_171000000_172000000 t_status_35
  41. Delete on t_status_172000000_173000000 t_status_36
  42. Delete on t_status_173000000_174000000 t_status_37
  43. Delete on t_status_174000000_175000000 t_status_38
  44. Delete on t_status_175000000_176000000 t_status_39
  45. Delete on t_status_176000000_177000000 t_status_40
  46. Delete on t_status_177000000_178000000 t_status_41
  47. Delete on t_status_178000000_179000000 t_status_42
  48. -> Merge Join (cost=17.73..1009103430.69 rows=29224764823 width=16) (actual time=911552.652..2536109.550 rows=21 loops=1)
  49. Merge Cond: (t_temp_streams_to_delete.id = t_status.stream_id)
  50. -> Index Scan using idx_t_temp_streams_to_delete__id on t_temp_streams_to_delete (cost=0.29..130779.30 rows=36734 width=10) (actual time=0.030..7.898 rows=36734 loops=1)
  51. -> Materialize (cost=17.44..570998876.24 rows=159115614 width=14) (actual time=73.044..2532297.649 rows=30713968 loops=1)
  52. -> Merge Append (cost=17.44..570601087.21 rows=159115614 width=14) (actual time=73.037..2524407.014 rows=30713968 loops=1)
  53. Sort Key: t_status.stream_id
  54. -> Index Scan using t_status_137000000_138000000_stream_id_idx on t_status_137000000_138000000 t_status_1 (cost=0.43..15007550.26 rows=4222522 width=14) (actual time=1.653..70794.780 rows=828766 loops=1)
  55. -> Index Scan using t_status_138000000_139000000_stream_id_idx on t_status_138000000_139000000 t_status_2 (cost=0.43..15862253.22 rows=4462986 width=14) (actual time=1.602..72099.329 rows=874563 loops=1)
  56. -> Index Scan using t_status_139000000_140000000_stream_id_idx on t_status_139000000_140000000 t_status_3 (cost=0.43..14224673.97 rows=4002236 width=14) (actual time=1.666..65647.163 rows=786878 loops=1)
  57. -> Index Scan using t_status_140000000_141000000_stream_id_idx on t_status_140000000_141000000 t_status_4 (cost=0.43..15753089.23 rows=4432320 width=14) (actual time=1.683..78092.500 rows=869081 loops=1)
  58. -> Index Scan using t_status_141000000_142000000_stream_id_idx on t_status_141000000_142000000 t_status_5 (cost=0.43..14681466.28 rows=4130790 width=14) (actual time=1.890..73663.192 rows=806881 loops=1)
  59. -> Index Scan using t_status_142000000_143000000_stream_id_idx on t_status_142000000_143000000 t_status_6 (cost=0.43..14775896.71 rows=4157352 width=14) (actual time=1.946..72082.682 rows=812991 loops=1)
  60. -> Index Scan using t_status_143000000_144000000_stream_id_idx on t_status_143000000_144000000 t_status_7 (cost=0.30..3615033.49 rows=1017146 width=14) (actual time=1.382..17973.996 rows=200012 loops=1)
  61. -> Index Scan using t_status_144000000_145000000_stream_id_idx on t_status_144000000_145000000 t_status_8 (cost=0.43..13857516.71 rows=3898952 width=14) (actual time=1.732..68914.482 rows=763428 loops=1)
  62. -> Index Scan using t_status_145000000_146000000_stream_id_idx on t_status_145000000_146000000 t_status_9 (cost=0.43..16948032.59 rows=4768544 width=14) (actual time=1.983..76852.926 rows=919283 loops=1)
  63. -> Index Scan using t_status_146000000_147000000_stream_id_idx on t_status_146000000_147000000 t_status_10 (cost=0.43..15504206.72 rows=4362286 width=14) (actual time=1.599..70143.121 rows=842595 loops=1)
  64. -> Index Scan using t_status_147000000_148000000_stream_id_idx on t_status_147000000_148000000 t_status_11 (cost=0.43..15829500.42 rows=4453866 width=14) (actual time=1.878..72873.632 rows=858278 loops=1)
  65. -> Index Scan using t_status_148000000_149000000_stream_id_idx on t_status_148000000_149000000 t_status_12 (cost=0.43..16953427.39 rows=4770064 width=14) (actual time=2.254..74173.764 rows=915680 loops=1)
  66. -> Index Scan using t_status_149000000_150000000_stream_id_idx on t_status_149000000_150000000 t_status_13 (cost=0.43..16200003.36 rows=4558062 width=14) (actual time=6.728..77317.984 rows=877401 loops=1)
  67. -> Index Scan using t_status_150000000_151000000_stream_id_idx on t_status_150000000_151000000 t_status_14 (cost=0.43..16724653.81 rows=4705692 width=14) (actual time=4.407..76464.900 rows=904116 loops=1)
  68. -> Index Scan using t_status_151000000_152000000_stream_id_idx on t_status_151000000_152000000 t_status_15 (cost=0.43..18303273.11 rows=5149912 width=14) (actual time=2.159..80111.795 rows=952655 loops=1)
  69. -> Index Scan using t_status_152000000_153000000_stream_id_idx on t_status_152000000_153000000 t_status_16 (cost=0.43..15503319.30 rows=4362058 width=14) (actual time=2.086..69530.265 rows=832990 loops=1)
  70. -> Index Scan using t_status_153000000_154000000_stream_id_idx on t_status_153000000_154000000 t_status_17 (cost=0.43..15610114.17 rows=4392116 width=14) (actual time=1.670..77054.921 rows=852015 loops=1)
  71. -> Index Scan using t_status_154000000_155000000_stream_id_idx on t_status_154000000_155000000 t_status_18 (cost=0.43..16296161.77 rows=4585156 width=14) (actual time=1.642..77225.133 rows=888373 loops=1)
  72. -> Index Scan using t_status_155000000_156000000_stream_id_idx on t_status_155000000_156000000 t_status_19 (cost=0.43..15656382.25 rows=4405188 width=14) (actual time=1.855..70905.473 rows=849352 loops=1)
  73. -> Index Scan using t_status_156000000_157000000_stream_id_idx on t_status_156000000_157000000 t_status_20 (cost=0.43..16843801.69 rows=4739284 width=14) (actual time=1.665..75645.530 rows=913365 loops=1)
  74. -> Index Scan using t_status_157000000_158000000_stream_id_idx on t_status_157000000_158000000 t_status_21 (cost=0.43..15876040.50 rows=4466938 width=14) (actual time=1.731..68530.263 rows=861256 loops=1)
  75. -> Index Scan using t_status_158000000_159000000_stream_id_idx on t_status_158000000_159000000 t_status_22 (cost=0.43..14671086.96 rows=4127902 width=14) (actual time=1.813..62875.972 rows=796728 loops=1)
  76. -> Index Scan using t_status_159000000_160000000_stream_id_idx on t_status_159000000_160000000 t_status_23 (cost=0.43..17277523.39 rows=4861264 width=14) (actual time=1.919..69087.187 rows=935719 loops=1)
  77. -> Index Scan using t_status_160000000_161000000_stream_id_idx on t_status_160000000_161000000 t_status_24 (cost=0.43..15799067.60 rows=4445278 width=14) (actual time=1.587..68085.843 rows=856581 loops=1)
  78. -> Index Scan using t_status_161000000_162000000_stream_id_idx on t_status_161000000_162000000 t_status_25 (cost=0.43..16763755.11 rows=4716712 width=14) (actual time=1.873..71185.674 rows=911636 loops=1)
  79. -> Index Scan using t_status_162000000_163000000_stream_id_idx on t_status_162000000_163000000 t_status_26 (cost=0.43..17566274.62 rows=4942546 width=14) (actual time=2.190..72911.991 rows=955360 loops=1)
  80. -> Index Scan using t_status_163000000_164000000_stream_id_idx on t_status_163000000_164000000 t_status_27 (cost=0.43..16261094.14 rows=4575314 width=14) (actual time=1.761..70348.135 rows=884629 loops=1)
  81. -> Index Scan using t_status_164000000_165000000_stream_id_idx on t_status_164000000_165000000 t_status_28 (cost=0.43..17404760.33 rows=4897060 width=14) (actual time=2.432..71449.156 rows=947678 loops=1)
  82. -> Index Scan using t_status_165000000_166000000_stream_id_idx on t_status_165000000_166000000 t_status_29 (cost=0.43..16688232.48 rows=4695470 width=14) (actual time=1.906..69161.158 rows=907229 loops=1)
  83. -> Index Scan using t_status_166000000_167000000_stream_id_idx on t_status_166000000_167000000 t_status_30 (cost=0.43..15968241.81 rows=4492892 width=14) (actual time=1.652..69326.850 rows=865521 loops=1)
  84. -> Index Scan using t_status_167000000_168000000_stream_id_idx on t_status_167000000_168000000 t_status_31 (cost=0.43..17186640.35 rows=4835728 width=14) (actual time=1.926..70101.118 rows=929507 loops=1)
  85. -> Index Scan using t_status_168000000_169000000_stream_id_idx on t_status_168000000_169000000 t_status_32 (cost=0.43..15716282.76 rows=4422022 width=14) (actual time=1.804..67814.909 rows=848853 loops=1)
  86. -> Index Scan using t_status_169000000_170000000_stream_id_idx on t_status_169000000_170000000 t_status_33 (cost=0.43..15925027.41 rows=4480732 width=14) (actual time=1.895..69709.986 rows=859510 loops=1)
  87. -> Index Scan using t_status_170000000_171000000_stream_id_idx on t_status_170000000_171000000 t_status_34 (cost=0.43..17255125.91 rows=4855032 width=14) (actual time=1.511..72055.162 rows=931445 loops=1)
  88. -> Index Scan using t_status_171000000_172000000_stream_id_idx on t_status_171000000_172000000 t_status_35 (cost=0.43..16121878.47 rows=4536136 width=14) (actual time=1.501..68556.232 rows=869351 loops=1)
  89. -> Index Scan using t_status_172000000_173000000_stream_id_idx on t_status_172000000_173000000 t_status_36 (cost=0.43..14876731.07 rows=4185776 width=14) (actual time=1.996..61595.129 rows=804268 loops=1)
  90. -> Index Scan using t_status_173000000_174000000_stream_id_idx on t_status_173000000_174000000 t_status_37 (cost=0.15..1229.85 rows=380 width=14) (actual time=0.008..0.008 rows=0 loops=1)
  91. -> Index Scan using t_status_174000000_175000000_stream_id_idx on t_status_174000000_175000000 t_status_38 (cost=0.15..1229.85 rows=380 width=14) (actual time=0.009..0.010 rows=0 loops=1)
  92. -> Index Scan using t_status_175000000_176000000_stream_id_idx on t_status_175000000_176000000 t_status_39 (cost=0.15..1229.85 rows=380 width=14) (actual time=0.007..0.007 rows=0 loops=1)
  93. -> Index Scan using t_status_176000000_177000000_stream_id_idx on t_status_176000000_177000000 t_status_40 (cost=0.15..1229.85 rows=380 width=14) (actual time=0.010..0.010 rows=0 loops=1)
  94. -> Index Scan using t_status_177000000_178000000_stream_id_idx on t_status_177000000_178000000 t_status_41 (cost=0.15..1229.85 rows=380 width=14) (actual time=0.006..0.006 rows=0 loops=1)
  95. -> Index Scan using t_status_178000000_179000000_stream_id_idx on t_status_178000000_179000000 t_status_42 (cost=0.15..1229.85 rows=380 width=14) (actual time=0.006..0.006 rows=0 loops=1)
  96. Planning Time: 267.898 ms
  97. Execution Time: 2536114.849 ms
  98. (93 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!