explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AePq

Settings
# exclusive inclusive rows x rows loops node
1. 43.311 4,827.366 ↓ 2,870.0 2,870 1

WindowAgg (cost=12,066.16..12,066.37 rows=1 width=18,407) (actual time=4,778.666..4,827.366 rows=2,870 loops=1)

2. 33.522 4,784.055 ↓ 2,870.0 2,870 1

Sort (cost=12,066.16..12,066.16 rows=1 width=12,425) (actual time=4,778.577..4,784.055 rows=2,870 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: 7,016kB
3. 25.982 4,750.533 ↓ 2,870.0 2,870 1

WindowAgg (cost=12,066.12..12,066.15 rows=1 width=12,425) (actual time=4,718.931..4,750.533 rows=2,870 loops=1)

4. 31.017 4,724.551 ↓ 2,870.0 2,870 1

Sort (cost=12,066.12..12,066.13 rows=1 width=12,417) (actual time=4,718.897..4,724.551 rows=2,870 loops=1)

  • Sort Key: f.dim_repair_order_id, f.dim_employee_id_technician, f.fact_labor_line_id
  • Sort Method: external sort Disk: 6,992kB
5. 21.659 4,693.534 ↓ 2,870.0 2,870 1

WindowAgg (cost=12,066.09..12,066.11 rows=1 width=12,417) (actual time=4,666.695..4,693.534 rows=2,870 loops=1)

6. 31.720 4,671.875 ↓ 2,870.0 2,870 1

Sort (cost=12,066.09..12,066.09 rows=1 width=12,409) (actual time=4,666.659..4,671.875 rows=2,870 loops=1)

  • Sort Key: f.dim_repair_order_id, f.pay_type_short, f.fact_labor_line_id
  • Sort Method: external sort Disk: 6,968kB
7. 20.838 4,640.155 ↓ 2,870.0 2,870 1

WindowAgg (cost=12,066.05..12,066.08 rows=1 width=12,409) (actual time=4,614.640..4,640.155 rows=2,870 loops=1)

8. 43.973 4,619.317 ↓ 2,870.0 2,870 1

Sort (cost=12,066.05..12,066.06 rows=1 width=12,401) (actual time=4,614.604..4,619.317 rows=2,870 loops=1)

  • Sort Key: f.dim_repair_order_id, f.fact_labor_line_id
  • Sort Method: external merge Disk: 6,936kB
9. 6.867 4,575.344 ↓ 2,870.0 2,870 1

Nested Loop Left Join (cost=7,376.59..12,066.04 rows=1 width=12,401) (actual time=4,333.632..4,575.344 rows=2,870 loops=1)

  • Join Filter: false
10. 6.042 4,568.477 ↓ 2,870.0 2,870 1

Nested Loop Left Join (cost=7,376.59..12,066.03 rows=1 width=10,505) (actual time=4,333.622..4,568.477 rows=2,870 loops=1)

  • Join Filter: false
11. 6.246 4,562.435 ↓ 2,870.0 2,870 1

Nested Loop Left Join (cost=7,376.59..12,066.02 rows=1 width=10,501) (actual time=4,333.615..4,562.435 rows=2,870 loops=1)

  • Join Filter: false
12. 6.280 4,556.189 ↓ 2,870.0 2,870 1

Nested Loop Left Join (cost=7,376.59..12,066.01 rows=1 width=10,497) (actual time=4,333.608..4,556.189 rows=2,870 loops=1)

  • Join Filter: false
13. 188.292 4,549.909 ↓ 2,870.0 2,870 1

Nested Loop Left Join (cost=7,376.59..12,066.00 rows=1 width=8,601) (actual time=4,333.600..4,549.909 rows=2,870 loops=1)

  • Join Filter: false
14. 4,361.617 4,361.617 ↓ 2,870.0 2,870 1

Remote Subquery Scan on all (dev_era_pgxl3_data) (cost=7,476.59..12,174.60 rows=1 width=8,597) (actual time=4,333.376..4,361.617 rows=2,870 loops=1)

15. 0.000 0.000 ↓ 0.0 0 2,870

Result (cost=0.00..0.00 rows=0 width=4) (actual time=0.000..0.000 rows=0 loops=2,870)

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

Result (cost=0.00..0.00 rows=0 width=1,896) (actual time=0.000..0.000 rows=0 loops=2,870)

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

Result (cost=0.00..0.00 rows=0 width=4) (actual time=0.000..0.000 rows=0 loops=2,870)

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

Result (cost=0.00..0.00 rows=0 width=4) (actual time=0.000..0.000 rows=0 loops=2,870)

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

Result (cost=0.00..0.00 rows=0 width=1,896) (actual time=0.000..0.000 rows=0 loops=2,870)

  • One-Time Filter: false