explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VWVR

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

Insert on travel_metric_odp_new (cost=54,294.28..696,924,940.29 rows=204,821,142 width=1,190) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=54,294.28..694,876,728.87 rows=204,821,142 width=1,190) (actual rows= loops=)

  • Merge Cond: ((o.project_id = b.project_id) AND (o.vehicle_type_id = b.vehicle_type_id) AND (o.vehicle_weight_id = b.vehicle_weight_id) AND (o.oz_id = b.oz_id) AND (o.dz_id = b.dz_id) AND (o.day_type = b.day_type) AND (o.day_part = b.day_part))
3. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=54,293.71..484,154,969.88 rows=204,821,142 width=586) (actual rows= loops=)

  • Merge Cond: ((o.project_id = a.project_id) AND (o.vehicle_type_id = a.vehicle_type_id) AND (o.vehicle_weight_id = a.vehicle_weight_id) AND (o.oz_id = a.oz_id) AND (o.dz_id = a.dz_id) AND (o.day_type = a.day_type) AND (o.day_part = a.day_part))
4. 0.000 0.000 ↓ 0.0

Merge Join (cost=54,293.14..303,173,420.39 rows=204,821,142 width=44) (actual rows= loops=)

  • Merge Cond: (o.project_id = p.project_id)
5. 0.000 0.000 ↓ 0.0

Index Scan using ix_travel_metric_odp5 on travel_metric_odp5 o (cost=0.57..299,743,198.11 rows=529,157,344 width=44) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project p (cost=0.29..59,042.71 rows=34,080 width=4) (actual rows= loops=)

  • Filter: (project_type_id = 101)
7. 0.000 0.000 ↓ 0.0

Index Scan using ix_travel_metric_prem_a5 on travel_metric_prem_a5 a (cost=0.57..171,965,672.56 rows=309,578,944 width=562) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using ix_travel_metric_prem_b5 on travel_metric_prem_b5 b (cost=0.57..200,956,192.90 rows=322,745,472 width=616) (actual rows= loops=)