explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vblX

Settings
# exclusive inclusive rows x rows loops node
1. 33.887 119.795 ↓ 3.1 82,423 1

Finalize HashAggregate (cost=32,104.65..32,372.22 rows=26,757 width=12) (actual time=107.254..119.795 rows=82,423 loops=1)

  • Group Key: psmexportid
2. 34.212 85.908 ↓ 1.6 83,865 1

Gather (cost=1,000.43..31,837.08 rows=53,514 width=12) (actual time=0.876..85.908 rows=83,865 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 26.238 51.696 ↓ 1.0 27,955 3

Partial GroupAggregate (cost=0.43..25,485.68 rows=26,757 width=12) (actual time=0.132..51.696 rows=27,955 loops=3)

  • Group Key: psmexportid
4. 25.458 25.458 ↑ 1.2 378,310 3

Parallel Index Only Scan using ix_roadworkrequest_psmexportid on roadworkrequest (cost=0.43..22,854.84 rows=472,655 width=4) (actual time=0.122..25.458 rows=378,310 loops=3)

  • Heap Fetches: 0
Planning time : 0.128 ms