explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GRdN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4,706.257 ↓ 0.0 0 1

Nested Loop (cost=96.25..1,090,074.40 rows=1 width=293) (actual time=4,706.257..4,706.257 rows=0 loops=1)

2. 0.002 4,706.257 ↓ 0.0 0 1

Nested Loop (cost=95.83..1,088,700.48 rows=180 width=184) (actual time=4,706.257..4,706.257 rows=0 loops=1)

3. 4,706.255 4,706.255 ↓ 0.0 0 1

Seq Scan on road_network (cost=0.00..1,068,724.55 rows=1 width=176) (actual time=4,706.255..4,706.255 rows=0 loops=1)

  • Filter: ((geom && '0103000020110F000001000000050000008FC2B976272970415C8FE237662F48C18FC2B97627297041EC51F818D67B48C1E17ADC72B5327041EC51F818D67B48C1E17ADC72B53270415C8FE237662F48C18FC2B976272970415C8FE237662F48C1'::geometry) AND _st_intersects(geom, '0103000020110F000001000000050000008FC2B976272970415C8FE237662F48C18FC2B97627297041EC51F818D67B48C1E17ADC72B5327041EC51F818D67B48C1E17ADC72B53270415C8FE237662F48C18FC2B976272970415C8FE237662F48C1'::geometry))
  • Rows Removed by Filter: 3293884
4. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments (cost=95.83..19,925.28 rows=5,065 width=16) (never executed)

  • Recheck Cond: (link_id = road_network.link_id)
5. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_road_segments_link_id (cost=0.00..94.56 rows=5,065 width=0) (never executed)

  • Index Cond: (link_id = road_network.link_id)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using road_movements_pkey on road_movements (cost=0.42..7.63 rows=1 width=117) (never executed)

  • Index Cond: (trip_id = road_segments.trip_id)
  • Filter: (commod_id = 2)
Planning time : 264.882 ms