explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KRZ4

Settings
# exclusive inclusive rows x rows loops node
1. 2,571.470 2,756.119 ↓ 0.0 0 1

Delete on subject (cost=0.42..32,769.75 rows=444,277 width=6) (actual time=2,756.119..2,756.119 rows=0 loops=1)

  • Buffers: shared hit=884801 read=21118 dirtied=19935 written=6586
2. 184.649 184.649 ↑ 1.0 442,386 1

Index Scan using subject_lognumber_idx on subject (cost=0.42..32,769.75 rows=444,277 width=6) (actual time=0.043..184.649 rows=442,386 loops=1)

  • Index Cond: (lognumber = 23)
  • Buffers: shared hit=29 read=21118 dirtied=19935 written=6586
Planning time : 0.127 ms
Execution time : 26,268,294.290 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint fk_12yh6jgtr7us7d791nu4jw7cu 11,251.534 ms 442386 0.025 ms
for constraint fk_13xo14houodpw2d186bexl97j 7,673.264 ms 442386 0.017 ms
for constraint fk_14v32rkucxf6fu00er9ecatuk 7,400.955 ms 442386 0.017 ms
for constraint fk_1c6n48u836u08v5xio8ocvu9s 8,514.884 ms 442386 0.019 ms
for constraint fk_1g1r736htaiuakjejw8mvrpq5 7,481.080 ms 442386 0.017 ms
for constraint fk_1nab65vbrslrm6q4iyw2h2fly 7,245.224 ms 442386 0.016 ms
for constraint fk_1oka8c3i2y1w3p824ttmh38a9 7,459.455 ms 442386 0.017 ms
for constraint fk_1s5otb8v8co8ir0gd54f30gt5 7,270.782 ms 442386 0.016 ms
for constraint fk_1usgs83nv5y6ny6voowt2yoy1 7,578.699 ms 442386 0.017 ms
for constraint fk_209gmpoj08ckh989vb6ydq4kd 7,268.460 ms 442386 0.016 ms
for constraint fk_21su9hciqqe8pa9tss1nge4sc 20,133.030 ms 442386 0.046 ms
for constraint fk_2eo76f865h051hilb0af2ycp6 7,448.675 ms 442386 0.017 ms
for constraint fk_2f1gtjqd2lf26nnwjdv6c28am 7,017.824 ms 442386 0.016 ms
for constraint fk_2hvufgeklj4oa0ecqmma159i 7,314.296 ms 442386 0.017 ms
for constraint fk_2jhue0hip7quo4uw7nkvl2uhn 7,367.832 ms 442386 0.017 ms
for constraint fk_3ujqn22ji87jgdlyq8a3q81lu 7,443.593 ms 442386 0.017 ms
for constraint fk_42fkob57hm4n1jykcqbu11mj1 7,267.763 ms 442386 0.016 ms
for constraint fk_47arshkgrnrg0lhprg5mya0vw 7,231.711 ms 442386 0.016 ms
for constraint fk_4ojv4hfiyux59n3q89fge2nrw 6,892.222 ms 442386 0.016 ms
for constraint fk_4pvkp852u5ss7fbriah05vwa 7,416.929 ms 442386 0.017 ms
for constraint fk_4vfgan7s7vv3irkvcf0guuxh1 7,332.876 ms 442386 0.017 ms
for constraint fk_55csxog6i2ugq4n46l1lbt2tb 7,483.043 ms 442386 0.017 ms
for constraint fk_5c7c4r0q5o3hddki9p30v323a 7,267.327 ms 442386 0.016 ms
for constraint fk_5gy2ut30cnmek579hynus9h2a 14,340.088 ms 442386 0.032 ms
for constraint fk_5iy4a99tfurxv7ihm3pq77wk3 7,128.048 ms 442386 0.016 ms
for constraint fk_6ejb3v8bv40r6clcwct451g1s 7,321.290 ms 442386 0.017 ms
for constraint fk_6keqmlso5rhlxqn3444qqf8gg 6,930.018 ms 442386 0.016 ms
for constraint fk_6pt2sw1kb0uh23swipqavi9h7 8,224.290 ms 442386 0.019 ms
for constraint fk_6vccspvpcpttt0m6vr4niw89g 7,396.818 ms 442386 0.017 ms
for constraint fk_73h6l8hh38xtvlcoyvotjrqer 7,377.997 ms 442386 0.017 ms
for constraint fk_761v58urqkemdobpinl1hr5tl 7,587.012 ms 442386 0.017 ms
for constraint fk_7ah1asrbkj6v6q6tynavgcrxb 6,976.436 ms 442386 0.016 ms
for constraint fk_7c2sq2n47isf2dmctdhroj2u3 7,590.159 ms 442386 0.017 ms
for constraint fk_88rfj99f0uwl8hty4bg9rhnxb 7,282.363 ms 442386 0.016 ms
for constraint fk_8d2lg6bwsjbu6cgfiprcund4o 7,058.000 ms 442386 0.016 ms
for constraint fk_8di2egrjxuupohgc1mgan82ss 7,368.272 ms 442386 0.017 ms
for constraint fk_8g0gq7eu9khkxskquxlgmoyd1 8,839.117 ms 442386 0.020 ms
for constraint fk_8lkegflhiadg4xaqjr916vvhm 931,509.744 ms 442386 2.106 ms
for constraint fk_8pbq02a4plyq4t2tux0keq8g8 11,638.068 ms 442386 0.026 ms
for constraint fk_8rfl4rxrfbuv0606iv1x4tap2 8,074.407 ms 442386 0.018 ms
for constraint fk_8scie2ivex0q8ev9yj5rm8ruc 8,082.743 ms 442386 0.018 ms
for constraint fk_8uaffxq4vsk3n6t4a31x3tnfb 7,428.429 ms 442386 0.017 ms
for constraint fk_9culpf76c11p85quqq8acvnjp 7,518.468 ms 442386 0.017 ms
for constraint fk_9hjb2p6nk6ugqbtoqjrd2brsh 9,178.906 ms 442386 0.021 ms
for constraint fk_9tw9b3ywa745nputvl51x8l1c 7,487.490 ms 442386 0.017 ms
for constraint fk_9uc53bjvvs3y8lxkea35rdd00 7,675.587 ms 442386 0.017 ms
for constraint fk_b07xhqjxpc3y3v9c8olvtpg8q 7,463.146 ms 442386 0.017 ms
for constraint fk_ceqto2y98i9x6lcwi47yrek4v 7,320.735 ms 442386 0.017 ms
for constraint fk_d4f5tnyiesyqlv7utua5181l0 7,334.944 ms 442386 0.017 ms
for constraint fk_df4a0369br3dccp6eyrjwp9kv 7,425.728 ms 442386 0.017 ms
for constraint fk_diplpbb6klkss8s133w5n35tk 7,338.198 ms 442386 0.017 ms
for constraint fk_e480805p3sg5al4e6q3se5yvh 7,503.818 ms 442386 0.017 ms
for constraint fk_e9fqtu339uf5hjadgoytexe6i 34,702.721 ms 442386 0.078 ms
for constraint fk_eqkhw17gu55br7bmo6lprvd1b 8,583.740 ms 442386 0.019 ms
for constraint fk_ew91tb31u71m9w2q2deslekn5 8,434.782 ms 442386 0.019 ms
for constraint fk_f4vetulp53xkwutf2gbp67s5i 7,330.570 ms 442386 0.017 ms
for constraint fk_flg0marc8w20nw9j1sxm5qhli 14,022.720 ms 442386 0.032 ms
for constraint fk_g4q3578v7k0u4aw7cxy1d0dc5 7,310.319 ms 442386 0.017 ms
for constraint fk_gmdj9fq2kgfjy1les8kph88lr 9,297.111 ms 442386 0.021 ms
for constraint fk_gp0ubv3x88jyrul2ge4m7dlce 9,106.914 ms 442386 0.021 ms
for constraint fk_gv8e6jdpx6r888dpup4jyh5ij 8,666.431 ms 442386 0.020 ms
for constraint fk_gynmap13hrrdvxomrc8xsf7j6 7,319.065 ms 442386 0.017 ms
for constraint fk_h5rh9dd4fvtosb9hh3u3nphey 7,545.215 ms 442386 0.017 ms
for constraint fk_hij0g0bbxolpbbavjkbtq65ln 6,942.980 ms 442386 0.016 ms
for constraint fk_hnt6477pi8si94u1mt9qfx6mr 8,664.874 ms 442386 0.020 ms
for constraint fk_hx641n8sj5797s6a7blyels4b 8,032.344 ms 442386 0.018 ms
for constraint fk_hxtuos2eok352ep8dmgns1kc7 7,686.008 ms 442386 0.017 ms
for constraint fk_i2t42b16o1rvl9tswa6t04kcs 7,346.469 ms 442386 0.017 ms
for constraint fk_i5x5nqhs6j4f7smc17ajk6edj 7,672.107 ms 442386 0.017 ms
for constraint fk_ie177so2t67fm3y2nluq616vg 7,459.097 ms 442386 0.017 ms
for constraint fk_ikfivg3qprlbi9qe9608e79wg 7,395.914 ms 442386 0.017 ms
for constraint fk_j61yuou3wk3pui31fe6gdfkdg 7,452.350 ms 442386 0.017 ms
for constraint fk_j8tg1rs7ptik5o0mfb60eoxuu 7,530.020 ms 442386 0.017 ms
for constraint fk_j9j6r9rsm23r66un2vmwi1su9 7,545.157 ms 442386 0.017 ms
for constraint fk_j9qkpd46uho1lkbtmow1v7f7p 1,821,807.391 ms 442386 4.118 ms
for constraint fk_jmn0eoddcalfp1j1fav8ib6hy 10,982.331 ms 442386 0.025 ms
for constraint fk_joj4tkkiatyxt7pa0lxpihw77 9,256.883 ms 442386 0.021 ms
for constraint fk_jsbtueod43s1404b9g4adjmbu 7,778.566 ms 442386 0.018 ms
for constraint fk_k4us05eksyhy21dk54dnv582g 7,690.104 ms 442386 0.017 ms
for constraint fk_l3pfquye914p94vd1h4kio4s6 7,369.764 ms 442386 0.017 ms
for constraint fk_l89cmierwd4opvc8pq5aao538 8,517.437 ms 442386 0.019 ms
for constraint fk_l9lpnbx75sgw5ubwg5q08g8w6 18,916,375.743 ms 442386 42.760 ms
for constraint fk_la2b2c1b242iu785weax3vm9x 29,848.317 ms 442386 0.067 ms
for constraint fk_lajuwht9crk38e0272vptahox 8,352.556 ms 442386 0.019 ms
for constraint fk_lgq0ck7ikipr5470wf3qgih4l 7,871.365 ms 442386 0.018 ms
for constraint fk_lmsy0lwc9qck9cxejvyag7kdd 21,471.188 ms 442386 0.049 ms
for constraint fk_m7m4pa975kqltxussmo9291ga 8,034.138 ms 442386 0.018 ms
for constraint fk_mbrmthgw5xrhmgoatuq9om98n 3,098,231.465 ms 442386 7.003 ms
for constraint fk_mmo0hh69avhw4abhbwi2nq19q 12,986.104 ms 442386 0.029 ms
for constraint fk_mryttxv197n7llr900j3vgkar 8,539.481 ms 442386 0.019 ms
for constraint fk_n18dhmatu51ydy8x022d6opkb 7,682.034 ms 442386 0.017 ms
for constraint fk_n4prap9k31kmmnfoip7giw3w 8,551.649 ms 442386 0.019 ms
for constraint fk_n8ufgmwpack3cskl1lohkgoep 8,022.749 ms 442386 0.018 ms
for constraint fk_nsvmphjl3cnrighqx6a26qn15 7,554.839 ms 442386 0.017 ms
for constraint fk_o1cwkv7rwchdceai1q5h97mjn 7,860.530 ms 442386 0.018 ms
for constraint fk_o3bxyggatcohovjp6ruo654sl 7,723.339 ms 442386 0.017 ms
for constraint fk_o3i1v8kptxk6c6rq0byjye73m 9,615.505 ms 442386 0.022 ms
for constraint fk_o5k0c1yehm58rmac498njrgfg 7,428.065 ms 442386 0.017 ms
for constraint fk_o7uv2xff0k511p4hawtuuytes 7,824.898 ms 442386 0.018 ms
for constraint fk_o9gobrt3g46x8kcwljm7skath 7,524.996 ms 442386 0.017 ms
for constraint fk_os30ueu8nkycjvvqcqhpdkxuv 7,738.777 ms 442386 0.017 ms
for constraint fk_p10f9yu2aiwu61r7abfs8k9mr 7,173.447 ms 442386 0.016 ms
for constraint fk_p27qxxoc9t9yg444qyekboonk 8,322.514 ms 442386 0.019 ms
for constraint fk_p5enwq1k1nql68wupuykxjx5a 7,843.674 ms 442386 0.018 ms
for constraint fk_p77dxjqerk8p13hfunenalb 8,116.712 ms 442386 0.018 ms
for constraint fk_pbeboks5e4oc08n79vpydyvhj 10,114.446 ms 442386 0.023 ms
for constraint fk_pcmvvba81h2xd5v62oeq1vapf 6,308.060 ms 442386 0.014 ms
for constraint fk_pmb6vx4nb1pjurrlrp62txkcv 8,024.996 ms 442386 0.018 ms
for constraint fk_ppeju9m9759p8rkfbmtoqpw37 7,207.077 ms 442386 0.016 ms
for constraint fk_psf0uc3yhan7s68j1cj1w89de 7,832.246 ms 442386 0.018 ms
for constraint fk_q2ltc6oprjqh683egj39m92m9 8,175.314 ms 442386 0.018 ms
for constraint fk_q505g2ol072eje64n0x9jx7ll 7,893.408 ms 442386 0.018 ms
for constraint fk_qinpsenjdeh97d31t45ajxb4v 7,505.732 ms 442386 0.017 ms
for constraint fk_ri8yo7s3bji5cxriascsg6igr 7,788.014 ms 442386 0.018 ms
for constraint fk_sgawrn3nca1rai77osoo9bt7u 7,690.541 ms 442386 0.017 ms
for constraint fk_slm7b9idorunml6utpt1jh316 481,117.086 ms 442386 1.088 ms
for constraint fk_t4pbocn45hx3ac2g8cp31ykw6 9,135.068 ms 442386 0.021 ms
for constraint fk_t72avo91ryeo48n2jb94l72uu 7,761.000 ms 442386 0.018 ms
for constraint fk_t90ttgkwu9vrajj5fhp6sjjat 9,661.530 ms 442386 0.022 ms
for constraint fk_tjf7eo6k50rcbjv55k4yosqcb 7,568.944 ms 442386 0.017 ms