explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UO04

Settings
# exclusive inclusive rows x rows loops node
1. 319.059 6,341.005 ↓ 2,579.7 7,739 1

Nested Loop Left Join (cost=8.24..2,111.12 rows=3 width=913) (actual time=22.762..6,341.005 rows=7,739 loops=1)

  • Filter: ((sjt_1._date_deleted IS NULL) AND ((sjt_1._expiration_date IS NULL) OR (sjt_1._expiration_date > now())))
2. 21.314 5,743.342 ↓ 1,934.8 7,739 1

Nested Loop Left Join (cost=7.38..2,101.49 rows=4 width=1,246) (actual time=19.405..5,743.342 rows=7,739 loops=1)

  • Filter: ((tng_0._date_deleted IS NULL) AND ((tng_0._expiration_date IS NULL) OR (tng_0._expiration_date > now())))
  • Rows Removed by Filter: 63119
3. 8.989 3,371.928 ↓ 591.7 7,100 1

Nested Loop Left Join (cost=6.40..2,082.36 rows=12 width=1,226) (actual time=12.385..3,371.928 rows=7,100 loops=1)

  • Filter: ((kse_0._date_deleted IS NULL) AND ((kse_0._expiration_date IS NULL) OR (kse_0._expiration_date > now())))
4. 7.024 3,348.739 ↓ 591.7 7,100 1

Nested Loop Left Join (cost=6.25..2,080.23 rows=12 width=1,227) (actual time=12.346..3,348.739 rows=7,100 loops=1)

  • Filter: ((sjt_0._date_deleted IS NULL) AND ((sjt_0._expiration_date IS NULL) OR (sjt_0._expiration_date > now())))
5. 5.010 3,256.515 ↓ 507.1 7,100 1

Nested Loop Left Join (cost=5.42..2,054.60 rows=14 width=1,006) (actual time=12.292..3,256.515 rows=7,100 loops=1)

  • Filter: ((zrt_0._date_deleted IS NULL) AND ((zrt_0._expiration_date IS NULL) OR (zrt_0._expiration_date > now())))
6. 7.870 2,995.905 ↓ 186.8 7,100 1

Nested Loop Left Join (cost=4.30..1,702.88 rows=38 width=902) (actual time=12.131..2,995.905 rows=7,100 loops=1)

  • Filter: ((kot_1._date_deleted IS NULL) AND ((kot_1._expiration_date IS NULL) OR (kot_1._expiration_date > now())))
7. 2.947 2,860.235 ↓ 71.0 7,100 1

Nested Loop Left Join (cost=3.75..1,633.43 rows=100 width=901) (actual time=10.464..2,860.235 rows=7,100 loops=1)

8. 0.365 789.288 ↑ 1.0 100 1

Nested Loop Left Join (cost=3.19..1,354.43 rows=100 width=862) (actual time=4.938..789.288 rows=100 loops=1)

9. 0.441 781.923 ↑ 1.0 100 1

Nested Loop Left Join (cost=2.64..1,076.18 rows=100 width=855) (actual time=3.187..781.923 rows=100 loops=1)

  • Filter: ((kge_0._date_deleted IS NULL) AND ((kge_0._expiration_date IS NULL) OR (kge_0._expiration_date > now())))
10. 0.453 780.882 ↑ 1.0 100 1

Nested Loop Left Join (cost=2.50..1,058.93 rows=100 width=863) (actual time=3.165..780.882 rows=100 loops=1)

11. 0.538 777.629 ↑ 1.0 100 1

Nested Loop Left Join (cost=1.95..780.18 rows=100 width=851) (actual time=3.105..777.629 rows=100 loops=1)

  • Filter: ((kce_0._date_deleted IS NULL) AND ((kce_0._expiration_date IS NULL) OR (kce_0._expiration_date > now())))
12. 0.349 776.391 ↑ 1.0 100 1

Nested Loop Left Join (cost=1.80..762.68 rows=100 width=853) (actual time=3.076..776.391 rows=100 loops=1)

13. 0.458 772.542 ↑ 1.0 100 1

Nested Loop Left Join (cost=1.25..483.93 rows=100 width=847) (actual time=2.989..772.542 rows=100 loops=1)

  • Filter: ((gme_0._date_deleted IS NULL) AND ((gme_0._expiration_date IS NULL) OR (gme_0._expiration_date > now())))
14. 0.550 770.184 ↑ 1.0 100 1

Nested Loop Left Join (cost=0.98..453.42 rows=100 width=838) (actual time=1.880..770.184 rows=100 loops=1)

15. 0.112 766.534 ↑ 1.0 100 1

Limit (cost=0.43..174.17 rows=100 width=1,413) (actual time=1.774..766.534 rows=100 loops=1)

16. 766.422 766.422 ↑ 4,754.4 100 1

Index Scan using brk_kadastraleobjecten_pkey on brk_kadastraleobjecten (cost=0.43..826,025.06 rows=475,439 width=1,413) (actual time=1.771..766.422 rows=100 loops=1)

  • Filter: ((_date_deleted IS NULL) AND ((_expiration_date IS NULL) OR (_expiration_date > now())))
  • Rows Removed by Filter: 885
17. 3.100 3.100 ↑ 1.0 1 100

Index Only Scan using src_dst_wide_mv_brk_kot_brk_gme_aangeduid_door_gemeente on mv_brk_kot_brk_gme_aangeduid_door_gemeente rel_0 (cost=0.55..2.77 rows=1 width=44) (actual time=0.030..0.031 rows=1 loops=100)

  • Index Cond: ((src_id = (brk_kadastraleobjecten._id)::text) AND (src_volgnummer = (brk_kadastraleobjecten.volgnummer)::text))
  • Heap Fetches: 100
18. 1.900 1.900 ↑ 1.0 1 100

Index Scan using brk_gme_b80bb7740288fda1f201890375a60c8f on brk_gemeentes gme_0 (cost=0.27..0.29 rows=1 width=35) (actual time=0.018..0.019 rows=1 loops=100)

  • Index Cond: ((rel_0.dst_id)::text = (_id)::text)
19. 3.500 3.500 ↑ 1.0 1 100

Index Scan using src_dst_wide_mv_brk_kot_brk_kce_aangeduid_door_kadastralegemeen on mv_brk_kot_brk_kce_aangeduid_door_kadastralegemeentecode rel_1 (cost=0.55..2.78 rows=1 width=51) (actual time=0.034..0.035 rows=1 loops=100)

  • Index Cond: (((src_id)::text = (brk_kadastraleobjecten._id)::text) AND ((src_volgnummer)::text = (brk_kadastraleobjecten.volgnummer)::text))
  • Filter: ((bronwaarde)::text = (brk_kadastraleobjecten.aangeduid_door_kadastralegemeentecode ->> 'bronwaarde'::text))
20. 0.700 0.700 ↑ 1.0 1 100

Index Scan using brk_kce_b80bb7740288fda1f201890375a60c8f on brk_kadastralegemeentecodes kce_0 (cost=0.14..0.16 rows=1 width=26) (actual time=0.006..0.007 rows=1 loops=100)

  • Index Cond: ((rel_1.dst_id)::text = (_id)::text)
21. 2.800 2.800 ↑ 1.0 1 100

Index Scan using src_dst_wide_mv_brk_kot_brk_kge_aangeduid_door_kadastralegemeen on mv_brk_kot_brk_kge_aangeduid_door_kadastralegemeente rel_2 (cost=0.55..2.78 rows=1 width=63) (actual time=0.027..0.028 rows=1 loops=100)

  • Index Cond: (((src_id)::text = (brk_kadastraleobjecten._id)::text) AND ((src_volgnummer)::text = (brk_kadastraleobjecten.volgnummer)::text))
  • Filter: ((bronwaarde)::text = (brk_kadastraleobjecten.aangeduid_door_kadastralegemeente ->> 'bronwaarde'::text))
22. 0.600 0.600 ↑ 1.0 1 100

Index Scan using brk_kge_b80bb7740288fda1f201890375a60c8f on brk_kadastralegemeentes kge_0 (cost=0.14..0.16 rows=1 width=30) (actual time=0.005..0.006 rows=1 loops=100)

  • Index Cond: ((rel_2.dst_id)::text = (_id)::text)
23. 7.000 7.000 ↑ 1.0 1 100

Index Only Scan using src_dst_wide_mv_brk_kot_brk_kse_aangeduid_door_kadastralesectie on mv_brk_kot_brk_kse_aangeduid_door_kadastralesectie rel_3 (cost=0.55..2.77 rows=1 width=46) (actual time=0.069..0.070 rows=1 loops=100)

  • Index Cond: ((src_id = (brk_kadastraleobjecten._id)::text) AND (src_volgnummer = (brk_kadastraleobjecten.volgnummer)::text))
  • Heap Fetches: 100
24. 2,068.000 2,068.000 ↓ 71.0 71 100

Index Only Scan using src_dst_wide_mv_brk_kot_brk_kot_is_ontstaan_uit_g_perceel on mv_brk_kot_brk_kot_is_ontstaan_uit_g_perceel rel_4 (cost=0.56..2.78 rows=1 width=78) (actual time=1.900..20.680 rows=71 loops=100)

  • Index Cond: ((src_id = (brk_kadastraleobjecten._id)::text) AND (src_volgnummer = (brk_kadastraleobjecten.volgnummer)::text))
  • Heap Fetches: 7100
25. 127.800 127.800 ↑ 1.0 1 7,100

Index Scan using brk_kot_2a4dbedb477015cfe2b9f2c990906f44 on brk_kadastraleobjecten kot_1 (cost=0.55..0.68 rows=1 width=94) (actual time=0.017..0.018 rows=1 loops=7,100)

  • Index Cond: (((rel_4.dst_id)::text = (_id)::text) AND ((rel_4.dst_volgnummer)::text = (volgnummer)::text))
26. 7.100 255.600 ↑ 1.0 1 7,100

Nested Loop Left Join (cost=1.11..9.24 rows=1 width=195) (actual time=0.031..0.036 rows=1 loops=7,100)

27. 134.900 134.900 ↑ 1.0 1 7,100

Index Scan using dst_id_mv_brk_zrt_brk_kot_rust_op_kadastraalobject on mv_brk_zrt_brk_kot_rust_op_kadastraalobject rel_5 (cost=0.56..8.33 rows=1 width=78) (actual time=0.014..0.019 rows=1 loops=7,100)

  • Index Cond: ((dst_id)::text = (brk_kadastraleobjecten._id)::text)
  • Filter: ((dst_volgnummer)::text = (brk_kadastraleobjecten.volgnummer)::text)
  • Rows Removed by Filter: 9
28. 113.600 113.600 ↑ 1.0 1 7,100

Index Scan using brk_zakelijkerechten__id_volgnummer_key on brk_zakelijkerechten zrt_0 (cost=0.56..0.92 rows=1 width=156) (actual time=0.016..0.016 rows=1 loops=7,100)

  • Index Cond: (((rel_5.src_id)::text = (_id)::text) AND ((rel_5.src_volgnummer)::text = (volgnummer)::text))
  • Filter: ((akr_aard_zakelijk_recht)::text = 'VE'::text)
29. 0.000 85.200 ↓ 0.0 0 7,100

Nested Loop Left Join (cost=0.84..1.82 rows=1 width=273) (actual time=0.012..0.012 rows=0 loops=7,100)

30. 85.200 85.200 ↓ 0.0 0 7,100

Index Only Scan using src_dst_wide_mv_brk_zrt_brk_sjt_betrokken_bij_appartementsrecht on mv_brk_zrt_brk_sjt_betrokken_bij_appartementsrechtsplitsing_vve rel_6 (cost=0.42..0.44 rows=1 width=61) (actual time=0.012..0.012 rows=0 loops=7,100)

  • Index Cond: ((src_id = (zrt_0._id)::text) AND (src_volgnummer = (zrt_0.volgnummer)::text))
  • Heap Fetches: 0
31. 0.000 0.000 ↓ 0.0 0

Index Scan using brk_sjt_b80bb7740288fda1f201890375a60c8f on brk_kadastralesubjecten sjt_0 (cost=0.42..1.38 rows=1 width=261) (never executed)

  • Index Cond: ((rel_6.dst_id)::text = (_id)::text)
32. 14.200 14.200 ↑ 1.0 1 7,100

Index Scan using brk_kse_b80bb7740288fda1f201890375a60c8f on brk_kadastralesecties kse_0 (cost=0.14..0.16 rows=1 width=29) (actual time=0.002..0.002 rows=1 loops=7,100)

  • Index Cond: ((rel_3.dst_id)::text = (_id)::text)
33. 0.000 2,350.100 ↓ 10.0 10 7,100

Nested Loop Left Join (cost=0.99..1.58 rows=1 width=114) (actual time=0.046..0.331 rows=10 loops=7,100)

34. 866.200 866.200 ↓ 10.0 10 7,100

Index Scan using dst_id_mv_brk_tng_brk_zrt_van_zakelijkrecht on mv_brk_tng_brk_zrt_van_zakelijkrecht rel_7 (cost=0.56..0.69 rows=1 width=46) (actual time=0.025..0.122 rows=10 loops=7,100)

  • Index Cond: ((dst_id)::text = (zrt_0._id)::text)
  • Filter: ((dst_volgnummer)::text = (zrt_0.volgnummer)::text)
35. 1,488.018 1,488.018 ↑ 1.0 1 70,858

Index Scan using brk_tenaamstellingen__id_key1 on brk_tenaamstellingen tng_0 (cost=0.43..0.89 rows=1 width=75) (actual time=0.021..0.021 rows=1 loops=70,858)

  • Index Cond: ((rel_7.src_id)::text = (_id)::text)
36. 15.478 278.604 ↑ 1.0 1 7,739

Nested Loop Left Join (cost=0.85..0.97 rows=1 width=376) (actual time=0.035..0.036 rows=1 loops=7,739)

37. 162.519 162.519 ↑ 1.0 1 7,739

Index Scan using src_id_mv_brk_tng_brk_sjt_van_kadastraalsubject on mv_brk_tng_brk_sjt_van_kadastraalsubject rel_8 (cost=0.43..0.46 rows=1 width=31) (actual time=0.021..0.021 rows=1 loops=7,739)

  • Index Cond: ((src_id)::text = (tng_0._id)::text)
38. 100.607 100.607 ↑ 1.0 1 7,739

Index Scan using brk_sjt_b80bb7740288fda1f201890375a60c8f on brk_kadastralesubjecten sjt_1 (cost=0.42..0.51 rows=1 width=393) (actual time=0.013..0.013 rows=1 loops=7,739)

  • Index Cond: ((rel_8.dst_id)::text = (_id)::text)
Planning time : 502.138 ms
Execution time : 6,352.243 ms