explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aGY

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

Hash Join (cost=19,086.81..12,465,086.43 rows=3,882 width=304) (actual rows= loops=)

  • Hash Cond: (road_segments.trip_id = road_movements.trip_id)
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,384.17..12,452,853.19 rows=579,383 width=195) (actual rows= loops=)

  • Hash Cond: (road_segments.link_id = v_transit_roads.link_id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on road_segments (cost=0.00..10,885,811.20 rows=593,771,520 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=8,373.54..8,373.54 rows=850 width=187) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on v_transit_roads (cost=91.63..8,373.54 rows=850 width=187) (actual rows= loops=)

  • Recheck Cond: (geometry && '0103000020110F000001000000050000008FC2B976272970415C8FE237662F48C18FC2B97627297041EC51F818D67B48C1E17ADC72B5327041EC51F818D67B48C1E17ADC72B53270415C8FE237662F48C18FC2B976272970415C8FE237662F48C1'::geometry)
  • Filter: _st_intersects(geometry, '0103000020110F000001000000050000008FC2B976272970415C8FE237662F48C18FC2B97627297041EC51F818D67B48C1E17ADC72B5327041EC51F818D67B48C1E17ADC72B53270415C8FE237662F48C18FC2B976272970415C8FE237662F48C1'::geometry)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on v_transit_roads_geometry_geom_idx (cost=0.00..91.42 rows=2,551 width=0) (actual rows= loops=)

  • Index Cond: (geometry && '0103000020110F000001000000050000008FC2B976272970415C8FE237662F48C18FC2B97627297041EC51F818D67B48C1E17ADC72B5327041EC51F818D67B48C1E17ADC72B53270415C8FE237662F48C18FC2B976272970415C8FE237662F48C1'::geometry)
7. 0.000 0.000 ↓ 0.0

Hash (cost=10,653.84..10,653.84 rows=3,904 width=117) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on road_movements (cost=74.68..10,653.84 rows=3,904 width=117) (actual rows= loops=)

  • Recheck Cond: (commod_id = 2)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_road_movements_commod_id (cost=0.00..73.70 rows=3,904 width=0) (actual rows= loops=)