explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vRk8

Settings
# exclusive inclusive rows x rows loops node
1. 28.362 200.716 ↓ 3.1 82,423 1

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

  • Group Key: (COALESCE(psmexportid, 0))
2. 89.079 172.354 ↓ 1.6 83,857 1

Gather (cost=26,218.11..31,837.08 rows=53,514 width=12) (actual time=154.791..172.354 rows=83,857 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 51.165 83.275 ↓ 1.0 27,952 3

Partial HashAggregate (cost=25,218.11..25,485.68 rows=26,757 width=12) (actual time=78.935..83.275 rows=27,952 loops=3)

  • Group Key: COALESCE(psmexportid, 0)
4. 32.110 32.110 ↑ 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.065..32.110 rows=378,310 loops=3)

  • Heap Fetches: 0
Planning time : 0.225 ms