explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AGC3

Settings
# exclusive inclusive rows x rows loops node
1. 4,420.101 4,789.492 ↓ 0.0 0 1

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

  • Buffers: shared hit=884775 read=21147 dirtied=19935 written=5452
2. 369.391 369.391 ↑ 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.747..369.391 rows=442,386 loops=1)

  • Index Cond: (lognumber = 23)
  • Buffers: shared hit=3 read=21147 dirtied=19935 written=5452
Planning time : 4.726 ms
Execution time : 888,179.907 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint fk_12yh6jgtr7us7d791nu4jw7cu 7,359.383 ms 442386 0.017 ms
for constraint fk_13xo14houodpw2d186bexl97j 6,475.453 ms 442386 0.015 ms
for constraint fk_14v32rkucxf6fu00er9ecatuk 6,408.744 ms 442386 0.014 ms
for constraint fk_1c6n48u836u08v5xio8ocvu9s 6,619.291 ms 442386 0.015 ms
for constraint fk_1g1r736htaiuakjejw8mvrpq5 6,314.090 ms 442386 0.014 ms
for constraint fk_1nab65vbrslrm6q4iyw2h2fly 7,031.309 ms 442386 0.016 ms
for constraint fk_1oka8c3i2y1w3p824ttmh38a9 6,451.737 ms 442386 0.015 ms
for constraint fk_1s5otb8v8co8ir0gd54f30gt5 6,392.207 ms 442386 0.014 ms
for constraint fk_1usgs83nv5y6ny6voowt2yoy1 7,073.805 ms 442386 0.016 ms
for constraint fk_209gmpoj08ckh989vb6ydq4kd 6,943.824 ms 442386 0.016 ms
for constraint fk_21su9hciqqe8pa9tss1nge4sc 6,668.009 ms 442386 0.015 ms
for constraint fk_2eo76f865h051hilb0af2ycp6 6,333.884 ms 442386 0.014 ms
for constraint fk_2f1gtjqd2lf26nnwjdv6c28am 6,838.330 ms 442386 0.015 ms
for constraint fk_2hvufgeklj4oa0ecqmma159i 6,899.985 ms 442386 0.016 ms
for constraint fk_2jhue0hip7quo4uw7nkvl2uhn 6,415.558 ms 442386 0.015 ms
for constraint fk_3ujqn22ji87jgdlyq8a3q81lu 7,137.962 ms 442386 0.016 ms
for constraint fk_42fkob57hm4n1jykcqbu11mj1 7,079.276 ms 442386 0.016 ms
for constraint fk_47arshkgrnrg0lhprg5mya0vw 7,003.539 ms 442386 0.016 ms
for constraint fk_4ojv4hfiyux59n3q89fge2nrw 6,424.317 ms 442386 0.015 ms
for constraint fk_4pvkp852u5ss7fbriah05vwa 6,312.856 ms 442386 0.014 ms
for constraint fk_4vfgan7s7vv3irkvcf0guuxh1 7,139.369 ms 442386 0.016 ms
for constraint fk_55csxog6i2ugq4n46l1lbt2tb 7,073.039 ms 442386 0.016 ms
for constraint fk_5c7c4r0q5o3hddki9p30v323a 6,564.321 ms 442386 0.015 ms
for constraint fk_5gy2ut30cnmek579hynus9h2a 12,398.809 ms 442386 0.028 ms
for constraint fk_5iy4a99tfurxv7ihm3pq77wk3 7,068.102 ms 442386 0.016 ms
for constraint fk_6ejb3v8bv40r6clcwct451g1s 7,058.271 ms 442386 0.016 ms
for constraint fk_6keqmlso5rhlxqn3444qqf8gg 6,427.727 ms 442386 0.015 ms
for constraint fk_6pt2sw1kb0uh23swipqavi9h7 6,787.132 ms 442386 0.015 ms
for constraint fk_6vccspvpcpttt0m6vr4niw89g 6,357.691 ms 442386 0.014 ms
for constraint fk_73h6l8hh38xtvlcoyvotjrqer 6,936.525 ms 442386 0.016 ms
for constraint fk_761v58urqkemdobpinl1hr5tl 6,571.323 ms 442386 0.015 ms
for constraint fk_7ah1asrbkj6v6q6tynavgcrxb 6,301.574 ms 442386 0.014 ms
for constraint fk_7c2sq2n47isf2dmctdhroj2u3 7,050.392 ms 442386 0.016 ms
for constraint fk_88rfj99f0uwl8hty4bg9rhnxb 7,041.494 ms 442386 0.016 ms
for constraint fk_8d2lg6bwsjbu6cgfiprcund4o 6,501.847 ms 442386 0.015 ms
for constraint fk_8di2egrjxuupohgc1mgan82ss 7,083.764 ms 442386 0.016 ms
for constraint fk_8g0gq7eu9khkxskquxlgmoyd1 7,200.015 ms 442386 0.016 ms
for constraint fk_8lkegflhiadg4xaqjr916vvhm 6,791.779 ms 442386 0.015 ms
for constraint fk_8pbq02a4plyq4t2tux0keq8g8 6,447.641 ms 442386 0.015 ms
for constraint fk_8rfl4rxrfbuv0606iv1x4tap2 6,476.736 ms 442386 0.015 ms
for constraint fk_8scie2ivex0q8ev9yj5rm8ruc 6,671.394 ms 442386 0.015 ms
for constraint fk_8uaffxq4vsk3n6t4a31x3tnfb 7,082.393 ms 442386 0.016 ms
for constraint fk_9culpf76c11p85quqq8acvnjp 7,212.277 ms 442386 0.016 ms
for constraint fk_9hjb2p6nk6ugqbtoqjrd2brsh 7,228.123 ms 442386 0.016 ms
for constraint fk_9tw9b3ywa745nputvl51x8l1c 7,044.048 ms 442386 0.016 ms
for constraint fk_9uc53bjvvs3y8lxkea35rdd00 6,496.145 ms 442386 0.015 ms
for constraint fk_b07xhqjxpc3y3v9c8olvtpg8q 6,464.356 ms 442386 0.015 ms
for constraint fk_ceqto2y98i9x6lcwi47yrek4v 6,387.664 ms 442386 0.014 ms
for constraint fk_d4f5tnyiesyqlv7utua5181l0 6,400.162 ms 442386 0.014 ms
for constraint fk_df4a0369br3dccp6eyrjwp9kv 6,393.954 ms 442386 0.014 ms
for constraint fk_diplpbb6klkss8s133w5n35tk 6,976.537 ms 442386 0.016 ms
for constraint fk_e480805p3sg5al4e6q3se5yvh 7,047.021 ms 442386 0.016 ms
for constraint fk_e9fqtu339uf5hjadgoytexe6i 20,211.162 ms 442386 0.046 ms
for constraint fk_eqkhw17gu55br7bmo6lprvd1b 7,198.281 ms 442386 0.016 ms
for constraint fk_ew91tb31u71m9w2q2deslekn5 6,776.896 ms 442386 0.015 ms
for constraint fk_f4vetulp53xkwutf2gbp67s5i 7,327.625 ms 442386 0.017 ms
for constraint fk_flg0marc8w20nw9j1sxm5qhli 8,026.304 ms 442386 0.018 ms
for constraint fk_g4q3578v7k0u4aw7cxy1d0dc5 7,010.854 ms 442386 0.016 ms
for constraint fk_gmdj9fq2kgfjy1les8kph88lr 7,175.475 ms 442386 0.016 ms
for constraint fk_gp0ubv3x88jyrul2ge4m7dlce 6,645.633 ms 442386 0.015 ms
for constraint fk_gv8e6jdpx6r888dpup4jyh5ij 6,955.830 ms 442386 0.016 ms
for constraint fk_gynmap13hrrdvxomrc8xsf7j6 6,418.311 ms 442386 0.015 ms
for constraint fk_h5rh9dd4fvtosb9hh3u3nphey 6,556.343 ms 442386 0.015 ms
for constraint fk_hij0g0bbxolpbbavjkbtq65ln 6,359.913 ms 442386 0.014 ms
for constraint fk_hnt6477pi8si94u1mt9qfx6mr 6,983.505 ms 442386 0.016 ms
for constraint fk_hx641n8sj5797s6a7blyels4b 6,512.657 ms 442386 0.015 ms
for constraint fk_hxtuos2eok352ep8dmgns1kc7 6,413.785 ms 442386 0.014 ms
for constraint fk_i2t42b16o1rvl9tswa6t04kcs 7,169.226 ms 442386 0.016 ms
for constraint fk_i5x5nqhs6j4f7smc17ajk6edj 7,242.975 ms 442386 0.016 ms
for constraint fk_ie177so2t67fm3y2nluq616vg 7,186.785 ms 442386 0.016 ms
for constraint fk_ikfivg3qprlbi9qe9608e79wg 6,412.142 ms 442386 0.014 ms
for constraint fk_j61yuou3wk3pui31fe6gdfkdg 7,096.103 ms 442386 0.016 ms
for constraint fk_j8tg1rs7ptik5o0mfb60eoxuu 6,532.672 ms 442386 0.015 ms
for constraint fk_j9j6r9rsm23r66un2vmwi1su9 6,504.997 ms 442386 0.015 ms
for constraint fk_j9qkpd46uho1lkbtmow1v7f7p 18,622.310 ms 442386 0.042 ms
for constraint fk_jmn0eoddcalfp1j1fav8ib6hy 8,036.059 ms 442386 0.018 ms
for constraint fk_joj4tkkiatyxt7pa0lxpihw77 7,087.133 ms 442386 0.016 ms
for constraint fk_jsbtueod43s1404b9g4adjmbu 6,242.836 ms 442386 0.014 ms
for constraint fk_k4us05eksyhy21dk54dnv582g 6,526.925 ms 442386 0.015 ms
for constraint fk_l3pfquye914p94vd1h4kio4s6 7,134.504 ms 442386 0.016 ms
for constraint fk_l89cmierwd4opvc8pq5aao538 6,732.398 ms 442386 0.015 ms
for constraint fk_l9lpnbx75sgw5ubwg5q08g8w6 22,717.834 ms 442386 0.051 ms
for constraint fk_la2b2c1b242iu785weax3vm9x 14,812.539 ms 442386 0.033 ms
for constraint fk_lajuwht9crk38e0272vptahox 7,630.317 ms 442386 0.017 ms
for constraint fk_lgq0ck7ikipr5470wf3qgih4l 6,540.556 ms 442386 0.015 ms
for constraint fk_lmsy0lwc9qck9cxejvyag7kdd 6,817.459 ms 442386 0.015 ms
for constraint fk_m7m4pa975kqltxussmo9291ga 6,499.692 ms 442386 0.015 ms
for constraint fk_mbrmthgw5xrhmgoatuq9om98n 6,861.933 ms 442386 0.016 ms
for constraint fk_mmo0hh69avhw4abhbwi2nq19q 7,138.937 ms 442386 0.016 ms
for constraint fk_mryttxv197n7llr900j3vgkar 6,585.090 ms 442386 0.015 ms
for constraint fk_n18dhmatu51ydy8x022d6opkb 6,367.296 ms 442386 0.014 ms
for constraint fk_n4prap9k31kmmnfoip7giw3w 6,736.477 ms 442386 0.015 ms
for constraint fk_n8ufgmwpack3cskl1lohkgoep 6,691.006 ms 442386 0.015 ms
for constraint fk_nsvmphjl3cnrighqx6a26qn15 6,345.545 ms 442386 0.014 ms
for constraint fk_o1cwkv7rwchdceai1q5h97mjn 6,594.860 ms 442386 0.015 ms
for constraint fk_o3bxyggatcohovjp6ruo654sl 7,153.394 ms 442386 0.016 ms
for constraint fk_o3i1v8kptxk6c6rq0byjye73m 7,058.124 ms 442386 0.016 ms
for constraint fk_o5k0c1yehm58rmac498njrgfg 7,157.861 ms 442386 0.016 ms
for constraint fk_o7uv2xff0k511p4hawtuuytes 6,579.826 ms 442386 0.015 ms
for constraint fk_o9gobrt3g46x8kcwljm7skath 7,091.686 ms 442386 0.016 ms
for constraint fk_os30ueu8nkycjvvqcqhpdkxuv 7,083.736 ms 442386 0.016 ms
for constraint fk_p10f9yu2aiwu61r7abfs8k9mr 6,453.036 ms 442386 0.015 ms
for constraint fk_p27qxxoc9t9yg444qyekboonk 6,459.475 ms 442386 0.015 ms
for constraint fk_p5enwq1k1nql68wupuykxjx5a 6,414.677 ms 442386 0.015 ms
for constraint fk_p77dxjqerk8p13hfunenalb 6,380.629 ms 442386 0.014 ms
for constraint fk_pbeboks5e4oc08n79vpydyvhj 7,242.592 ms 442386 0.016 ms
for constraint fk_pcmvvba81h2xd5v62oeq1vapf 4,076.529 ms 442386 0.009 ms
for constraint fk_pmb6vx4nb1pjurrlrp62txkcv 6,779.985 ms 442386 0.015 ms
for constraint fk_ppeju9m9759p8rkfbmtoqpw37 6,390.375 ms 442386 0.014 ms
for constraint fk_psf0uc3yhan7s68j1cj1w89de 6,499.964 ms 442386 0.015 ms
for constraint fk_q2ltc6oprjqh683egj39m92m9 6,759.204 ms 442386 0.015 ms
for constraint fk_q505g2ol072eje64n0x9jx7ll 6,500.175 ms 442386 0.015 ms
for constraint fk_qinpsenjdeh97d31t45ajxb4v 7,181.515 ms 442386 0.016 ms
for constraint fk_ri8yo7s3bji5cxriascsg6igr 7,083.926 ms 442386 0.016 ms
for constraint fk_sgawrn3nca1rai77osoo9bt7u 6,613.158 ms 442386 0.015 ms
for constraint fk_slm7b9idorunml6utpt1jh316 6,739.076 ms 442386 0.015 ms
for constraint fk_t4pbocn45hx3ac2g8cp31ykw6 6,518.386 ms 442386 0.015 ms
for constraint fk_t72avo91ryeo48n2jb94l72uu 6,490.357 ms 442386 0.015 ms
for constraint fk_t90ttgkwu9vrajj5fhp6sjjat 7,771.317 ms 442386 0.018 ms
for constraint fk_tjf7eo6k50rcbjv55k4yosqcb 7,200.561 ms 442386 0.016 ms