explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3tJw

Settings
# exclusive inclusive rows x rows loops node
1. 31.336 116,538.422 ↑ 1.0 1 1

Aggregate (cost=124,150,650.65..124,150,650.75 rows=1 width=32) (actual time=116,538.422..116,538.422 rows=1 loops=1)

  • Functions: 6987
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 650.613 ms, Inlining 69.660 ms, Optimization 44450.012 ms, Emission 29583.891 ms, Total 74754.175 ms
2. 5.063 116,507.086 ↑ 1.8 3,432 1

Subquery Scan on q (cost=124,140,662.32..124,150,632.72 rows=6,171 width=52) (actual time=102,302.123..116,507.086 rows=3,432 loops=1)

3. 13,901.431 116,502.023 ↑ 1.8 3,432 1

GroupAggregate (cost=124,140,662.32..124,150,015.62 rows=6,171 width=248) (actual time=102,302.105..116,502.023 rows=3,432 loops=1)

  • Group Key: v_transit_roads_partitioned.link_id, v_transit_roads_partitioned.street_name, v_transit_roads_partitioned.road_speed, v_transit_roads_partitioned.road_rank, v_transit_roads_partitioned.truck, v_transit_roads_partitioned.surface, v_transit_roads_partitioned.road_km, v_transit_roads_partitioned.geometry
4. 6,339.715 102,600.592 ↓ 22.9 3,493,140 1

Sort (cost=124,140,662.32..124,141,044.00 rows=152,669 width=208) (actual time=102,301.992..102,600.592 rows=3,493,140 loops=1)

  • Sort Key: v_transit_roads_partitioned.link_id, v_transit_roads_partitioned.street_name, v_transit_roads_partitioned.road_speed, v_transit_roads_partitioned.road_rank, v_transit_roads_partitioned.truck, v_transit_roads_partitioned.surface, v_transit_roads_partitioned.road_km, v_transit_roads_partitioned.geometry
  • Sort Method: quicksort Memory: 1141224kB
5. 1,216.352 96,260.877 ↓ 22.9 3,493,140 1

Nested Loop (cost=1.14..124,127,517.49 rows=152,669 width=208) (actual time=74,162.539..96,260.877 rows=3,493,140 loops=1)

6. 982.006 84,565.105 ↓ 22.9 3,493,140 1

Nested Loop (cost=0.72..123,777,749.75 rows=152,669 width=192) (actual time=74,160.368..84,565.105 rows=3,493,140 loops=1)

7. 74,134.305 74,574.099 ↓ 15.3 3,432 1

Nested Loop (cost=0.57..54.87 rows=224 width=184) (actual time=74,157.921..74,574.099 rows=3,432 loops=1)

8. 1.354 1.354 ↑ 1.0 1 1

Index Scan using idx_v_transit_boundaries_code on v_transit_boundaries (cost=0.28..2.38 rows=1 width=78,632) (actual time=1.352..1.354 rows=1 loops=1)

  • Index Cond: (code = ANY ('{LGA_34580}'::text[]))
9. 438.440 438.440 ↓ 3,432.0 3,432 1

Index Scan using v_transit_roads_geometry_geom_idx_partitioned on v_transit_roads_partitioned (cost=0.29..52.39 rows=1 width=184) (actual time=24.769..438.440 rows=3,432 loops=1)

  • Index Cond: ((geometry && v_transit_boundaries.geometry) AND (geometry && '0103000020110F000001000000050000003D0A977A991F7041CDCCCC56F6E247C13D0A977A991F7041EC51F818D67B48C1E17ADC72B5327041EC51F818D67B48C1E17ADC72B5327041CDCCCC56F6E247C13D0A977A991F7041CDCCCC56F6E247C1'::geometry))
  • Filter: (st_intersects(geometry, '0103000020110F000001000000050000003D0A977A991F7041CDCCCC56F6E247C13D0A977A991F7041EC51F818D67B48C1E17ADC72B5327041EC51F818D67B48C1E17ADC72B5327041CDCCCC56F6E247C13D0A977A991F7041CDCCCC56F6E247C1'::geometry) AND st_intersects(geometry, v_transit_boundaries.geometry))
  • Rows Removed by Filter: 1564
10. 334.794 9,009.000 ↑ 502.0 1,018 3,432

Append (cost=0.15..501,473.79 rows=511,052 width=16) (actual time=0.449..2.625 rows=1,018 loops=3,432)

11. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
12. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
13. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
14. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
15. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
16. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
17. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
18. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
19. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
20. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
21. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
22. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
23. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
24. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
25. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
26. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
27. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
28. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
29. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
30. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
31. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
32. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
33. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
34. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
35. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
36. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
37. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
38. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
39. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
40. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
41. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
42. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
43. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
44. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
45. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
46. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
47. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
48. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
49. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
50. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
51. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
52. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
53. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
54. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
55. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
56. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
57. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
58. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
59. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
60. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
61. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
62. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
63. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
64. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
65. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
66. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
67. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
68. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
69. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
70. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
71. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
72. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
73. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
74. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
75. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
76. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
77. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
78. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
79. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
80. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
81. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
82. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
83. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
84. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
85. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
86. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
87. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
88. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
89. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
90. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
91. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
92. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
93. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
94. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
95. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
96. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
97. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
98. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
99. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
100. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
101. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
102. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
103. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
104. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
105. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
106. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
107. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
108. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
109. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
110. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
111. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
112. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
113. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
114. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_103_link_id_idx on road_segments_partitioned_103 (cost=0.42..289.59 rows=292 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
115. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
116. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
117. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
118. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_107_link_id_trip_id_idx on road_segments_partitioned_107 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
119. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
120. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
121. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
122. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
123. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
124. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
125. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
126. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
127. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
128. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
129. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
130. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
131. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
132. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
133. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
134. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
135. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
136. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
137. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
138. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
139. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
140. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
141. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
142. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
143. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
144. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
145. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
146. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
147. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
148. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
149. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
150. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
151. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
152. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
153. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
154. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
155. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_144 (cost=0.66..3.28 rows=6 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
156. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_144_link_id_idx (cost=0.00..0.66 rows=6 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
157. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_145_link_id_idx on road_segments_partitioned_145 (cost=0.42..1,087.58 rows=1,102 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
158. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_146_link_id_idx on road_segments_partitioned_146 (cost=0.29..37.47 rows=37 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
159. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
160. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
161. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
162. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_150_link_id_trip_id_idx on road_segments_partitioned_150 (cost=0.28..7.38 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
163. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
164. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
165. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
166. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
167. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
168. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_156_link_id_idx on road_segments_partitioned_156 (cost=0.28..6.69 rows=6 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
169. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
170. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
171. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
172. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
173. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
174. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
175. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
176. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
177. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
178. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
179. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
180. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
181. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
182. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
183. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
184. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
185. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
186. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
187. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
188. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
189. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
190. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
191. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
192. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
193. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
194. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
195. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
196. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
197. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
198. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
199. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
200. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_188_link_id_idx on road_segments_partitioned_188 (cost=0.43..1,852.88 rows=1,876 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
201. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
202. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_190_link_id_idx on road_segments_partitioned_190 (cost=0.29..89.52 rows=90 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
203. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
204. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
205. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
206. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
207. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
208. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
209. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
210. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
211. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_199 (cost=1.20..23.86 rows=26 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
212. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_199_link_id_trip_id_idx (cost=0.00..1.19 rows=26 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
213. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
214. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
215. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
216. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
217. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
218. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
219. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
220. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
221. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
222. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
223. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
224. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
225. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
226. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
227. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
228. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
229. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
230. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
231. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
232. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
233. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
234. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
235. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
236. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
237. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
238. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
239. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_226_link_id_trip_id_idx on road_segments_partitioned_226 (cost=0.28..7.38 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
240. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
241. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
242. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_229_link_id_trip_id_idx on road_segments_partitioned_229 (cost=0.29..62.52 rows=63 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
243. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_230_link_id_idx on road_segments_partitioned_230 (cost=0.42..696.38 rows=706 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
244. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_231_link_id_idx on road_segments_partitioned_231 (cost=0.42..1,592.79 rows=1,634 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
245. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
246. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
247. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
248. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
249. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
250. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
251. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
252. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
253. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_240_link_id_idx on road_segments_partitioned_240 (cost=0.28..10.66 rows=10 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
254. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
255. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
256. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_243_link_id_idx on road_segments_partitioned_243 (cost=0.28..29.17 rows=29 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
257. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
258. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
259. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
260. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
261. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
262. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
263. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
264. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
265. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
266. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
267. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
268. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
269. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
270. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
271. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
272. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
273. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
274. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
275. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
276. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
277. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
278. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
279. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
280. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
281. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_268_link_id_idx on road_segments_partitioned_268 (cost=0.29..249.73 rows=253 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
282. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_269_link_id_idx on road_segments_partitioned_269 (cost=0.42..421.49 rows=426 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
283. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_270_link_id_idx on road_segments_partitioned_270 (cost=0.42..1,035.17 rows=1,054 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
284. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_271_link_id_idx on road_segments_partitioned_271 (cost=0.42..590.60 rows=602 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
285. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_272_link_id_idx on road_segments_partitioned_272 (cost=0.28..34.56 rows=34 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
286. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_273_link_id_idx on road_segments_partitioned_273 (cost=0.42..1,704.13 rows=1,726 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
287. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
288. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
289. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
290. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
291. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
292. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
293. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
294. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
295. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
296. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
297. 0.000 0.000 ↓ 0.0 0

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

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
298. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_284_link_id_idx (cost=0.00..1.21 rows=27 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
299. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_285_link_id_idx on road_segments_partitioned_285 (cost=0.29..42.40 rows=42 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
300. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
301. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
302. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
303. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
304. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
305. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
306. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
307. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
308. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
309. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
310. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
311. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
312. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
313. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
314. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
315. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
316. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
317. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
318. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
319. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
320. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
321. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
322. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
323. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
324. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_310_link_id_idx on road_segments_partitioned_310 (cost=0.29..424.62 rows=434 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
325. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
326. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
327. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_313 (cost=1.65..108.12 rows=151 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
328. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_313_link_id_idx (cost=0.00..1.61 rows=151 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
329. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_314_link_id_trip_id_idx on road_segments_partitioned_314 (cost=0.29..87.31 rows=88 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
330. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_315 (cost=12.56..1,301.04 rows=2,112 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
331. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_315_link_id_idx (cost=0.00..12.03 rows=2,112 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
332. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
333. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
334. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
335. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_319_link_id_trip_id_idx on road_segments_partitioned_319 (cost=0.28..7.42 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
336. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_320_link_id_trip_id_idx on road_segments_partitioned_320 (cost=0.28..7.56 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
337. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
338. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
339. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_323_link_id_trip_id_idx on road_segments_partitioned_323 (cost=0.28..18.22 rows=18 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
340. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
341. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
342. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
343. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_327_link_id_idx on road_segments_partitioned_327 (cost=0.42..610.66 rows=618 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
344. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_328_link_id_idx on road_segments_partitioned_328 (cost=0.42..450.56 rows=458 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
345. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
346. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
347. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
348. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
349. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
350. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
351. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
352. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
353. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
354. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
355. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
356. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
357. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
358. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
359. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
360. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
361. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
362. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_346_link_id_idx on road_segments_partitioned_346 (cost=0.29..57.66 rows=58 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
363. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
364. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_348 (cost=3.14..309.58 rows=336 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
365. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_348_link_id_idx (cost=0.00..3.05 rows=336 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
366. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_349_link_id_idx on road_segments_partitioned_349 (cost=0.29..100.28 rows=101 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
367. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
368. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_351_link_id_trip_id_idx on road_segments_partitioned_351 (cost=0.28..15.62 rows=15 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
369. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_352_link_id_idx on road_segments_partitioned_352 (cost=0.29..296.08 rows=309 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
370. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
371. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_354_link_id_trip_id_idx on road_segments_partitioned_354 (cost=0.28..20.54 rows=20 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
372. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
373. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
374. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
375. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_358_link_id_idx on road_segments_partitioned_358 (cost=0.42..2,156.90 rows=2,186 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
376. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
377. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
378. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
379. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
380. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_363_link_id_idx on road_segments_partitioned_363 (cost=0.29..47.94 rows=48 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
381. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_364_link_id_trip_id_idx on road_segments_partitioned_364 (cost=0.28..7.53 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
382. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
383. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_366_link_id_idx on road_segments_partitioned_366 (cost=0.29..143.92 rows=154 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
384. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_367_link_id_idx on road_segments_partitioned_367 (cost=0.29..147.52 rows=150 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
385. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_368_link_id_idx on road_segments_partitioned_368 (cost=0.29..276.45 rows=280 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
386. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_369_link_id_idx on road_segments_partitioned_369 (cost=0.43..3,324.48 rows=3,378 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
387. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_370_link_id_idx on road_segments_partitioned_370 (cost=0.43..1,701.36 rows=1,729 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
388. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
389. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
390. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
391. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
392. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
393. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
394. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
395. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
396. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
397. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
398. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
399. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
400. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
401. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
402. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
403. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
404. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_387_link_id_trip_id_idx on road_segments_partitioned_387 (cost=0.28..7.54 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
405. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_388_link_id_trip_id_idx on road_segments_partitioned_388 (cost=0.29..98.15 rows=99 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
406. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
407. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
408. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
409. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_392 (cost=4.51..241.63 rows=489 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
410. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_392_link_id_idx (cost=0.00..4.39 rows=489 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
411. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_393 (cost=3.11..204.94 rows=330 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
412. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_393_link_id_idx (cost=0.00..3.03 rows=330 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
413. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
414. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
415. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
416. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
417. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
418. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
419. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_400_link_id_idx on road_segments_partitioned_400 (cost=0.42..1,891.89 rows=1,916 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
420. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_401_link_id_idx on road_segments_partitioned_401 (cost=0.29..469.58 rows=475 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
421. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_402_link_id_idx on road_segments_partitioned_402 (cost=0.29..210.25 rows=213 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
422. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
423. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
424. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_405_link_id_idx on road_segments_partitioned_405 (cost=0.29..68.15 rows=69 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
425. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_406_link_id_idx on road_segments_partitioned_406 (cost=0.29..327.49 rows=331 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
426. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_407_link_id_idx on road_segments_partitioned_407 (cost=0.29..125.63 rows=127 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
427. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
428. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_409_link_id_idx on road_segments_partitioned_409 (cost=0.28..15.61 rows=15 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
429. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_410_link_id_idx on road_segments_partitioned_410 (cost=0.29..409.07 rows=414 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
430. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_411_link_id_idx on road_segments_partitioned_411 (cost=0.42..1,955.46 rows=1,994 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
431. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_412_link_id_idx on road_segments_partitioned_412 (cost=0.43..1,115.66 rows=1,129 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
432. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_413_link_id_idx on road_segments_partitioned_413 (cost=0.43..1,448.94 rows=1,468 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
433. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
434. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
435. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
436. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
437. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
438. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
439. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
440. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
441. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
442. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
443. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
444. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
445. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
446. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_427_link_id_idx on road_segments_partitioned_427 (cost=0.42..222.18 rows=225 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
447. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_428_link_id_idx on road_segments_partitioned_428 (cost=0.29..91.14 rows=92 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
448. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_429 (cost=4.48..184.79 rows=481 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
449. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_429_link_id_trip_id_idx (cost=0.00..4.36 rows=481 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
450. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
451. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
452. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
453. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
454. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
455. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
456. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
457. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
458. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
459. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
460. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
461. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
462. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_442_link_id_idx on road_segments_partitioned_442 (cost=0.42..1,034.29 rows=1,047 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
463. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_443_link_id_trip_id_idx on road_segments_partitioned_443 (cost=0.28..7.38 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
464. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_444_link_id_idx on road_segments_partitioned_444 (cost=0.29..526.73 rows=533 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
465. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_445 (cost=11.58..1,435.01 rows=1,809 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
466. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_445_link_id_idx (cost=0.00..11.13 rows=1,809 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
467. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_446_link_id_idx on road_segments_partitioned_446 (cost=0.42..1,236.30 rows=1,297 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
468. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_447_link_id_idx on road_segments_partitioned_447 (cost=0.42..957.70 rows=973 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
469. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_448_link_id_idx on road_segments_partitioned_448 (cost=0.42..568.36 rows=575 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
470. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_449_link_id_idx on road_segments_partitioned_449 (cost=0.29..68.47 rows=69 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
471. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
472. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_451_link_id_idx on road_segments_partitioned_451 (cost=0.28..31.95 rows=32 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
473. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_452_link_id_idx on road_segments_partitioned_452 (cost=0.42..1,075.95 rows=1,140 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
474. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_453_link_id_trip_id_idx on road_segments_partitioned_453 (cost=0.29..170.96 rows=173 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
475. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_454_link_id_idx on road_segments_partitioned_454 (cost=0.43..2,782.29 rows=2,821 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
476. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_455_link_id_idx on road_segments_partitioned_455 (cost=0.43..1,564.52 rows=1,584 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
477. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_456_link_id_idx on road_segments_partitioned_456 (cost=0.42..816.70 rows=828 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
478. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_457_link_id_idx on road_segments_partitioned_457 (cost=0.42..322.61 rows=328 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
479. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
480. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
481. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
482. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
483. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
484. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
485. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
486. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
487. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
488. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_467_link_id_idx on road_segments_partitioned_467 (cost=0.29..47.92 rows=48 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
489. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_468_link_id_trip_id_idx on road_segments_partitioned_468 (cost=0.29..88.47 rows=89 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
490. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_469_link_id_idx on road_segments_partitioned_469 (cost=0.29..119.21 rows=120 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
491. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_470_link_id_trip_id_idx on road_segments_partitioned_470 (cost=0.28..19.38 rows=19 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
492. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
493. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
494. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
495. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
496. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
497. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
498. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
499. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
500. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
501. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
502. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
503. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
504. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
505. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_484_link_id_idx on road_segments_partitioned_484 (cost=0.42..997.79 rows=1,016 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
506. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_485_link_id_trip_id_idx on road_segments_partitioned_485 (cost=0.28..7.38 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
507. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
508. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_487_link_id_trip_id_idx on road_segments_partitioned_487 (cost=0.28..7.40 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
509. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_488_link_id_idx on road_segments_partitioned_488 (cost=0.28..10.66 rows=10 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
510. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_489_link_id_idx on road_segments_partitioned_489 (cost=0.42..686.79 rows=695 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
511. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_490_link_id_idx on road_segments_partitioned_490 (cost=0.42..1,378.50 rows=1,398 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
512. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_491_link_id_idx on road_segments_partitioned_491 (cost=0.42..1,284.40 rows=1,323 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
513. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_492_link_id_idx on road_segments_partitioned_492 (cost=0.42..609.10 rows=620 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
514. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_493_link_id_idx on road_segments_partitioned_493 (cost=0.42..477.73 rows=485 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
515. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_494_link_id_idx on road_segments_partitioned_494 (cost=0.42..2,710.20 rows=2,745 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
516. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_495_link_id_idx on road_segments_partitioned_495 (cost=0.42..861.06 rows=877 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
517. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_496 (cost=24.08..3,838.43 rows=4,023 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
518. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_496_link_id_idx (cost=0.00..23.07 rows=4,023 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
519. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_497_link_id_idx on road_segments_partitioned_497 (cost=0.42..2,536.85 rows=2,580 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
520. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_498_link_id_idx on road_segments_partitioned_498 (cost=0.42..534.43 rows=542 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
521. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_499_link_id_idx on road_segments_partitioned_499 (cost=0.43..743.64 rows=752 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
522. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
523. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
524. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
525. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
526. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
527. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
528. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
529. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_507_link_id_trip_id_idx on road_segments_partitioned_507 (cost=0.28..7.38 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
530. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_508_link_id_idx on road_segments_partitioned_508 (cost=0.28..64.58 rows=65 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
531. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
532. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
533. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_511_link_id_idx on road_segments_partitioned_511 (cost=0.29..220.16 rows=227 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
534. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_512_link_id_idx on road_segments_partitioned_512 (cost=0.28..33.41 rows=33 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
535. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
536. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
537. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
538. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
539. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
540. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
541. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
542. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
543. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
544. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
545. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
546. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
547. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_525_link_id_idx on road_segments_partitioned_525 (cost=0.29..566.11 rows=578 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
548. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_526 (cost=5.32..621.66 rows=735 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
549. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_526_link_id_idx (cost=0.00..5.14 rows=735 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
550. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_527_link_id_idx on road_segments_partitioned_527 (cost=0.28..14.56 rows=14 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
551. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
552. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
553. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_530_link_id_idx on road_segments_partitioned_530 (cost=0.28..10.75 rows=10 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
554. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_531_link_id_trip_id_idx on road_segments_partitioned_531 (cost=0.28..31.20 rows=31 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
555. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_532_link_id_idx on road_segments_partitioned_532 (cost=0.29..77.70 rows=78 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
556. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_533_link_id_idx on road_segments_partitioned_533 (cost=0.28..15.61 rows=15 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
557. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_534_link_id_idx on road_segments_partitioned_534 (cost=0.42..909.26 rows=922 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
558. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_535_link_id_idx on road_segments_partitioned_535 (cost=0.42..1,130.66 rows=1,146 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
559. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_536_link_id_idx on road_segments_partitioned_536 (cost=0.29..336.54 rows=341 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
560. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_537_link_id_idx on road_segments_partitioned_537 (cost=0.29..465.78 rows=473 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
561. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
562. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_539_link_id_idx on road_segments_partitioned_539 (cost=0.42..3,353.15 rows=3,396 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
563. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_540_link_id_idx on road_segments_partitioned_540 (cost=0.42..343.31 rows=349 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
564. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_541_link_id_idx on road_segments_partitioned_541 (cost=0.42..693.27 rows=702 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
565. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_542_link_id_idx on road_segments_partitioned_542 (cost=0.29..297.16 rows=316 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
566. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
567. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
568. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
569. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
570. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
571. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_548_link_id_trip_id_idx on road_segments_partitioned_548 (cost=0.28..7.54 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
572. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_549_link_id_idx on road_segments_partitioned_549 (cost=0.29..76.55 rows=77 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
573. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_550_link_id_idx on road_segments_partitioned_550 (cost=0.28..8.55 rows=8 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
574. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
575. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_552_link_id_idx on road_segments_partitioned_552 (cost=0.28..23.10 rows=23 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
576. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_553_link_id_idx on road_segments_partitioned_553 (cost=0.29..305.23 rows=309 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
577. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_554_link_id_idx on road_segments_partitioned_554 (cost=0.29..137.89 rows=139 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
578. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
579. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
580. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
581. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
582. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
583. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
584. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
585. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
586. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
587. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
588. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
589. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
590. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_567_link_id_idx on road_segments_partitioned_567 (cost=0.29..733.22 rows=751 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
591. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_568_link_id_idx on road_segments_partitioned_568 (cost=0.29..410.22 rows=415 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
592. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_569_link_id_idx on road_segments_partitioned_569 (cost=0.28..21.58 rows=21 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
593. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
594. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_571_link_id_trip_id_idx on road_segments_partitioned_571 (cost=0.28..7.38 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
595. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
596. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
597. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_574_link_id_idx on road_segments_partitioned_574 (cost=0.29..127.83 rows=129 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
598. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_575_link_id_idx on road_segments_partitioned_575 (cost=0.28..35.03 rows=35 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
599. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
600. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_577_link_id_idx on road_segments_partitioned_577 (cost=0.29..148.21 rows=150 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
601. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_578_link_id_idx on road_segments_partitioned_578 (cost=0.42..1,578.51 rows=1,599 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
602. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_579_link_id_idx on road_segments_partitioned_579 (cost=0.42..2,131.23 rows=2,158 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
603. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_580_link_id_idx on road_segments_partitioned_580 (cost=0.28..10.75 rows=10 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
604. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_581_link_id_idx on road_segments_partitioned_581 (cost=0.42..1,177.67 rows=1,194 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
605. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_582_link_id_idx on road_segments_partitioned_582 (cost=0.43..2,367.69 rows=2,398 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
606. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_583_link_id_trip_id_idx on road_segments_partitioned_583 (cost=0.29..148.29 rows=150 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
607. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_584_link_id_idx on road_segments_partitioned_584 (cost=0.42..842.54 rows=854 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
608. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_585_link_id_idx on road_segments_partitioned_585 (cost=0.42..663.38 rows=671 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
609. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
610. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
611. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
612. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
613. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_590 (cost=1.54..102.64 rows=118 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
614. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_590_link_id_trip_id_idx (cost=0.00..1.51 rows=118 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
615. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
616. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
617. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
618. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
619. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
620. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_596_link_id_idx on road_segments_partitioned_596 (cost=0.29..96.54 rows=97 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
621. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
622. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
623. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
624. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
625. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
626. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
627. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
628. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
629. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
630. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
631. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
632. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
633. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_609_link_id_idx on road_segments_partitioned_609 (cost=0.29..386.02 rows=390 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
634. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_610_link_id_idx on road_segments_partitioned_610 (cost=0.42..516.91 rows=523 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
635. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
636. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
637. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
638. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
639. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_615_link_id_trip_id_idx on road_segments_partitioned_615 (cost=0.28..23.12 rows=23 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
640. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_616_link_id_idx on road_segments_partitioned_616 (cost=0.29..40.98 rows=41 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
641. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
642. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
643. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_619_link_id_trip_id_idx on road_segments_partitioned_619 (cost=0.28..32.35 rows=32 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
644. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_620_link_id_idx on road_segments_partitioned_620 (cost=0.29..174.23 rows=176 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
645. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_621_link_id_idx on road_segments_partitioned_621 (cost=0.43..2,775.94 rows=2,816 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
646. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_622_link_id_idx on road_segments_partitioned_622 (cost=0.42..1,322.07 rows=1,339 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
647. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_623_link_id_idx on road_segments_partitioned_623 (cost=0.42..1,412.89 rows=1,446 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
648. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_624_link_id_idx on road_segments_partitioned_624 (cost=0.43..2,756.31 rows=2,792 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
649. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_625_link_id_idx on road_segments_partitioned_625 (cost=0.42..1,350.64 rows=1,377 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
650. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_626_link_id_idx on road_segments_partitioned_626 (cost=0.43..939.22 rows=951 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
651. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_627_link_id_idx on road_segments_partitioned_627 (cost=0.43..659.99 rows=668 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
652. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_628_link_id_idx on road_segments_partitioned_628 (cost=0.42..850.02 rows=884 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
653. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
654. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
655. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
656. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_632_link_id_idx on road_segments_partitioned_632 (cost=0.29..201.61 rows=204 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
657. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
658. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
659. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
660. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
661. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_637 (cost=4.67..178.94 rows=549 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
662. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_637_link_id_idx (cost=0.00..4.53 rows=549 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
663. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_638_link_id_idx on road_segments_partitioned_638 (cost=0.28..39.38 rows=39 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
664. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
665. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
666. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
667. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
668. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
669. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
670. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
671. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_segments_partitioned_646 (cost=1.17..9.22 rows=20 width=16) (never executed)

  • Recheck Cond: (link_id = v_transit_roads_partitioned.link_id)
672. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on road_segments_partitioned_646_link_id_idx (cost=0.00..1.17 rows=20 width=0) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
673. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_647_link_id_trip_id_idx on road_segments_partitioned_647 (cost=0.28..7.42 rows=7 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
674. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
675. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_649_link_id_idx on road_segments_partitioned_649 (cost=0.28..12.32 rows=12 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
676. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_650_link_id_idx on road_segments_partitioned_650 (cost=0.28..25.33 rows=25 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
677. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_651_link_id_idx on road_segments_partitioned_651 (cost=0.42..636.42 rows=644 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
678. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
679. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
680. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
681. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
682. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
683. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_657_link_id_trip_id_idx on road_segments_partitioned_657 (cost=0.28..8.60 rows=8 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
684. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_658_link_id_idx on road_segments_partitioned_658 (cost=0.28..40.91 rows=41 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
685. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_659_link_id_trip_id_idx on road_segments_partitioned_659 (cost=0.28..24.27 rows=24 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
686. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_660_link_id_idx on road_segments_partitioned_660 (cost=0.28..27.47 rows=27 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
687. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_661_link_id_idx on road_segments_partitioned_661 (cost=0.29..108.91 rows=110 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
688. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
689. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_663_link_id_idx on road_segments_partitioned_663 (cost=0.28..33.49 rows=33 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
690. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_664_link_id_idx on road_segments_partitioned_664 (cost=0.42..3,637.83 rows=3,688 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
691. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_665_link_id_idx on road_segments_partitioned_665 (cost=0.42..1,698.94 rows=1,906 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
692. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_666_link_id_trip_id_idx on road_segments_partitioned_666 (cost=0.28..8.60 rows=8 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
693. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_667_link_id_idx on road_segments_partitioned_667 (cost=0.42..1,718.23 rows=1,742 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
694. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_668_link_id_idx on road_segments_partitioned_668 (cost=0.42..1,080.46 rows=1,094 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
695. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_669_link_id_idx on road_segments_partitioned_669 (cost=0.42..323.90 rows=327 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
696. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_670_link_id_idx on road_segments_partitioned_670 (cost=0.43..1,343.12 rows=1,360 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
697. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_671_link_id_idx on road_segments_partitioned_671 (cost=0.42..1,905.16 rows=1,933 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
698. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
699. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
700. 0.000 0.000 ↓ 0.0 0

Index Scan using road_segments_partitioned_674_link_id_idx on road_segments_partitioned_674 (cost=0.29..166.07 rows=168 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
701. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
702. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
703. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
704. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
705. 0.000 0.000 ↓ 0.0 0

Index Only Scan using road_segments_partitioned_679_link_id_trip_id_idx on road_segments_partitioned_679 (cost=0.29..137.45 rows=139 width=16) (never executed)

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
  • Heap Fetches: 0
706. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
707. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
708. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
709. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)
710. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (link_id = v_transit_roads_partitioned.link_id)