explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C9xN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 328,901.770 ↑ 1.0 13 1

Finalize GroupAggregate (cost=9,667,528.11..9,667,531.51 rows=13 width=35) (actual time=328,901.732..328,901.770 rows=13 loops=1)

  • Group Key: p.region_code
2. 630.379 329,519.911 ↓ 1.5 39 1

Gather Merge (cost=9,667,528.11..9,667,531.15 rows=26 width=35) (actual time=328,901.716..329,519.911 rows=39 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.056 328,889.532 ↑ 1.0 13 3 / 3

Sort (cost=9,666,528.09..9,666,528.12 rows=13 width=35) (actual time=328,889.531..328,889.532 rows=13 loops=3)

  • Sort Key: p.region_code
  • Sort Method: quicksort Memory: 26kB
  • Worker 0: Sort Method: quicksort Memory: 26kB
  • Worker 1: Sort Method: quicksort Memory: 26kB
4. 8,565.184 328,889.476 ↑ 1.0 13 3 / 3

Partial HashAggregate (cost=9,666,527.69..9,666,527.85 rows=13 width=35) (actual time=328,889.467..328,889.476 rows=13 loops=3)

  • Group Key: p.region_code
5. 19,559.676 320,324.292 ↑ 1.3 28,411,014 3 / 3

Merge Join (cost=603.35..9,488,958.12 rows=35,513,913 width=14) (actual time=3.119..320,324.292 rows=28,411,014 loops=3)

  • Merge Cond: (s.id_ref_parcel_fk = p.id)
6. 18,704.172 18,704.172 ↑ 1.3 28,411,014 3 / 3

Parallel Index Scan using parcel_surface_new_id_ref_parcel_fk on parcel_surface_new s (cost=0.57..2,529,373.66 rows=35,513,913 width=15) (actual time=0.117..18,704.172 rows=28,411,014 loops=3)

7. 282,060.444 282,060.444 ↓ 1.0 85,232,758 3 / 3

Index Scan using parcel_new_pkey on parcel_new p (cost=0.57..6,302,859.49 rows=85,217,328 width=7) (actual time=0.794..282,060.444 rows=85,232,758 loops=3)

Planning time : 6.283 ms
Execution time : 329,520.052 ms