explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2phR

Settings
# exclusive inclusive rows x rows loops node
1. 974.883 1,879.254 ↓ 0.0 0 1

Delete on privates (cost=40,726.58..87,988.53 rows=443,235 width=12) (actual time=1,879.254..1,879.254 rows=0 loops=1)

2. 402.104 904.371 ↑ 1.0 442,386 1

Hash Join (cost=40,726.58..87,988.53 rows=443,235 width=12) (actual time=361.371..904.371 rows=442,386 loops=1)

  • Hash Cond: (subject.id = privates.id)
3. 143.172 143.172 ↑ 1.0 442,386 1

Index Scan using subject_lognumber_idx on subject (cost=0.42..32,891.47 rows=444,903 width=14) (actual time=0.023..143.172 rows=442,386 loops=1)

  • Index Cond: (lognumber = 23)
4. 169.875 359.095 ↑ 1.0 902,718 1

Hash (cost=25,034.18..25,034.18 rows=902,718 width=14) (actual time=359.095..359.095 rows=902,718 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3676kB
5. 189.220 189.220 ↑ 1.0 902,718 1

Seq Scan on privates (cost=0.00..25,034.18 rows=902,718 width=14) (actual time=0.025..189.220 rows=902,718 loops=1)

Planning time : 0.370 ms
Execution time : 150,867.894 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint fk_1t4jhpao071ptei8ry3vf5vf4 11,674.814 ms 442386 0.026 ms
for constraint fk_2cpk7iv9duf5ypt0gg3li3tfh 10,910.674 ms 442386 0.025 ms
for constraint fk_3h0of117tkf7c268c6h3fjedj 11,031.052 ms 442386 0.025 ms
for constraint fk_5nsswhtv9xvkhmkddt9f31kx9 11,540.188 ms 442386 0.026 ms
for constraint fk_70ykrtf27rf4tyge6ly17wdq0 11,413.051 ms 442386 0.026 ms
for constraint fk_8akig60iy1c2ek3wubitmscii 11,409.791 ms 442386 0.026 ms
for constraint fk_a6pf8q57c1h1r9f6cswk61cj9 11,482.364 ms 442386 0.026 ms
for constraint fk_csewdh104dd8wohn32266i9lv 11,473.245 ms 442386 0.026 ms
for constraint fk_ehj1jyt8vfhuvs2etlcb0763l 11,433.865 ms 442386 0.026 ms
for constraint fk_gtewgu35hrqmcn8s28fwhkmy9 11,457.271 ms 442386 0.026 ms
for constraint fk_n45nnwidskcvughkko9m51dr 11,431.214 ms 442386 0.026 ms
for constraint fk_r6u4hwokni8l7poh0ikyewhyt 11,479.708 ms 442386 0.026 ms
for constraint fk_t7ihhc4ottle5wl0xtvwtducd 11,430.504 ms 442386 0.026 ms