explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cm6s

Settings
# exclusive inclusive rows x rows loops node
1. 187.114 1,374.398 ↓ 1.5 1,189,081 1

Finalize GroupAggregate (cost=225,455.79..364,631.51 rows=785,273 width=8) (actual time=885.368..1,374.398 rows=1,189,081 loops=1)

  • Group Key: roadworkrequestid
2. 251.915 1,187.284 ↓ 1.2 1,189,081 1

Gather Merge (cost=225,455.79..351,695.63 rows=1,016,630 width=8) (actual time=885.363..1,187.284 rows=1,189,081 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 90.020 935.369 ↑ 1.3 396,360 3 / 3

Partial GroupAggregate (cost=224,455.77..233,351.28 rows=508,315 width=8) (actual time=813.986..935.369 rows=396,360 loops=3)

  • Group Key: roadworkrequestid
4. 144.126 845.349 ↑ 1.3 396,360 3 / 3

Sort (cost=224,455.77..225,726.56 rows=508,315 width=8) (actual time=813.975..845.349 rows=396,360 loops=3)

  • Sort Key: roadworkrequestid
  • Sort Method: external merge Disk: 7,784kB
  • Worker 0: Sort Method: external merge Disk: 6,224kB
  • Worker 1: Sort Method: external merge Disk: 7,064kB
5. 701.223 701.223 ↑ 1.3 396,360 3 / 3

Parallel Seq Scan on roadworkrequesthistory (cost=0.00..169,328.29 rows=508,315 width=8) (actual time=0.383..701.223 rows=396,360 loops=3)

  • Filter: (roadworkstatustypeid = 18)
  • Rows Removed by Filter: 4,097,010
Planning time : 5.515 ms