HTML
SOURCE
STATS

#	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

Delete on subject  (cost=0.42..32769.75 rows=444277 width=6) (actual time=2756.119..2756.119 rows=0 loops=1)
  Buffers: shared hit=884801 read=21118 dirtied=19935 written=6586
  ->  Index Scan using subject_lognumber_idx on subject  (cost=0.42..32769.75 rows=444277 width=6) (actual time=0.043..184.649 rows=442386 loops=1)
        Index Cond: (lognumber = 23)
        Buffers: shared hit=29 read=21118 dirtied=19935 written=6586
Planning time: 0.127 ms
Trigger for constraint fk_12yh6jgtr7us7d791nu4jw7cu: time=11251.534 calls=442386
Trigger for constraint fk_13xo14houodpw2d186bexl97j: time=7673.264 calls=442386
Trigger for constraint fk_14v32rkucxf6fu00er9ecatuk: time=7400.955 calls=442386
Trigger for constraint fk_1c6n48u836u08v5xio8ocvu9s: time=8514.884 calls=442386
Trigger for constraint fk_1g1r736htaiuakjejw8mvrpq5: time=7481.080 calls=442386
Trigger for constraint fk_1nab65vbrslrm6q4iyw2h2fly: time=7245.224 calls=442386
Trigger for constraint fk_1oka8c3i2y1w3p824ttmh38a9: time=7459.455 calls=442386
Trigger for constraint fk_1s5otb8v8co8ir0gd54f30gt5: time=7270.782 calls=442386
Trigger for constraint fk_1usgs83nv5y6ny6voowt2yoy1: time=7578.699 calls=442386
Trigger for constraint fk_209gmpoj08ckh989vb6ydq4kd: time=7268.460 calls=442386
Trigger for constraint fk_21su9hciqqe8pa9tss1nge4sc: time=20133.030 calls=442386
Trigger for constraint fk_2eo76f865h051hilb0af2ycp6: time=7448.675 calls=442386
Trigger for constraint fk_2f1gtjqd2lf26nnwjdv6c28am: time=7017.824 calls=442386
Trigger for constraint fk_2hvufgeklj4oa0ecqmma159i: time=7314.296 calls=442386
Trigger for constraint fk_2jhue0hip7quo4uw7nkvl2uhn: time=7367.832 calls=442386
Trigger for constraint fk_3ujqn22ji87jgdlyq8a3q81lu: time=7443.593 calls=442386
Trigger for constraint fk_42fkob57hm4n1jykcqbu11mj1: time=7267.763 calls=442386
Trigger for constraint fk_47arshkgrnrg0lhprg5mya0vw: time=7231.711 calls=442386
Trigger for constraint fk_4ojv4hfiyux59n3q89fge2nrw: time=6892.222 calls=442386
Trigger for constraint fk_4pvkp852u5ss7fbriah05vwa: time=7416.929 calls=442386
Trigger for constraint fk_4vfgan7s7vv3irkvcf0guuxh1: time=7332.876 calls=442386
Trigger for constraint fk_55csxog6i2ugq4n46l1lbt2tb: time=7483.043 calls=442386
Trigger for constraint fk_5c7c4r0q5o3hddki9p30v323a: time=7267.327 calls=442386
Trigger for constraint fk_5gy2ut30cnmek579hynus9h2a: time=14340.088 calls=442386
Trigger for constraint fk_5iy4a99tfurxv7ihm3pq77wk3: time=7128.048 calls=442386
Trigger for constraint fk_6ejb3v8bv40r6clcwct451g1s: time=7321.290 calls=442386
Trigger for constraint fk_6keqmlso5rhlxqn3444qqf8gg: time=6930.018 calls=442386
Trigger for constraint fk_6pt2sw1kb0uh23swipqavi9h7: time=8224.290 calls=442386
Trigger for constraint fk_6vccspvpcpttt0m6vr4niw89g: time=7396.818 calls=442386
Trigger for constraint fk_73h6l8hh38xtvlcoyvotjrqer: time=7377.997 calls=442386
Trigger for constraint fk_761v58urqkemdobpinl1hr5tl: time=7587.012 calls=442386
Trigger for constraint fk_7ah1asrbkj6v6q6tynavgcrxb: time=6976.436 calls=442386
Trigger for constraint fk_7c2sq2n47isf2dmctdhroj2u3: time=7590.159 calls=442386
Trigger for constraint fk_88rfj99f0uwl8hty4bg9rhnxb: time=7282.363 calls=442386
Trigger for constraint fk_8d2lg6bwsjbu6cgfiprcund4o: time=7058.000 calls=442386
Trigger for constraint fk_8di2egrjxuupohgc1mgan82ss: time=7368.272 calls=442386
Trigger for constraint fk_8g0gq7eu9khkxskquxlgmoyd1: time=8839.117 calls=442386
Trigger for constraint fk_8lkegflhiadg4xaqjr916vvhm: time=931509.744 calls=442386
Trigger for constraint fk_8pbq02a4plyq4t2tux0keq8g8: time=11638.068 calls=442386
Trigger for constraint fk_8rfl4rxrfbuv0606iv1x4tap2: time=8074.407 calls=442386
Trigger for constraint fk_8scie2ivex0q8ev9yj5rm8ruc: time=8082.743 calls=442386
Trigger for constraint fk_8uaffxq4vsk3n6t4a31x3tnfb: time=7428.429 calls=442386
Trigger for constraint fk_9culpf76c11p85quqq8acvnjp: time=7518.468 calls=442386
Trigger for constraint fk_9hjb2p6nk6ugqbtoqjrd2brsh: time=9178.906 calls=442386
Trigger for constraint fk_9tw9b3ywa745nputvl51x8l1c: time=7487.490 calls=442386
Trigger for constraint fk_9uc53bjvvs3y8lxkea35rdd00: time=7675.587 calls=442386
Trigger for constraint fk_b07xhqjxpc3y3v9c8olvtpg8q: time=7463.146 calls=442386
Trigger for constraint fk_ceqto2y98i9x6lcwi47yrek4v: time=7320.735 calls=442386
Trigger for constraint fk_d4f5tnyiesyqlv7utua5181l0: time=7334.944 calls=442386
Trigger for constraint fk_df4a0369br3dccp6eyrjwp9kv: time=7425.728 calls=442386
Trigger for constraint fk_diplpbb6klkss8s133w5n35tk: time=7338.198 calls=442386
Trigger for constraint fk_e480805p3sg5al4e6q3se5yvh: time=7503.818 calls=442386
Trigger for constraint fk_e9fqtu339uf5hjadgoytexe6i: time=34702.721 calls=442386
Trigger for constraint fk_eqkhw17gu55br7bmo6lprvd1b: time=8583.740 calls=442386
Trigger for constraint fk_ew91tb31u71m9w2q2deslekn5: time=8434.782 calls=442386
Trigger for constraint fk_f4vetulp53xkwutf2gbp67s5i: time=7330.570 calls=442386
Trigger for constraint fk_flg0marc8w20nw9j1sxm5qhli: time=14022.720 calls=442386
Trigger for constraint fk_g4q3578v7k0u4aw7cxy1d0dc5: time=7310.319 calls=442386
Trigger for constraint fk_gmdj9fq2kgfjy1les8kph88lr: time=9297.111 calls=442386
Trigger for constraint fk_gp0ubv3x88jyrul2ge4m7dlce: time=9106.914 calls=442386
Trigger for constraint fk_gv8e6jdpx6r888dpup4jyh5ij: time=8666.431 calls=442386
Trigger for constraint fk_gynmap13hrrdvxomrc8xsf7j6: time=7319.065 calls=442386
Trigger for constraint fk_h5rh9dd4fvtosb9hh3u3nphey: time=7545.215 calls=442386
Trigger for constraint fk_hij0g0bbxolpbbavjkbtq65ln: time=6942.980 calls=442386
Trigger for constraint fk_hnt6477pi8si94u1mt9qfx6mr: time=8664.874 calls=442386
Trigger for constraint fk_hx641n8sj5797s6a7blyels4b: time=8032.344 calls=442386
Trigger for constraint fk_hxtuos2eok352ep8dmgns1kc7: time=7686.008 calls=442386
Trigger for constraint fk_i2t42b16o1rvl9tswa6t04kcs: time=7346.469 calls=442386
Trigger for constraint fk_i5x5nqhs6j4f7smc17ajk6edj: time=7672.107 calls=442386
Trigger for constraint fk_ie177so2t67fm3y2nluq616vg: time=7459.097 calls=442386
Trigger for constraint fk_ikfivg3qprlbi9qe9608e79wg: time=7395.914 calls=442386
Trigger for constraint fk_j61yuou3wk3pui31fe6gdfkdg: time=7452.350 calls=442386
Trigger for constraint fk_j8tg1rs7ptik5o0mfb60eoxuu: time=7530.020 calls=442386
Trigger for constraint fk_j9j6r9rsm23r66un2vmwi1su9: time=7545.157 calls=442386
Trigger for constraint fk_j9qkpd46uho1lkbtmow1v7f7p: time=1821807.391 calls=442386
Trigger for constraint fk_jmn0eoddcalfp1j1fav8ib6hy: time=10982.331 calls=442386
Trigger for constraint fk_joj4tkkiatyxt7pa0lxpihw77: time=9256.883 calls=442386
Trigger for constraint fk_jsbtueod43s1404b9g4adjmbu: time=7778.566 calls=442386
Trigger for constraint fk_k4us05eksyhy21dk54dnv582g: time=7690.104 calls=442386
Trigger for constraint fk_l3pfquye914p94vd1h4kio4s6: time=7369.764 calls=442386
Trigger for constraint fk_l89cmierwd4opvc8pq5aao538: time=8517.437 calls=442386
Trigger for constraint fk_l9lpnbx75sgw5ubwg5q08g8w6: time=18916375.743 calls=442386
Trigger for constraint fk_la2b2c1b242iu785weax3vm9x: time=29848.317 calls=442386
Trigger for constraint fk_lajuwht9crk38e0272vptahox: time=8352.556 calls=442386
Trigger for constraint fk_lgq0ck7ikipr5470wf3qgih4l: time=7871.365 calls=442386
Trigger for constraint fk_lmsy0lwc9qck9cxejvyag7kdd: time=21471.188 calls=442386
Trigger for constraint fk_m7m4pa975kqltxussmo9291ga: time=8034.138 calls=442386
Trigger for constraint fk_mbrmthgw5xrhmgoatuq9om98n: time=3098231.465 calls=442386
Trigger for constraint fk_mmo0hh69avhw4abhbwi2nq19q: time=12986.104 calls=442386
Trigger for constraint fk_mryttxv197n7llr900j3vgkar: time=8539.481 calls=442386
Trigger for constraint fk_n18dhmatu51ydy8x022d6opkb: time=7682.034 calls=442386
Trigger for constraint fk_n4prap9k31kmmnfoip7giw3w: time=8551.649 calls=442386
Trigger for constraint fk_n8ufgmwpack3cskl1lohkgoep: time=8022.749 calls=442386
Trigger for constraint fk_nsvmphjl3cnrighqx6a26qn15: time=7554.839 calls=442386
Trigger for constraint fk_o1cwkv7rwchdceai1q5h97mjn: time=7860.530 calls=442386
Trigger for constraint fk_o3bxyggatcohovjp6ruo654sl: time=7723.339 calls=442386
Trigger for constraint fk_o3i1v8kptxk6c6rq0byjye73m: time=9615.505 calls=442386
Trigger for constraint fk_o5k0c1yehm58rmac498njrgfg: time=7428.065 calls=442386
Trigger for constraint fk_o7uv2xff0k511p4hawtuuytes: time=7824.898 calls=442386
Trigger for constraint fk_o9gobrt3g46x8kcwljm7skath: time=7524.996 calls=442386
Trigger for constraint fk_os30ueu8nkycjvvqcqhpdkxuv: time=7738.777 calls=442386
Trigger for constraint fk_p10f9yu2aiwu61r7abfs8k9mr: time=7173.447 calls=442386
Trigger for constraint fk_p27qxxoc9t9yg444qyekboonk: time=8322.514 calls=442386
Trigger for constraint fk_p5enwq1k1nql68wupuykxjx5a: time=7843.674 calls=442386
Trigger for constraint fk_p77dxjqerk8p13hfunenalb: time=8116.712 calls=442386
Trigger for constraint fk_pbeboks5e4oc08n79vpydyvhj: time=10114.446 calls=442386
Trigger for constraint fk_pcmvvba81h2xd5v62oeq1vapf: time=6308.060 calls=442386
Trigger for constraint fk_pmb6vx4nb1pjurrlrp62txkcv: time=8024.996 calls=442386
Trigger for constraint fk_ppeju9m9759p8rkfbmtoqpw37: time=7207.077 calls=442386
Trigger for constraint fk_psf0uc3yhan7s68j1cj1w89de: time=7832.246 calls=442386
Trigger for constraint fk_q2ltc6oprjqh683egj39m92m9: time=8175.314 calls=442386
Trigger for constraint fk_q505g2ol072eje64n0x9jx7ll: time=7893.408 calls=442386
Trigger for constraint fk_qinpsenjdeh97d31t45ajxb4v: time=7505.732 calls=442386
Trigger for constraint fk_ri8yo7s3bji5cxriascsg6igr: time=7788.014 calls=442386
Trigger for constraint fk_sgawrn3nca1rai77osoo9bt7u: time=7690.541 calls=442386
Trigger for constraint fk_slm7b9idorunml6utpt1jh316: time=481117.086 calls=442386
Trigger for constraint fk_t4pbocn45hx3ac2g8cp31ykw6: time=9135.068 calls=442386
Trigger for constraint fk_t72avo91ryeo48n2jb94l72uu: time=7761.000 calls=442386
Trigger for constraint fk_t90ttgkwu9vrajj5fhp6sjjat: time=9661.530 calls=442386
Trigger for constraint fk_tjf7eo6k50rcbjv55k4yosqcb: time=7568.944 calls=442386
Execution time: 26268294.290 ms

Per node type stats

node type	count	sum of times	% of query
Delete	1	2,571.470 ms	93.3 %
Index Scan	1	184.649 ms	6.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
subject	2	2,756.119 ms	100.0 %
Delete	1	2,571.470 ms	93.3 %
Index Scan	1	184.649 ms	6.7 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KRZ4

Color mode:

Visible columns:

Per node type stats

Per table stats