explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U1Fr

Settings
# exclusive inclusive rows x rows loops node
1. 486.466 111,244.830 ↑ 175,217.3 200,788 1

Sort (cost=15,340,945,975.87..15,428,899,815.55 rows=35,181,535,874 width=438) (actual time=111,211.233..111,244.830 rows=200,788 loops=1)

  • Sort Key: brk_stukdelen._gobid
  • Sort Method: external merge Disk: 105888kB
2. 952.473 110,758.364 ↑ 175,217.3 200,788 1

Hash Left Join (cost=45,778,318.14..1,008,091,706.88 rows=35,181,535,874 width=438) (actual time=105,417.087..110,758.364 rows=200,788 loops=1)

  • Hash Cond: (((rel_3.dst_id)::text = (zrt_0._id)::text) AND ((rel_3.dst_volgnummer)::text = (zrt_0.volgnummer)::text))
3. 3,925.851 14,924.190 ↑ 175,217.3 200,788 1

Hash Right Join (cost=45,312,346.89..471,107,066.77 rows=35,181,535,874 width=474) (actual time=10,534.025..14,924.190 rows=200,788 loops=1)

  • Hash Cond: ((rel_2.src_id)::text = (brk_stukdelen._id)::text)
4. 444.951 1,599.820 ↑ 1.0 664,900 1

Hash Left Join (cost=215,087.09..233,796.82 rows=664,900 width=48) (actual time=1,041.633..1,599.820 rows=664,900 loops=1)

  • Hash Cond: (((rel_2.dst_id)::text = (akt_0._id)::text) AND ((rel_2.dst_volgnummer)::text = (akt_0.volgnummer)::text))
5. 113.963 113.963 ↑ 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.031..113.963 rows=664,900 loops=1)

6. 167.705 1,040.906 ↑ 1.0 424,427 1

Hash (cost=208,654.30..208,654.30 rows=428,853 width=82) (actual time=1,040.905..1,040.906 rows=424,427 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 51652kB
7. 828.926 873.201 ↑ 1.0 424,427 1

Bitmap Heap Scan on brk_aantekeningenkadastraleobjecten akt_0 (cost=6,187.42..208,654.30 rows=428,853 width=82) (actual time=66.127..873.201 rows=424,427 loops=1)

  • Recheck Cond: ((_expiration_date IS NULL) OR (_expiration_date > now()))
  • Heap Blocks: exact=98969
8. 0.002 44.275 ↓ 0.0 0 1

BitmapOr (cost=6,187.42..6,187.42 rows=431,525 width=0) (actual time=44.275..44.275 rows=0 loops=1)

9. 44.252 44.252 ↓ 1.0 424,419 1

Bitmap Index Scan on brk_akt_1a9d849ff5a68997176b6144236806ae (cost=0.00..5,867.29 rows=423,942 width=0) (actual time=44.252..44.252 rows=424,419 loops=1)

  • Index Cond: (_expiration_date IS NULL)
10. 0.021 0.021 ↑ 947.9 8 1

Bitmap Index Scan on brk_akt_1a9d849ff5a68997176b6144236806ae (cost=0.00..105.70 rows=7,583 width=0) (actual time=0.021..0.021 rows=8 loops=1)

  • Index Cond: (_expiration_date > now())
11. 246.597 9,398.519 ↑ 2,799.9 188,977 1

Hash (cost=8,513,210.54..8,513,210.54 rows=529,125,220 width=438) (actual time=9,398.519..9,398.519 rows=188,977 loops=1)

  • Buckets: 524288 Batches: 2048 Memory Usage: 39913kB
12. 388.758 9,151.922 ↑ 2,799.9 188,977 1

Hash Right Join (cost=1,698,580.63..8,513,210.54 rows=529,125,220 width=438) (actual time=8,625.540..9,151.922 rows=188,977 loops=1)

  • Hash Cond: ((rel_3.src_id)::text = (brk_stukdelen._id)::text)
13. 154.268 154.268 ↑ 1.0 704,984 1

Seq Scan on mv_brk_sdl_brk_zrt_is_bron_voor_zakelijk_recht rel_3 (cost=0.00..16,935.84 rows=704,984 width=45) (actual time=0.015..154.268 rows=704,984 loops=1)

14. 20.538 8,608.896 ↑ 612.1 17,423 1

Hash (cost=1,013,251.32..1,013,251.32 rows=10,665,305 width=400) (actual time=8,608.896..8,608.896 rows=17,423 loops=1)

  • Buckets: 524288 Batches: 32 Memory Usage: 4279kB
15. 207.311 8,588.358 ↑ 612.1 17,423 1

Hash Right Join (cost=798,898.61..1,013,251.32 rows=10,665,305 width=400) (actual time=7,871.063..8,588.358 rows=17,423 loops=1)

  • Hash Cond: ((rel_1.src_id)::text = (brk_stukdelen._id)::text)
16. 404.370 1,475.134 ↑ 1.0 587,243 1

Hash Left Join (cost=124,457.06..139,953.02 rows=587,243 width=47) (actual time=963.507..1,475.134 rows=587,243 loops=1)

  • Hash Cond: ((rel_1.dst_id)::text = (art_0._id)::text)
17. 108.560 108.560 ↑ 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.010..108.560 rows=587,243 loops=1)

18. 195.941 962.204 ↓ 1.1 563,447 1

Hash (cost=117,894.54..117,894.54 rows=525,002 width=78) (actual time=962.204..962.204 rows=563,447 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 69566kB
19. 766.263 766.263 ↓ 1.1 563,447 1

Seq Scan on brk_aantekeningenrechten art_0 (cost=0.00..117,894.54 rows=525,002 width=78) (actual time=0.030..766.263 rows=563,447 loops=1)

  • Filter: ((_expiration_date IS NULL) OR (_expiration_date > now()))
  • Rows Removed by Filter: 4426
20. 24.846 6,905.913 ↑ 66.6 10,000 1

Hash (cost=634,883.74..634,883.74 rows=666,224 width=359) (actual time=6,905.913..6,905.913 rows=10,000 loops=1)

  • Buckets: 524288 Batches: 2 Memory Usage: 5798kB
21. 13.580 6,881.067 ↑ 66.6 10,000 1

Nested Loop Left Join (cost=1.28..634,883.74 rows=666,224 width=359) (actual time=3.129..6,881.067 rows=10,000 loops=1)

22. 24.671 6,867.487 ↑ 66.6 10,000 1

Nested Loop Left Join (cost=0.85..52,659.64 rows=666,224 width=323) (actual time=3.124..6,867.487 rows=10,000 loops=1)

23. 3.347 5,432.816 ↑ 1.0 10,000 1

Limit (cost=0.42..5,042.84 rows=10,000 width=904) (actual time=2.228..5,432.816 rows=10,000 loops=1)

24. 5,429.469 5,429.469 ↑ 39.3 10,000 1

Index Scan using brk_sdl_d05569f886377400312d8c2edd4c6f4c on brk_stukdelen (cost=0.42..198,222.48 rows=393,109 width=904) (actual time=2.226..5,429.469 rows=10,000 loops=1)

  • Index Cond: (_gobid > 470000)
  • Filter: ((_expiration_date IS NULL) OR (_expiration_date > now()))
25. 1,410.000 1,410.000 ↓ 0.0 0 10,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..4.08 rows=67 width=13) (actual time=0.141..0.141 rows=0 loops=10,000)

  • Index Cond: ((brk_stukdelen._id)::text = (src_id)::text)
26. 0.000 0.000 ↓ 0.0 0 10,000

Index Scan using brk_tenaamstellingen__id_key1 on brk_tenaamstellingen tng_0 (cost=0.43..0.87 rows=1 width=50) (actual time=0.000..0.000 rows=0 loops=10,000)

  • Index Cond: ((_id)::text = (rel_0.dst_id)::text)
  • Filter: ((_expiration_date IS NULL) OR (_expiration_date > now()))
27. 533.652 94,881.701 ↓ 1.1 788,683 1

Hash (cost=454,868.18..454,868.18 rows=740,205 width=68) (actual time=94,881.701..94,881.701 rows=788,683 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 75267kB
28. 94,153.568 94,348.049 ↓ 1.1 788,683 1

Bitmap Heap Scan on brk_zakelijkerechten zrt_0 (cost=10,922.01..454,868.18 rows=740,205 width=68) (actual time=326.098..94,348.049 rows=788,683 loops=1)

  • Recheck Cond: ((_expiration_date IS NULL) OR (_expiration_date > now()))
  • Heap Blocks: exact=417174
29. 0.002 194.481 ↓ 0.0 0 1

BitmapOr (cost=10,922.01..10,922.01 rows=740,205 width=0) (actual time=194.481..194.481 rows=0 loops=1)

30. 194.459 194.459 ↓ 2.0 1,458,715 1

Bitmap Index Scan on brk_zrt_1a9d849ff5a68997176b6144236806ae (cost=0.00..10,550.36 rows=740,205 width=0) (actual time=194.459..194.459 rows=1,458,715 loops=1)

  • Index Cond: (_expiration_date IS NULL)
31. 0.020 0.020 ↓ 0.0 0 1

Bitmap Index Scan on brk_zrt_1a9d849ff5a68997176b6144236806ae (cost=0.00..1.54 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (_expiration_date > now())
Planning time : 8.738 ms
Execution time : 111,275.098 ms