explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GpZ2

Settings
# exclusive inclusive rows x rows loops node
1. 364.284 4,174.174 ↓ 1.1 1,134,901 1

Finalize GroupAggregate (cost=806,420.94..1,121,626.32 rows=1,074,208 width=12) (actual time=2,210.756..4,174.174 rows=1,134,901 loops=1)

  • Group Key: roadworkrequestid
2. 0.000 3,809.890 ↓ 1.5 3,229,562 1

Gather Merge (cost=806,420.94..1,100,142.16 rows=2,148,416 width=12) (actual time=2,210.751..3,809.890 rows=3,229,562 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,424.925 8,976.678 ↓ 1.0 1,076,521 3

Partial GroupAggregate (cost=805,420.92..851,161.62 rows=1,074,208 width=12) (actual time=2,137.366..2,992.226 rows=1,076,521 loops=3)

  • Group Key: roadworkrequestid
4. 6,076.092 7,551.753 ↑ 1.2 3,733,187 3

Sort (cost=805,420.92..817,087.13 rows=4,666,483 width=12) (actual time=2,137.357..2,517.251 rows=3,733,187 loops=3)

  • Sort Key: roadworkrequestid
  • Sort Method: external merge Disk: 98440kB
5. 1,475.661 1,475.661 ↑ 1.2 3,733,187 3

Parallel Seq Scan on roadworkrequesthistory (cost=0.00..129,014.83 rows=4,666,483 width=12) (actual time=0.120..491.887 rows=3,733,187 loops=3)

Planning time : 1.558 ms