explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KwwA

Settings
# exclusive inclusive rows x rows loops node
1. 12.747 9,677.579 ↑ 1.0 100,000 1

Limit (cost=3.97..491,161.41 rows=100,000 width=442) (actual time=5.196..9,677.579 rows=100,000 loops=1)

2. 557.868 9,664.832 ↑ 26.1 100,000 1

Nested Loop Left Join (cost=3.97..12,835,568.86 rows=2,613,330 width=442) (actual time=5.194..9,664.832 rows=100,000 loops=1)

3. 58.960 4,206.964 ↑ 26.1 100,000 1

Nested Loop Left Join (cost=3.41..10,130,161.19 rows=2,613,330 width=474) (actual time=5.125..4,206.964 rows=100,000 loops=1)

4. 105.564 4,148.004 ↑ 26.1 100,000 1

Nested Loop Left Join (cost=2.98..8,360,735.86 rows=2,613,330 width=438) (actual time=5.115..4,148.004 rows=100,000 loops=1)

5. 21.107 2,042.440 ↑ 8.9 100,000 1

Nested Loop Left Join (cost=2.55..6,283,891.56 rows=891,586 width=437) (actual time=5.082..2,042.440 rows=100,000 loops=1)

6. 6.723 1,797.655 ↑ 27.9 31,954 1

Nested Loop Left Join (cost=2.13..4,690,551.18 rows=891,586 width=399) (actual time=3.876..1,797.655 rows=31,954 loops=1)

7. 18.165 1,407.484 ↑ 27.9 31,954 1

Nested Loop Left Join (cost=1.70..4,074,900.59 rows=891,586 width=397) (actual time=3.863..1,407.484 rows=31,954 loops=1)

8. 10.643 1,275.719 ↑ 78.5 11,360 1

Nested Loop Left Join (cost=1.27..1,404,309.74 rows=891,586 width=357) (actual time=2.529..1,275.719 rows=11,360 loops=1)

9. 10.526 1,106.036 ↑ 78.5 11,360 1

Nested Loop Left Join (cost=0.85..895,993.73 rows=891,586 width=353) (actual time=2.514..1,106.036 rows=11,360 loops=1)

10. 29.250 29.250 ↑ 130.4 6,835 1

Index Scan using brk_sdl_d05569f886377400312d8c2edd4c6f4c on brk_stukdelen sdl_0 (cost=0.42..114,107.34 rows=891,586 width=316) (actual time=0.029..29.250 rows=6,835 loops=1)

  • Filter: ((_expiration_date IS NULL) OR (_expiration_date > now()))
11. 1,066.260 1,066.260 ↑ 16.0 1 6,835

Index Scan using src_id_mv_brk_sdl_brk_art_is_bron_voor_aantekening_recht on mv_brk_sdl_brk_art_is_bron_voor_aantekening_recht rel_1 (cost=0.42..0.72 rows=16 width=43) (actual time=0.154..0.156 rows=1 loops=6,835)

  • Index Cond: ((sdl_0._id)::text = (src_id)::text)
12. 159.040 159.040 ↑ 1.0 1 11,360

Index Scan using brk_art_b80bb7740288fda1f201890375a60c8f on brk_aantekeningenrechten art_0 (cost=0.42..0.56 rows=1 width=78) (actual time=0.014..0.014 rows=1 loops=11,360)

  • Index Cond: ((_id)::text = (rel_1.dst_id)::text)
  • Filter: ((_expiration_date IS NULL) OR (_expiration_date > now()))
  • Rows Removed by Filter: 0
13. 113.600 113.600 ↑ 46.5 2 11,360

Index Scan using src_id_mv_brk_sdl_brk_akt_is_bron_voor_aantekening_kadastraal_o on mv_brk_sdl_brk_akt_is_bron_voor_aantekening_kadastraal_object rel_2 (cost=0.42..2.07 rows=93 width=46) (actual time=0.009..0.010 rows=2 loops=11,360)

  • Index Cond: ((sdl_0._id)::text = (src_id)::text)
14. 383.448 383.448 ↑ 1.0 1 31,954

Index Scan using brk_akt_b80bb7740288fda1f201890375a60c8f on brk_aantekeningenkadastraleobjecten akt_0 (cost=0.43..0.68 rows=1 width=82) (actual time=0.011..0.012 rows=1 loops=31,954)

  • Index Cond: ((_id)::text = (rel_2.dst_id)::text)
  • Filter: (((volgnummer)::text = (rel_2.dst_volgnummer)::text) AND ((_expiration_date IS NULL) OR (_expiration_date > now())))
  • Rows Removed by Filter: 1
15. 223.678 223.678 ↑ 24.5 2 31,954

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..1.30 rows=49 width=45) (actual time=0.005..0.007 rows=2 loops=31,954)

  • Index Cond: ((sdl_0._id)::text = (src_id)::text)
16. 2,000.000 2,000.000 ↓ 0.0 0 100,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..1.65 rows=68 width=13) (actual time=0.020..0.020 rows=0 loops=100,000)

  • Index Cond: ((sdl_0._id)::text = (src_id)::text)
17. 0.000 0.000 ↓ 0.0 0 100,000

Index Scan using brk_tng_2a4dbedb477015cfe2b9f2c990906f44 on brk_tenaamstellingen tng_0 (cost=0.43..0.67 rows=1 width=50) (actual time=0.000..0.000 rows=0 loops=100,000)

  • Index Cond: ((_id)::text = (rel_0.dst_id)::text)
  • Filter: ((_expiration_date IS NULL) OR (_expiration_date > now()))
18. 4,900.000 4,900.000 ↑ 1.0 1 100,000

Index Scan using brk_zrt_2a4dbedb477015cfe2b9f2c990906f44 on brk_zakelijkerechten zrt_0 (cost=0.56..1.02 rows=1 width=68) (actual time=0.049..0.049 rows=1 loops=100,000)

  • Index Cond: (((_id)::text = (rel_3.dst_id)::text) AND ((volgnummer)::text = (rel_3.dst_volgnummer)::text))
  • Filter: ((_expiration_date IS NULL) OR (_expiration_date > now()))
  • Rows Removed by Filter: 0
Planning time : 10.256 ms
Execution time : 9,684.850 ms