explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OZp4

Settings
# exclusive inclusive rows x rows loops node
1. 4.099 432,366.239 ↑ 1.0 1 1

Aggregate (cost=555,410,983.23..555,410,983.33 rows=1 width=32) (actual time=432,366.239..432,366.239 rows=1 loops=1)

  • Functions: 7060
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 615.108 ms, Inlining 65.697 ms, Optimization 40240.892 ms, Emission 29394.999 ms, Total 70316.696 ms
2. 0.834 432,362.140 ↑ 5.4 1,126 1

Subquery Scan on q (cost=555,407,798.23..555,410,965.62 rows=6,042 width=52) (actual time=432,317.570..432,362.140 rows=1,126 loops=1)

3. 42.921 432,361.306 ↑ 5.4 1,126 1

GroupAggregate (cost=555,407,798.23..555,410,361.42 rows=6,042 width=248) (actual time=432,317.558..432,361.306 rows=1,126 loops=1)

  • Group Key: v_transit_roads_partitioned.link_id, v_transit_roads_partitioned.street_name, v_transit_roads_partitioned.road_speed, v_transit_roads_partitioned.road_rank, v_transit_roads_partitioned.truck, v_transit_roads_partitioned.surface, v_transit_roads_partitioned.road_km, v_transit_roads_partitioned.geometry
4. 11.690 432,318.385 ↑ 3.7 7,996 1

Sort (cost=555,407,798.23..555,407,872.17 rows=29,576 width=208) (actual time=432,317.330..432,318.385 rows=7,996 loops=1)

  • Sort Key: v_transit_roads_partitioned.link_id, v_transit_roads_partitioned.street_name, v_transit_roads_partitioned.road_speed, v_transit_roads_partitioned.road_rank, v_transit_roads_partitioned.truck, v_transit_roads_partitioned.surface, v_transit_roads_partitioned.road_km, v_transit_roads_partitioned.geometry
  • Sort Method: quicksort Memory: 2398kB
5. 2.430 432,306.695 ↑ 3.7 7,996 1

Nested Loop Left Join (cost=157,872.49..555,405,601.90 rows=29,576 width=208) (actual time=83,311.167..432,306.695 rows=7,996 loops=1)

  • Join Filter: NULL::boolean
6. 1,938.223 432,304.265 ↑ 3.7 7,996 1

Hash Join (cost=157,872.49..555,402,644.30 rows=29,576 width=208) (actual time=83,311.163..432,304.265 rows=7,996 loops=1)

  • Hash Cond: (road_segments_partitioned_0.link_id = v_transit_roads_partitioned.link_id)
7. 2,361.660 430,165.479 ↓ 1.7 7,329,912 1

Nested Loop (cost=0.58..555,233,578.59 rows=4,264,107 width=32) (actual time=71,555.145..430,165.479 rows=7,329,912 loops=1)

8. 18.915 18.915 ↑ 1.0 4,113 1

Index Scan using idx_road_movements_commod_id on road_movements (cost=0.42..4,322.54 rows=4,176 width=32) (actual time=0.040..18.915 rows=4,113 loops=1)

  • Index Cond: (commod_id = ANY ('{2}'::integer[]))
9. 79,973.172 427,784.904 ↑ 65.7 1,782 4,113

Append (cost=0.15..121,253.30 rows=117,039 width=16) (actual time=28.418..104.008 rows=1,782 loops=4,113)

10. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_0_trip_id_idx on road_segments_partitioned_0 (cost=0.15..6.47 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
11. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_1_trip_id_idx on road_segments_partitioned_1 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
12. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_2_trip_id_idx on road_segments_partitioned_2 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
13. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_3_trip_id_idx on road_segments_partitioned_3 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
14. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_4_trip_id_idx on road_segments_partitioned_4 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
15. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_5_trip_id_idx on road_segments_partitioned_5 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
16. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_6_trip_id_idx on road_segments_partitioned_6 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
17. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_7_trip_id_idx on road_segments_partitioned_7 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
18. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_8_trip_id_idx on road_segments_partitioned_8 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
19. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_9_trip_id_idx on road_segments_partitioned_9 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
20. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_10_trip_id_idx on road_segments_partitioned_10 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
21. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_11_trip_id_idx on road_segments_partitioned_11 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
22. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_12_trip_id_idx on road_segments_partitioned_12 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
23. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_13_trip_id_idx on road_segments_partitioned_13 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
24. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_14_trip_id_idx on road_segments_partitioned_14 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
25. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_15_trip_id_idx on road_segments_partitioned_15 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
26. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_16_trip_id_idx on road_segments_partitioned_16 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
27. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_17_trip_id_idx on road_segments_partitioned_17 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
28. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_18_trip_id_idx on road_segments_partitioned_18 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
29. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_19_trip_id_idx on road_segments_partitioned_19 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
30. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_20_trip_id_idx on road_segments_partitioned_20 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
31. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_21_trip_id_idx on road_segments_partitioned_21 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
32. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_22_trip_id_idx on road_segments_partitioned_22 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
33. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_23_trip_id_idx on road_segments_partitioned_23 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
34. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_24_trip_id_idx on road_segments_partitioned_24 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
35. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_25_trip_id_idx on road_segments_partitioned_25 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
36. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_26_trip_id_idx on road_segments_partitioned_26 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
37. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_27_trip_id_idx on road_segments_partitioned_27 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
38. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_28_trip_id_idx on road_segments_partitioned_28 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
39. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_29_trip_id_idx on road_segments_partitioned_29 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
40. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_30_trip_id_idx on road_segments_partitioned_30 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
41. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_31_trip_id_idx on road_segments_partitioned_31 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
42. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_32_trip_id_idx on road_segments_partitioned_32 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
43. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_33_trip_id_idx on road_segments_partitioned_33 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
44. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_34_trip_id_idx on road_segments_partitioned_34 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
45. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_35_trip_id_idx on road_segments_partitioned_35 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
46. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_36_trip_id_idx on road_segments_partitioned_36 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
47. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_37_trip_id_idx on road_segments_partitioned_37 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
48. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_38_trip_id_idx on road_segments_partitioned_38 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
49. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_39_trip_id_idx on road_segments_partitioned_39 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
50. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_40_trip_id_idx on road_segments_partitioned_40 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
51. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_41_trip_id_idx on road_segments_partitioned_41 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
52. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_42_trip_id_idx on road_segments_partitioned_42 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
53. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_43_trip_id_idx on road_segments_partitioned_43 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
54. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_44_trip_id_idx on road_segments_partitioned_44 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
55. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_45_trip_id_idx on road_segments_partitioned_45 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
56. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_46_trip_id_idx on road_segments_partitioned_46 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
57. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_47_trip_id_idx on road_segments_partitioned_47 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
58. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_48_trip_id_idx on road_segments_partitioned_48 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
59. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_49_trip_id_idx on road_segments_partitioned_49 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
60. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_50_trip_id_idx on road_segments_partitioned_50 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
61. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_51_trip_id_idx on road_segments_partitioned_51 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
62. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_52_trip_id_idx on road_segments_partitioned_52 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
63. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_53_trip_id_idx on road_segments_partitioned_53 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
64. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_54_trip_id_idx on road_segments_partitioned_54 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
65. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_55_trip_id_idx on road_segments_partitioned_55 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
66. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_56_trip_id_idx on road_segments_partitioned_56 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
67. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_57_trip_id_idx on road_segments_partitioned_57 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
68. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_58_trip_id_idx on road_segments_partitioned_58 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
69. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_59_trip_id_idx on road_segments_partitioned_59 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
70. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_60_trip_id_idx on road_segments_partitioned_60 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
71. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_61_trip_id_idx on road_segments_partitioned_61 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
72. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_62_trip_id_idx on road_segments_partitioned_62 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
73. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_63_trip_id_idx on road_segments_partitioned_63 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
74. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_64_trip_id_idx on road_segments_partitioned_64 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
75. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_65_trip_id_idx on road_segments_partitioned_65 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
76. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_66_trip_id_idx on road_segments_partitioned_66 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
77. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_67_trip_id_idx on road_segments_partitioned_67 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
78. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_68_trip_id_idx on road_segments_partitioned_68 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
79. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_69_trip_id_idx on road_segments_partitioned_69 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
80. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_70_trip_id_idx on road_segments_partitioned_70 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
81. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_71_trip_id_idx on road_segments_partitioned_71 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
82. 28.791 28.791 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_72_trip_id_idx on road_segments_partitioned_72 (cost=0.15..6.97 rows=7 width=16) (actual time=0.007..0.007 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
83. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_73_trip_id_idx on road_segments_partitioned_73 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
84. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_74_trip_id_idx on road_segments_partitioned_74 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
85. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_75_trip_id_idx on road_segments_partitioned_75 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
86. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_76_trip_id_idx on road_segments_partitioned_76 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
87. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_77_trip_id_idx on road_segments_partitioned_77 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
88. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_78_trip_id_idx on road_segments_partitioned_78 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
89. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_79_trip_id_idx on road_segments_partitioned_79 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
90. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_80_trip_id_idx on road_segments_partitioned_80 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
91. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_81_trip_id_idx on road_segments_partitioned_81 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
92. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_82_trip_id_idx on road_segments_partitioned_82 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
93. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_83_trip_id_idx on road_segments_partitioned_83 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
94. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_84_trip_id_idx on road_segments_partitioned_84 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
95. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_85_trip_id_idx on road_segments_partitioned_85 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
96. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_86_trip_id_idx on road_segments_partitioned_86 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
97. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_87_trip_id_idx on road_segments_partitioned_87 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
98. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_88_trip_id_idx on road_segments_partitioned_88 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
99. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_89_trip_id_idx on road_segments_partitioned_89 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
100. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_90_trip_id_idx on road_segments_partitioned_90 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
101. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_91_trip_id_idx on road_segments_partitioned_91 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
102. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_92_trip_id_idx on road_segments_partitioned_92 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
103. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_93_trip_id_idx on road_segments_partitioned_93 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
104. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_94_trip_id_idx on road_segments_partitioned_94 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
105. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_95_trip_id_idx on road_segments_partitioned_95 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
106. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_96_trip_id_idx on road_segments_partitioned_96 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
107. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_97_trip_id_idx on road_segments_partitioned_97 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
108. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_98_trip_id_idx on road_segments_partitioned_98 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
109. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_99_trip_id_idx on road_segments_partitioned_99 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
110. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_100_trip_id_idx on road_segments_partitioned_100 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
111. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_101_trip_id_idx on road_segments_partitioned_101 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
112. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_102_trip_id_idx on road_segments_partitioned_102 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
113. 148.068 148.068 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_103_trip_id_idx on road_segments_partitioned_103 (cost=0.42..171.59 rows=173 width=16) (actual time=0.018..0.036 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
114. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_104_trip_id_idx on road_segments_partitioned_104 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
115. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_105_trip_id_idx on road_segments_partitioned_105 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
116. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_106_trip_id_idx on road_segments_partitioned_106 (cost=0.28..7.43 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
117. 20.565 20.565 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_107_trip_id_link_id_idx on road_segments_partitioned_107 (cost=0.28..7.38 rows=7 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
118. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_108_trip_id_idx on road_segments_partitioned_108 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
119. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_109_trip_id_idx on road_segments_partitioned_109 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
120. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_110_trip_id_idx on road_segments_partitioned_110 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
121. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_111_trip_id_idx on road_segments_partitioned_111 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
122. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_112_trip_id_idx on road_segments_partitioned_112 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
123. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_113_trip_id_idx on road_segments_partitioned_113 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
124. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_114_trip_id_idx on road_segments_partitioned_114 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
125. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_115_trip_id_idx on road_segments_partitioned_115 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
126. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_116_trip_id_idx on road_segments_partitioned_116 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
127. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_117_trip_id_idx on road_segments_partitioned_117 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
128. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_118_trip_id_idx on road_segments_partitioned_118 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
129. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_119_trip_id_idx on road_segments_partitioned_119 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
130. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_120_trip_id_idx on road_segments_partitioned_120 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
131. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_121_trip_id_idx on road_segments_partitioned_121 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
132. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_122_trip_id_idx on road_segments_partitioned_122 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
133. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_123_trip_id_idx on road_segments_partitioned_123 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
134. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_124_trip_id_idx on road_segments_partitioned_124 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
135. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_125_trip_id_idx on road_segments_partitioned_125 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
136. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_126_trip_id_idx on road_segments_partitioned_126 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
137. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_127_trip_id_idx on road_segments_partitioned_127 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
138. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_128_trip_id_idx on road_segments_partitioned_128 (cost=0.15..6.47 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
139. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_129_trip_id_idx on road_segments_partitioned_129 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
140. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_130_trip_id_idx on road_segments_partitioned_130 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
141. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_131_trip_id_idx on road_segments_partitioned_131 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
142. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_132_trip_id_idx on road_segments_partitioned_132 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
143. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_133_trip_id_idx on road_segments_partitioned_133 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
144. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_134_trip_id_idx on road_segments_partitioned_134 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
145. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_135_trip_id_idx on road_segments_partitioned_135 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
146. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_136_trip_id_idx on road_segments_partitioned_136 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
147. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_137_trip_id_idx on road_segments_partitioned_137 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
148. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_138_trip_id_idx on road_segments_partitioned_138 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
149. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_139_trip_id_idx on road_segments_partitioned_139 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
150. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_140_trip_id_idx on road_segments_partitioned_140 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
151. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_141_trip_id_idx on road_segments_partitioned_141 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
152. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_142_trip_id_idx on road_segments_partitioned_142 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
153. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_143_trip_id_idx on road_segments_partitioned_143 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
154. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_144_trip_id_idx on road_segments_partitioned_144 (cost=0.14..2.74 rows=4 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
155. 222.102 222.102 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_145_trip_id_idx on road_segments_partitioned_145 (cost=0.42..288.87 rows=292 width=16) (actual time=0.030..0.054 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
156. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_146_trip_id_idx on road_segments_partitioned_146 (cost=0.29..58.19 rows=58 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
157. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_147_trip_id_idx on road_segments_partitioned_147 (cost=0.28..13.38 rows=13 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
158. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_148_trip_id_idx on road_segments_partitioned_148 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
159. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_149_trip_id_idx on road_segments_partitioned_149 (cost=0.28..29.08 rows=29 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
160. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_150_trip_id_idx on road_segments_partitioned_150 (cost=0.28..7.46 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
161. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_151_trip_id_idx on road_segments_partitioned_151 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
162. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_152_trip_id_idx on road_segments_partitioned_152 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
163. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_153_trip_id_idx on road_segments_partitioned_153 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
164. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_154_trip_id_idx on road_segments_partitioned_154 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
165. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_155_trip_id_idx on road_segments_partitioned_155 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
166. 12.339 41.130 ↓ 0.0 0 4,113

Bitmap Heap Scan on road_segments_partitioned_156 (cost=1.21..11.41 rows=41 width=16) (actual time=0.010..0.010 rows=0 loops=4,113)

  • Recheck Cond: (trip_id = road_movements.trip_id)
167. 28.791 28.791 ↓ 0.0 0 4,113

Bitmap Index Scan on road_segments_partitioned_156_trip_id_idx (cost=0.00..1.20 rows=41 width=0) (actual time=0.007..0.007 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
168. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_157_trip_id_idx on road_segments_partitioned_157 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
169. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_158_trip_id_idx on road_segments_partitioned_158 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
170. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_159_trip_id_idx on road_segments_partitioned_159 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
171. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_160_trip_id_idx on road_segments_partitioned_160 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
172. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_161_trip_id_idx on road_segments_partitioned_161 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
173. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_162_trip_id_idx on road_segments_partitioned_162 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
174. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_163_trip_id_idx on road_segments_partitioned_163 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
175. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_164_trip_id_idx on road_segments_partitioned_164 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
176. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_165_trip_id_idx on road_segments_partitioned_165 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
177. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_166_trip_id_idx on road_segments_partitioned_166 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
178. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_167_trip_id_idx on road_segments_partitioned_167 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
179. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_168_trip_id_idx on road_segments_partitioned_168 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
180. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_169_trip_id_idx on road_segments_partitioned_169 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
181. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_170_trip_id_idx on road_segments_partitioned_170 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
182. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_171_trip_id_idx on road_segments_partitioned_171 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
183. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_172_trip_id_idx on road_segments_partitioned_172 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
184. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_173_trip_id_idx on road_segments_partitioned_173 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
185. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_174_trip_id_idx on road_segments_partitioned_174 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
186. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_175_trip_id_idx on road_segments_partitioned_175 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
187. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_176_trip_id_idx on road_segments_partitioned_176 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
188. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_177_trip_id_idx on road_segments_partitioned_177 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
189. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_178_trip_id_idx on road_segments_partitioned_178 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
190. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_179_trip_id_idx on road_segments_partitioned_179 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
191. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_180_trip_id_idx on road_segments_partitioned_180 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
192. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_181_trip_id_idx on road_segments_partitioned_181 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
193. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_182_trip_id_idx on road_segments_partitioned_182 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
194. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_183_trip_id_idx on road_segments_partitioned_183 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
195. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_184_trip_id_idx on road_segments_partitioned_184 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
196. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_185_trip_id_idx on road_segments_partitioned_185 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
197. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_186_trip_id_idx on road_segments_partitioned_186 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
198. 115.164 115.164 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_187_trip_id_idx on road_segments_partitioned_187 (cost=0.42..660.36 rows=668 width=16) (actual time=0.018..0.028 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
199. 234.441 234.441 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_188_trip_id_idx on road_segments_partitioned_188 (cost=0.43..310.53 rows=314 width=16) (actual time=0.033..0.057 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
200. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_189_trip_id_idx on road_segments_partitioned_189 (cost=0.28..17.82 rows=17 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
201. 20.565 20.565 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_190_trip_id_link_id_idx on road_segments_partitioned_190 (cost=0.29..89.53 rows=90 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
202. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_191_trip_id_idx on road_segments_partitioned_191 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
203. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_192_trip_id_idx on road_segments_partitioned_192 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
204. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_193_trip_id_idx on road_segments_partitioned_193 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
205. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_194_trip_id_idx on road_segments_partitioned_194 (cost=0.15..6.47 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
206. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_195_trip_id_idx on road_segments_partitioned_195 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
207. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_196_trip_id_idx on road_segments_partitioned_196 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
208. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_197_trip_id_idx on road_segments_partitioned_197 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
209. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_198_trip_id_idx on road_segments_partitioned_198 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
210. 8.226 28.791 ↓ 0.0 0 4,113

Bitmap Heap Scan on road_segments_partitioned_199 (cost=1.30..27.76 rows=63 width=16) (actual time=0.007..0.007 rows=0 loops=4,113)

  • Recheck Cond: (trip_id = road_movements.trip_id)
211. 20.565 20.565 ↓ 0.0 0 4,113

Bitmap Index Scan on road_segments_partitioned_199_trip_id_idx (cost=0.00..1.29 rows=63 width=0) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
212. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_200_trip_id_idx on road_segments_partitioned_200 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
213. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_201_trip_id_idx on road_segments_partitioned_201 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
214. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_202_trip_id_idx on road_segments_partitioned_202 (cost=0.15..6.47 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
215. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_203_trip_id_idx on road_segments_partitioned_203 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
216. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_204_trip_id_idx on road_segments_partitioned_204 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
217. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_205_trip_id_idx on road_segments_partitioned_205 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
218. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_206_trip_id_idx on road_segments_partitioned_206 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
219. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_207_trip_id_idx on road_segments_partitioned_207 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
220. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_208_trip_id_idx on road_segments_partitioned_208 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
221. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_209_trip_id_idx on road_segments_partitioned_209 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
222. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_210_trip_id_idx on road_segments_partitioned_210 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
223. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_211_trip_id_idx on road_segments_partitioned_211 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
224. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_212_trip_id_idx on road_segments_partitioned_212 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
225. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_213_trip_id_idx on road_segments_partitioned_213 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
226. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_214_trip_id_idx on road_segments_partitioned_214 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
227. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_215_trip_id_idx on road_segments_partitioned_215 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
228. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_216_trip_id_idx on road_segments_partitioned_216 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
229. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_217_trip_id_idx on road_segments_partitioned_217 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
230. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_218_trip_id_idx on road_segments_partitioned_218 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
231. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_219_trip_id_idx on road_segments_partitioned_219 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
232. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_220_trip_id_idx on road_segments_partitioned_220 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
233. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_221_trip_id_idx on road_segments_partitioned_221 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
234. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_222_trip_id_idx on road_segments_partitioned_222 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
235. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_223_trip_id_idx on road_segments_partitioned_223 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
236. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_224_trip_id_idx on road_segments_partitioned_224 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
237. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_225_trip_id_idx on road_segments_partitioned_225 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
238. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_226_trip_id_idx on road_segments_partitioned_226 (cost=0.28..7.46 rows=7 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
239. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_227_trip_id_idx on road_segments_partitioned_227 (cost=0.28..7.35 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
240. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_228_trip_id_idx on road_segments_partitioned_228 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
241. 37.017 37.017 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_229_trip_id_idx on road_segments_partitioned_229 (cost=0.29..62.51 rows=63 width=16) (actual time=0.006..0.009 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
242. 127.503 127.503 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_230_trip_id_idx on road_segments_partitioned_230 (cost=0.42..54.47 rows=54 width=16) (actual time=0.016..0.031 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
243. 152.181 152.181 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_231_trip_id_idx on road_segments_partitioned_231 (cost=0.42..117.48 rows=118 width=16) (actual time=0.030..0.037 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
244. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_232_trip_id_idx on road_segments_partitioned_232 (cost=0.28..26.40 rows=26 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
245. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_233_trip_id_idx on road_segments_partitioned_233 (cost=0.28..12.22 rows=12 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
246. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_234_trip_id_idx on road_segments_partitioned_234 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
247. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_235_trip_id_idx on road_segments_partitioned_235 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
248. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_236_trip_id_idx on road_segments_partitioned_236 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
249. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_237_trip_id_idx on road_segments_partitioned_237 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
250. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_238_trip_id_idx on road_segments_partitioned_238 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
251. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_239_trip_id_idx on road_segments_partitioned_239 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
252. 16.452 16.452 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_240_trip_id_link_id_idx on road_segments_partitioned_240 (cost=0.28..10.70 rows=10 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
253. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_241_trip_id_idx on road_segments_partitioned_241 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
254. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_242_trip_id_idx on road_segments_partitioned_242 (cost=0.28..21.59 rows=21 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
255. 4.113 32.904 ↓ 0.0 0 4,113

Bitmap Heap Scan on road_segments_partitioned_243 (cost=1.46..71.50 rows=98 width=16) (actual time=0.008..0.008 rows=0 loops=4,113)

  • Recheck Cond: (trip_id = road_movements.trip_id)
256. 28.791 28.791 ↓ 0.0 0 4,113

Bitmap Index Scan on road_segments_partitioned_243_trip_id_idx (cost=0.00..1.43 rows=98 width=0) (actual time=0.007..0.007 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
257. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_244_trip_id_idx on road_segments_partitioned_244 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
258. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_245_trip_id_idx on road_segments_partitioned_245 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
259. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_246_trip_id_idx on road_segments_partitioned_246 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
260. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_247_trip_id_idx on road_segments_partitioned_247 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
261. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_248_trip_id_idx on road_segments_partitioned_248 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
262. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_249_trip_id_idx on road_segments_partitioned_249 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
263. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_250_trip_id_idx on road_segments_partitioned_250 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
264. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_251_trip_id_idx on road_segments_partitioned_251 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
265. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_252_trip_id_idx on road_segments_partitioned_252 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
266. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_253_trip_id_idx on road_segments_partitioned_253 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
267. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_254_trip_id_idx on road_segments_partitioned_254 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
268. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_255_trip_id_idx on road_segments_partitioned_255 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
269. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_256_trip_id_idx on road_segments_partitioned_256 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
270. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_257_trip_id_idx on road_segments_partitioned_257 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
271. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_258_trip_id_idx on road_segments_partitioned_258 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
272. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_259_trip_id_idx on road_segments_partitioned_259 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
273. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_260_trip_id_idx on road_segments_partitioned_260 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
274. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_261_trip_id_idx on road_segments_partitioned_261 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
275. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_262_trip_id_idx on road_segments_partitioned_262 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
276. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_263_trip_id_idx on road_segments_partitioned_263 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
277. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_264_trip_id_idx on road_segments_partitioned_264 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
278. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_265_trip_id_idx on road_segments_partitioned_265 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
279. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_266_trip_id_idx on road_segments_partitioned_266 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
280. 28.791 28.791 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_267_trip_id_idx on road_segments_partitioned_267 (cost=0.28..7.40 rows=7 width=16) (actual time=0.007..0.007 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
281. 65.808 65.808 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_268_trip_id_idx on road_segments_partitioned_268 (cost=0.29..51.24 rows=51 width=16) (actual time=0.009..0.016 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
282. 123.390 123.390 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_269_trip_id_idx on road_segments_partitioned_269 (cost=0.42..139.10 rows=140 width=16) (actual time=0.017..0.030 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
283. 115.164 115.164 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_270_trip_id_idx on road_segments_partitioned_270 (cost=0.42..121.36 rows=122 width=16) (actual time=0.016..0.028 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
284. 106.938 106.938 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_271_trip_id_idx on road_segments_partitioned_271 (cost=0.42..103.51 rows=104 width=16) (actual time=0.014..0.026 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
285. 45.243 45.243 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_272_trip_id_link_id_idx on road_segments_partitioned_272 (cost=0.28..34.56 rows=34 width=16) (actual time=0.011..0.011 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
286. 127.503 127.503 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_273_trip_id_idx on road_segments_partitioned_273 (cost=0.42..106.58 rows=107 width=16) (actual time=0.024..0.031 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
287. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_274_trip_id_idx on road_segments_partitioned_274 (cost=0.29..57.24 rows=57 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
288. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_275_trip_id_idx on road_segments_partitioned_275 (cost=0.28..7.46 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
289. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_276_trip_id_idx on road_segments_partitioned_276 (cost=0.28..35.05 rows=35 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
290. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_277_trip_id_idx on road_segments_partitioned_277 (cost=0.28..10.79 rows=10 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
291. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_278_trip_id_idx on road_segments_partitioned_278 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
292. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_279_trip_id_idx on road_segments_partitioned_279 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
293. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_280_trip_id_idx on road_segments_partitioned_280 (cost=0.15..6.47 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
294. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_281_trip_id_idx on road_segments_partitioned_281 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
295. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_282_trip_id_idx on road_segments_partitioned_282 (cost=0.28..12.22 rows=12 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
296. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_283_trip_id_idx on road_segments_partitioned_283 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
297. 4.113 24.678 ↓ 0.0 0 4,113

Bitmap Heap Scan on road_segments_partitioned_284 (cost=1.21..25.69 rows=34 width=16) (actual time=0.006..0.006 rows=0 loops=4,113)

  • Recheck Cond: (trip_id = road_movements.trip_id)
298. 20.565 20.565 ↓ 0.0 0 4,113

Bitmap Index Scan on road_segments_partitioned_284_trip_id_idx (cost=0.00..1.20 rows=34 width=0) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
299. 41.130 41.130 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_285_trip_id_idx on road_segments_partitioned_285 (cost=0.29..79.74 rows=80 width=16) (actual time=0.010..0.010 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
300. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_286_trip_id_idx on road_segments_partitioned_286 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
301. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_287_trip_id_idx on road_segments_partitioned_287 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
302. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_288_trip_id_idx on road_segments_partitioned_288 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
303. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_289_trip_id_idx on road_segments_partitioned_289 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
304. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_290_trip_id_idx on road_segments_partitioned_290 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
305. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_291_trip_id_idx on road_segments_partitioned_291 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
306. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_292_trip_id_idx on road_segments_partitioned_292 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
307. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_293_trip_id_idx on road_segments_partitioned_293 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
308. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_294_trip_id_idx on road_segments_partitioned_294 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
309. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_295_trip_id_idx on road_segments_partitioned_295 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
310. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_296_trip_id_idx on road_segments_partitioned_296 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
311. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_297_trip_id_idx on road_segments_partitioned_297 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
312. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_298_trip_id_idx on road_segments_partitioned_298 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
313. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_299_trip_id_idx on road_segments_partitioned_299 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
314. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_300_trip_id_idx on road_segments_partitioned_300 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
315. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_301_trip_id_idx on road_segments_partitioned_301 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
316. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_302_trip_id_idx on road_segments_partitioned_302 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
317. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_303_trip_id_idx on road_segments_partitioned_303 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
318. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_304_trip_id_idx on road_segments_partitioned_304 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
319. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_305_trip_id_idx on road_segments_partitioned_305 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
320. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_306_trip_id_idx on road_segments_partitioned_306 (cost=0.28..20.52 rows=20 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
321. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_307_trip_id_idx on road_segments_partitioned_307 (cost=0.28..7.43 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
322. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_308_trip_id_idx on road_segments_partitioned_308 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
323. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_309_trip_id_idx on road_segments_partitioned_309 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
324. 90.486 90.486 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_310_trip_id_idx on road_segments_partitioned_310 (cost=0.29..133.07 rows=134 width=16) (actual time=0.009..0.022 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
325. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_311_trip_id_idx on road_segments_partitioned_311 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
326. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_312_trip_id_idx on road_segments_partitioned_312 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
327. 20.565 20.565 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_313_trip_id_link_id_idx on road_segments_partitioned_313 (cost=0.29..64.02 rows=64 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
328. 37.017 37.017 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_314_trip_id_link_id_idx on road_segments_partitioned_314 (cost=0.29..87.31 rows=88 width=16) (actual time=0.009..0.009 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
329. 119.277 119.277 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_315_trip_id_idx on road_segments_partitioned_315 (cost=0.42..51.49 rows=51 width=16) (actual time=0.025..0.029 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
330. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_316_trip_id_idx on road_segments_partitioned_316 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
331. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_317_trip_id_idx on road_segments_partitioned_317 (cost=0.29..72.81 rows=73 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
332. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_318_trip_id_idx on road_segments_partitioned_318 (cost=0.29..232.45 rows=235 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
333. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_319_trip_id_idx on road_segments_partitioned_319 (cost=0.28..7.46 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
334. 16.452 16.452 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_320_trip_id_link_id_idx on road_segments_partitioned_320 (cost=0.28..7.50 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
335. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_321_trip_id_idx on road_segments_partitioned_321 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
336. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_322_trip_id_idx on road_segments_partitioned_322 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
337. 20.565 20.565 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_323_trip_id_link_id_idx on road_segments_partitioned_323 (cost=0.28..18.21 rows=18 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
338. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_324_trip_id_idx on road_segments_partitioned_324 (cost=0.28..27.46 rows=27 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
339. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_325_trip_id_idx on road_segments_partitioned_325 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
340. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_326_trip_id_idx on road_segments_partitioned_326 (cost=0.28..7.40 rows=7 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
341. 172.746 172.746 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_327_trip_id_idx on road_segments_partitioned_327 (cost=0.42..184.45 rows=186 width=16) (actual time=0.042..0.042 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
342. 189.198 189.198 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_328_trip_id_idx on road_segments_partitioned_328 (cost=0.42..187.43 rows=189 width=16) (actual time=0.046..0.046 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
343. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_329_trip_id_idx on road_segments_partitioned_329 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
344. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_330_trip_id_idx on road_segments_partitioned_330 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
345. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_331_trip_id_idx on road_segments_partitioned_331 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
346. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_332_trip_id_idx on road_segments_partitioned_332 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
347. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_333_trip_id_idx on road_segments_partitioned_333 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
348. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_334_trip_id_idx on road_segments_partitioned_334 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
349. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_335_trip_id_idx on road_segments_partitioned_335 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
350. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_336_trip_id_idx on road_segments_partitioned_336 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
351. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_337_trip_id_idx on road_segments_partitioned_337 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
352. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_338_trip_id_idx on road_segments_partitioned_338 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
353. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_339_trip_id_idx on road_segments_partitioned_339 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
354. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_340_trip_id_idx on road_segments_partitioned_340 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
355. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_341_trip_id_idx on road_segments_partitioned_341 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
356. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_342_trip_id_idx on road_segments_partitioned_342 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
357. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_343_trip_id_idx on road_segments_partitioned_343 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
358. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_344_trip_id_idx on road_segments_partitioned_344 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
359. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_345_trip_id_idx on road_segments_partitioned_345 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
360. 37.017 37.017 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_346_trip_id_idx on road_segments_partitioned_346 (cost=0.29..20.66 rows=20 width=16) (actual time=0.006..0.009 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
361. 69.921 69.921 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_347_trip_id_idx on road_segments_partitioned_347 (cost=0.29..145.61 rows=147 width=16) (actual time=0.008..0.017 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
362. 41.130 41.130 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_348_trip_id_idx on road_segments_partitioned_348 (cost=0.29..60.06 rows=60 width=16) (actual time=0.010..0.010 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
363. 53.469 53.469 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_349_trip_id_link_id_idx on road_segments_partitioned_349 (cost=0.29..100.28 rows=101 width=16) (actual time=0.008..0.013 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 75
364. 65.808 65.808 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_350_trip_id_idx on road_segments_partitioned_350 (cost=0.29..159.05 rows=161 width=16) (actual time=0.008..0.016 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
365. 28.791 28.791 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_351_trip_id_link_id_idx on road_segments_partitioned_351 (cost=0.28..15.60 rows=15 width=16) (actual time=0.006..0.007 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 12
366. 65.808 65.808 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_352_trip_id_idx on road_segments_partitioned_352 (cost=0.29..59.06 rows=59 width=16) (actual time=0.006..0.016 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
367. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_353_trip_id_idx on road_segments_partitioned_353 (cost=0.28..14.44 rows=14 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
368. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_354_trip_id_idx on road_segments_partitioned_354 (cost=0.28..20.51 rows=20 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
369. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_355_trip_id_idx on road_segments_partitioned_355 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
370. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_356_trip_id_idx on road_segments_partitioned_356 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
371. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_357_trip_id_idx on road_segments_partitioned_357 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
372. 143.955 143.955 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_358_trip_id_idx on road_segments_partitioned_358 (cost=0.42..117.42 rows=118 width=16) (actual time=0.029..0.035 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
373. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_359_trip_id_idx on road_segments_partitioned_359 (cost=0.28..7.35 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
374. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_360_trip_id_idx on road_segments_partitioned_360 (cost=0.29..157.52 rows=159 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
375. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_361_trip_id_idx on road_segments_partitioned_361 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
376. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_362_trip_id_idx on road_segments_partitioned_362 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
377. 16.452 16.452 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_363_trip_id_link_id_idx on road_segments_partitioned_363 (cost=0.29..47.92 rows=48 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
378. 16.452 16.452 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_364_trip_id_link_id_idx on road_segments_partitioned_364 (cost=0.28..7.53 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
379. 24.678 24.678 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_365_trip_id_idx on road_segments_partitioned_365 (cost=0.29..358.47 rows=362 width=16) (actual time=0.006..0.006 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
380. 24.678 24.678 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_366_trip_id_link_id_idx on road_segments_partitioned_366 (cost=0.29..66.02 rows=66 width=16) (actual time=0.006..0.006 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
381. 24.678 24.678 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_367_trip_id_idx on road_segments_partitioned_367 (cost=0.29..85.71 rows=86 width=16) (actual time=0.006..0.006 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
382. 32.904 32.904 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_368_trip_id_idx on road_segments_partitioned_368 (cost=0.29..229.58 rows=232 width=16) (actual time=0.008..0.008 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
383. 139.842 139.842 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_369_trip_id_idx on road_segments_partitioned_369 (cost=0.43..353.87 rows=358 width=16) (actual time=0.034..0.034 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
384. 255.006 255.006 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_370_trip_id_idx on road_segments_partitioned_370 (cost=0.43..356.76 rows=360 width=16) (actual time=0.062..0.062 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
385. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_371_trip_id_idx on road_segments_partitioned_371 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
386. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_372_trip_id_idx on road_segments_partitioned_372 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
387. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_373_trip_id_idx on road_segments_partitioned_373 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
388. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_374_trip_id_idx on road_segments_partitioned_374 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
389. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_375_trip_id_idx on road_segments_partitioned_375 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
390. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_376_trip_id_idx on road_segments_partitioned_376 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
391. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_377_trip_id_idx on road_segments_partitioned_377 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
392. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_378_trip_id_idx on road_segments_partitioned_378 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
393. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_379_trip_id_idx on road_segments_partitioned_379 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
394. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_380_trip_id_idx on road_segments_partitioned_380 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
395. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_381_trip_id_idx on road_segments_partitioned_381 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
396. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_382_trip_id_idx on road_segments_partitioned_382 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
397. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_383_trip_id_idx on road_segments_partitioned_383 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
398. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_384_trip_id_idx on road_segments_partitioned_384 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
399. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_385_trip_id_idx on road_segments_partitioned_385 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
400. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_386_trip_id_idx on road_segments_partitioned_386 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
401. 24.678 24.678 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_387_trip_id_link_id_idx on road_segments_partitioned_387 (cost=0.28..7.53 rows=7 width=16) (actual time=0.005..0.006 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 6
402. 65.808 65.808 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_388_trip_id_link_id_idx on road_segments_partitioned_388 (cost=0.29..98.16 rows=99 width=16) (actual time=0.008..0.016 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 80
403. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_389_trip_id_idx on road_segments_partitioned_389 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
404. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_390_trip_id_idx on road_segments_partitioned_390 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
405. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_391_trip_id_idx on road_segments_partitioned_391 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
406. 28.791 28.791 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_392_trip_id_idx on road_segments_partitioned_392 (cost=0.29..52.12 rows=52 width=16) (actual time=0.007..0.007 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
407. 32.904 32.904 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_393_trip_id_link_id_idx on road_segments_partitioned_393 (cost=0.29..46.42 rows=46 width=16) (actual time=0.007..0.008 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 92
408. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_394_trip_id_idx on road_segments_partitioned_394 (cost=0.28..7.40 rows=7 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
409. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_395_trip_id_idx on road_segments_partitioned_395 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
410. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_396_trip_id_idx on road_segments_partitioned_396 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
411. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_397_trip_id_idx on road_segments_partitioned_397 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
412. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_398_trip_id_idx on road_segments_partitioned_398 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
413. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_399_trip_id_idx on road_segments_partitioned_399 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
414. 156.294 156.294 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_400_trip_id_idx on road_segments_partitioned_400 (cost=0.42..1,893.66 rows=1,916 width=16) (actual time=0.031..0.038 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
415. 57.582 57.582 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_401_trip_id_idx on road_segments_partitioned_401 (cost=0.29..469.58 rows=475 width=16) (actual time=0.014..0.014 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
416. 24.678 24.678 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_402_trip_id_idx on road_segments_partitioned_402 (cost=0.29..210.25 rows=213 width=16) (actual time=0.006..0.006 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
417. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_403_trip_id_idx on road_segments_partitioned_403 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
418. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_404_trip_id_idx on road_segments_partitioned_404 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
419. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_405_trip_id_idx on road_segments_partitioned_405 (cost=0.29..24.48 rows=24 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
420. 24.678 24.678 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_406_trip_id_idx on road_segments_partitioned_406 (cost=0.29..44.45 rows=44 width=16) (actual time=0.006..0.006 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
421. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_407_trip_id_idx on road_segments_partitioned_407 (cost=0.29..125.62 rows=127 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
422. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_408_trip_id_idx on road_segments_partitioned_408 (cost=0.28..7.43 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
423. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_409_trip_id_idx on road_segments_partitioned_409 (cost=0.28..15.60 rows=15 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
424. 61.695 61.695 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_410_trip_id_idx on road_segments_partitioned_410 (cost=0.29..409.07 rows=414 width=16) (actual time=0.015..0.015 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
425. 111.051 111.051 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_411_trip_id_idx on road_segments_partitioned_411 (cost=0.42..120.61 rows=122 width=16) (actual time=0.027..0.027 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
426. 205.650 205.650 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_412_trip_id_idx on road_segments_partitioned_412 (cost=0.43..279.91 rows=282 width=16) (actual time=0.050..0.050 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
427. 2,303.280 2,303.280 ↑ 43.1 7 4,113

Index Scan using road_segments_partitioned_413_trip_id_idx on road_segments_partitioned_413 (cost=0.43..299.64 rows=302 width=16) (actual time=0.139..0.560 rows=7 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
428. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_414_trip_id_idx on road_segments_partitioned_414 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
429. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_415_trip_id_idx on road_segments_partitioned_415 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
430. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_416_trip_id_idx on road_segments_partitioned_416 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
431. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_417_trip_id_idx on road_segments_partitioned_417 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
432. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_418_trip_id_idx on road_segments_partitioned_418 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
433. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_419_trip_id_idx on road_segments_partitioned_419 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
434. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_420_trip_id_idx on road_segments_partitioned_420 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
435. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_421_trip_id_idx on road_segments_partitioned_421 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
436. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_422_trip_id_idx on road_segments_partitioned_422 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
437. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_423_trip_id_idx on road_segments_partitioned_423 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
438. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_424_trip_id_idx on road_segments_partitioned_424 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
439. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_425_trip_id_idx on road_segments_partitioned_425 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
440. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_426_trip_id_idx on road_segments_partitioned_426 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
441. 94.599 94.599 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_427_trip_id_idx on road_segments_partitioned_427 (cost=0.29..154.67 rows=156 width=16) (actual time=0.009..0.023 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
442. 57.582 57.582 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_428_trip_id_link_id_idx on road_segments_partitioned_428 (cost=0.29..91.14 rows=92 width=16) (actual time=0.007..0.014 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 74
443. 28.791 28.791 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_429_trip_id_link_id_idx on road_segments_partitioned_429 (cost=0.29..36.46 rows=36 width=16) (actual time=0.007..0.007 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 72
444. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_430_trip_id_idx on road_segments_partitioned_430 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
445. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_431_trip_id_idx on road_segments_partitioned_431 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
446. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_432_trip_id_idx on road_segments_partitioned_432 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
447. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_433_trip_id_idx on road_segments_partitioned_433 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
448. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_434_trip_id_idx on road_segments_partitioned_434 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
449. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_435_trip_id_idx on road_segments_partitioned_435 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
450. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_436_trip_id_idx on road_segments_partitioned_436 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
451. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_437_trip_id_idx on road_segments_partitioned_437 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
452. 28.791 28.791 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_438_trip_id_idx on road_segments_partitioned_438 (cost=0.28..7.40 rows=7 width=16) (actual time=0.007..0.007 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
453. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_439_trip_id_idx on road_segments_partitioned_439 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
454. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_440_trip_id_idx on road_segments_partitioned_440 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
455. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_441_trip_id_idx on road_segments_partitioned_441 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
456. 180.972 180.972 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_442_trip_id_idx on road_segments_partitioned_442 (cost=0.42..1,035.17 rows=1,047 width=16) (actual time=0.029..0.044 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
457. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_443_trip_id_idx on road_segments_partitioned_443 (cost=0.28..7.46 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
458. 57.582 57.582 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_444_trip_id_idx on road_segments_partitioned_444 (cost=0.42..527.73 rows=533 width=16) (actual time=0.014..0.014 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
459. 65.808 65.808 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_445_trip_id_idx on road_segments_partitioned_445 (cost=0.42..77.09 rows=77 width=16) (actual time=0.016..0.016 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
460. 65.808 65.808 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_446_trip_id_idx on road_segments_partitioned_446 (cost=0.42..69.20 rows=69 width=16) (actual time=0.016..0.016 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
461. 61.695 61.695 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_447_trip_id_idx on road_segments_partitioned_447 (cost=0.42..67.24 rows=67 width=16) (actual time=0.015..0.015 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
462. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_448_trip_id_idx on road_segments_partitioned_448 (cost=0.29..568.23 rows=575 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
463. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_449_trip_id_idx on road_segments_partitioned_449 (cost=0.29..68.47 rows=69 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
464. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_450_trip_id_idx on road_segments_partitioned_450 (cost=0.28..29.08 rows=29 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
465. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_451_trip_id_idx on road_segments_partitioned_451 (cost=0.28..13.85 rows=13 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
466. 61.695 61.695 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_452_trip_id_idx on road_segments_partitioned_452 (cost=0.42..44.59 rows=44 width=16) (actual time=0.015..0.015 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
467. 45.243 45.243 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_453_trip_id_link_id_idx on road_segments_partitioned_453 (cost=0.29..170.96 rows=173 width=16) (actual time=0.011..0.011 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
468. 2,089.404 2,089.404 ↑ 37.9 7 4,113

Index Scan using road_segments_partitioned_454_trip_id_idx on road_segments_partitioned_454 (cost=0.43..262.33 rows=265 width=16) (actual time=0.075..0.508 rows=7 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
469. 1,937.223 1,937.223 ↑ 53.2 4 4,113

Index Scan using road_segments_partitioned_455_trip_id_idx on road_segments_partitioned_455 (cost=0.43..211.05 rows=213 width=16) (actual time=0.096..0.471 rows=4 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
470. 193.311 193.311 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_456_trip_id_idx on road_segments_partitioned_456 (cost=0.42..191.26 rows=193 width=16) (actual time=0.047..0.047 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
471. 82.260 82.260 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_457_trip_id_idx on road_segments_partitioned_457 (cost=0.42..124.35 rows=125 width=16) (actual time=0.020..0.020 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
472. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_458_trip_id_idx on road_segments_partitioned_458 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
473. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_459_trip_id_idx on road_segments_partitioned_459 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
474. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_460_trip_id_idx on road_segments_partitioned_460 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
475. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_461_trip_id_idx on road_segments_partitioned_461 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
476. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_462_trip_id_idx on road_segments_partitioned_462 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
477. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_463_trip_id_idx on road_segments_partitioned_463 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
478. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_464_trip_id_idx on road_segments_partitioned_464 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
479. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_465_trip_id_idx on road_segments_partitioned_465 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
480. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_466_trip_id_idx on road_segments_partitioned_466 (cost=0.28..13.38 rows=13 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
481. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_467_trip_id_idx on road_segments_partitioned_467 (cost=0.29..47.93 rows=48 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
482. 49.356 49.356 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_468_trip_id_link_id_idx on road_segments_partitioned_468 (cost=0.29..88.46 rows=89 width=16) (actual time=0.007..0.012 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 54
483. 65.808 65.808 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_469_trip_id_idx on road_segments_partitioned_469 (cost=0.29..119.21 rows=120 width=16) (actual time=0.008..0.016 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
484. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_470_trip_id_idx on road_segments_partitioned_470 (cost=0.28..19.35 rows=19 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
485. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_471_trip_id_idx on road_segments_partitioned_471 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
486. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_472_trip_id_idx on road_segments_partitioned_472 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
487. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_473_trip_id_idx on road_segments_partitioned_473 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
488. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_474_trip_id_idx on road_segments_partitioned_474 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
489. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_475_trip_id_idx on road_segments_partitioned_475 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
490. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_476_trip_id_idx on road_segments_partitioned_476 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
491. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_477_trip_id_idx on road_segments_partitioned_477 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
492. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_478_trip_id_idx on road_segments_partitioned_478 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
493. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_479_trip_id_idx on road_segments_partitioned_479 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
494. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_480_trip_id_idx on road_segments_partitioned_480 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
495. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_481_trip_id_idx on road_segments_partitioned_481 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
496. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_482_trip_id_idx on road_segments_partitioned_482 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
497. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_483_trip_id_idx on road_segments_partitioned_483 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
498. 119.277 119.277 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_484_trip_id_idx on road_segments_partitioned_484 (cost=0.42..126.27 rows=127 width=16) (actual time=0.023..0.029 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
499. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_485_trip_id_idx on road_segments_partitioned_485 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
500. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_486_trip_id_idx on road_segments_partitioned_486 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
501. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_487_trip_id_idx on road_segments_partitioned_487 (cost=0.28..7.46 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
502. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_488_trip_id_idx on road_segments_partitioned_488 (cost=0.28..10.66 rows=10 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
503. 65.808 65.808 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_489_trip_id_idx on road_segments_partitioned_489 (cost=0.42..108.60 rows=109 width=16) (actual time=0.016..0.016 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
504. 86.373 86.373 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_490_trip_id_idx on road_segments_partitioned_490 (cost=0.42..236.65 rows=239 width=16) (actual time=0.021..0.021 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
505. 69.921 69.921 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_491_trip_id_idx on road_segments_partitioned_491 (cost=0.42..135.14 rows=136 width=16) (actual time=0.017..0.017 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
506. 41.130 41.130 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_492_trip_id_idx on road_segments_partitioned_492 (cost=0.42..46.59 rows=46 width=16) (actual time=0.010..0.010 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
507. 37.017 37.017 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_493_trip_id_idx on road_segments_partitioned_493 (cost=0.42..75.09 rows=75 width=16) (actual time=0.009..0.009 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
508. 90.486 90.486 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_494_trip_id_idx on road_segments_partitioned_494 (cost=0.42..2,712.85 rows=2,745 width=16) (actual time=0.022..0.022 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
509. 61.695 61.695 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_495_trip_id_idx on road_segments_partitioned_495 (cost=0.42..111.50 rows=112 width=16) (actual time=0.015..0.015 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
510. 230.328 230.328 ↑ 41.5 2 4,113

Index Scan using road_segments_partitioned_496_trip_id_idx on road_segments_partitioned_496 (cost=0.42..83.00 rows=83 width=16) (actual time=0.052..0.056 rows=2 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
511. 847.278 847.278 ↑ 27.0 2 4,113

Index Scan using road_segments_partitioned_497_trip_id_idx on road_segments_partitioned_497 (cost=0.42..54.48 rows=54 width=16) (actual time=0.050..0.206 rows=2 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
512. 86.373 86.373 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_498_trip_id_idx on road_segments_partitioned_498 (cost=0.42..95.77 rows=96 width=16) (actual time=0.021..0.021 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
513. 119.277 119.277 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_499_trip_id_idx on road_segments_partitioned_499 (cost=0.43..628.22 rows=635 width=16) (actual time=0.029..0.029 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
514. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_500_trip_id_idx on road_segments_partitioned_500 (cost=0.15..6.47 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
515. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_501_trip_id_idx on road_segments_partitioned_501 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
516. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_502_trip_id_idx on road_segments_partitioned_502 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
517. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_503_trip_id_idx on road_segments_partitioned_503 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
518. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_504_trip_id_idx on road_segments_partitioned_504 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
519. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_505_trip_id_idx on road_segments_partitioned_505 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
520. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_506_trip_id_idx on road_segments_partitioned_506 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
521. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_507_trip_id_idx on road_segments_partitioned_507 (cost=0.28..7.46 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
522. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_508_trip_id_idx on road_segments_partitioned_508 (cost=0.28..48.05 rows=48 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
523. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_509_trip_id_idx on road_segments_partitioned_509 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
524. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_510_trip_id_idx on road_segments_partitioned_510 (cost=0.28..7.40 rows=7 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
525. 61.695 61.695 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_511_trip_id_idx on road_segments_partitioned_511 (cost=0.29..69.80 rows=70 width=16) (actual time=0.007..0.015 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
526. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_512_trip_id_idx on road_segments_partitioned_512 (cost=0.28..33.43 rows=33 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
527. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_513_trip_id_idx on road_segments_partitioned_513 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
528. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_514_trip_id_idx on road_segments_partitioned_514 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
529. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_515_trip_id_idx on road_segments_partitioned_515 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
530. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_516_trip_id_idx on road_segments_partitioned_516 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
531. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_517_trip_id_idx on road_segments_partitioned_517 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
532. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_518_trip_id_idx on road_segments_partitioned_518 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
533. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_519_trip_id_idx on road_segments_partitioned_519 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
534. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_520_trip_id_idx on road_segments_partitioned_520 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
535. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_521_trip_id_idx on road_segments_partitioned_521 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
536. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_522_trip_id_idx on road_segments_partitioned_522 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
537. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_523_trip_id_idx on road_segments_partitioned_523 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
538. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_524_trip_id_idx on road_segments_partitioned_524 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
539. 98.712 98.712 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_525_trip_id_idx on road_segments_partitioned_525 (cost=0.29..65.11 rows=65 width=16) (actual time=0.019..0.024 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
540. 69.921 69.921 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_526_trip_id_idx on road_segments_partitioned_526 (cost=0.29..59.14 rows=59 width=16) (actual time=0.017..0.017 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
541. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_527_trip_id_idx on road_segments_partitioned_527 (cost=0.28..14.54 rows=14 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
542. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_528_trip_id_idx on road_segments_partitioned_528 (cost=0.28..7.46 rows=7 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
543. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_529_trip_id_idx on road_segments_partitioned_529 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
544. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_530_trip_id_idx on road_segments_partitioned_530 (cost=0.28..10.79 rows=10 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
545. 12.339 12.339 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_531_trip_id_link_id_idx on road_segments_partitioned_531 (cost=0.28..31.21 rows=31 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
546. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_532_trip_id_idx on road_segments_partitioned_532 (cost=0.29..77.70 rows=78 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
547. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_533_trip_id_idx on road_segments_partitioned_533 (cost=0.28..15.60 rows=15 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
548. 49.356 49.356 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_534_trip_id_idx on road_segments_partitioned_534 (cost=0.42..45.57 rows=45 width=16) (actual time=0.012..0.012 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
549. 65.808 65.808 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_535_trip_id_idx on road_segments_partitioned_535 (cost=0.42..118.48 rows=119 width=16) (actual time=0.016..0.016 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
550. 45.243 45.243 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_536_trip_id_idx on road_segments_partitioned_536 (cost=0.29..337.42 rows=341 width=16) (actual time=0.011..0.011 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
551. 57.582 57.582 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_537_trip_id_idx on road_segments_partitioned_537 (cost=0.29..21.83 rows=21 width=16) (actual time=0.014..0.014 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
552. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_538_trip_id_idx on road_segments_partitioned_538 (cost=0.28..7.40 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
553. 1,229.787 1,229.787 ↑ 1,132.0 3 4,113

Index Scan using road_segments_partitioned_539_trip_id_idx on road_segments_partitioned_539 (cost=0.42..3,356.68 rows=3,396 width=16) (actual time=0.057..0.299 rows=3 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
554. 41.130 41.130 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_540_trip_id_idx on road_segments_partitioned_540 (cost=0.42..117.42 rows=118 width=16) (actual time=0.010..0.010 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
555. 123.390 123.390 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_541_trip_id_idx on road_segments_partitioned_541 (cost=0.42..192.30 rows=194 width=16) (actual time=0.030..0.030 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
556. 41.130 41.130 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_542_trip_id_idx on road_segments_partitioned_542 (cost=0.29..37.60 rows=37 width=16) (actual time=0.010..0.010 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
557. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_543_trip_id_idx on road_segments_partitioned_543 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
558. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_544_trip_id_idx on road_segments_partitioned_544 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
559. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_545_trip_id_idx on road_segments_partitioned_545 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
560. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_546_trip_id_idx on road_segments_partitioned_546 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
561. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_547_trip_id_idx on road_segments_partitioned_547 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
562. 16.452 16.452 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_548_trip_id_link_id_idx on road_segments_partitioned_548 (cost=0.28..7.54 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
563. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_549_trip_id_idx on road_segments_partitioned_549 (cost=0.29..76.55 rows=77 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
564. 12.339 12.339 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_550_trip_id_link_id_idx on road_segments_partitioned_550 (cost=0.28..8.60 rows=8 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
565. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_551_trip_id_idx on road_segments_partitioned_551 (cost=0.28..7.35 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
566. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_552_trip_id_idx on road_segments_partitioned_552 (cost=0.28..23.13 rows=23 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
567. 28.791 28.791 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_553_trip_id_idx on road_segments_partitioned_553 (cost=0.29..76.94 rows=77 width=16) (actual time=0.007..0.007 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
568. 24.678 24.678 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_554_trip_id_idx on road_segments_partitioned_554 (cost=0.29..56.16 rows=56 width=16) (actual time=0.006..0.006 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
569. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_555_trip_id_idx on road_segments_partitioned_555 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
570. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_556_trip_id_idx on road_segments_partitioned_556 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
571. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_557_trip_id_idx on road_segments_partitioned_557 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
572. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_558_trip_id_idx on road_segments_partitioned_558 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
573. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_559_trip_id_idx on road_segments_partitioned_559 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
574. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_560_trip_id_idx on road_segments_partitioned_560 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
575. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_561_trip_id_idx on road_segments_partitioned_561 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
576. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_562_trip_id_idx on road_segments_partitioned_562 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
577. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_563_trip_id_idx on road_segments_partitioned_563 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
578. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_564_trip_id_idx on road_segments_partitioned_564 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
579. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_565_trip_id_idx on road_segments_partitioned_565 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
580. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_566_trip_id_idx on road_segments_partitioned_566 (cost=0.28..7.40 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
581. 82.260 82.260 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_567_trip_id_idx on road_segments_partitioned_567 (cost=0.29..72.98 rows=73 width=16) (actual time=0.020..0.020 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
582. 82.260 82.260 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_568_trip_id_idx on road_segments_partitioned_568 (cost=0.29..410.22 rows=415 width=16) (actual time=0.020..0.020 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
583. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_569_trip_id_idx on road_segments_partitioned_569 (cost=0.28..21.58 rows=21 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
584. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_570_trip_id_idx on road_segments_partitioned_570 (cost=0.28..13.38 rows=13 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
585. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_571_trip_id_idx on road_segments_partitioned_571 (cost=0.28..7.46 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
586. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_572_trip_id_idx on road_segments_partitioned_572 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
587. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_573_trip_id_idx on road_segments_partitioned_573 (cost=0.28..7.46 rows=7 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
588. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_574_trip_id_idx on road_segments_partitioned_574 (cost=0.29..127.84 rows=129 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
589. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_575_trip_id_idx on road_segments_partitioned_575 (cost=0.28..35.03 rows=35 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
590. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_576_trip_id_idx on road_segments_partitioned_576 (cost=0.28..7.40 rows=7 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
591. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_577_trip_id_idx on road_segments_partitioned_577 (cost=0.29..148.20 rows=150 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
592. 69.921 69.921 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_578_trip_id_idx on road_segments_partitioned_578 (cost=0.42..142.12 rows=143 width=16) (actual time=0.017..0.017 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
593. 106.938 106.938 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_579_trip_id_idx on road_segments_partitioned_579 (cost=0.42..2,132.12 rows=2,158 width=16) (actual time=0.026..0.026 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
594. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_580_trip_id_idx on road_segments_partitioned_580 (cost=0.28..10.66 rows=10 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
595. 111.051 111.051 ↑ 47.0 1 4,113

Index Scan using road_segments_partitioned_581_trip_id_idx on road_segments_partitioned_581 (cost=0.42..47.55 rows=47 width=16) (actual time=0.025..0.027 rows=1 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
596. 283.797 283.797 ↑ 62.3 3 4,113

Index Scan using road_segments_partitioned_582_trip_id_idx on road_segments_partitioned_582 (cost=0.43..185.38 rows=187 width=16) (actual time=0.063..0.069 rows=3 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
597. 20.565 20.565 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_583_trip_id_link_id_idx on road_segments_partitioned_583 (cost=0.29..148.29 rows=150 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
598. 139.842 139.842 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_584_trip_id_idx on road_segments_partitioned_584 (cost=0.42..198.17 rows=200 width=16) (actual time=0.034..0.034 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
599. 156.294 156.294 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_585_trip_id_idx on road_segments_partitioned_585 (cost=0.42..186.44 rows=188 width=16) (actual time=0.038..0.038 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
600. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_586_trip_id_idx on road_segments_partitioned_586 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
601. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_587_trip_id_idx on road_segments_partitioned_587 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
602. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_588_trip_id_idx on road_segments_partitioned_588 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
603. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_589_trip_id_idx on road_segments_partitioned_589 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
604. 16.452 16.452 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_590_trip_id_idx on road_segments_partitioned_590 (cost=0.29..79.48 rows=80 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
605. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_591_trip_id_idx on road_segments_partitioned_591 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
606. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_592_trip_id_idx on road_segments_partitioned_592 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
607. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_593_trip_id_idx on road_segments_partitioned_593 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
608. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_594_trip_id_idx on road_segments_partitioned_594 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
609. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_595_trip_id_idx on road_segments_partitioned_595 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
610. 49.356 49.356 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_596_trip_id_idx on road_segments_partitioned_596 (cost=0.29..96.55 rows=97 width=16) (actual time=0.006..0.012 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
611. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_597_trip_id_idx on road_segments_partitioned_597 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
612. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_598_trip_id_idx on road_segments_partitioned_598 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
613. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_599_trip_id_idx on road_segments_partitioned_599 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
614. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_600_trip_id_idx on road_segments_partitioned_600 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
615. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_601_trip_id_idx on road_segments_partitioned_601 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
616. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_602_trip_id_idx on road_segments_partitioned_602 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
617. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_603_trip_id_idx on road_segments_partitioned_603 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
618. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_604_trip_id_idx on road_segments_partitioned_604 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
619. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_605_trip_id_idx on road_segments_partitioned_605 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
620. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_606_trip_id_idx on road_segments_partitioned_606 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
621. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_607_trip_id_idx on road_segments_partitioned_607 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
622. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_608_trip_id_idx on road_segments_partitioned_608 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
623. 90.486 90.486 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_609_trip_id_idx on road_segments_partitioned_609 (cost=0.29..386.02 rows=390 width=16) (actual time=0.018..0.022 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
624. 143.955 143.955 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_610_trip_id_idx on road_segments_partitioned_610 (cost=0.42..242.48 rows=245 width=16) (actual time=0.027..0.035 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
625. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_611_trip_id_idx on road_segments_partitioned_611 (cost=0.15..6.97 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
626. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_612_trip_id_idx on road_segments_partitioned_612 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
627. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_613_trip_id_idx on road_segments_partitioned_613 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
628. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_614_trip_id_idx on road_segments_partitioned_614 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
629. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_615_trip_id_idx on road_segments_partitioned_615 (cost=0.28..23.13 rows=23 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
630. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_616_trip_id_idx on road_segments_partitioned_616 (cost=0.29..41.00 rows=41 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
631. 12.339 12.339 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_617_trip_id_idx on road_segments_partitioned_617 (cost=0.28..7.40 rows=7 width=16) (actual time=0.003..0.003 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
632. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_618_trip_id_idx on road_segments_partitioned_618 (cost=0.15..6.97 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
633. 16.452 16.452 ↓ 0.0 0 4,113

Index Only Scan using road_segments_partitioned_619_trip_id_link_id_idx on road_segments_partitioned_619 (cost=0.28..32.37 rows=32 width=16) (actual time=0.004..0.004 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
634. 20.565 20.565 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_620_trip_id_idx on road_segments_partitioned_620 (cost=0.29..174.23 rows=176 width=16) (actual time=0.005..0.005 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
635. 143.955 143.955 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_621_trip_id_idx on road_segments_partitioned_621 (cost=0.43..170.71 rows=172 width=16) (actual time=0.035..0.035 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
636. 378.396 378.396 ↑ 58.0 1 4,113

Index Scan using road_segments_partitioned_622_trip_id_idx on road_segments_partitioned_622 (cost=0.42..58.09 rows=58 width=16) (actual time=0.032..0.092 rows=1 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
637. 625.176 625.176 ↑ 102.0 1 4,113

Index Scan using road_segments_partitioned_623_trip_id_idx on road_segments_partitioned_623 (cost=0.42..101.75 rows=102 width=16) (actual time=0.030..0.152 rows=1 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
638. 649.854 649.854 ↑ 293.0 1 4,113

Index Scan using road_segments_partitioned_624_trip_id_idx on road_segments_partitioned_624 (cost=0.43..289.82 rows=293 width=16) (actual time=0.062..0.158 rows=1 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
639. 390.735 390.735 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_625_trip_id_idx on road_segments_partitioned_625 (cost=0.42..116.52 rows=117 width=16) (actual time=0.041..0.095 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
640. 111.051 111.051 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_626_trip_id_idx on road_segments_partitioned_626 (cost=0.43..282.89 rows=285 width=16) (actual time=0.027..0.027 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
641. 139.842 139.842 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_627_trip_id_idx on road_segments_partitioned_627 (cost=0.43..365.57 rows=369 width=16) (actual time=0.034..0.034 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
642. 106.938 106.938 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_628_trip_id_idx on road_segments_partitioned_628 (cost=0.42..118.48 rows=119 width=16) (actual time=0.026..0.026 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
643. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_629_trip_id_idx on road_segments_partitioned_629 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
644. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_630_trip_id_idx on road_segments_partitioned_630 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
645. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_631_trip_id_idx on road_segments_partitioned_631 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
646. 32.904 32.904 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_632_trip_id_idx on road_segments_partitioned_632 (cost=0.29..90.65 rows=91 width=16) (actual time=0.008..0.008 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
647. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_633_trip_id_idx on road_segments_partitioned_633 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
648. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_634_trip_id_idx on road_segments_partitioned_634 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
649. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_635_trip_id_idx on road_segments_partitioned_635 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
650. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_636_trip_id_idx on road_segments_partitioned_636 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
651. 49.356 49.356 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_637_trip_id_idx on road_segments_partitioned_637 (cost=0.29..29.69 rows=29 width=16) (actual time=0.007..0.012 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
652. 37.017 37.017 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_638_trip_id_idx on road_segments_partitioned_638 (cost=0.28..39.36 rows=39 width=16) (actual time=0.006..0.009 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
653. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_639_trip_id_idx on road_segments_partitioned_639 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
654. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_640_trip_id_idx on road_segments_partitioned_640 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
655. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_641_trip_id_idx on road_segments_partitioned_641 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
656. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_642_trip_id_idx on road_segments_partitioned_642 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
657. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_643_trip_id_idx on road_segments_partitioned_643 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
658. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_644_trip_id_idx on road_segments_partitioned_644 (cost=0.15..6.47 rows=7 width=16) (actual time=0.002..0.002 rows=0 loops=4,113)

  • Index Cond: (trip_id = road_movements.trip_id)
659. 8.226 8.226 ↓ 0.0 0 4,113

Index Scan using road_segments_partitioned_645_trip_id_idx on road_segments_partitioned_645 (cost=0.15..6.97