explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mT9l

Settings
# exclusive inclusive rows x rows loops node
1. 2,381.189 17,664.964 ↓ 4.4 2,196,034 1

WindowAgg (cost=453,251.94..465,782.14 rows=501,208 width=55) (actual time=14,303.064..17,664.964 rows=2,196,034 loops=1)

2. 5,443.706 15,283.775 ↓ 4.4 2,196,034 1

Sort (cost=453,251.94..454,504.96 rows=501,208 width=47) (actual time=14,303.044..15,283.775 rows=2,196,034 loops=1)

  • Sort Key: company, ro_num, vin, line
  • Sort Method: external merge Disk: 133,216kB
3. 2,576.055 9,840.069 ↓ 4.4 2,196,034 1

Finalize GroupAggregate (cost=210,875.65..390,378.94 rows=501,208 width=47) (actual time=3,995.049..9,840.069 rows=2,196,034 loops=1)

  • Group Key: company, line, ro_num, vin, is_flat_rate, tech_payrate, tech_id
4. 1,717.324 7,264.014 ↓ 2.2 2,253,995 1

Gather Merge (cost=210,875.65..360,306.46 rows=1,002,416 width=47) (actual time=3,995.026..7,264.014 rows=2,253,995 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 1,074.747 5,546.690 ↓ 1.5 751,332 3 / 3

Partial GroupAggregate (cost=209,875.62..243,602.76 rows=501,208 width=47) (actual time=3,979.355..5,546.690 rows=751,332 loops=3)

  • Group Key: company, line, ro_num, vin, is_flat_rate, tech_payrate, tech_id
6. 2,706.781 4,471.943 ↑ 1.3 834,593 3 / 3

Sort (cost=209,875.62..212,486.08 rows=1,044,184 width=47) (actual time=3,979.327..4,471.943 rows=834,593 loops=3)

  • Sort Key: company, line, ro_num, vin, is_flat_rate, tech_payrate, tech_id
  • Sort Method: external merge Disk: 48,704kB
  • Worker 0: Sort Method: external merge Disk: 51,792kB
  • Worker 1: Sort Method: external merge Disk: 51,432kB
7. 1,765.162 1,765.162 ↑ 1.3 834,593 3 / 3

Parallel Seq Scan on techhrs (cost=0.00..73,365.84 rows=1,044,184 width=47) (actual time=0.674..1,765.162 rows=834,593 loops=3)

Planning time : 0.344 ms
Execution time : 17,856.406 ms