explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MhWG

Settings
# exclusive inclusive rows x rows loops node
1. 6,305.928 69,766.470 ↓ 1.4 823,687 1

WindowAgg (cost=2,538,312.99..2,651,407.22 rows=572,629 width=1,544) (actual time=62,745.661..69,766.470 rows=823,687 loops=1)

2. 3,801.154 63,460.542 ↓ 1.4 823,687 1

Sort (cost=2,538,312.99..2,539,744.56 rows=572,629 width=740) (actual time=62,745.613..63,460.542 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,806.367 59,659.388 ↓ 1.4 823,687 1

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

4. 3,677.035 56,853.021 ↓ 1.4 823,687 1

Sort (cost=2,360,612.57..2,362,044.15 rows=572,629 width=732) (actual time=56,141.989..56,853.021 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,812.132 53,175.986 ↓ 1.4 823,687 1

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

6. 3,946.894 50,363.854 ↓ 1.4 823,687 1

Sort (cost=2,184,058.11..2,185,489.68 rows=572,629 width=724) (actual time=49,685.694..50,363.854 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,751.979 46,416.960 ↓ 1.4 823,687 1

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

8. 43,664.981 43,664.981 ↓ 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,884.922..43,664.981 rows=823,687 loops=1)