explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OLsG

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 10,354.434 ↑ 1.0 1 1

Finalize Aggregate (cost=846,639.87..846,639.88 rows=1 width=8) (actual time=10,354.434..10,354.434 rows=1 loops=1)

2. 65.443 10,396.627 ↓ 1.5 3 1

Gather (cost=846,639.65..846,639.86 rows=2 width=8) (actual time=10,348.053..10,396.627 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 727.262 10,331.184 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=845,639.65..845,639.66 rows=1 width=8) (actual time=10,331.184..10,331.184 rows=1 loops=3)

4. 3,368.846 9,603.922 ↑ 1.2 9,840,566 3 / 3

Hash Left Join (cost=26,305.29..814,911.64 rows=12,291,205 width=0) (actual time=735.502..9,603.922 rows=9,840,566 loops=3)

  • Hash Cond: (r.id = cv.screening_ronde)
5. 3,580.652 5,983.465 ↑ 1.2 9,836,918 3 / 3

Hash Left Join (cost=16,685.99..758,169.91 rows=12,291,205 width=8) (actual time=481.482..5,983.465 rows=9,836,918 loops=3)

  • Hash Cond: (r.id = rv.screening_ronde)
6. 1,925.103 1,925.103 ↑ 1.2 9,832,964 3 / 3

Parallel Seq Scan on screening_ronde r (cost=0.00..693,565.05 rows=12,291,205 width=8) (actual time=0.027..1,925.103 rows=9,832,964 loops=3)

7. 197.281 477.710 ↑ 1.0 438,444 3 / 3

Hash (cost=11,205.44..11,205.44 rows=438,444 width=8) (actual time=477.710..477.710 rows=438,444 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 21223kB
8. 280.429 280.429 ↑ 1.0 438,444 3 / 3

Seq Scan on follow_up_radiologieverslag rv (cost=0.00..11,205.44 rows=438,444 width=8) (actual time=0.920..280.429 rows=438,444 loops=3)

9. 102.581 251.611 ↑ 1.0 247,302 3 / 3

Hash (cost=6,528.02..6,528.02 rows=247,302 width=8) (actual time=251.611..251.611 rows=247,302 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 11709kB
10. 149.030 149.030 ↑ 1.0 247,302 3 / 3

Seq Scan on cda_verslag cv (cost=0.00..6,528.02 rows=247,302 width=8) (actual time=0.051..149.030 rows=247,302 loops=3)

Planning time : 2.212 ms
Execution time : 10,398.664 ms