explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cpCJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.079 55.861 ↓ 6.5 130 1

Nested Loop (cost=92.63..15,687.99 rows=20 width=304) (actual time=31.915..55.861 rows=130 loops=1)

2. 29.152 29.152 ↑ 1.0 1 1

Index Scan using road_movements_pkey on road_movements (cost=0.42..8.45 rows=1 width=117) (actual time=29.151..29.152 rows=1 loops=1)

  • Index Cond: (trip_id = 516591)
  • Filter: (commod_id = 2)
3. 0.520 26.630 ↓ 6.5 130 1

Nested Loop (cost=92.20..15,679.29 rows=20 width=195) (actual time=2.753..26.630 rows=130 loops=1)

4. 13.948 14.586 ↓ 3.4 2,881 1

Bitmap Heap Scan on v_transit_roads (cost=91.63..8,373.54 rows=850 width=187) (actual time=0.829..14.586 rows=2,881 loops=1)

  • Recheck Cond: (geometry && '0103000020110F000001000000050000008FC2B976272970415C8FE237662F48C18FC2B97627297041EC51F818D67B48C1E17ADC72B5327041EC51F818D67B48C1E17ADC72B53270415C8FE237662F48C18FC2B976272970415C8FE237662F48C1'::geometry)
  • Filter: _st_intersects(geometry, '0103000020110F000001000000050000008FC2B976272970415C8FE237662F48C18FC2B97627297041EC51F818D67B48C1E17ADC72B5327041EC51F818D67B48C1E17ADC72B53270415C8FE237662F48C18FC2B976272970415C8FE237662F48C1'::geometry)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=599
5. 0.638 0.638 ↓ 1.1 2,882 1

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

  • Index Cond: (geometry && '0103000020110F000001000000050000008FC2B976272970415C8FE237662F48C18FC2B97627297041EC51F818D67B48C1E17ADC72B5327041EC51F818D67B48C1E17ADC72B53270415C8FE237662F48C18FC2B976272970415C8FE237662F48C1'::geometry)
6. 11.524 11.524 ↓ 0.0 0 2,881

Index Only Scan using idx_road_segments_keyrev on road_segments (cost=0.57..8.59 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=2,881)

  • Index Cond: ((trip_id = 516591) AND (link_id = v_transit_roads.link_id))
  • Heap Fetches: 130
Planning time : 5.156 ms