explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ev4H

Settings
# exclusive inclusive rows x rows loops node
1. 6,516.523 70,524.620 ↓ 1.4 823,687 1

WindowAgg (cost=2,538,312.99..2,651,407.22 rows=572,629 width=1,544) (actual time=63,260.449..70,524.620 rows=823,687 loops=1)

2. 3,821.661 64,008.097 ↓ 1.4 823,687 1

Sort (cost=2,538,312.99..2,539,744.56 rows=572,629 width=740) (actual time=63,260.400..64,008.097 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,758.732 60,186.436 ↓ 1.4 823,687 1

WindowAgg (cost=2,360,612.57..2,373,496.73 rows=572,629 width=740) (actual time=56,708.931..60,186.436 rows=823,687 loops=1)

4. 3,740.764 57,427.704 ↓ 1.4 823,687 1

Sort (cost=2,360,612.57..2,362,044.15 rows=572,629 width=732) (actual time=56,708.915..57,427.704 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,858.726 53,686.940 ↓ 1.4 823,687 1

WindowAgg (cost=2,184,058.11..2,196,942.26 rows=572,629 width=732) (actual time=50,126.451..53,686.940 rows=823,687 loops=1)

6. 4,199.915 50,828.214 ↓ 1.4 823,687 1

Sort (cost=2,184,058.11..2,185,489.68 rows=572,629 width=724) (actual time=50,126.437..50,828.214 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,773.063 46,628.299 ↓ 1.4 823,687 1

WindowAgg (cost=2,007,218.02..2,021,533.74 rows=572,629 width=724) (actual time=22,458.473..46,628.299 rows=823,687 loops=1)

8. 43,855.236 43,855.236 ↓ 1.4 823,687 1

Remote Subquery Scan on all (pr_era_pgxl2_data,pr_era_pgxl3_data) (cost=2,007,218.02..2,011,512.73 rows=572,629 width=716) (actual time=22,458.461..43,855.236 rows=823,687 loops=1)