explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OWLj

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=22,029.14..23,560.84 rows=87,526 width=24) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=22,029.14..22,247.95 rows=87,526 width=24) (actual rows= loops=)

  • Sort Key: weight_sheets.id, rf_from_fhr.fleet_haul_region_id, rf_from_ws.fleet_haul_region_id, rf_from_fhr.id, rf_from_ws.id, fhr.id
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,374.98..13,048.88 rows=87,526 width=24) (actual rows= loops=)

  • Hash Cond: (fhr.recovery_facility_id = rf_from_fhr.id)
  • Join Filter: (rf_from_fhr.fleet_haul_region_id <> rf_from_ws.fleet_haul_region_id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,369.03..12,770.42 rows=100,524 width=20) (actual rows= loops=)

  • Hash Cond: (weight_sheets.recovery_facility_id = rf_from_ws.id)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,363.09..12,492.07 rows=100,524 width=16) (actual rows= loops=)

  • Hash Cond: (fhrs.fleet_haul_route_id = fhr.id)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=7,278.66..11,143.72 rows=100,524 width=12) (actual rows= loops=)

  • Hash Cond: (wsrs.fleet_haul_route_stop_id = fhrs.id)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=761.09..2,770.27 rows=100,524 width=16) (actual rows= loops=)

  • Hash Cond: (wsrs.weight_sheet_id = weight_sheets.id)
8. 0.000 0.000 ↓ 0.0

Seq Scan on weight_sheets_route_stops wsrs (cost=0.00..1,745.24 rows=100,524 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=518.82..518.82 rows=19,382 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on weight_sheets (cost=0.00..518.82 rows=19,382 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=3,956.14..3,956.14 rows=156,114 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on fleet_haul_route_stops fhrs (cost=0.00..3,956.14 rows=156,114 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=779.19..779.19 rows=24,419 width=8) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on fleet_haul_routes fhr (cost=0.00..779.19 rows=24,419 width=8) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=4.31..4.31 rows=131 width=8) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on recovery_facilities rf_from_ws (cost=0.00..4.31 rows=131 width=8) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash (cost=4.31..4.31 rows=131 width=8) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on recovery_facilities rf_from_fhr (cost=0.00..4.31 rows=131 width=8) (actual rows= loops=)