explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wVOl

Settings
# exclusive inclusive rows x rows loops node
1. 162.172 11,705.199 ↓ 3.5 75,009 1

Group (cost=1,035,923.54..1,036,246.91 rows=21,558 width=22) (actual time=11,428.293..11,705.199 rows=75,009 loops=1)

  • Group Key: country__aln, postal_code__aln
2. 629.462 11,543.027 ↓ 3.6 157,091 1

Sort (cost=1,035,923.54..1,036,031.33 rows=43,116 width=22) (actual time=11,428.287..11,543.027 rows=157,091 loops=1)

  • Sort Key: country__aln, postal_code__aln
  • Sort Method: quicksort Memory: 18417kB
3. 163.503 10,913.565 ↓ 3.6 157,091 1

Gather (cost=1,028,077.31..1,032,604.49 rows=43,116 width=22) (actual time=10,710.220..10,913.565 rows=157,091 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 4,902.644 10,750.062 ↓ 2.4 52,364 3

Partial HashAggregate (cost=1,027,077.31..1,027,292.89 rows=21,558 width=22) (actual time=10,707.244..10,750.062 rows=52,364 loops=3)

  • Group Key: country__aln, postal_code__aln
5. 5,847.418 5,847.418 ↑ 1.3 5,300,763 3

Parallel Seq Scan on address__aln (cost=0.00..993,947.54 rows=6,625,954 width=22) (actual time=0.033..5,847.418 rows=5,300,763 loops=3)

Planning time : 0.112 ms
Execution time : 11,752.033 ms