explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HLkE

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 749.950 ↓ 0.0 0 1

WindowAgg (cost=37,601.47..37,604.24 rows=13 width=18,407) (actual time=749.950..749.950 rows=0 loops=1)

2. 0.056 749.948 ↓ 0.0 0 1

Sort (cost=37,601.47..37,601.51 rows=13 width=12,425) (actual time=749.948..749.948 rows=0 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: quicksort Memory: 25kB
3. 0.001 749.892 ↓ 0.0 0 1

WindowAgg (cost=37,600.94..37,601.23 rows=13 width=12,425) (actual time=749.892..749.892 rows=0 loops=1)

4. 0.004 749.891 ↓ 0.0 0 1

Sort (cost=37,600.94..37,600.97 rows=13 width=12,417) (actual time=749.891..749.891 rows=0 loops=1)

  • Sort Key: f.dim_repair_order_id, f.dim_employee_id_technician, f.fact_labor_line_id
  • Sort Method: quicksort Memory: 25kB
5. 0.002 749.887 ↓ 0.0 0 1

WindowAgg (cost=37,600.41..37,600.70 rows=13 width=12,417) (actual time=749.887..749.887 rows=0 loops=1)

6. 0.006 749.885 ↓ 0.0 0 1

Sort (cost=37,600.41..37,600.44 rows=13 width=12,409) (actual time=749.885..749.885 rows=0 loops=1)

  • Sort Key: f.dim_repair_order_id, f.pay_type_short, f.fact_labor_line_id
  • Sort Method: quicksort Memory: 25kB
7. 0.002 749.879 ↓ 0.0 0 1

WindowAgg (cost=37,599.91..37,600.17 rows=13 width=12,409) (actual time=749.879..749.879 rows=0 loops=1)

8. 0.009 749.877 ↓ 0.0 0 1

Sort (cost=37,599.91..37,599.94 rows=13 width=12,401) (actual time=749.877..749.877 rows=0 loops=1)

  • Sort Key: f.dim_repair_order_id, f.fact_labor_line_id
  • Sort Method: quicksort Memory: 25kB
9. 0.001 749.868 ↓ 0.0 0 1

Nested Loop Left Join (cost=32,909.50..37,599.67 rows=13 width=12,401) (actual time=749.868..749.868 rows=0 loops=1)

  • Join Filter: false
10. 0.001 749.867 ↓ 0.0 0 1

Nested Loop Left Join (cost=32,909.50..37,599.54 rows=13 width=10,505) (actual time=749.867..749.867 rows=0 loops=1)

  • Join Filter: false
11. 0.000 749.866 ↓ 0.0 0 1

Nested Loop Left Join (cost=32,909.50..37,599.41 rows=13 width=10,501) (actual time=749.866..749.866 rows=0 loops=1)

  • Join Filter: false
12. 0.001 749.866 ↓ 0.0 0 1

Nested Loop Left Join (cost=32,909.50..37,599.28 rows=13 width=10,497) (actual time=749.866..749.866 rows=0 loops=1)

  • Join Filter: false
13. 0.002 749.865 ↓ 0.0 0 1

Nested Loop Left Join (cost=32,909.50..37,599.15 rows=13 width=8,601) (actual time=749.865..749.865 rows=0 loops=1)

  • Join Filter: false
14. 749.863 749.863 ↓ 0.0 0 1

Remote Subquery Scan on all (dev_era_pgxl3_data) (cost=33,009.50..37,810.84 rows=13 width=8,597) (actual time=749.863..749.863 rows=0 loops=1)

15. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=4) (never executed)

  • One-Time Filter: false
16. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=1,896) (never executed)

  • One-Time Filter: false
17. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=4) (never executed)

  • One-Time Filter: false
18. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=4) (never executed)

  • One-Time Filter: false
19. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=1,896) (never executed)

  • One-Time Filter: false