explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AKFa

Settings
# exclusive inclusive rows x rows loops node
1. 6,528.001 67,105.910 ↓ 1.4 823,687 1

WindowAgg (cost=2,383,038.06..2,496,132.29 rows=572,629 width=1,544) (actual time=59,870.746..67,105.910 rows=823,687 loops=1)

2. 3,877.101 60,577.909 ↓ 1.4 823,687 1

Sort (cost=2,383,038.06..2,384,469.64 rows=572,629 width=740) (actual time=59,870.698..60,577.909 rows=823,687 loops=1)

  • Sort Key: f.dim_repair_order_id, f.dim_employee_id_technician, f.pay_type_short, f.fact_labor_line_id
  • Sort Method: external sort Disk: 677,496kB
3. 2,823.476 56,700.808 ↓ 1.4 823,687 1

WindowAgg (cost=2,205,337.65..2,218,221.80 rows=572,629 width=740) (actual time=53,188.325..56,700.808 rows=823,687 loops=1)

4. 3,736.866 53,877.332 ↓ 1.4 823,687 1

Sort (cost=2,205,337.65..2,206,769.22 rows=572,629 width=732) (actual time=53,188.308..53,877.332 rows=823,687 loops=1)

  • Sort Key: f.dim_repair_order_id, f.dim_employee_id_technician, f.fact_labor_line_id
  • Sort Method: external sort Disk: 671,048kB
5. 2,859.520 50,140.466 ↓ 1.4 823,687 1

WindowAgg (cost=2,028,783.18..2,041,667.33 rows=572,629 width=732) (actual time=46,565.182..50,140.466 rows=823,687 loops=1)

6. 3,991.138 47,280.946 ↓ 1.4 823,687 1

Sort (cost=2,028,783.18..2,030,214.75 rows=572,629 width=724) (actual time=46,565.167..47,280.946 rows=823,687 loops=1)

  • Sort Key: f.dim_repair_order_id, f.pay_type_short, f.fact_labor_line_id
  • Sort Method: external sort Disk: 664,600kB
7. 2,733.001 43,289.808 ↓ 1.4 823,687 1

WindowAgg (cost=1,851,943.09..1,866,258.81 rows=572,629 width=724) (actual time=19,976.820..43,289.808 rows=823,687 loops=1)

8. 40,556.807 40,556.807 ↓ 1.4 823,687 1

Remote Subquery Scan on all (pr_era_pgxl2_data,pr_era_pgxl3_data) (cost=1,851,943.09..1,856,237.81 rows=572,629 width=716) (actual time=19,976.809..40,556.807 rows=823,687 loops=1)