API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 17th, 2023
116
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.72 KB | None | 0 0
raw download clone embed print report
  1. QUERY PLAN
  2. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  3. Delete on t_status (cost=17.48..195106001.53 rows=0 width=0) (actual time=2483799.047..2483799.066 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=17.48..195106001.53 rows=5642273524 width=16) (actual time=888433.234..2483796.475 rows=21 loops=1)
  47. Merge Cond: (t_temp_streams_to_delete.id = t_status.stream_id)
  48. -> 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.012..8.646 rows=36734 loops=1)
  49. -> Materialize (cost=17.19..110417826.60 rows=30719625 width=14) (actual time=70.369..2480021.869 rows=30713968 loops=1)
  50. -> Merge Append (cost=17.19..110341027.53 rows=30719625 width=14) (actual time=70.363..2472281.740 rows=30713968 loops=1)
  51. Sort Key: t_status.stream_id
  52. -> Index Scan using t_status_137000000_138000000_stream_id_idx on t_status_137000000_138000000 t_status_1 (cost=0.42..2950311.92 rows=828766 width=14) (actual time=2.021..69074.094 rows=828766 loops=1)
  53. -> Index Scan using t_status_138000000_139000000_stream_id_idx on t_status_138000000_139000000 t_status_2 (cost=0.42..3113358.87 rows=874563 width=14) (actual time=1.681..71274.689 rows=874563 loops=1)
  54. -> Index Scan using t_status_139000000_140000000_stream_id_idx on t_status_139000000_140000000 t_status_3 (cost=0.42..2801191.59 rows=786878 width=14) (actual time=1.901..63948.543 rows=786878 loops=1)
  55. -> Index Scan using t_status_140000000_141000000_stream_id_idx on t_status_140000000_141000000 t_status_4 (cost=0.42..3093824.64 rows=869081 width=14) (actual time=1.770..76748.619 rows=869081 loops=1)
  56. -> Index Scan using t_status_141000000_142000000_stream_id_idx on t_status_141000000_142000000 t_status_5 (cost=0.42..2872419.64 rows=806881 width=14) (actual time=2.298..73465.780 rows=806881 loops=1)
  57. -> Index Scan using t_status_142000000_143000000_stream_id_idx on t_status_142000000_143000000 t_status_6 (cost=0.42..2894159.29 rows=812991 width=14) (actual time=2.061..71561.728 rows=812991 loops=1)
  58. -> Index Scan using t_status_143000000_144000000_stream_id_idx on t_status_143000000_144000000 t_status_7 (cost=0.29..711996.48 rows=200012 width=14) (actual time=1.132..17453.225 rows=200012 loops=1)
  59. -> Index Scan using t_status_144000000_145000000_stream_id_idx on t_status_144000000_145000000 t_status_8 (cost=0.42..2717711.84 rows=763428 width=14) (actual time=1.700..66680.806 rows=763428 loops=1)
  60. -> Index Scan using t_status_145000000_146000000_stream_id_idx on t_status_145000000_146000000 t_status_9 (cost=0.42..3272585.67 rows=919283 width=14) (actual time=1.549..75018.399 rows=919283 loops=1)
  61. -> Index Scan using t_status_146000000_147000000_stream_id_idx on t_status_146000000_147000000 t_status_10 (cost=0.42..2999587.35 rows=842595 width=14) (actual time=1.666..68005.091 rows=842595 loops=1)
  62. -> Index Scan using t_status_147000000_148000000_stream_id_idx on t_status_147000000_148000000 t_status_11 (cost=0.42..3055414.59 rows=858278 width=14) (actual time=1.636..72202.487 rows=858278 loops=1)
  63. -> Index Scan using t_status_148000000_149000000_stream_id_idx on t_status_148000000_149000000 t_status_12 (cost=0.42..3259795.62 rows=915680 width=14) (actual time=1.987..71724.483 rows=915680 loops=1)
  64. -> Index Scan using t_status_149000000_150000000_stream_id_idx on t_status_149000000_150000000 t_status_13 (cost=0.42..3123493.44 rows=877401 width=14) (actual time=1.738..74050.446 rows=877401 loops=1)
  65. -> Index Scan using t_status_150000000_151000000_stream_id_idx on t_status_150000000_151000000 t_status_14 (cost=0.42..3218602.17 rows=904116 width=14) (actual time=1.664..72837.832 rows=904116 loops=1)
  66. -> Index Scan using t_status_151000000_152000000_stream_id_idx on t_status_151000000_152000000 t_status_15 (cost=0.42..3391538.25 rows=952655 width=14) (actual time=1.461..76813.735 rows=952655 loops=1)
  67. -> Index Scan using t_status_152000000_153000000_stream_id_idx on t_status_152000000_153000000 t_status_16 (cost=0.42..2965419.27 rows=832990 width=14) (actual time=1.685..68346.907 rows=832990 loops=1)
  68. -> Index Scan using t_status_153000000_154000000_stream_id_idx on t_status_153000000_154000000 t_status_17 (cost=0.42..3033104.65 rows=852015 width=14) (actual time=1.634..75686.308 rows=852015 loops=1)
  69. -> Index Scan using t_status_154000000_155000000_stream_id_idx on t_status_154000000_155000000 t_status_18 (cost=0.42..3162534.02 rows=888373 width=14) (actual time=1.639..75020.487 rows=888373 loops=1)
  70. -> Index Scan using t_status_155000000_156000000_stream_id_idx on t_status_155000000_156000000 t_status_19 (cost=0.42..3023636.70 rows=849352 width=14) (actual time=1.700..71739.676 rows=849352 loops=1)
  71. -> Index Scan using t_status_156000000_157000000_stream_id_idx on t_status_156000000_157000000 t_status_20 (cost=0.42..3251516.90 rows=913365 width=14) (actual time=1.649..73637.684 rows=913365 loops=1)
  72. -> Index Scan using t_status_157000000_158000000_stream_id_idx on t_status_157000000_158000000 t_status_21 (cost=0.42..3066039.26 rows=861256 width=14) (actual time=1.776..66481.851 rows=861256 loops=1)
  73. -> Index Scan using t_status_158000000_159000000_stream_id_idx on t_status_158000000_159000000 t_status_22 (cost=0.42..2836311.34 rows=796728 width=14) (actual time=1.460..60992.528 rows=796728 loops=1)
  74. -> Index Scan using t_status_159000000_160000000_stream_id_idx on t_status_159000000_160000000 t_status_23 (cost=0.42..3331096.21 rows=935719 width=14) (actual time=3.091..69006.477 rows=935719 loops=1)
  75. -> Index Scan using t_status_160000000_161000000_stream_id_idx on t_status_160000000_161000000 t_status_24 (cost=0.42..3049373.14 rows=856581 width=14) (actual time=2.661..66365.184 rows=856581 loops=1)
  76. -> Index Scan using t_status_161000000_162000000_stream_id_idx on t_status_161000000_162000000 t_status_25 (cost=0.42..3245358.96 rows=911636 width=14) (actual time=2.979..70466.397 rows=911636 loops=1)
  77. -> Index Scan using t_status_162000000_163000000_stream_id_idx on t_status_162000000_163000000 t_status_26 (cost=0.42..3401006.82 rows=955360 width=14) (actual time=1.770..72430.172 rows=955360 loops=1)
  78. -> Index Scan using t_status_163000000_164000000_stream_id_idx on t_status_163000000_164000000 t_status_27 (cost=0.42..3149217.86 rows=884629 width=14) (actual time=2.581..69853.420 rows=884629 loops=1)
  79. -> Index Scan using t_status_164000000_165000000_stream_id_idx on t_status_164000000_165000000 t_status_28 (cost=0.42..3373647.59 rows=947678 width=14) (actual time=1.546..70008.164 rows=947678 loops=1)
  80. -> Index Scan using t_status_165000000_166000000_stream_id_idx on t_status_165000000_166000000 t_status_29 (cost=0.42..3229688.86 rows=907229 width=14) (actual time=3.362..66826.219 rows=907229 loops=1)
  81. -> Index Scan using t_status_166000000_167000000_stream_id_idx on t_status_166000000_167000000 t_status_30 (cost=0.42..3082890.27 rows=865990 width=14) (actual time=1.997..69004.231 rows=865521 loops=1)
  82. -> Index Scan using t_status_167000000_168000000_stream_id_idx on t_status_167000000_168000000 t_status_31 (cost=0.42..3309573.44 rows=929668 width=14) (actual time=1.738..67834.809 rows=929507 loops=1)
  83. -> Index Scan using t_status_168000000_169000000_stream_id_idx on t_status_168000000_169000000 t_status_32 (cost=0.42..3023737.05 rows=849375 width=14) (actual time=1.709..65991.972 rows=848853 loops=1)
  84. -> Index Scan using t_status_169000000_170000000_stream_id_idx on t_status_169000000_170000000 t_status_33 (cost=0.42..3061291.21 rows=859919 width=14) (actual time=1.837..71512.220 rows=859510 loops=1)
  85. -> Index Scan using t_status_170000000_171000000_stream_id_idx on t_status_170000000_171000000 t_status_34 (cost=0.42..3316217.45 rows=931535 width=14) (actual time=2.014..69500.503 rows=931445 loops=1)
  86. -> Index Scan using t_status_171000000_172000000_stream_id_idx on t_status_171000000_172000000 t_status_35 (cost=0.42..3097411.43 rows=870067 width=14) (actual time=3.033..67946.749 rows=869351 loops=1)
  87. -> Index Scan using t_status_172000000_173000000_stream_id_idx on t_status_172000000_173000000 t_status_36 (cost=0.42..2866735.50 rows=805272 width=14) (actual time=2.169..58767.312 rows=804268 loops=1)
  88. -> 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.007..0.008 rows=0 loops=1)
  89. -> 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.009 rows=0 loops=1)
  90. -> 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)
  91. -> 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.009..0.009 rows=0 loops=1)
  92. -> 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)
  93. -> 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)
  94. Planning Time: 280.152 ms
  95. Execution Time: 2483801.491 ms
  96. (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!