explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RKw5

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

  • Group Key: roadworkrequestid
2. 0.000 3,747.105 ↓ 1.5 3,225,910 1

Gather Merge (cost=806,420.94..1,100,142.16 rows=2,148,416 width=12) (actual time=2,218.505..3,747.105 rows=3,225,910 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,400.349 8,970.864 ↓ 1.0 1,075,303 3

Partial GroupAggregate (cost=805,420.92..851,161.62 rows=1,074,208 width=12) (actual time=2,149.828..2,990.288 rows=1,075,303 loops=3)

  • Group Key: roadworkrequestid
4. 6,063.546 7,570.515 ↑ 1.2 3,733,187 3

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

  • Sort Key: roadworkrequestid
  • Sort Method: external merge Disk: 96872kB
5. 1,506.969 1,506.969 ↑ 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.123..502.323 rows=3,733,187 loops=3)

Planning time : 1.606 ms