explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xGyM

Settings
# exclusive inclusive rows x rows loops node
1. 0.108 27.776 ↓ 6.5 130 1

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

2. 0.024 0.024 ↑ 1.0 1 1

Index Scan using move on road_movements (cost=0.42..8.45 rows=1 width=117) (actual time=0.023..0.024 rows=1 loops=1)

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

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

4. 14.640 15.252 ↓ 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.778..15.252 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.612 0.612 ↓ 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.612..0.612 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 : 1.722 ms