explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6aZ5

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4,744.758 ↑ 1.0 1 1

Finalize Aggregate (cost=737,791.74..737,791.75 rows=1 width=8) (actual time=4,744.757..4,744.758 rows=1 loops=1)

2. 49.879 4,776.839 ↓ 1.5 3 1

Gather (cost=737,791.53..737,791.74 rows=2 width=8) (actual time=4,740.079..4,776.839 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 9.851 4,726.960 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=736,791.53..736,791.54 rows=1 width=8) (actual time=4,726.960..4,726.960 rows=1 loops=3)

4. 2,558.474 4,717.109 ↑ 1.2 80,616 3 / 3

Hash Semi Join (cost=9,619.30..736,545.15 rows=98,552 width=0) (actual time=286.327..4,717.109 rows=80,616 loops=3)

  • Hash Cond: (r.id = cv1.screening_ronde)
5. 1,875.724 1,875.724 ↑ 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,875.724 rows=9,832,964 loops=3)

6. 115.245 282.911 ↑ 1.0 247,302 3 / 3

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

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

Seq Scan on cda_verslag cv1 (cost=0.00..6,528.02 rows=247,302 width=8) (actual time=0.042..167.666 rows=247,302 loops=3)

Planning time : 0.680 ms
Execution time : 4,777.988 ms