API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 17th, 2023
237
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.19 KB | None | 0 0
raw download clone embed print report
  1. QUERY PLAN
  2. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  3. Delete on t_status (cost=36411011.32..475180456.37 rows=0 width=0) (actual time=175474.541..175474.561 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=36411011.32..475180456.37 rows=29224764823 width=16) (actual time=170830.898..175474.475 rows=21 loops=1)
  47. Merge Cond: (t_temp_streams_to_delete.id = t_status.stream_id)
  48. -> Sort (cost=3315.66..3407.50 rows=36734 width=10) (actual time=12.605..15.634 rows=36734 loops=1)
  49. Sort Key: t_temp_streams_to_delete.id
  50. Sort Method: quicksort Memory: 3088kB
  51. -> Seq Scan on t_temp_streams_to_delete (cost=0.00..530.34 rows=36734 width=10) (actual time=0.014..3.567 rows=36734 loops=1)
  52. -> Materialize (cost=36407695.65..37203273.72 rows=159115614 width=14) (actual time=166366.079..172827.777 rows=30713968 loops=1)
  53. -> Sort (cost=36407695.65..36805484.69 rows=159115614 width=14) (actual time=166366.066..169462.240 rows=30713968 loops=1)
  54. Sort Key: t_status.stream_id
  55. Sort Method: external merge Disk: 721408kB
  56. -> Append (cost=0.00..6573987.21 rows=159115614 width=14) (actual time=0.446..150394.589 rows=30717345 loops=1)
  57. -> Seq Scan on t_status_137000000_138000000 t_status_1 (cost=0.00..153344.22 rows=4222522 width=14) (actual time=0.445..3911.033 rows=828766 loops=1)
  58. -> Seq Scan on t_status_138000000_139000000 t_status_2 (cost=0.00..162076.86 rows=4462986 width=14) (actual time=0.386..4488.473 rows=874563 loops=1)
  59. -> Seq Scan on t_status_139000000_140000000 t_status_3 (cost=0.00..145344.36 rows=4002236 width=14) (actual time=0.399..4431.747 rows=786878 loops=1)
  60. -> Seq Scan on t_status_140000000_141000000 t_status_4 (cost=0.00..160963.20 rows=4432320 width=14) (actual time=0.395..4044.489 rows=869081 loops=1)
  61. -> Seq Scan on t_status_141000000_142000000 t_status_5 (cost=0.00..150012.90 rows=4130790 width=14) (actual time=0.534..3802.118 rows=806881 loops=1)
  62. -> Seq Scan on t_status_142000000_143000000 t_status_6 (cost=0.00..150977.52 rows=4157352 width=14) (actual time=0.412..3791.785 rows=812991 loops=1)
  63. -> Seq Scan on t_status_143000000_144000000 t_status_7 (cost=0.00..36938.46 rows=1017146 width=14) (actual time=0.415..1007.511 rows=200012 loops=1)
  64. -> Seq Scan on t_status_144000000_145000000 t_status_8 (cost=0.00..141593.52 rows=3898952 width=14) (actual time=0.383..3566.573 rows=763428 loops=1)
  65. -> Seq Scan on t_status_145000000_146000000 t_status_9 (cost=0.00..173173.44 rows=4768544 width=14) (actual time=0.458..4393.027 rows=919283 loops=1)
  66. -> Seq Scan on t_status_146000000_147000000 t_status_10 (cost=0.00..158419.86 rows=4362286 width=14) (actual time=0.433..3983.332 rows=842595 loops=1)
  67. -> Seq Scan on t_status_147000000_148000000 t_status_11 (cost=0.00..161745.66 rows=4453866 width=14) (actual time=0.479..4224.112 rows=858278 loops=1)
  68. -> Seq Scan on t_status_148000000_149000000 t_status_12 (cost=0.00..173228.64 rows=4770064 width=14) (actual time=0.487..4455.011 rows=915680 loops=1)
  69. -> Seq Scan on t_status_149000000_150000000 t_status_13 (cost=0.00..165529.62 rows=4558062 width=14) (actual time=0.781..4302.402 rows=877401 loops=1)
  70. -> Seq Scan on t_status_150000000_151000000 t_status_14 (cost=0.00..170890.92 rows=4705692 width=14) (actual time=0.393..4283.870 rows=904116 loops=1)
  71. -> Seq Scan on t_status_151000000_152000000 t_status_15 (cost=0.00..187023.12 rows=5149912 width=14) (actual time=0.441..4702.708 rows=952655 loops=1)
  72. -> Seq Scan on t_status_152000000_153000000 t_status_16 (cost=0.00..158411.58 rows=4362058 width=14) (actual time=0.415..3988.261 rows=832990 loops=1)
  73. -> Seq Scan on t_status_153000000_154000000 t_status_17 (cost=0.00..159503.16 rows=4392116 width=14) (actual time=0.355..4013.669 rows=852015 loops=1)
  74. -> Seq Scan on t_status_154000000_155000000 t_status_18 (cost=0.00..166513.56 rows=4585156 width=14) (actual time=0.524..4152.952 rows=888373 loops=1)
  75. -> Seq Scan on t_status_155000000_156000000 t_status_19 (cost=0.00..159977.88 rows=4405188 width=14) (actual time=0.472..3933.522 rows=849352 loops=1)
  76. -> Seq Scan on t_status_156000000_157000000 t_status_20 (cost=0.00..172110.84 rows=4739284 width=14) (actual time=0.368..4337.375 rows=913365 loops=1)
  77. -> Seq Scan on t_status_157000000_158000000 t_status_21 (cost=0.00..162220.38 rows=4466938 width=14) (actual time=0.573..4169.453 rows=861256 loops=1)
  78. -> Seq Scan on t_status_158000000_159000000 t_status_22 (cost=0.00..149908.02 rows=4127902 width=14) (actual time=1.012..3770.852 rows=796728 loops=1)
  79. -> Seq Scan on t_status_159000000_160000000 t_status_23 (cost=0.00..176540.64 rows=4861264 width=14) (actual time=0.541..4476.350 rows=935719 loops=1)
  80. -> Seq Scan on t_status_160000000_161000000 t_status_24 (cost=0.00..161433.78 rows=4445278 width=14) (actual time=0.564..4014.534 rows=856581 loops=1)
  81. -> Seq Scan on t_status_161000000_162000000 t_status_25 (cost=0.00..171291.12 rows=4716712 width=14) (actual time=0.454..4320.139 rows=911636 loops=1)
  82. -> Seq Scan on t_status_162000000_163000000 t_status_26 (cost=0.00..179492.46 rows=4942546 width=14) (actual time=3.646..4507.235 rows=955360 loops=1)
  83. -> Seq Scan on t_status_163000000_164000000 t_status_27 (cost=0.00..166156.14 rows=4575314 width=14) (actual time=0.424..4206.948 rows=884629 loops=1)
  84. -> Seq Scan on t_status_164000000_165000000 t_status_28 (cost=0.00..177840.60 rows=4897060 width=14) (actual time=0.493..4619.488 rows=947678 loops=1)
  85. -> Seq Scan on t_status_165000000_166000000 t_status_29 (cost=0.00..170519.70 rows=4695470 width=14) (actual time=0.449..4394.152 rows=907229 loops=1)
  86. -> Seq Scan on t_status_166000000_167000000 t_status_30 (cost=0.00..163162.92 rows=4492892 width=14) (actual time=0.452..4172.523 rows=865990 loops=1)
  87. -> Seq Scan on t_status_167000000_168000000 t_status_31 (cost=0.00..175613.28 rows=4835728 width=14) (actual time=0.634..4509.154 rows=929668 loops=1)
  88. -> Seq Scan on t_status_168000000_169000000 t_status_32 (cost=0.00..160589.22 rows=4422022 width=14) (actual time=0.466..4163.242 rows=849375 loops=1)
  89. -> Seq Scan on t_status_169000000_170000000 t_status_33 (cost=0.00..162721.32 rows=4480732 width=14) (actual time=0.430..4054.348 rows=859919 loops=1)
  90. -> Seq Scan on t_status_170000000_171000000 t_status_34 (cost=0.00..176314.32 rows=4855032 width=14) (actual time=0.532..4591.528 rows=931535 loops=1)
  91. -> Seq Scan on t_status_171000000_172000000 t_status_35 (cost=0.00..164733.36 rows=4536136 width=14) (actual time=0.412..4204.107 rows=870067 loops=1)
  92. -> Seq Scan on t_status_172000000_173000000 t_status_36 (cost=0.00..152009.76 rows=4185776 width=14) (actual time=0.914..3842.057 rows=805272 loops=1)
  93. -> Seq Scan on t_status_173000000_174000000 t_status_37 (cost=0.00..13.80 rows=380 width=14) (actual time=0.005..0.005 rows=0 loops=1)
  94. -> Seq Scan on t_status_174000000_175000000 t_status_38 (cost=0.00..13.80 rows=380 width=14) (actual time=0.002..0.003 rows=0 loops=1)
  95. -> Seq Scan on t_status_175000000_176000000 t_status_39 (cost=0.00..13.80 rows=380 width=14) (actual time=0.009..0.010 rows=0 loops=1)
  96. -> Seq Scan on t_status_176000000_177000000 t_status_40 (cost=0.00..13.80 rows=380 width=14) (actual time=0.002..0.002 rows=0 loops=1)
  97. -> Seq Scan on t_status_177000000_178000000 t_status_41 (cost=0.00..13.80 rows=380 width=14) (actual time=0.002..0.002 rows=0 loops=1)
  98. -> Seq Scan on t_status_178000000_179000000 t_status_42 (cost=0.00..13.80 rows=380 width=14) (actual time=0.002..0.002 rows=0 loops=1)
  99. Planning Time: 147.098 ms
  100. Execution Time: 175568.936 ms
  101. (98 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!