explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hWvH

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

Finalize Aggregate (cost=741,909.43..741,909.44 rows=1 width=8) (actual time=4,765.610..4,765.610 rows=1 loops=1)

2. 56.892 4,799.417 ↓ 1.5 3 1

Gather (cost=741,909.21..741,909.42 rows=2 width=8) (actual time=4,761.719..4,799.417 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 9.449 4,742.525 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=740,909.21..740,909.22 rows=1 width=8) (actual time=4,742.525..4,742.525 rows=1 loops=3)

4. 2,409.683 4,733.076 ↑ 1.2 80,616 3 / 3

Hash Join (cost=14,833.37..740,662.83 rows=98,552 width=0) (actual time=542.930..4,733.076 rows=80,616 loops=3)

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

6. 106.227 539.393 ↓ 1.0 241,848 3 / 3

Hash (cost=11,876.80..11,876.80 rows=236,526 width=8) (actual time=539.393..539.393 rows=241,848 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 11496kB
7. 333.726 433.166 ↓ 1.0 241,848 3 / 3

HashAggregate (cost=7,146.28..9,511.53 rows=236,526 width=8) (actual time=320.687..433.166 rows=241,848 loops=3)

  • Group Key: cv1.screening_ronde
8. 99.440 99.440 ↑ 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.038..99.440 rows=247,302 loops=3)

Planning time : 0.477 ms
Execution time : 4,806.909 ms