explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jJts

Settings
# exclusive inclusive rows x rows loops node
1. 364.291 4,059.291 ↓ 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,159.532..4,059.291 rows=1,134,901 loops=1)

  • Group Key: roadworkrequestid
2. 0.000 3,695.000 ↓ 1.5 3,224,936 1

Gather Merge (cost=806,420.94..1,100,142.16 rows=2,148,416 width=12) (actual time=2,159.527..3,695.000 rows=3,224,936 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,412.172 8,818.332 ↓ 1.0 1,074,979 3

Partial GroupAggregate (cost=805,420.92..851,161.62 rows=1,074,208 width=12) (actual time=2,090.943..2,939.444 rows=1,074,979 loops=3)

  • Group Key: roadworkrequestid
4. 5,972.205 7,406.160 ↑ 1.2 3,733,187 3

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

  • Sort Key: roadworkrequestid
  • Sort Method: external merge Disk: 98088kB
5. 1,433.955 1,433.955 ↑ 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.227..477.985 rows=3,733,187 loops=3)

Planning time : 3.293 ms