explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HjPV : partition+sort+1

Settings
# exclusive inclusive rows x rows loops node
1. 0.466 220.599 ↓ 1.5 300 1

Finalize GroupAggregate (cost=4,049.96..4,100.63 rows=200 width=12) (actual time=219.093..220.599 rows=300 loops=1)

  • Group Key: a2.b
  • Buffers: shared hit=278
2. 0.000 220.133 ↓ 1.5 600 1

Gather Merge (cost=4,049.96..4,096.63 rows=400 width=12) (actual time=219.076..220.133 rows=600 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=944
3. 0.798 636.195 ↑ 1.0 200 3

Sort (cost=3,049.94..3,050.44 rows=200 width=12) (actual time=211.962..212.065 rows=200 loops=3)

  • Sort Key: a2.b
  • Sort Method: quicksort Memory: 34kB
  • Worker 0: Sort Method: quicksort Memory: 39kB
  • Worker 1: Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=944
4. 162.606 635.397 ↑ 1.0 200 3

Partial HashAggregate (cost=3,040.29..3,042.29 rows=200 width=12) (actual time=211.686..211.799 rows=200 loops=3)

  • Group Key: a2.b
  • Buffers: shared hit=930
5. 314.713 472.791 ↑ 1.2 70,000 3

Parallel Append (cost=0.00..2,602.79 rows=87,500 width=4) (actual time=0.011..157.597 rows=70,000 loops=3)

  • Buffers: shared hit=930
6. 36.295 36.295 ↓ 1.7 70,501 1

Parallel Seq Scan on a2 (cost=0.00..726.71 rows=41,471 width=4) (actual time=0.010..36.295 rows=70,501 loops=1)

  • Buffers: shared hit=312
7. 60.003 60.003 ↑ 1.8 23,350 3

Parallel Seq Scan on a3 (cost=0.00..722.05 rows=41,205 width=4) (actual time=0.006..20.001 rows=23,350 loops=3)

  • Buffers: shared hit=310
8. 61.780 61.780 ↑ 1.2 34,725 2

Parallel Seq Scan on a1 (cost=0.00..716.53 rows=40,853 width=4) (actual time=0.008..30.890 rows=34,725 loops=2)

  • Buffers: shared hit=308
Planning time : 0.102 ms
Execution time : 220.892 ms