explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s3jE

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 130,744.509 ↓ 0.0 0 1

Sort (cost=1,553,237.65..1,553,238.15 rows=200 width=36) (actual time=130,744.509..130,744.509 rows=0 loops=1)

  • Sort Key: road_movements.commodity
  • Sort Method: quicksort Memory: 25kB
  • Functions: 28210
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 4709.720 ms, Inlining 701.226 ms, Optimization 317814.107 ms, Emission 190811.345 ms, Total 514036.398 ms
2. 0.002 130,744.500 ↓ 0.0 0 1

HashAggregate (cost=1,553,206.51..1,553,230.01 rows=200 width=36) (actual time=130,744.500..130,744.500 rows=0 loops=1)

  • Group Key: road_movements.commodity
3. 0.000 130,744.498 ↓ 0.0 0 1

Finalize HashAggregate (cost=1,422,093.38..1,484,736.32 rows=582,725 width=52) (actual time=130,744.498..130,744.498 rows=0 loops=1)

  • Group Key: road_movements.trip_id
4. 1,502.125 130,792.572 ↓ 0.0 0 1

Gather (cost=1,171,521.63..1,404,611.63 rows=1,748,175 width=124) (actual time=130,740.295..130,792.572 rows=0 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
5. 8.183 129,290.447 ↓ 0.0 0 4 / 4

Partial HashAggregate (cost=1,170,521.63..1,228,794.13 rows=582,725 width=124) (actual time=129,290.447..129,290.447 rows=0 loops=4)

  • Group Key: road_movements.trip_id
6. 0.000 129,282.264 ↓ 0.0 0 4 / 4

Nested Loop Left Join (cost=85,180.25..1,086,547.09 rows=6,717,963 width=40) (actual time=129,282.264..129,282.264 rows=0 loops=4)

  • Join Filter: NULL::boolean
7. 6.482 129,282.265 ↓ 0.0 0 4 / 4

Parallel Hash Join (cost=85,180.25..414,750.79 rows=6,717,963 width=40) (actual time=129,282.263..129,282.265 rows=0 loops=4)

  • Hash Cond: (road_segments_partitioned_0.link_id = v_transit_roads_partitioned.link_id)
8. 0.000 0.032 ↓ 0.0 0 1 / 4

Nested Loop (cost=8.15..311,943.23 rows=6,717,963 width=48) (actual time=0.126..0.126 rows=0 loops=1)

9. 0.009 0.032 ↓ 0.0 0 1 / 4

Parallel Hash Semi Join (cost=8.00..46,052.22 rows=2 width=48) (actual time=0.125..0.128 rows=0 loops=1)

  • Hash Cond: (road_movements.trip_id = road_segments_partitioned_0_1.trip_id)
10. 0.000 0.000 ↓ 0.0 0 / 4

Parallel Seq Scan on road_movements (cost=0.00..45,550.58 rows=187,976 width=40) (never executed)

11. 0.001 0.024 ↓ 0.0 0 1 / 4

Parallel Hash (cost=7.59..7.59 rows=4 width=8) (actual time=0.093..0.094 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
12. 0.023 0.023 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_segments_partitioned_0_link_id_trip_id_idx on road_segments_partitioned_0 road_segments_partitioned_0_1 (cost=0.15..7.59 rows=4 width=8) (actual time=0.092..0.092 rows=0 loops=1)

  • Index Cond: (link_id = 1201710493)
  • Heap Fetches: 0
13. 0.000 0.000 ↓ 0.0 0 / 4

Append (cost=0.15..121,241.61 rows=117,039 width=16) (never executed)

14. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_0_trip_id_idx on road_segments_partitioned_0 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
15. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_1_trip_id_idx on road_segments_partitioned_1 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
16. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_2_trip_id_idx on road_segments_partitioned_2 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
17. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_3_trip_id_idx on road_segments_partitioned_3 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
18. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_4_trip_id_idx on road_segments_partitioned_4 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
19. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_5_trip_id_idx on road_segments_partitioned_5 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
20. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_6_trip_id_idx on road_segments_partitioned_6 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
21. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_7_trip_id_idx on road_segments_partitioned_7 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
22. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_8_trip_id_idx on road_segments_partitioned_8 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
23. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_9_trip_id_idx on road_segments_partitioned_9 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
24. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_10_trip_id_idx on road_segments_partitioned_10 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
25. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_11_trip_id_idx on road_segments_partitioned_11 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
26. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_12_trip_id_idx on road_segments_partitioned_12 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
27. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_13_trip_id_idx on road_segments_partitioned_13 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
28. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_14_trip_id_idx on road_segments_partitioned_14 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
29. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_15_trip_id_idx on road_segments_partitioned_15 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
30. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_16_trip_id_idx on road_segments_partitioned_16 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
31. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_17_trip_id_idx on road_segments_partitioned_17 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
32. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_18_trip_id_idx on road_segments_partitioned_18 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
33. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_19_trip_id_idx on road_segments_partitioned_19 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
34. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_20_trip_id_idx on road_segments_partitioned_20 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
35. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_21_trip_id_idx on road_segments_partitioned_21 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
36. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_22_trip_id_idx on road_segments_partitioned_22 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
37. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_23_trip_id_idx on road_segments_partitioned_23 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
38. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_24_trip_id_idx on road_segments_partitioned_24 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
39. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_25_trip_id_idx on road_segments_partitioned_25 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
40. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_26_trip_id_idx on road_segments_partitioned_26 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
41. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_27_trip_id_idx on road_segments_partitioned_27 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
42. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_28_trip_id_idx on road_segments_partitioned_28 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
43. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_29_trip_id_idx on road_segments_partitioned_29 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
44. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_30_trip_id_idx on road_segments_partitioned_30 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
45. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_31_trip_id_idx on road_segments_partitioned_31 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
46. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_32_trip_id_idx on road_segments_partitioned_32 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
47. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_33_trip_id_idx on road_segments_partitioned_33 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
48. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_34_trip_id_idx on road_segments_partitioned_34 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
49. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_35_trip_id_idx on road_segments_partitioned_35 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
50. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_36_trip_id_idx on road_segments_partitioned_36 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
51. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_37_trip_id_idx on road_segments_partitioned_37 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
52. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_38_trip_id_idx on road_segments_partitioned_38 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
53. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_39_trip_id_idx on road_segments_partitioned_39 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
54. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_40_trip_id_idx on road_segments_partitioned_40 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
55. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_41_trip_id_idx on road_segments_partitioned_41 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
56. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_42_trip_id_idx on road_segments_partitioned_42 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
57. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_43_trip_id_idx on road_segments_partitioned_43 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
58. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_44_trip_id_idx on road_segments_partitioned_44 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
59. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_45_trip_id_idx on road_segments_partitioned_45 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
60. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_46_trip_id_idx on road_segments_partitioned_46 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
61. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_47_trip_id_idx on road_segments_partitioned_47 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
62. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_48_trip_id_idx on road_segments_partitioned_48 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
63. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_49_trip_id_idx on road_segments_partitioned_49 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
64. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_50_trip_id_idx on road_segments_partitioned_50 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
65. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_51_trip_id_idx on road_segments_partitioned_51 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
66. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_52_trip_id_idx on road_segments_partitioned_52 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
67. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_53_trip_id_idx on road_segments_partitioned_53 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
68. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_54_trip_id_idx on road_segments_partitioned_54 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
69. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_55_trip_id_idx on road_segments_partitioned_55 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
70. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_56_trip_id_idx on road_segments_partitioned_56 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
71. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_57_trip_id_idx on road_segments_partitioned_57 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
72. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_58_trip_id_idx on road_segments_partitioned_58 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
73. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_59_trip_id_idx on road_segments_partitioned_59 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
74. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_60_trip_id_idx on road_segments_partitioned_60 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
75. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_61_trip_id_idx on road_segments_partitioned_61 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
76. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_62_trip_id_idx on road_segments_partitioned_62 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
77. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_63_trip_id_idx on road_segments_partitioned_63 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
78. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_64_trip_id_idx on road_segments_partitioned_64 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
79. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_65_trip_id_idx on road_segments_partitioned_65 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
80. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_66_trip_id_idx on road_segments_partitioned_66 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
81. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_67_trip_id_idx on road_segments_partitioned_67 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
82. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_68_trip_id_idx on road_segments_partitioned_68 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
83. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_69_trip_id_idx on road_segments_partitioned_69 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
84. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_70_trip_id_idx on road_segments_partitioned_70 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
85. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_71_trip_id_idx on road_segments_partitioned_71 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
86. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_72_trip_id_idx on road_segments_partitioned_72 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
87. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_73_trip_id_idx on road_segments_partitioned_73 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
88. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_74_trip_id_idx on road_segments_partitioned_74 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
89. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_75_trip_id_idx on road_segments_partitioned_75 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
90. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_76_trip_id_idx on road_segments_partitioned_76 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
91. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_77_trip_id_idx on road_segments_partitioned_77 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
92. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_78_trip_id_idx on road_segments_partitioned_78 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
93. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_79_trip_id_idx on road_segments_partitioned_79 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
94. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_80_trip_id_idx on road_segments_partitioned_80 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
95. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_81_trip_id_idx on road_segments_partitioned_81 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
96. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_82_trip_id_idx on road_segments_partitioned_82 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
97. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_83_trip_id_idx on road_segments_partitioned_83 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
98. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_84_trip_id_idx on road_segments_partitioned_84 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
99. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_85_trip_id_idx on road_segments_partitioned_85 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
100. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_86_trip_id_idx on road_segments_partitioned_86 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
101. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_87_trip_id_idx on road_segments_partitioned_87 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
102. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_88_trip_id_idx on road_segments_partitioned_88 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
103. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_89_trip_id_idx on road_segments_partitioned_89 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
104. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_90_trip_id_idx on road_segments_partitioned_90 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
105. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_91_trip_id_idx on road_segments_partitioned_91 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
106. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_92_trip_id_idx on road_segments_partitioned_92 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
107. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_93_trip_id_idx on road_segments_partitioned_93 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
108. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_94_trip_id_idx on road_segments_partitioned_94 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
109. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_95_trip_id_idx on road_segments_partitioned_95 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
110. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_96_trip_id_idx on road_segments_partitioned_96 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
111. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_97_trip_id_idx on road_segments_partitioned_97 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
112. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_98_trip_id_idx on road_segments_partitioned_98 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
113. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_99_trip_id_idx on road_segments_partitioned_99 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
114. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_100_trip_id_idx on road_segments_partitioned_100 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
115. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_101_trip_id_idx on road_segments_partitioned_101 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
116. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_102_trip_id_idx on road_segments_partitioned_102 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
117. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_103_trip_id_idx on road_segments_partitioned_103 (cost=0.42..171.58 rows=173 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
118. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_104_trip_id_idx on road_segments_partitioned_104 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
119. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_105_trip_id_idx on road_segments_partitioned_105 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
120. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_106_trip_id_idx on road_segments_partitioned_106 (cost=0.28..7.43 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
121. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
122. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_108_trip_id_idx on road_segments_partitioned_108 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
123. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_109_trip_id_idx on road_segments_partitioned_109 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
124. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_110_trip_id_idx on road_segments_partitioned_110 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
125. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_111_trip_id_idx on road_segments_partitioned_111 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
126. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_112_trip_id_idx on road_segments_partitioned_112 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
127. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_113_trip_id_idx on road_segments_partitioned_113 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
128. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_114_trip_id_idx on road_segments_partitioned_114 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
129. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_115_trip_id_idx on road_segments_partitioned_115 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
130. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_116_trip_id_idx on road_segments_partitioned_116 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
131. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_117_trip_id_idx on road_segments_partitioned_117 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
132. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_118_trip_id_idx on road_segments_partitioned_118 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
133. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_119_trip_id_idx on road_segments_partitioned_119 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
134. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_120_trip_id_idx on road_segments_partitioned_120 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
135. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_121_trip_id_idx on road_segments_partitioned_121 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
136. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_122_trip_id_idx on road_segments_partitioned_122 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
137. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_123_trip_id_idx on road_segments_partitioned_123 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
138. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_124_trip_id_idx on road_segments_partitioned_124 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
139. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_125_trip_id_idx on road_segments_partitioned_125 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
140. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_126_trip_id_idx on road_segments_partitioned_126 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
141. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_127_trip_id_idx on road_segments_partitioned_127 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
142. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_128_trip_id_idx on road_segments_partitioned_128 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
143. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_129_trip_id_idx on road_segments_partitioned_129 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
144. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_130_trip_id_idx on road_segments_partitioned_130 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
145. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_131_trip_id_idx on road_segments_partitioned_131 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
146. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_132_trip_id_idx on road_segments_partitioned_132 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
147. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_133_trip_id_idx on road_segments_partitioned_133 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
148. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_134_trip_id_idx on road_segments_partitioned_134 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
149. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_135_trip_id_idx on road_segments_partitioned_135 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
150. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_136_trip_id_idx on road_segments_partitioned_136 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
151. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_137_trip_id_idx on road_segments_partitioned_137 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
152. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_138_trip_id_idx on road_segments_partitioned_138 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
153. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_139_trip_id_idx on road_segments_partitioned_139 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
154. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_140_trip_id_idx on road_segments_partitioned_140 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
155. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_141_trip_id_idx on road_segments_partitioned_141 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
156. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_142_trip_id_idx on road_segments_partitioned_142 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
157. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_143_trip_id_idx on road_segments_partitioned_143 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
158. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_144_trip_id_idx on road_segments_partitioned_144 (cost=0.14..2.74 rows=4 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
159. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_145_trip_id_idx on road_segments_partitioned_145 (cost=0.42..288.85 rows=292 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
160. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_146_trip_id_idx on road_segments_partitioned_146 (cost=0.29..58.19 rows=58 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
161. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_147_trip_id_idx on road_segments_partitioned_147 (cost=0.28..13.38 rows=13 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
162. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_148_trip_id_idx on road_segments_partitioned_148 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
163. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_149_trip_id_idx on road_segments_partitioned_149 (cost=0.28..29.08 rows=29 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
164. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_150_trip_id_idx on road_segments_partitioned_150 (cost=0.28..7.46 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
165. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_151_trip_id_idx on road_segments_partitioned_151 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
166. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_152_trip_id_idx on road_segments_partitioned_152 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
167. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_153_trip_id_idx on road_segments_partitioned_153 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
168. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_154_trip_id_idx on road_segments_partitioned_154 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
169. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_155_trip_id_idx on road_segments_partitioned_155 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
170. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Heap Scan on road_segments_partitioned_156 (cost=1.21..11.41 rows=41 width=16) (never executed)

  • Recheck Cond: (trip_id = road_movements.trip_id)
171. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Index Scan on road_segments_partitioned_156_trip_id_idx (cost=0.00..1.20 rows=41 width=0) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
172. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_157_trip_id_idx on road_segments_partitioned_157 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
173. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_158_trip_id_idx on road_segments_partitioned_158 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
174. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_159_trip_id_idx on road_segments_partitioned_159 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
175. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_160_trip_id_idx on road_segments_partitioned_160 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
176. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_161_trip_id_idx on road_segments_partitioned_161 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
177. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_162_trip_id_idx on road_segments_partitioned_162 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
178. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_163_trip_id_idx on road_segments_partitioned_163 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
179. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_164_trip_id_idx on road_segments_partitioned_164 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
180. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_165_trip_id_idx on road_segments_partitioned_165 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
181. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_166_trip_id_idx on road_segments_partitioned_166 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
182. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_167_trip_id_idx on road_segments_partitioned_167 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
183. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_168_trip_id_idx on road_segments_partitioned_168 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
184. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_169_trip_id_idx on road_segments_partitioned_169 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
185. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_170_trip_id_idx on road_segments_partitioned_170 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
186. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_171_trip_id_idx on road_segments_partitioned_171 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
187. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_172_trip_id_idx on road_segments_partitioned_172 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
188. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_173_trip_id_idx on road_segments_partitioned_173 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
189. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_174_trip_id_idx on road_segments_partitioned_174 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
190. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_175_trip_id_idx on road_segments_partitioned_175 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
191. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_176_trip_id_idx on road_segments_partitioned_176 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
192. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_177_trip_id_idx on road_segments_partitioned_177 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
193. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_178_trip_id_idx on road_segments_partitioned_178 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
194. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_179_trip_id_idx on road_segments_partitioned_179 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
195. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_180_trip_id_idx on road_segments_partitioned_180 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
196. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_181_trip_id_idx on road_segments_partitioned_181 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
197. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_182_trip_id_idx on road_segments_partitioned_182 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
198. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_183_trip_id_idx on road_segments_partitioned_183 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
199. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_184_trip_id_idx on road_segments_partitioned_184 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
200. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_185_trip_id_idx on road_segments_partitioned_185 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
201. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_186_trip_id_idx on road_segments_partitioned_186 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
202. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_187_trip_id_idx on road_segments_partitioned_187 (cost=0.42..660.36 rows=668 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
203. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_188_trip_id_idx on road_segments_partitioned_188 (cost=0.43..310.50 rows=314 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
204. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_189_trip_id_idx on road_segments_partitioned_189 (cost=0.28..17.82 rows=17 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
205. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
206. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_191_trip_id_idx on road_segments_partitioned_191 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
207. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_192_trip_id_idx on road_segments_partitioned_192 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
208. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_193_trip_id_idx on road_segments_partitioned_193 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
209. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_194_trip_id_idx on road_segments_partitioned_194 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
210. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_195_trip_id_idx on road_segments_partitioned_195 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
211. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_196_trip_id_idx on road_segments_partitioned_196 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
212. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_197_trip_id_idx on road_segments_partitioned_197 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
213. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_198_trip_id_idx on road_segments_partitioned_198 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
214. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Heap Scan on road_segments_partitioned_199 (cost=1.30..27.76 rows=63 width=16) (never executed)

  • Recheck Cond: (trip_id = road_movements.trip_id)
215. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Index Scan on road_segments_partitioned_199_trip_id_idx (cost=0.00..1.29 rows=63 width=0) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
216. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_200_trip_id_idx on road_segments_partitioned_200 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
217. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_201_trip_id_idx on road_segments_partitioned_201 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
218. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_202_trip_id_idx on road_segments_partitioned_202 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
219. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_203_trip_id_idx on road_segments_partitioned_203 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
220. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_204_trip_id_idx on road_segments_partitioned_204 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
221. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_205_trip_id_idx on road_segments_partitioned_205 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
222. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_206_trip_id_idx on road_segments_partitioned_206 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
223. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_207_trip_id_idx on road_segments_partitioned_207 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
224. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_208_trip_id_idx on road_segments_partitioned_208 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
225. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_209_trip_id_idx on road_segments_partitioned_209 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
226. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_210_trip_id_idx on road_segments_partitioned_210 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
227. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_211_trip_id_idx on road_segments_partitioned_211 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
228. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_212_trip_id_idx on road_segments_partitioned_212 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
229. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_213_trip_id_idx on road_segments_partitioned_213 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
230. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_214_trip_id_idx on road_segments_partitioned_214 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
231. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_215_trip_id_idx on road_segments_partitioned_215 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
232. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_216_trip_id_idx on road_segments_partitioned_216 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
233. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_217_trip_id_idx on road_segments_partitioned_217 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
234. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_218_trip_id_idx on road_segments_partitioned_218 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
235. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_219_trip_id_idx on road_segments_partitioned_219 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
236. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_220_trip_id_idx on road_segments_partitioned_220 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
237. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_221_trip_id_idx on road_segments_partitioned_221 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
238. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_222_trip_id_idx on road_segments_partitioned_222 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
239. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_223_trip_id_idx on road_segments_partitioned_223 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
240. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_224_trip_id_idx on road_segments_partitioned_224 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
241. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_225_trip_id_idx on road_segments_partitioned_225 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
242. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_226_trip_id_idx on road_segments_partitioned_226 (cost=0.28..7.46 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
243. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_227_trip_id_idx on road_segments_partitioned_227 (cost=0.28..7.35 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
244. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_228_trip_id_idx on road_segments_partitioned_228 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
245. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_229_trip_id_idx on road_segments_partitioned_229 (cost=0.29..62.51 rows=63 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
246. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_230_trip_id_idx on road_segments_partitioned_230 (cost=0.42..54.46 rows=54 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
247. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_231_trip_id_idx on road_segments_partitioned_231 (cost=0.42..117.47 rows=118 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
248. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_232_trip_id_idx on road_segments_partitioned_232 (cost=0.28..26.40 rows=26 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
249. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_233_trip_id_idx on road_segments_partitioned_233 (cost=0.28..12.22 rows=12 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
250. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_234_trip_id_idx on road_segments_partitioned_234 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
251. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_235_trip_id_idx on road_segments_partitioned_235 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
252. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_236_trip_id_idx on road_segments_partitioned_236 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
253. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_237_trip_id_idx on road_segments_partitioned_237 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
254. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_238_trip_id_idx on road_segments_partitioned_238 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
255. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_239_trip_id_idx on road_segments_partitioned_239 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
256. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
257. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_241_trip_id_idx on road_segments_partitioned_241 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
258. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_242_trip_id_idx on road_segments_partitioned_242 (cost=0.28..21.59 rows=21 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
259. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Heap Scan on road_segments_partitioned_243 (cost=1.46..71.50 rows=98 width=16) (never executed)

  • Recheck Cond: (trip_id = road_movements.trip_id)
260. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Index Scan on road_segments_partitioned_243_trip_id_idx (cost=0.00..1.43 rows=98 width=0) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
261. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_244_trip_id_idx on road_segments_partitioned_244 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
262. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_245_trip_id_idx on road_segments_partitioned_245 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
263. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_246_trip_id_idx on road_segments_partitioned_246 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
264. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_247_trip_id_idx on road_segments_partitioned_247 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
265. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_248_trip_id_idx on road_segments_partitioned_248 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
266. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_249_trip_id_idx on road_segments_partitioned_249 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
267. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_250_trip_id_idx on road_segments_partitioned_250 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
268. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_251_trip_id_idx on road_segments_partitioned_251 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
269. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_252_trip_id_idx on road_segments_partitioned_252 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
270. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_253_trip_id_idx on road_segments_partitioned_253 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
271. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_254_trip_id_idx on road_segments_partitioned_254 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
272. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_255_trip_id_idx on road_segments_partitioned_255 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
273. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_256_trip_id_idx on road_segments_partitioned_256 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
274. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_257_trip_id_idx on road_segments_partitioned_257 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
275. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_258_trip_id_idx on road_segments_partitioned_258 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
276. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_259_trip_id_idx on road_segments_partitioned_259 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
277. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_260_trip_id_idx on road_segments_partitioned_260 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
278. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_261_trip_id_idx on road_segments_partitioned_261 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
279. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_262_trip_id_idx on road_segments_partitioned_262 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
280. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_263_trip_id_idx on road_segments_partitioned_263 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
281. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_264_trip_id_idx on road_segments_partitioned_264 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
282. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_265_trip_id_idx on road_segments_partitioned_265 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
283. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_266_trip_id_idx on road_segments_partitioned_266 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
284. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_267_trip_id_idx on road_segments_partitioned_267 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
285. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_268_trip_id_idx on road_segments_partitioned_268 (cost=0.29..51.24 rows=51 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
286. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_269_trip_id_idx on road_segments_partitioned_269 (cost=0.42..139.10 rows=140 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
287. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_270_trip_id_idx on road_segments_partitioned_270 (cost=0.42..121.36 rows=122 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
288. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_271_trip_id_idx on road_segments_partitioned_271 (cost=0.42..103.51 rows=104 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
289. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
290. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_273_trip_id_idx on road_segments_partitioned_273 (cost=0.42..106.57 rows=107 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
291. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_274_trip_id_idx on road_segments_partitioned_274 (cost=0.29..57.24 rows=57 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
292. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_275_trip_id_idx on road_segments_partitioned_275 (cost=0.28..7.46 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
293. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_276_trip_id_idx on road_segments_partitioned_276 (cost=0.28..35.05 rows=35 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
294. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_277_trip_id_idx on road_segments_partitioned_277 (cost=0.28..10.79 rows=10 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
295. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_278_trip_id_idx on road_segments_partitioned_278 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
296. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_279_trip_id_idx on road_segments_partitioned_279 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
297. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_280_trip_id_idx on road_segments_partitioned_280 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
298. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_281_trip_id_idx on road_segments_partitioned_281 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
299. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_282_trip_id_idx on road_segments_partitioned_282 (cost=0.28..12.22 rows=12 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
300. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_283_trip_id_idx on road_segments_partitioned_283 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
301. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Heap Scan on road_segments_partitioned_284 (cost=1.21..25.69 rows=34 width=16) (never executed)

  • Recheck Cond: (trip_id = road_movements.trip_id)
302. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Index Scan on road_segments_partitioned_284_trip_id_idx (cost=0.00..1.20 rows=34 width=0) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
303. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_285_trip_id_idx on road_segments_partitioned_285 (cost=0.29..79.74 rows=80 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
304. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_286_trip_id_idx on road_segments_partitioned_286 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
305. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_287_trip_id_idx on road_segments_partitioned_287 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
306. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_288_trip_id_idx on road_segments_partitioned_288 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
307. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_289_trip_id_idx on road_segments_partitioned_289 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
308. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_290_trip_id_idx on road_segments_partitioned_290 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
309. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_291_trip_id_idx on road_segments_partitioned_291 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
310. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_292_trip_id_idx on road_segments_partitioned_292 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
311. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_293_trip_id_idx on road_segments_partitioned_293 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
312. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_294_trip_id_idx on road_segments_partitioned_294 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
313. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_295_trip_id_idx on road_segments_partitioned_295 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
314. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_296_trip_id_idx on road_segments_partitioned_296 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
315. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_297_trip_id_idx on road_segments_partitioned_297 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
316. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_298_trip_id_idx on road_segments_partitioned_298 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
317. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_299_trip_id_idx on road_segments_partitioned_299 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
318. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_300_trip_id_idx on road_segments_partitioned_300 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
319. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_301_trip_id_idx on road_segments_partitioned_301 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
320. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_302_trip_id_idx on road_segments_partitioned_302 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
321. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_303_trip_id_idx on road_segments_partitioned_303 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
322. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_304_trip_id_idx on road_segments_partitioned_304 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
323. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_305_trip_id_idx on road_segments_partitioned_305 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
324. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_306_trip_id_idx on road_segments_partitioned_306 (cost=0.28..20.52 rows=20 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
325. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_307_trip_id_idx on road_segments_partitioned_307 (cost=0.28..7.43 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
326. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_308_trip_id_idx on road_segments_partitioned_308 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
327. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_309_trip_id_idx on road_segments_partitioned_309 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
328. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_310_trip_id_idx on road_segments_partitioned_310 (cost=0.29..133.07 rows=134 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
329. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_311_trip_id_idx on road_segments_partitioned_311 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
330. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_312_trip_id_idx on road_segments_partitioned_312 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
331. 0.000 0.000 ↓ 0.0 0 / 4

Index Only Scan using road_segments_partitioned_313_trip_id_link_id_idx on road_segments_partitioned_313 (cost=0.29..64.01 rows=64 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
332. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
333. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_315_trip_id_idx on road_segments_partitioned_315 (cost=0.42..51.49 rows=51 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
334. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_316_trip_id_idx on road_segments_partitioned_316 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
335. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_317_trip_id_idx on road_segments_partitioned_317 (cost=0.29..72.81 rows=73 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
336. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_318_trip_id_idx on road_segments_partitioned_318 (cost=0.29..232.44 rows=235 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
337. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_319_trip_id_idx on road_segments_partitioned_319 (cost=0.28..7.46 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
338. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
339. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_321_trip_id_idx on road_segments_partitioned_321 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
340. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_322_trip_id_idx on road_segments_partitioned_322 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
341. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
342. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_324_trip_id_idx on road_segments_partitioned_324 (cost=0.28..27.46 rows=27 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
343. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_325_trip_id_idx on road_segments_partitioned_325 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
344. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_326_trip_id_idx on road_segments_partitioned_326 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
345. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_327_trip_id_idx on road_segments_partitioned_327 (cost=0.42..184.44 rows=186 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
346. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_328_trip_id_idx on road_segments_partitioned_328 (cost=0.42..187.41 rows=189 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
347. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_329_trip_id_idx on road_segments_partitioned_329 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
348. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_330_trip_id_idx on road_segments_partitioned_330 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
349. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_331_trip_id_idx on road_segments_partitioned_331 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
350. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_332_trip_id_idx on road_segments_partitioned_332 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
351. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_333_trip_id_idx on road_segments_partitioned_333 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
352. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_334_trip_id_idx on road_segments_partitioned_334 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
353. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_335_trip_id_idx on road_segments_partitioned_335 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
354. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_336_trip_id_idx on road_segments_partitioned_336 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
355. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_337_trip_id_idx on road_segments_partitioned_337 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
356. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_338_trip_id_idx on road_segments_partitioned_338 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
357. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_339_trip_id_idx on road_segments_partitioned_339 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
358. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_340_trip_id_idx on road_segments_partitioned_340 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
359. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_341_trip_id_idx on road_segments_partitioned_341 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
360. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_342_trip_id_idx on road_segments_partitioned_342 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
361. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_343_trip_id_idx on road_segments_partitioned_343 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
362. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_344_trip_id_idx on road_segments_partitioned_344 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
363. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_345_trip_id_idx on road_segments_partitioned_345 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
364. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_346_trip_id_idx on road_segments_partitioned_346 (cost=0.29..20.66 rows=20 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
365. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_347_trip_id_idx on road_segments_partitioned_347 (cost=0.29..145.61 rows=147 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
366. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_348_trip_id_idx on road_segments_partitioned_348 (cost=0.29..60.06 rows=60 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
367. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
368. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_350_trip_id_idx on road_segments_partitioned_350 (cost=0.29..159.05 rows=161 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
369. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
370. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_352_trip_id_idx on road_segments_partitioned_352 (cost=0.29..59.06 rows=59 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
371. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_353_trip_id_idx on road_segments_partitioned_353 (cost=0.28..14.44 rows=14 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
372. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_354_trip_id_idx on road_segments_partitioned_354 (cost=0.28..20.51 rows=20 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
373. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_355_trip_id_idx on road_segments_partitioned_355 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
374. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_356_trip_id_idx on road_segments_partitioned_356 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
375. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_357_trip_id_idx on road_segments_partitioned_357 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
376. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_358_trip_id_idx on road_segments_partitioned_358 (cost=0.42..117.42 rows=118 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
377. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_359_trip_id_idx on road_segments_partitioned_359 (cost=0.28..7.35 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
378. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_360_trip_id_idx on road_segments_partitioned_360 (cost=0.29..157.51 rows=159 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
379. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_361_trip_id_idx on road_segments_partitioned_361 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
380. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_362_trip_id_idx on road_segments_partitioned_362 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
381. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
382. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
383. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_365_trip_id_idx on road_segments_partitioned_365 (cost=0.29..358.47 rows=362 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
384. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
385. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_367_trip_id_idx on road_segments_partitioned_367 (cost=0.29..85.71 rows=86 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
386. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_368_trip_id_idx on road_segments_partitioned_368 (cost=0.29..229.58 rows=232 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
387. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_369_trip_id_idx on road_segments_partitioned_369 (cost=0.43..353.84 rows=358 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
388. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_370_trip_id_idx on road_segments_partitioned_370 (cost=0.43..356.72 rows=360 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
389. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_371_trip_id_idx on road_segments_partitioned_371 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
390. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_372_trip_id_idx on road_segments_partitioned_372 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
391. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_373_trip_id_idx on road_segments_partitioned_373 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
392. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_374_trip_id_idx on road_segments_partitioned_374 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
393. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_375_trip_id_idx on road_segments_partitioned_375 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
394. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_376_trip_id_idx on road_segments_partitioned_376 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
395. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_377_trip_id_idx on road_segments_partitioned_377 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
396. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_378_trip_id_idx on road_segments_partitioned_378 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
397. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_379_trip_id_idx on road_segments_partitioned_379 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
398. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_380_trip_id_idx on road_segments_partitioned_380 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
399. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_381_trip_id_idx on road_segments_partitioned_381 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
400. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_382_trip_id_idx on road_segments_partitioned_382 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
401. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_383_trip_id_idx on road_segments_partitioned_383 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
402. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_384_trip_id_idx on road_segments_partitioned_384 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
403. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_385_trip_id_idx on road_segments_partitioned_385 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
404. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_386_trip_id_idx on road_segments_partitioned_386 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
405. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
406. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
407. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_389_trip_id_idx on road_segments_partitioned_389 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
408. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_390_trip_id_idx on road_segments_partitioned_390 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
409. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_391_trip_id_idx on road_segments_partitioned_391 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
410. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_392_trip_id_idx on road_segments_partitioned_392 (cost=0.29..52.12 rows=52 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
411. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
412. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_394_trip_id_idx on road_segments_partitioned_394 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
413. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_395_trip_id_idx on road_segments_partitioned_395 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
414. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_396_trip_id_idx on road_segments_partitioned_396 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
415. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_397_trip_id_idx on road_segments_partitioned_397 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
416. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_398_trip_id_idx on road_segments_partitioned_398 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
417. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_399_trip_id_idx on road_segments_partitioned_399 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
418. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_400_trip_id_idx on road_segments_partitioned_400 (cost=0.42..1,893.65 rows=1,916 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
419. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_401_trip_id_idx on road_segments_partitioned_401 (cost=0.29..469.58 rows=475 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
420. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_402_trip_id_idx on road_segments_partitioned_402 (cost=0.29..210.25 rows=213 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
421. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_403_trip_id_idx on road_segments_partitioned_403 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
422. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_404_trip_id_idx on road_segments_partitioned_404 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
423. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_405_trip_id_idx on road_segments_partitioned_405 (cost=0.29..24.48 rows=24 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
424. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_406_trip_id_idx on road_segments_partitioned_406 (cost=0.29..44.45 rows=44 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
425. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_407_trip_id_idx on road_segments_partitioned_407 (cost=0.29..125.62 rows=127 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
426. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_408_trip_id_idx on road_segments_partitioned_408 (cost=0.28..7.43 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
427. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_409_trip_id_idx on road_segments_partitioned_409 (cost=0.28..15.60 rows=15 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
428. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_410_trip_id_idx on road_segments_partitioned_410 (cost=0.29..409.07 rows=414 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
429. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_411_trip_id_idx on road_segments_partitioned_411 (cost=0.42..120.60 rows=122 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
430. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_412_trip_id_idx on road_segments_partitioned_412 (cost=0.43..279.89 rows=282 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
431. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_413_trip_id_idx on road_segments_partitioned_413 (cost=0.43..299.60 rows=302 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
432. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_414_trip_id_idx on road_segments_partitioned_414 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
433. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_415_trip_id_idx on road_segments_partitioned_415 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
434. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_416_trip_id_idx on road_segments_partitioned_416 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
435. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_417_trip_id_idx on road_segments_partitioned_417 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
436. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_418_trip_id_idx on road_segments_partitioned_418 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
437. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_419_trip_id_idx on road_segments_partitioned_419 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
438. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_420_trip_id_idx on road_segments_partitioned_420 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
439. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_421_trip_id_idx on road_segments_partitioned_421 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
440. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_422_trip_id_idx on road_segments_partitioned_422 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
441. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_423_trip_id_idx on road_segments_partitioned_423 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
442. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_424_trip_id_idx on road_segments_partitioned_424 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
443. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_425_trip_id_idx on road_segments_partitioned_425 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
444. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_426_trip_id_idx on road_segments_partitioned_426 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
445. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_427_trip_id_idx on road_segments_partitioned_427 (cost=0.29..154.66 rows=156 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
446. 0.000 0.000 ↓ 0.0 0 / 4

Index Only Scan using road_segments_partitioned_428_trip_id_link_id_idx on road_segments_partitioned_428 (cost=0.29..91.13 rows=92 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
447. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
448. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_430_trip_id_idx on road_segments_partitioned_430 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
449. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_431_trip_id_idx on road_segments_partitioned_431 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
450. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_432_trip_id_idx on road_segments_partitioned_432 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
451. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_433_trip_id_idx on road_segments_partitioned_433 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
452. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_434_trip_id_idx on road_segments_partitioned_434 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
453. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_435_trip_id_idx on road_segments_partitioned_435 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
454. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_436_trip_id_idx on road_segments_partitioned_436 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
455. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_437_trip_id_idx on road_segments_partitioned_437 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
456. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_438_trip_id_idx on road_segments_partitioned_438 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
457. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_439_trip_id_idx on road_segments_partitioned_439 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
458. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_440_trip_id_idx on road_segments_partitioned_440 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
459. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_441_trip_id_idx on road_segments_partitioned_441 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
460. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
461. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_443_trip_id_idx on road_segments_partitioned_443 (cost=0.28..7.46 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
462. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_444_trip_id_idx on road_segments_partitioned_444 (cost=0.42..527.73 rows=533 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
463. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_445_trip_id_idx on road_segments_partitioned_445 (cost=0.42..77.09 rows=77 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
464. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_446_trip_id_idx on road_segments_partitioned_446 (cost=0.42..69.19 rows=69 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
465. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_447_trip_id_idx on road_segments_partitioned_447 (cost=0.42..67.23 rows=67 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
466. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_448_trip_id_idx on road_segments_partitioned_448 (cost=0.29..568.23 rows=575 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
467. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_449_trip_id_idx on road_segments_partitioned_449 (cost=0.29..68.47 rows=69 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
468. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_450_trip_id_idx on road_segments_partitioned_450 (cost=0.28..29.08 rows=29 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
469. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_451_trip_id_idx on road_segments_partitioned_451 (cost=0.28..13.85 rows=13 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
470. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_452_trip_id_idx on road_segments_partitioned_452 (cost=0.42..44.59 rows=44 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
471. 0.000 0.000 ↓ 0.0 0 / 4

Index Only Scan using road_segments_partitioned_453_trip_id_link_id_idx on road_segments_partitioned_453 (cost=0.29..170.95 rows=173 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
472. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_454_trip_id_idx on road_segments_partitioned_454 (cost=0.43..262.29 rows=265 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
473. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_455_trip_id_idx on road_segments_partitioned_455 (cost=0.43..211.03 rows=213 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
474. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_456_trip_id_idx on road_segments_partitioned_456 (cost=0.42..191.25 rows=193 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
475. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_457_trip_id_idx on road_segments_partitioned_457 (cost=0.42..124.34 rows=125 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
476. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_458_trip_id_idx on road_segments_partitioned_458 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
477. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_459_trip_id_idx on road_segments_partitioned_459 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
478. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_460_trip_id_idx on road_segments_partitioned_460 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
479. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_461_trip_id_idx on road_segments_partitioned_461 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
480. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_462_trip_id_idx on road_segments_partitioned_462 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
481. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_463_trip_id_idx on road_segments_partitioned_463 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
482. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_464_trip_id_idx on road_segments_partitioned_464 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
483. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_465_trip_id_idx on road_segments_partitioned_465 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
484. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_466_trip_id_idx on road_segments_partitioned_466 (cost=0.28..13.38 rows=13 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
485. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_467_trip_id_idx on road_segments_partitioned_467 (cost=0.29..47.93 rows=48 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
486. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
487. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_469_trip_id_idx on road_segments_partitioned_469 (cost=0.29..119.21 rows=120 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
488. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_470_trip_id_idx on road_segments_partitioned_470 (cost=0.28..19.35 rows=19 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
489. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_471_trip_id_idx on road_segments_partitioned_471 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
490. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_472_trip_id_idx on road_segments_partitioned_472 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
491. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_473_trip_id_idx on road_segments_partitioned_473 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
492. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_474_trip_id_idx on road_segments_partitioned_474 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
493. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_475_trip_id_idx on road_segments_partitioned_475 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
494. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_476_trip_id_idx on road_segments_partitioned_476 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
495. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_477_trip_id_idx on road_segments_partitioned_477 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
496. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_478_trip_id_idx on road_segments_partitioned_478 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
497. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_479_trip_id_idx on road_segments_partitioned_479 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
498. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_480_trip_id_idx on road_segments_partitioned_480 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
499. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_481_trip_id_idx on road_segments_partitioned_481 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
500. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_482_trip_id_idx on road_segments_partitioned_482 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
501. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_483_trip_id_idx on road_segments_partitioned_483 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
502. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_484_trip_id_idx on road_segments_partitioned_484 (cost=0.42..126.27 rows=127 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
503. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_485_trip_id_idx on road_segments_partitioned_485 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
504. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_486_trip_id_idx on road_segments_partitioned_486 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
505. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_487_trip_id_idx on road_segments_partitioned_487 (cost=0.28..7.46 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
506. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_488_trip_id_idx on road_segments_partitioned_488 (cost=0.28..10.66 rows=10 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
507. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_489_trip_id_idx on road_segments_partitioned_489 (cost=0.42..108.60 rows=109 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
508. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_490_trip_id_idx on road_segments_partitioned_490 (cost=0.42..236.64 rows=239 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
509. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_491_trip_id_idx on road_segments_partitioned_491 (cost=0.42..135.13 rows=136 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
510. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_492_trip_id_idx on road_segments_partitioned_492 (cost=0.42..46.58 rows=46 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
511. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_493_trip_id_idx on road_segments_partitioned_493 (cost=0.42..75.09 rows=75 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
512. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_494_trip_id_idx on road_segments_partitioned_494 (cost=0.42..2,712.83 rows=2,745 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
513. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_495_trip_id_idx on road_segments_partitioned_495 (cost=0.42..111.49 rows=112 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
514. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_496_trip_id_idx on road_segments_partitioned_496 (cost=0.42..82.99 rows=83 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
515. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_497_trip_id_idx on road_segments_partitioned_497 (cost=0.42..54.48 rows=54 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
516. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_498_trip_id_idx on road_segments_partitioned_498 (cost=0.42..95.76 rows=96 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
517. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_499_trip_id_idx on road_segments_partitioned_499 (cost=0.43..628.19 rows=635 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
518. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_500_trip_id_idx on road_segments_partitioned_500 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
519. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_501_trip_id_idx on road_segments_partitioned_501 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
520. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_502_trip_id_idx on road_segments_partitioned_502 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
521. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_503_trip_id_idx on road_segments_partitioned_503 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
522. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_504_trip_id_idx on road_segments_partitioned_504 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
523. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_505_trip_id_idx on road_segments_partitioned_505 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
524. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_506_trip_id_idx on road_segments_partitioned_506 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
525. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_507_trip_id_idx on road_segments_partitioned_507 (cost=0.28..7.46 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
526. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_508_trip_id_idx on road_segments_partitioned_508 (cost=0.28..48.05 rows=48 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
527. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_509_trip_id_idx on road_segments_partitioned_509 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
528. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_510_trip_id_idx on road_segments_partitioned_510 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
529. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_511_trip_id_idx on road_segments_partitioned_511 (cost=0.29..69.80 rows=70 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
530. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_512_trip_id_idx on road_segments_partitioned_512 (cost=0.28..33.43 rows=33 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
531. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_513_trip_id_idx on road_segments_partitioned_513 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
532. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_514_trip_id_idx on road_segments_partitioned_514 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
533. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_515_trip_id_idx on road_segments_partitioned_515 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
534. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_516_trip_id_idx on road_segments_partitioned_516 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
535. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_517_trip_id_idx on road_segments_partitioned_517 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
536. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_518_trip_id_idx on road_segments_partitioned_518 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
537. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_519_trip_id_idx on road_segments_partitioned_519 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
538. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_520_trip_id_idx on road_segments_partitioned_520 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
539. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_521_trip_id_idx on road_segments_partitioned_521 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
540. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_522_trip_id_idx on road_segments_partitioned_522 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
541. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_523_trip_id_idx on road_segments_partitioned_523 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
542. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_524_trip_id_idx on road_segments_partitioned_524 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
543. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_525_trip_id_idx on road_segments_partitioned_525 (cost=0.29..65.11 rows=65 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
544. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_526_trip_id_idx on road_segments_partitioned_526 (cost=0.29..59.14 rows=59 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
545. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_527_trip_id_idx on road_segments_partitioned_527 (cost=0.28..14.54 rows=14 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
546. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_528_trip_id_idx on road_segments_partitioned_528 (cost=0.28..7.46 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
547. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_529_trip_id_idx on road_segments_partitioned_529 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
548. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_530_trip_id_idx on road_segments_partitioned_530 (cost=0.28..10.79 rows=10 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
549. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
550. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_532_trip_id_idx on road_segments_partitioned_532 (cost=0.29..77.70 rows=78 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
551. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_533_trip_id_idx on road_segments_partitioned_533 (cost=0.28..15.60 rows=15 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
552. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_534_trip_id_idx on road_segments_partitioned_534 (cost=0.42..45.56 rows=45 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
553. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_535_trip_id_idx on road_segments_partitioned_535 (cost=0.42..118.47 rows=119 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
554. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_536_trip_id_idx on road_segments_partitioned_536 (cost=0.29..337.42 rows=341 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
555. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_537_trip_id_idx on road_segments_partitioned_537 (cost=0.29..21.83 rows=21 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
556. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_538_trip_id_idx on road_segments_partitioned_538 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
557. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_539_trip_id_idx on road_segments_partitioned_539 (cost=0.42..3,356.67 rows=3,396 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
558. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_540_trip_id_idx on road_segments_partitioned_540 (cost=0.42..117.42 rows=118 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
559. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_541_trip_id_idx on road_segments_partitioned_541 (cost=0.42..192.29 rows=194 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
560. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_542_trip_id_idx on road_segments_partitioned_542 (cost=0.29..37.59 rows=37 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
561. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_543_trip_id_idx on road_segments_partitioned_543 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
562. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_544_trip_id_idx on road_segments_partitioned_544 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
563. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_545_trip_id_idx on road_segments_partitioned_545 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
564. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_546_trip_id_idx on road_segments_partitioned_546 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
565. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_547_trip_id_idx on road_segments_partitioned_547 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
566. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
567. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_549_trip_id_idx on road_segments_partitioned_549 (cost=0.29..76.55 rows=77 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
568. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
569. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_551_trip_id_idx on road_segments_partitioned_551 (cost=0.28..7.35 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
570. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_552_trip_id_idx on road_segments_partitioned_552 (cost=0.28..23.13 rows=23 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
571. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_553_trip_id_idx on road_segments_partitioned_553 (cost=0.29..76.94 rows=77 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
572. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_554_trip_id_idx on road_segments_partitioned_554 (cost=0.29..56.16 rows=56 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
573. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_555_trip_id_idx on road_segments_partitioned_555 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
574. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_556_trip_id_idx on road_segments_partitioned_556 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
575. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_557_trip_id_idx on road_segments_partitioned_557 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
576. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_558_trip_id_idx on road_segments_partitioned_558 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
577. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_559_trip_id_idx on road_segments_partitioned_559 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
578. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_560_trip_id_idx on road_segments_partitioned_560 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
579. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_561_trip_id_idx on road_segments_partitioned_561 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
580. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_562_trip_id_idx on road_segments_partitioned_562 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
581. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_563_trip_id_idx on road_segments_partitioned_563 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
582. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_564_trip_id_idx on road_segments_partitioned_564 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
583. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_565_trip_id_idx on road_segments_partitioned_565 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
584. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_566_trip_id_idx on road_segments_partitioned_566 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
585. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_567_trip_id_idx on road_segments_partitioned_567 (cost=0.29..72.98 rows=73 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
586. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_568_trip_id_idx on road_segments_partitioned_568 (cost=0.29..410.21 rows=415 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
587. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_569_trip_id_idx on road_segments_partitioned_569 (cost=0.28..21.58 rows=21 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
588. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_570_trip_id_idx on road_segments_partitioned_570 (cost=0.28..13.38 rows=13 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
589. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_571_trip_id_idx on road_segments_partitioned_571 (cost=0.28..7.46 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
590. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_572_trip_id_idx on road_segments_partitioned_572 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
591. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_573_trip_id_idx on road_segments_partitioned_573 (cost=0.28..7.46 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
592. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_574_trip_id_idx on road_segments_partitioned_574 (cost=0.29..127.84 rows=129 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
593. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_575_trip_id_idx on road_segments_partitioned_575 (cost=0.28..35.03 rows=35 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
594. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_576_trip_id_idx on road_segments_partitioned_576 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
595. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_577_trip_id_idx on road_segments_partitioned_577 (cost=0.29..148.20 rows=150 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
596. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_578_trip_id_idx on road_segments_partitioned_578 (cost=0.42..142.11 rows=143 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
597. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_579_trip_id_idx on road_segments_partitioned_579 (cost=0.42..2,132.11 rows=2,158 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
598. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_580_trip_id_idx on road_segments_partitioned_580 (cost=0.28..10.66 rows=10 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
599. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_581_trip_id_idx on road_segments_partitioned_581 (cost=0.42..47.55 rows=47 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
600. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_582_trip_id_idx on road_segments_partitioned_582 (cost=0.43..185.35 rows=187 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
601. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
602. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_584_trip_id_idx on road_segments_partitioned_584 (cost=0.42..198.16 rows=200 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
603. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_585_trip_id_idx on road_segments_partitioned_585 (cost=0.42..186.43 rows=188 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
604. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_586_trip_id_idx on road_segments_partitioned_586 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
605. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_587_trip_id_idx on road_segments_partitioned_587 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
606. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_588_trip_id_idx on road_segments_partitioned_588 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
607. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_589_trip_id_idx on road_segments_partitioned_589 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
608. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_590_trip_id_idx on road_segments_partitioned_590 (cost=0.29..79.48 rows=80 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
609. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_591_trip_id_idx on road_segments_partitioned_591 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
610. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_592_trip_id_idx on road_segments_partitioned_592 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
611. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_593_trip_id_idx on road_segments_partitioned_593 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
612. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_594_trip_id_idx on road_segments_partitioned_594 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
613. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_595_trip_id_idx on road_segments_partitioned_595 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
614. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_596_trip_id_idx on road_segments_partitioned_596 (cost=0.29..96.55 rows=97 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
615. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_597_trip_id_idx on road_segments_partitioned_597 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
616. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_598_trip_id_idx on road_segments_partitioned_598 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
617. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_599_trip_id_idx on road_segments_partitioned_599 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
618. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_600_trip_id_idx on road_segments_partitioned_600 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
619. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_601_trip_id_idx on road_segments_partitioned_601 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
620. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_602_trip_id_idx on road_segments_partitioned_602 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
621. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_603_trip_id_idx on road_segments_partitioned_603 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
622. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_604_trip_id_idx on road_segments_partitioned_604 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
623. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_605_trip_id_idx on road_segments_partitioned_605 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
624. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_606_trip_id_idx on road_segments_partitioned_606 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
625. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_607_trip_id_idx on road_segments_partitioned_607 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
626. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_608_trip_id_idx on road_segments_partitioned_608 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
627. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_609_trip_id_idx on road_segments_partitioned_609 (cost=0.29..386.02 rows=390 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
628. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_610_trip_id_idx on road_segments_partitioned_610 (cost=0.42..242.47 rows=245 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
629. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_611_trip_id_idx on road_segments_partitioned_611 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
630. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_612_trip_id_idx on road_segments_partitioned_612 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
631. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_613_trip_id_idx on road_segments_partitioned_613 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
632. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_614_trip_id_idx on road_segments_partitioned_614 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
633. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_615_trip_id_idx on road_segments_partitioned_615 (cost=0.28..23.13 rows=23 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
634. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_616_trip_id_idx on road_segments_partitioned_616 (cost=0.29..41.00 rows=41 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
635. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_617_trip_id_idx on road_segments_partitioned_617 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
636. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_618_trip_id_idx on road_segments_partitioned_618 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
637. 0.000 0.000 ↓ 0.0 0 / 4

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) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
638. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_620_trip_id_idx on road_segments_partitioned_620 (cost=0.29..174.23 rows=176 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
639. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_621_trip_id_idx on road_segments_partitioned_621 (cost=0.43..170.69 rows=172 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
640. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_622_trip_id_idx on road_segments_partitioned_622 (cost=0.42..58.08 rows=58 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
641. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_623_trip_id_idx on road_segments_partitioned_623 (cost=0.42..101.74 rows=102 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
642. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_624_trip_id_idx on road_segments_partitioned_624 (cost=0.43..289.78 rows=293 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
643. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_625_trip_id_idx on road_segments_partitioned_625 (cost=0.42..116.50 rows=117 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
644. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_626_trip_id_idx on road_segments_partitioned_626 (cost=0.43..282.86 rows=285 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
645. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_627_trip_id_idx on road_segments_partitioned_627 (cost=0.43..365.54 rows=369 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
646. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_628_trip_id_idx on road_segments_partitioned_628 (cost=0.42..118.47 rows=119 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
647. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_629_trip_id_idx on road_segments_partitioned_629 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
648. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_630_trip_id_idx on road_segments_partitioned_630 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
649. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_631_trip_id_idx on road_segments_partitioned_631 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
650. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_632_trip_id_idx on road_segments_partitioned_632 (cost=0.29..90.65 rows=91 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
651. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_633_trip_id_idx on road_segments_partitioned_633 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
652. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_634_trip_id_idx on road_segments_partitioned_634 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
653. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_635_trip_id_idx on road_segments_partitioned_635 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
654. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_636_trip_id_idx on road_segments_partitioned_636 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
655. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_637_trip_id_idx on road_segments_partitioned_637 (cost=0.29..29.69 rows=29 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
656. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_638_trip_id_idx on road_segments_partitioned_638 (cost=0.28..39.36 rows=39 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
657. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_639_trip_id_idx on road_segments_partitioned_639 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
658. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_640_trip_id_idx on road_segments_partitioned_640 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
659. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_641_trip_id_idx on road_segments_partitioned_641 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
660. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_642_trip_id_idx on road_segments_partitioned_642 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
661. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_643_trip_id_idx on road_segments_partitioned_643 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
662. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_644_trip_id_idx on road_segments_partitioned_644 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
663. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_645_trip_id_idx on road_segments_partitioned_645 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
664. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Heap Scan on road_segments_partitioned_646 (cost=1.21..11.31 rows=40 width=16) (never executed)

  • Recheck Cond: (trip_id = road_movements.trip_id)
665. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Index Scan on road_segments_partitioned_646_trip_id_idx (cost=0.00..1.20 rows=40 width=0) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
666. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_647_trip_id_idx on road_segments_partitioned_647 (cost=0.28..7.46 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
667. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_648_trip_id_idx on road_segments_partitioned_648 (cost=0.28..7.35 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
668. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_649_trip_id_idx on road_segments_partitioned_649 (cost=0.28..12.33 rows=12 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
669. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Heap Scan on road_segments_partitioned_650 (cost=1.38..39.37 rows=78 width=16) (never executed)

  • Recheck Cond: (trip_id = road_movements.trip_id)
670. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Index Scan on road_segments_partitioned_650_trip_id_idx (cost=0.00..1.36 rows=78 width=0) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
671. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_651_trip_id_idx on road_segments_partitioned_651 (cost=0.42..129.18 rows=130 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
672. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_652_trip_id_idx on road_segments_partitioned_652 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
673. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_653_trip_id_idx on road_segments_partitioned_653 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
674. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_654_trip_id_idx on road_segments_partitioned_654 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
675. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_655_trip_id_idx on road_segments_partitioned_655 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
676. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_656_trip_id_idx on road_segments_partitioned_656 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
677. 0.000 0.000 ↓ 0.0 0 / 4

Index Only Scan using road_segments_partitioned_657_trip_id_link_id_idx on road_segments_partitioned_657 (cost=0.28..8.59 rows=8 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
678. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_658_trip_id_idx on road_segments_partitioned_658 (cost=0.28..40.90 rows=41 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
679. 0.000 0.000 ↓ 0.0 0 / 4

Index Only Scan using road_segments_partitioned_659_trip_id_link_id_idx on road_segments_partitioned_659 (cost=0.28..24.27 rows=24 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
680. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_660_trip_id_idx on road_segments_partitioned_660 (cost=0.28..27.46 rows=27 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
681. 0.000 0.000 ↓ 0.0 0 / 4

Index Only Scan using road_segments_partitioned_661_trip_id_link_id_idx on road_segments_partitioned_661 (cost=0.29..108.91 rows=110 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
682. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_662_trip_id_idx on road_segments_partitioned_662 (cost=0.28..13.38 rows=13 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
683. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_663_trip_id_idx on road_segments_partitioned_663 (cost=0.28..33.50 rows=33 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
684. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_664_trip_id_idx on road_segments_partitioned_664 (cost=0.42..119.47 rows=120 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
685. 0.000 0.000 ↓ 0.0 0 / 4

Index Only Scan using road_segments_partitioned_665_trip_id_link_id_idx on road_segments_partitioned_665 (cost=0.42..26.89 rows=26 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
686. 0.000 0.000 ↓ 0.0 0 / 4

Index Only Scan using road_segments_partitioned_666_trip_id_link_id_idx on road_segments_partitioned_666 (cost=0.28..8.59 rows=8 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
687. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_667_trip_id_idx on road_segments_partitioned_667 (cost=0.42..143.09 rows=144 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
688. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_668_trip_id_idx on road_segments_partitioned_668 (cost=0.42..135.21 rows=136 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
689. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_669_trip_id_idx on road_segments_partitioned_669 (cost=0.42..232.65 rows=235 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
690. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_670_trip_id_idx on road_segments_partitioned_670 (cost=0.43..423.75 rows=428 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
691. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_671_trip_id_idx on road_segments_partitioned_671 (cost=0.42..147.99 rows=149 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
692. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_672_trip_id_idx on road_segments_partitioned_672 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
693. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_673_trip_id_idx on road_segments_partitioned_673 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
694. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_674_trip_id_idx on road_segments_partitioned_674 (cost=0.29..166.06 rows=168 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
695. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_675_trip_id_idx on road_segments_partitioned_675 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
696. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_676_trip_id_idx on road_segments_partitioned_676 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
697. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_677_trip_id_idx on road_segments_partitioned_677 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
698. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_678_trip_id_idx on road_segments_partitioned_678 (cost=0.15..6.97 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
699. 0.000 0.000 ↓ 0.0 0 / 4

Index Only Scan using road_segments_partitioned_679_trip_id_link_id_idx on road_segments_partitioned_679 (cost=0.29..137.45 rows=139 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
  • Heap Fetches: 0
700. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_680_trip_id_idx on road_segments_partitioned_680 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
701. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_681_trip_id_idx on road_segments_partitioned_681 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
702. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_682_trip_id_idx on road_segments_partitioned_682 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
703. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_683_trip_id_idx on road_segments_partitioned_683 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
704. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_684_trip_id_idx on road_segments_partitioned_684 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
705. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_685_trip_id_idx on road_segments_partitioned_685 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
706. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_686_trip_id_idx on road_segments_partitioned_686 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
707. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Heap Scan on road_segments_partitioned_687 (cost=1.30..18.16 rows=67 width=16) (never executed)

  • Recheck Cond: (trip_id = road_movements.trip_id)
708. 0.000 0.000 ↓ 0.0 0 / 4

Bitmap Index Scan on road_segments_partitioned_687_trip_id_link_id_idx (cost=0.00..1.28 rows=67 width=0) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
709. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_688_trip_id_idx on road_segments_partitioned_688 (cost=0.15..6.47 rows=7 width=16) (never executed)

  • Index Cond: (trip_id = road_movements.trip_id)
710. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using road_segments_partitioned_689_trip_id_idx on road_segments_partitioned_689 (cost=0.15..6