explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ijNI

Settings
# exclusive inclusive rows x rows loops node
1. 10.626 7,505.858 ↑ 26,703.9 9,732 1

Sort (cost=210,984,049.83..211,633,755.13 rows=259,882,118 width=442) (actual time=7,504.743..7,505.858 rows=9,732 loops=1)

  • Sort Key: brk_stukdelen._gobid
  • Sort Method: quicksort Memory: 10043kB
2. 332.365 7,495.232 ↑ 26,703.9 9,732 1

Hash Left Join (cost=777,959.91..113,269,183.31 rows=259,882,118 width=442) (actual time=6,555.938..7,495.232 rows=9,732 loops=1)

  • Hash Cond: (((rel_3.dst_id)::text = (zrt_0._id)::text) AND ((rel_3.dst_volgnummer)::text = (zrt_0.volgnummer)::text))
  • Filter: ((zrt_0._expiration_date IS NULL) OR (zrt_0._expiration_date > now()))
  • Rows Removed by Filter: 11
3. 75.058 5,058.828 ↑ 65,069.1 9,743 1

Merge Right Join (cost=432,521.29..10,288,356.95 rows=633,968,372 width=474) (actual time=4,439.821..5,058.828 rows=9,743 loops=1)

  • Merge Cond: ((rel_3.src_id)::text = (brk_stukdelen._id)::text)
4. 197.274 197.274 ↑ 1.0 690,917 1

Index Scan using src_id_mv_brk_sdl_brk_zrt_is_bron_voor_zakelijk_recht on mv_brk_sdl_brk_zrt_is_bron_voor_zakelijk_recht rel_3 (cost=0.42..23,578.30 rows=704,984 width=45) (actual time=0.011..197.274 rows=690,917 loops=1)

5. 1.784 4,786.496 ↑ 1,337.0 9,743 1

Materialize (cost=432,518.20..786,067.47 rows=13,026,772 width=442) (actual time=4,433.350..4,786.496 rows=9,743 loops=1)

6. 77.471 4,784.712 ↑ 3,839.3 3,393 1

Merge Left Join (cost=432,518.20..753,500.54 rows=13,026,772 width=442) (actual time=4,433.345..4,784.712 rows=3,393 loops=1)

  • Merge Cond: ((brk_stukdelen._id)::text = (rel_1.src_id)::text)
  • Filter: ((art_0._expiration_date IS NULL) OR (art_0._expiration_date > now()))
  • Rows Removed by Filter: 6
7. 72.663 2,491.824 ↑ 306.8 2,714 1

Merge Left Join (cost=285,084.58..332,483.39 rows=832,616 width=401) (actual time=2,319.528..2,491.824 rows=2,714 loops=1)

  • Merge Cond: ((brk_stukdelen._id)::text = (rel_2.src_id)::text)
  • Filter: ((akt_0._expiration_date IS NULL) OR (akt_0._expiration_date > now()))
8. 2.048 10.798 ↑ 25.4 1,000 1

Sort (cost=69,679.00..69,742.58 rows=25,431 width=359) (actual time=10.512..10.798 rows=1,000 loops=1)

  • Sort Key: brk_stukdelen._id
  • Sort Method: quicksort Memory: 540kB
9. 0.798 8.750 ↑ 25.4 1,000 1

Nested Loop Left Join (cost=1.28..67,818.18 rows=25,431 width=359) (actual time=0.028..8.750 rows=1,000 loops=1)

  • Filter: ((tng_0._expiration_date IS NULL) OR (tng_0._expiration_date > now()))
10. 0.127 1.952 ↑ 1.0 1,000 1

Limit (cost=0.42..128.41 rows=1,000 width=904) (actual time=0.014..1.952 rows=1,000 loops=1)

11. 1.825 1.825 ↑ 891.6 1,000 1

Index Scan using brk_sdl_d05569f886377400312d8c2edd4c6f4c on brk_stukdelen (cost=0.42..114,107.34 rows=891,586 width=904) (actual time=0.013..1.825 rows=1,000 loops=1)

  • Filter: ((_expiration_date IS NULL) OR (_expiration_date > now()))
12. 0.000 6.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=0.86..66.66 rows=68 width=57) (actual time=0.006..0.006 rows=0 loops=1,000)

13. 6.000 6.000 ↓ 0.0 0 1,000

Index Scan using src_id_mv_brk_sdl_brk_tng_is_bron_voor_tenaamstelling on mv_brk_sdl_brk_tng_is_bron_voor_tenaamstelling rel_0 (cost=0.43..20.96 rows=68 width=13) (actual time=0.006..0.006 rows=0 loops=1,000)

  • Index Cond: ((brk_stukdelen._id)::text = (src_id)::text)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using brk_tng_2a4dbedb477015cfe2b9f2c990906f44 on brk_tenaamstellingen tng_0 (cost=0.43..0.66 rows=1 width=58) (never executed)

  • Index Cond: ((_id)::text = (rel_0.dst_id)::text)
15. 956.220 2,408.363 ↑ 1.0 662,959 1

Sort (cost=215,405.57..217,067.82 rows=664,900 width=56) (actual time=2,307.914..2,408.363 rows=662,959 loops=1)

  • Sort Key: rel_2.src_id
  • Sort Method: quicksort Memory: 90418kB
16. 976.786 1,452.143 ↑ 1.0 664,900 1

Hash Right Join (cost=25,192.50..151,100.51 rows=664,900 width=56) (actual time=293.316..1,452.143 rows=664,900 loops=1)

  • Hash Cond: (((akt_0._id)::text = (rel_2.dst_id)::text) AND ((akt_0.volgnummer)::text = (rel_2.dst_volgnummer)::text))
17. 183.468 183.468 ↑ 1.0 1,203,355 1

Seq Scan on brk_aantekeningenkadastraleobjecten akt_0 (cost=0.00..111,143.11 rows=1,203,511 width=90) (actual time=0.010..183.468 rows=1,203,355 loops=1)

18. 178.233 291.889 ↑ 1.0 664,900 1

Hash (cost=15,219.00..15,219.00 rows=664,900 width=46) (actual time=291.889..291.889 rows=664,900 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 51343kB
19. 113.656 113.656 ↑ 1.0 664,900 1

Seq Scan on mv_brk_sdl_brk_akt_is_bron_voor_aantekening_kadastraal_object rel_2 (cost=0.00..15,219.00 rows=664,900 width=46) (actual time=0.020..113.656 rows=664,900 loops=1)

20. 1,263.186 2,215.417 ↑ 1.0 586,019 1

Sort (cost=147,433.63..148,901.74 rows=587,243 width=55) (actual time=2,113.267..2,215.417 rows=586,019 loops=1)

  • Sort Key: rel_1.src_id
  • Sort Method: quicksort Memory: 93188kB
21. 352.287 952.231 ↑ 1.0 587,243 1

Hash Right Join (cost=21,294.97..91,165.18 rows=587,243 width=55) (actual time=244.659..952.231 rows=587,243 loops=1)

  • Hash Cond: ((art_0._id)::text = (rel_1.dst_id)::text)
22. 359.889 359.889 ↓ 1.0 567,873 1

Seq Scan on brk_aantekeningenrechten art_0 (cost=0.00..61,868.39 rows=567,839 width=86) (actual time=0.012..359.889 rows=567,873 loops=1)

23. 161.639 240.055 ↑ 1.0 587,243 1

Hash (cost=13,954.43..13,954.43 rows=587,243 width=43) (actual time=240.055..240.055 rows=587,243 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 52180kB
24. 78.416 78.416 ↑ 1.0 587,243 1

Seq Scan on mv_brk_sdl_brk_art_is_bron_voor_aantekening_recht rel_1 (cost=0.00..13,954.43 rows=587,243 width=43) (actual time=0.018..78.416 rows=587,243 loops=1)

25. 752.834 2,104.039 ↑ 1.0 2,213,581 1

Hash (cost=284,109.25..284,109.25 rows=2,214,425 width=76) (actual time=2,104.039..2,104.039 rows=2,213,581 loops=1)

  • Buckets: 2097152 Batches: 4 Memory Usage: 67556kB
26. 1,351.205 1,351.205 ↑ 1.0 2,213,581 1

Seq Scan on brk_zakelijkerechten zrt_0 (cost=0.00..284,109.25 rows=2,214,425 width=76) (actual time=0.044..1,351.205 rows=2,213,581 loops=1)

Planning time : 3.428 ms
Execution time : 7,507.165 ms