explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4g2o

Settings
# exclusive inclusive rows x rows loops node
1. 148.758 114,417.343 ↑ 307,423.4 114,440 1

Sort (cost=15,340,943,455.77..15,428,897,295.45 rows=35,181,535,874 width=438) (actual time=114,403.025..114,417.343 rows=114,440 loops=1)

  • Sort Key: brk_stukdelen._gobid
  • Sort Method: quicksort Memory: 115935kB
2. 503.276 114,268.585 ↑ 307,423.4 114,440 1

Hash Left Join (cost=45,775,798.04..1,008,089,186.78 rows=35,181,535,874 width=438) (actual time=98,227.719..114,268.585 rows=114,440 loops=1)

  • Hash Cond: (((rel_3.dst_id)::text = (zrt_0._id)::text) AND ((rel_3.dst_volgnummer)::text = (zrt_0.volgnummer)::text))
3. 14,863.237 79,236.734 ↑ 307,423.4 114,440 1

Hash Right Join (cost=45,309,826.79..471,104,546.67 rows=35,181,535,874 width=474) (actual time=63,694.173..79,236.734 rows=114,440 loops=1)

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

Hash Left Join (cost=215,087.09..233,796.82 rows=664,900 width=48) (actual time=61,358.768..62,150.297 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. 347.647 347.647 ↑ 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.024..347.647 rows=664,900 loops=1)

6. 206.964 61,355.827 ↑ 1.0 424,427 1

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

  • Buckets: 524288 Batches: 1 Memory Usage: 51652kB
7. 1,108.291 61,148.863 ↑ 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=60,071.323..61,148.863 rows=424,427 loops=1)

  • Recheck Cond: ((_expiration_date IS NULL) OR (_expiration_date > now()))
  • Heap Blocks: exact=98969
8. 0.007 60,040.572 ↓ 0.0 0 1

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

9. 60,040.478 60,040.478 ↓ 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=60,040.478..60,040.478 rows=424,419 loops=1)

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

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

  • Index Cond: (_expiration_date > now())
11. 93.706 2,223.200 ↑ 8,202.3 64,509 1

Hash (cost=8,510,690.45..8,510,690.45 rows=529,125,220 width=438) (actual time=2,223.200..2,223.200 rows=64,509 loops=1)

  • Buckets: 524288 Batches: 2048 Memory Usage: 6615kB
12. 354.769 2,129.494 ↑ 8,202.3 64,509 1

Hash Right Join (cost=1,696,060.54..8,510,690.45 rows=529,125,220 width=438) (actual time=1,646.386..2,129.494 rows=64,509 loops=1)

  • Hash Cond: ((rel_3.src_id)::text = (brk_stukdelen._id)::text)
13. 135.160 135.160 ↑ 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.021..135.160 rows=704,984 loops=1)

14. 16.017 1,639.565 ↑ 651.0 16,384 1

Hash (cost=1,010,731.22..1,010,731.22 rows=10,665,305 width=400) (actual time=1,639.565..1,639.565 rows=16,384 loops=1)

  • Buckets: 524288 Batches: 32 Memory Usage: 4263kB
15. 211.802 1,623.548 ↑ 651.0 16,384 1

Hash Right Join (cost=796,378.51..1,010,731.22 rows=10,665,305 width=400) (actual time=932.329..1,623.548 rows=16,384 loops=1)

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

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

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

18. 217.807 789.136 ↓ 1.1 563,447 1

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

  • Buckets: 1048576 Batches: 1 Memory Usage: 69566kB
19. 571.329 571.329 ↓ 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.028..571.329 rows=563,447 loops=1)

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

Hash (cost=632,363.65..632,363.65 rows=666,224 width=359) (actual time=134.911..134.911 rows=10,000 loops=1)

  • Buckets: 524288 Batches: 2 Memory Usage: 5774kB
21. 4.784 125.643 ↑ 66.6 10,000 1

Nested Loop Left Join (cost=1.28..632,363.65 rows=666,224 width=359) (actual time=0.139..125.643 rows=10,000 loops=1)

22. 5.891 120.859 ↑ 66.6 10,000 1

Nested Loop Left Join (cost=0.85..50,139.55 rows=666,224 width=323) (actual time=0.125..120.859 rows=10,000 loops=1)

23. 1.099 34.968 ↑ 1.0 10,000 1

Limit (cost=0.42..2,522.75 rows=10,000 width=904) (actual time=0.064..34.968 rows=10,000 loops=1)

24. 33.869 33.869 ↑ 82.8 10,000 1

Index Scan using brk_sdl_d05569f886377400312d8c2edd4c6f4c on brk_stukdelen (cost=0.42..208,767.89 rows=827,680 width=904) (actual time=0.062..33.869 rows=10,000 loops=1)

  • Filter: ((_expiration_date IS NULL) OR (_expiration_date > now()))
25. 80.000 80.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.008..0.008 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. 382.667 34,528.575 ↓ 1.1 788,683 1

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

  • Buckets: 1048576 Batches: 1 Memory Usage: 75267kB
28. 33,904.809 34,145.908 ↓ 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=389.362..34,145.908 rows=788,683 loops=1)

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

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

30. 241.074 241.074 ↓ 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=241.074..241.074 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 : 128.755 ms
Execution time : 114,435.147 ms