explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 56mm

Settings
# exclusive inclusive rows x rows loops node
1. 30.944 350,924.834 ↑ 1.0 1 1

Aggregate (cost=96,247,828.13..96,247,828.23 rows=1 width=32) (actual time=350,924.834..350,924.834 rows=1 loops=1)

  • Functions: 2884
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 324.289 ms, Inlining 63.744 ms, Optimization 21398.448 ms, Emission 14115.738 ms, Total 35902.219 ms"Execution Time: 351337.323 ms
2. 4.621 350,893.890 ↑ 1.8 3,432 1

Subquery Scan on q (cost=96,237,839.80..96,247,810.20 rows=6,171 width=52) (actual time=335,956.258..350,893.890 rows=3,432 loops=1)

3. 14,277.218 350,889.269 ↑ 1.8 3,432 1

GroupAggregate (cost=96,237,839.80..96,247,193.10 rows=6,171 width=248) (actual time=335,956.243..350,889.269 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. 5,729.577 336,612.051 ↓ 22.9 3,493,140 1

Sort (cost=96,237,839.80..96,238,221.47 rows=152,669 width=208) (actual time=335,956.130..336,612.051 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. 2,827.478 330,882.474 ↓ 22.9 3,493,140 1

Nested Loop (cost=78.26..96,224,694.96 rows=152,669 width=208) (actual time=71,905.605..330,882.474 rows=3,493,140 loops=1)

6. 49,753.914 321,068.716 ↓ 22.9 3,493,140 1

Hash Join (cost=77.83..95,874,927.22 rows=152,669 width=192) (actual time=71,905.557..321,068.716 rows=3,493,140 loops=1)

  • Hash Cond: (road_segments_partitioned_0.link_id = v_transit_roads_partitioned.link_id)
7. 41,398.420 271,135.943 ↑ 1.0 593,771,497 1

Append (cost=0.00..93,628,225.60 rows=595,019,544 width=16) (actual time=35,597.971..271,135.943 rows=593,771,497 loops=1)

8. 0.046 0.046 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_0 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.046..0.046 rows=0 loops=1)

9. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_1 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

10. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_2 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

11. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_3 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

12. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_4 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

13. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_5 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

14. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_6 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

15. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_7 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

16. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_8 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

17. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_9 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

18. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_10 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

19. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_11 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

20. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_12 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

21. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_13 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

22. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_14 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

23. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_15 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

24. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_16 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

25. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_17 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

26. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_18 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

27. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_19 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

28. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_20 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

29. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_21 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

30. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_22 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

31. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_23 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

32. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_24 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

33. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_25 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

34. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_26 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

35. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_27 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

36. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_28 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

37. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_29 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

38. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_30 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

39. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_31 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

40. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_32 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

41. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_33 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.010 rows=0 loops=1)

42. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_34 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

43. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_35 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

44. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_36 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

45. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_37 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

46. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_38 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.010 rows=0 loops=1)

47. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_39 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

48. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_40 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

49. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_41 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

50. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_42 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

51. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_43 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

52. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_44 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.010 rows=0 loops=1)

53. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_45 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.010 rows=0 loops=1)

54. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_46 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

55. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_47 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

56. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_48 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

57. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_49 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

58. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_50 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

59. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_51 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

60. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_52 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

61. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_53 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

62. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_54 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

63. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_55 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

64. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_56 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

65. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_57 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

66. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_58 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.009 rows=0 loops=1)

67. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_59 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

68. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_60 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

69. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_61 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

70. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_62 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.009 rows=0 loops=1)

71. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_63 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.009 rows=0 loops=1)

72. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_64 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

73. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_65 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

74. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_66 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

75. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_67 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

76. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_68 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

77. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_69 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

78. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_70 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

79. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_71 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

80. 35,597.291 35,597.291 ↑ 11.4 119 1

Seq Scan on road_segments_partitioned_72 (cost=0.00..146.00 rows=1,360 width=16) (actual time=35,597.275..35,597.291 rows=119 loops=1)

81. 0.048 0.048 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_73 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.048..0.048 rows=0 loops=1)

82. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_74 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.011..0.011 rows=0 loops=1)

83. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_75 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

84. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_76 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

85. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_77 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

86. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_78 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.011 rows=0 loops=1)

87. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_79 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

88. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_80 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

89. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_81 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

90. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_82 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

91. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_83 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

92. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_84 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

93. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_85 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.010 rows=0 loops=1)

94. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_86 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

95. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_87 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

96. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_88 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

97. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_89 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

98. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_90 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

99. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_91 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

100. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_92 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

101. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_93 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

102. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_94 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

103. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_95 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

104. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_96 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

105. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_97 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

106. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_98 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

107. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_99 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

108. 0.045 0.045 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_100 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.044..0.045 rows=0 loops=1)

109. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_101 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

110. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_102 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

111. 88.358 88.358 ↑ 1.0 261,387 1

Seq Scan on road_segments_partitioned_103 (cost=0.00..28,060.70 rows=261,387 width=16) (actual time=0.687..88.358 rows=261,387 loops=1)

112. 0.477 0.477 ↑ 19.2 71 1

Seq Scan on road_segments_partitioned_104 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.471..0.477 rows=71 loops=1)

113. 0.457 0.457 ↑ 12.4 110 1

Seq Scan on road_segments_partitioned_105 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.447..0.457 rows=110 loops=1)

114. 1.220 1.220 ↑ 1.6 853 1

Seq Scan on road_segments_partitioned_106 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.495..1.220 rows=853 loops=1)

115. 1.211 1.211 ↑ 1.0 1,360 1

Seq Scan on road_segments_partitioned_107 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.447..1.211 rows=1,360 loops=1)

116. 0.480 0.480 ↑ 10.1 134 1

Seq Scan on road_segments_partitioned_108 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.468..0.480 rows=134 loops=1)

117. 0.409 0.409 ↑ 16.4 83 1

Seq Scan on road_segments_partitioned_109 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.401..0.409 rows=83 loops=1)

118. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_110 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

119. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_111 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

120. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_112 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

121. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_113 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.011..0.011 rows=0 loops=1)

122. 0.486 0.486 ↑ 340.0 4 1

Seq Scan on road_segments_partitioned_114 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.486..0.486 rows=4 loops=1)

123. 0.508 0.508 ↑ 13.6 100 1

Seq Scan on road_segments_partitioned_115 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.499..0.508 rows=100 loops=1)

124. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_116 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

125. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_117 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.017..0.017 rows=0 loops=1)

126. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_118 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.011 rows=0 loops=1)

127. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_119 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

128. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_120 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

129. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_121 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

130. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_122 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

131. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_123 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

132. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_124 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

133. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_125 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.011..0.011 rows=0 loops=1)

134. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_126 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

135. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_127 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

136. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_128 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

137. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_129 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

138. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_130 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

139. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_131 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

140. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_132 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

141. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_133 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

142. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_134 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

143. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_135 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

144. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_136 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

145. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_137 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.017..0.017 rows=0 loops=1)

146. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_138 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

147. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_139 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

148. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_140 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

149. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_141 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

150. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_142 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

151. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_143 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.010 rows=0 loops=1)

152. 0.039 0.039 ↑ 1.0 185 1

Seq Scan on road_segments_partitioned_144 (cost=0.00..20.50 rows=185 width=16) (actual time=0.020..0.039 rows=185 loops=1)

153. 344.370 344.370 ↑ 1.0 994,672 1

Seq Scan on road_segments_partitioned_145 (cost=0.00..106,781.20 rows=994,672 width=16) (actual time=0.509..344.370 rows=994,672 loops=1)

154. 4.018 4.018 ↑ 1.0 12,448 1

Seq Scan on road_segments_partitioned_146 (cost=0.00..1,336.80 rows=12,448 width=16) (actual time=0.056..4.018 rows=12,448 loops=1)

155. 1.745 1.745 ↑ 1.0 2,499 1

Seq Scan on road_segments_partitioned_147 (cost=0.00..277.40 rows=2,584 width=16) (actual time=0.448..1.745 rows=2,499 loops=1)

156. 1.033 1.033 ↑ 4.9 280 1

Seq Scan on road_segments_partitioned_148 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.492..1.033 rows=280 loops=1)

157. 2.697 2.697 ↑ 1.0 5,746 1

Seq Scan on road_segments_partitioned_149 (cost=0.00..627.80 rows=5,848 width=16) (actual time=0.482..2.697 rows=5,746 loops=1)

158. 1.293 1.293 ↑ 1.3 1,065 1

Seq Scan on road_segments_partitioned_150 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.533..1.293 rows=1,065 loops=1)

159. 0.482 0.482 ↑ 170.0 8 1

Seq Scan on road_segments_partitioned_151 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.481..0.482 rows=8 loops=1)

160. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_152 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.019..0.019 rows=0 loops=1)

161. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_153 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

162. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_154 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

163. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_155 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

164. 0.944 0.944 ↑ 1.0 733 1

Seq Scan on road_segments_partitioned_156 (cost=0.00..79.30 rows=733 width=16) (actual time=0.458..0.944 rows=733 loops=1)

165. 1.002 1.002 ↑ 2.2 628 1

Seq Scan on road_segments_partitioned_157 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.464..1.002 rows=628 loops=1)

166. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_158 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

167. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_159 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

168. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_160 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

169. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_161 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

170. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_162 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

171. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_163 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

172. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_164 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

173. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_165 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

174. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_166 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

175. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_167 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.009 rows=0 loops=1)

176. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_168 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

177. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_169 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

178. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_170 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

179. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_171 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.021..0.021 rows=0 loops=1)

180. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_172 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

181. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_173 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

182. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_174 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

183. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_175 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

184. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_176 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

185. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_177 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.011..0.011 rows=0 loops=1)

186. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_178 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

187. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_179 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

188. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_180 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.017..0.017 rows=0 loops=1)

189. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_181 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

190. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_182 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

191. 0.505 0.505 ↑ 8.3 164 1

Seq Scan on road_segments_partitioned_183 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.481..0.505 rows=164 loops=1)

192. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_184 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.018..0.018 rows=0 loops=1)

193. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_185 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.011..0.011 rows=0 loops=1)

194. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_186 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

195. 47.677 47.677 ↑ 1.0 133,569 1

Seq Scan on road_segments_partitioned_187 (cost=0.00..14,351.80 rows=133,688 width=16) (actual time=0.413..47.677 rows=133,569 loops=1)

196. 451.989 451.989 ↑ 1.0 1,288,657 1

Seq Scan on road_segments_partitioned_188 (cost=0.00..138,341.70 rows=1,288,657 width=16) (actual time=0.538..451.989 rows=1,288,657 loops=1)

197. 2.215 2.215 ↑ 1.0 3,298 1

Seq Scan on road_segments_partitioned_189 (cost=0.00..365.00 rows=3,400 width=16) (actual time=0.549..2.215 rows=3,298 loops=1)

198. 7.030 7.030 ↑ 1.0 17,884 1

Seq Scan on road_segments_partitioned_190 (cost=0.00..1,927.20 rows=17,952 width=16) (actual time=0.462..7.030 rows=17,884 loops=1)

199. 0.993 0.993 ↑ 1.7 809 1

Seq Scan on road_segments_partitioned_191 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.435..0.993 rows=809 loops=1)

200. 1.236 1.236 ↑ 1.8 770 1

Seq Scan on road_segments_partitioned_192 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.480..1.236 rows=770 loops=1)

201. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_193 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

202. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_194 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

203. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_195 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

204. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_196 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

205. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_197 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

206. 0.443 0.443 ↑ 340.0 4 1

Seq Scan on road_segments_partitioned_198 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.442..0.443 rows=4 loops=1)

207. 1.940 1.940 ↑ 1.0 2,701 1

Seq Scan on road_segments_partitioned_199 (cost=0.00..290.10 rows=2,701 width=16) (actual time=0.436..1.940 rows=2,701 loops=1)

208. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_200 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.021..0.021 rows=0 loops=1)

209. 0.496 0.496 ↑ 1,360.0 1 1

Seq Scan on road_segments_partitioned_201 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.495..0.496 rows=1 loops=1)

210. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_202 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

211. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_203 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

212. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_204 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

213. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_205 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

214. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_206 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

215. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_207 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.016..0.016 rows=0 loops=1)

216. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_208 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

217. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_209 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

218. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_210 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

219. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_211 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

220. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_212 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

221. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_213 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

222. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_214 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

223. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_215 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

224. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_216 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

225. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_217 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

226. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_218 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

227. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_219 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

228. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_220 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

229. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_221 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

230. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_222 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

231. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_223 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

232. 0.523 0.523 ↑ 5.4 252 1

Seq Scan on road_segments_partitioned_224 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.490..0.523 rows=252 loops=1)

233. 0.431 0.431 ↑ 18.9 72 1

Seq Scan on road_segments_partitioned_225 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.424..0.431 rows=72 loops=1)

234. 1.308 1.308 ↑ 1.2 1,091 1

Seq Scan on road_segments_partitioned_226 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.487..1.308 rows=1,091 loops=1)

235. 1.011 1.011 ↑ 3.3 418 1

Seq Scan on road_segments_partitioned_227 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.491..1.011 rows=418 loops=1)

236. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_228 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

237. 6.149 6.149 ↑ 1.0 12,606 1

Seq Scan on road_segments_partitioned_229 (cost=0.00..1,357.80 rows=12,648 width=16) (actual time=0.551..6.149 rows=12,606 loops=1)

238. 70.792 70.792 ↑ 1.0 213,770 1

Seq Scan on road_segments_partitioned_230 (cost=0.00..22,949.00 rows=213,770 width=16) (actual time=0.513..70.792 rows=213,770 loops=1)

239. 129.878 129.878 ↑ 1.0 385,740 1

Seq Scan on road_segments_partitioned_231 (cost=0.00..41,411.00 rows=385,740 width=16) (actual time=0.552..129.878 rows=385,740 loops=1)

240. 2.406 2.406 ↑ 1.0 5,143 1

Seq Scan on road_segments_partitioned_232 (cost=0.00..554.80 rows=5,168 width=16) (actual time=0.545..2.406 rows=5,143 loops=1)

241. 1.442 1.442 ↑ 1.0 2,258 1

Seq Scan on road_segments_partitioned_233 (cost=0.00..248.20 rows=2,312 width=16) (actual time=0.482..1.442 rows=2,258 loops=1)

242. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_234 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.016..0.016 rows=0 loops=1)

243. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_235 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

244. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_236 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

245. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_237 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

246. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_238 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.016..0.016 rows=0 loops=1)

247. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_239 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

248. 1.406 1.406 ↑ 1.1 1,786 1

Seq Scan on road_segments_partitioned_240 (cost=0.00..204.40 rows=1,904 width=16) (actual time=0.497..1.406 rows=1,786 loops=1)

249. 1.094 1.094 ↑ 1.7 796 1

Seq Scan on road_segments_partitioned_241 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.427..1.094 rows=796 loops=1)

250. 1.903 1.903 ↑ 1.0 4,088 1

Seq Scan on road_segments_partitioned_242 (cost=0.00..452.60 rows=4,216 width=16) (actual time=0.411..1.903 rows=4,088 loops=1)

251. 2.710 2.710 ↑ 1.0 8,155 1

Seq Scan on road_segments_partitioned_243 (cost=0.00..875.50 rows=8,155 width=16) (actual time=0.441..2.710 rows=8,155 loops=1)

252. 0.020 0.020 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_244 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.020..0.020 rows=0 loops=1)

253. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_245 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

254. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_246 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

255. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_247 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.016..0.016 rows=0 loops=1)

256. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_248 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

257. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_249 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

258. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_250 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

259. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_251 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

260. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_252 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

261. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_253 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

262. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_254 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.011..0.011 rows=0 loops=1)

263. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_255 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

264. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_256 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.010 rows=0 loops=1)

265. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_257 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

266. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_258 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

267. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_259 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

268. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_260 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

269. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_261 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

270. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_262 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

271. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_263 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

272. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_264 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.015 rows=0 loops=1)

273. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_265 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

274. 0.465 0.465 ↑ 6.0 228 1

Seq Scan on road_segments_partitioned_266 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.435..0.465 rows=228 loops=1)

275. 1.014 1.014 ↑ 2.9 468 1

Seq Scan on road_segments_partitioned_267 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.477..1.014 rows=468 loops=1)

276. 9.998 9.998 ↑ 1.0 30,339 1

Seq Scan on road_segments_partitioned_268 (cost=0.00..3,257.90 rows=30,339 width=16) (actual time=0.435..9.998 rows=30,339 loops=1)

277. 56.233 56.233 ↑ 1.0 167,227 1

Seq Scan on road_segments_partitioned_269 (cost=0.00..17,952.70 rows=167,227 width=16) (actual time=0.559..56.233 rows=167,227 loops=1)

278. 50.300 50.300 ↑ 1.0 134,948 1

Seq Scan on road_segments_partitioned_270 (cost=0.00..14,487.80 rows=134,948 width=16) (actual time=0.562..50.300 rows=134,948 loops=1)

279. 39.671 39.671 ↑ 1.0 122,292 1

Seq Scan on road_segments_partitioned_271 (cost=0.00..13,129.20 rows=122,292 width=16) (actual time=0.319..39.671 rows=122,292 loops=1)

280. 2.770 2.770 ↑ 1.0 6,747 1

Seq Scan on road_segments_partitioned_272 (cost=0.00..730.00 rows=6,800 width=16) (actual time=0.464..2.770 rows=6,747 loops=1)

281. 85.639 85.639 ↑ 1.0 269,199 1

Seq Scan on road_segments_partitioned_273 (cost=0.00..28,899.90 rows=269,199 width=16) (actual time=0.521..85.639 rows=269,199 loops=1)

282. 3.718 3.718 ↑ 1.0 11,389 1

Seq Scan on road_segments_partitioned_274 (cost=0.00..1,226.40 rows=11,424 width=16) (actual time=0.531..3.718 rows=11,389 loops=1)

283. 1.194 1.194 ↑ 1.4 994 1

Seq Scan on road_segments_partitioned_275 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.453..1.194 rows=994 loops=1)

284. 3.144 3.144 ↑ 1.0 7,045 1

Seq Scan on road_segments_partitioned_276 (cost=0.00..759.20 rows=7,072 width=16) (actual time=0.443..3.144 rows=7,045 loops=1)

285. 1.725 1.725 ↑ 1.0 2,018 1

Seq Scan on road_segments_partitioned_277 (cost=0.00..219.00 rows=2,040 width=16) (actual time=0.471..1.725 rows=2,018 loops=1)

286. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_278 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.016..0.016 rows=0 loops=1)

287. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_279 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.021..0.021 rows=0 loops=1)

288. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_280 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

289. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_281 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

290. 1.469 1.469 ↑ 1.1 2,199 1

Seq Scan on road_segments_partitioned_282 (cost=0.00..248.20 rows=2,312 width=16) (actual time=0.498..1.469 rows=2,199 loops=1)

291. 0.487 0.487 ↑ 5.9 231 1

Seq Scan on road_segments_partitioned_283 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.458..0.487 rows=231 loops=1)

292. 1.981 1.981 ↑ 1.0 2,856 1

Seq Scan on road_segments_partitioned_284 (cost=0.00..306.60 rows=2,856 width=16) (actual time=0.416..1.981 rows=2,856 loops=1)

293. 7.453 7.453 ↑ 1.0 26,957 1

Seq Scan on road_segments_partitioned_285 (cost=0.00..2,894.70 rows=26,957 width=16) (actual time=0.447..7.453 rows=26,957 loops=1)

294. 0.025 0.025 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_286 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.025..0.025 rows=0 loops=1)

295. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_287 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

296. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_288 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

297. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_289 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

298. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_290 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

299. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_291 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

300. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_292 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

301. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_293 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

302. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_294 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.016..0.016 rows=0 loops=1)

303. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_295 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

304. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_296 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

305. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_297 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

306. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_298 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

307. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_299 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

308. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_300 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

309. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_301 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

310. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_302 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

311. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_303 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.011..0.011 rows=0 loops=1)

312. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_304 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

313. 0.022 0.022 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_305 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.022..0.022 rows=0 loops=1)

314. 2.275 2.275 ↑ 1.0 3,984 1

Seq Scan on road_segments_partitioned_306 (cost=0.00..438.00 rows=4,080 width=16) (actual time=0.484..2.275 rows=3,984 loops=1)

315. 1.152 1.152 ↑ 1.5 918 1

Seq Scan on road_segments_partitioned_307 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.471..1.152 rows=918 loops=1)

316. 0.434 0.434 ↑ 22.3 61 1

Seq Scan on road_segments_partitioned_308 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.428..0.434 rows=61 loops=1)

317. 0.483 0.483 ↑ 17.7 77 1

Seq Scan on road_segments_partitioned_309 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.475..0.483 rows=77 loops=1)

318. 23.108 23.108 ↑ 1.0 66,425 1

Seq Scan on road_segments_partitioned_310 (cost=0.00..7,131.50 rows=66,425 width=16) (actual time=0.520..23.108 rows=66,425 loops=1)

319. 1.099 1.099 ↑ 2.6 522 1

Seq Scan on road_segments_partitioned_311 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.624..1.099 rows=522 loops=1)

320. 0.385 0.385 ↑ 15.1 90 1

Seq Scan on road_segments_partitioned_312 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.377..0.385 rows=90 loops=1)

321. 4.261 4.261 ↑ 1.0 12,247 1

Seq Scan on road_segments_partitioned_313 (cost=0.00..1,315.70 rows=12,247 width=16) (actual time=0.499..4.261 rows=12,247 loops=1)

322. 5.643 5.643 ↑ 1.0 17,493 1

Seq Scan on road_segments_partitioned_314 (cost=0.00..1,883.40 rows=17,544 width=16) (actual time=0.454..5.643 rows=17,493 loops=1)

323. 48.601 48.601 ↑ 1.0 145,694 1

Seq Scan on road_segments_partitioned_315 (cost=0.00..15,641.40 rows=145,694 width=16) (actual time=0.473..48.601 rows=145,694 loops=1)

324. 0.034 0.034 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_316 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.034..0.034 rows=0 loops=1)

325. 4.471 4.471 ↑ 1.0 14,501 1

Seq Scan on road_segments_partitioned_317 (cost=0.00..1,562.20 rows=14,552 width=16) (actual time=0.577..4.471 rows=14,501 loops=1)

326. 15.132 15.132 ↑ 1.0 46,832 1

Seq Scan on road_segments_partitioned_318 (cost=0.00..5,037.00 rows=46,920 width=16) (actual time=0.249..15.132 rows=46,832 loops=1)

327. 1.242 1.242 ↑ 1.1 1,197 1

Seq Scan on road_segments_partitioned_319 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.491..1.242 rows=1,197 loops=1)

328. 1.262 1.262 ↑ 1.1 1,396 1

Seq Scan on road_segments_partitioned_320 (cost=0.00..160.60 rows=1,496 width=16) (actual time=0.512..1.262 rows=1,396 loops=1)

329. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_321 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

330. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_322 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

331. 1.663 1.663 ↑ 1.0 3,421 1

Seq Scan on road_segments_partitioned_323 (cost=0.00..379.60 rows=3,536 width=16) (actual time=0.460..1.663 rows=3,421 loops=1)

332. 2.583 2.583 ↑ 1.0 5,282 1

Seq Scan on road_segments_partitioned_324 (cost=0.00..569.40 rows=5,304 width=16) (actual time=0.506..2.583 rows=5,282 loops=1)

333. 0.494 0.494 ↑ 30.9 44 1

Seq Scan on road_segments_partitioned_325 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.490..0.494 rows=44 loops=1)

334. 1.029 1.029 ↑ 2.4 561 1

Seq Scan on road_segments_partitioned_326 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.431..1.029 rows=561 loops=1)

335. 247.168 247.168 ↑ 1.0 756,731 1

Seq Scan on road_segments_partitioned_327 (cost=0.00..81,238.10 rows=756,731 width=16) (actual time=0.547..247.168 rows=756,731 loops=1)

336. 330.245 330.245 ↑ 1.0 965,575 1

Seq Scan on road_segments_partitioned_328 (cost=0.00..103,657.50 rows=965,575 width=16) (actual time=0.555..330.245 rows=965,575 loops=1)

337. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_329 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.021..0.021 rows=0 loops=1)

338. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_330 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.010 rows=0 loops=1)

339. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_331 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

340. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_332 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.018..0.018 rows=0 loops=1)

341. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_333 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

342. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_334 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

343. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_335 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

344. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_336 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.010 rows=0 loops=1)

345. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_337 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

346. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_338 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

347. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_339 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

348. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_340 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

349. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_341 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

350. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_342 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

351. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_343 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

352. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_344 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

353. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_345 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

354. 4.732 4.732 ↑ 1.0 12,792 1

Seq Scan on road_segments_partitioned_346 (cost=0.00..1,374.20 rows=12,792 width=16) (actual time=0.559..4.732 rows=12,792 loops=1)

355. 11.864 11.864 ↑ 1.0 29,290 1

Seq Scan on road_segments_partitioned_347 (cost=0.00..3,153.60 rows=29,376 width=16) (actual time=0.494..11.864 rows=29,290 loops=1)

356. 6.149 6.149 ↑ 1.0 36,954 1

Seq Scan on road_segments_partitioned_348 (cost=0.00..3,967.40 rows=36,954 width=16) (actual time=0.051..6.149 rows=36,954 loops=1)

357. 6.871 6.871 ↑ 1.0 20,083 1

Seq Scan on road_segments_partitioned_349 (cost=0.00..2,160.80 rows=20,128 width=16) (actual time=0.551..6.871 rows=20,083 loops=1)

358. 12.660 12.660 ↑ 1.0 32,109 1

Seq Scan on road_segments_partitioned_350 (cost=0.00..3,460.20 rows=32,232 width=16) (actual time=0.472..12.660 rows=32,109 loops=1)

359. 1.961 1.961 ↑ 1.0 2,974 1

Seq Scan on road_segments_partitioned_351 (cost=0.00..321.20 rows=2,992 width=16) (actual time=0.488..1.961 rows=2,974 loops=1)

360. 13.100 13.100 ↑ 1.0 37,961 1

Seq Scan on road_segments_partitioned_352 (cost=0.00..4,076.10 rows=37,961 width=16) (actual time=0.480..13.100 rows=37,961 loops=1)

361. 1.988 1.988 ↑ 1.0 2,612 1

Seq Scan on road_segments_partitioned_353 (cost=0.00..292.00 rows=2,720 width=16) (actual time=0.447..1.988 rows=2,612 loops=1)

362. 1.939 1.939 ↑ 1.0 4,054 1

Seq Scan on road_segments_partitioned_354 (cost=0.00..438.00 rows=4,080 width=16) (actual time=0.457..1.939 rows=4,054 loops=1)

363. 1.204 1.204 ↑ 1.7 785 1

Seq Scan on road_segments_partitioned_355 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.510..1.204 rows=785 loops=1)

364. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_356 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.017..0.018 rows=0 loops=1)

365. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_357 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

366. 116.976 116.976 ↑ 1.0 330,147 1

Seq Scan on road_segments_partitioned_358 (cost=0.00..35,442.70 rows=330,147 width=16) (actual time=0.566..116.976 rows=330,147 loops=1)

367. 1.043 1.043 ↑ 3.2 427 1

Seq Scan on road_segments_partitioned_359 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.527..1.043 rows=427 loops=1)

368. 9.844 9.844 ↑ 1.0 31,737 1

Seq Scan on road_segments_partitioned_360 (cost=0.00..3,416.40 rows=31,824 width=16) (actual time=0.451..9.844 rows=31,737 loops=1)

369. 0.912 0.912 ↑ 3.5 385 1

Seq Scan on road_segments_partitioned_361 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.473..0.912 rows=385 loops=1)

370. 0.989 0.989 ↑ 2.9 475 1

Seq Scan on road_segments_partitioned_362 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.466..0.989 rows=475 loops=1)

371. 3.256 3.256 ↑ 1.0 9,457 1

Seq Scan on road_segments_partitioned_363 (cost=0.00..1,022.00 rows=9,520 width=16) (actual time=0.441..3.256 rows=9,457 loops=1)

372. 1.126 1.126 ↑ 1.1 1,424 1

Seq Scan on road_segments_partitioned_364 (cost=0.00..160.60 rows=1,496 width=16) (actual time=0.383..1.126 rows=1,424 loops=1)

373. 23.394 23.394 ↑ 1.0 72,332 1

Seq Scan on road_segments_partitioned_365 (cost=0.00..7,767.20 rows=72,352 width=16) (actual time=0.412..23.394 rows=72,332 loops=1)

374. 11.615 11.615 ↑ 1.0 29,244 1

Seq Scan on road_segments_partitioned_366 (cost=0.00..3,140.40 rows=29,244 width=16) (actual time=0.526..11.615 rows=29,244 loops=1)

375. 10.120 10.120 ↑ 1.0 32,849 1

Seq Scan on road_segments_partitioned_367 (cost=0.00..3,526.90 rows=32,849 width=16) (actual time=0.577..10.120 rows=32,849 loops=1)

376. 31.307 31.307 ↑ 1.0 98,698 1

Seq Scan on road_segments_partitioned_368 (cost=0.00..10,595.80 rows=98,698 width=16) (actual time=0.241..31.307 rows=98,698 loops=1)

377. 517.652 517.652 ↑ 1.0 1,567,255 1

Seq Scan on road_segments_partitioned_369 (cost=0.00..168,249.50 rows=1,567,255 width=16) (actual time=0.584..517.652 rows=1,567,255 loops=1)

378. 853.686 853.686 ↑ 1.0 2,437,477 1

Seq Scan on road_segments_partitioned_370 (cost=0.00..261,670.70 rows=2,437,477 width=16) (actual time=0.566..853.686 rows=2,437,477 loops=1)

379. 0.051 0.051 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_371 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.051..0.051 rows=0 loops=1)

380. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_372 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.011..0.011 rows=0 loops=1)

381. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_373 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

382. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_374 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

383. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_375 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

384. 0.020 0.020 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_376 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.020..0.020 rows=0 loops=1)

385. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_377 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.016..0.016 rows=0 loops=1)

386. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_378 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.011..0.011 rows=0 loops=1)

387. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_379 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.010 rows=0 loops=1)

388. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_380 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

389. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_381 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

390. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_382 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

391. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_383 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

392. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_384 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

393. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_385 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

394. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_386 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

395. 1.563 1.563 ↑ 1.0 1,482 1

Seq Scan on road_segments_partitioned_387 (cost=0.00..160.60 rows=1,496 width=16) (actual time=0.474..1.563 rows=1,482 loops=1)

396. 8.795 8.795 ↑ 1.0 19,814 1

Seq Scan on road_segments_partitioned_388 (cost=0.00..2,131.60 rows=19,856 width=16) (actual time=0.440..8.795 rows=19,814 loops=1)

397. 0.467 0.467 ↑ 226.7 6 1

Seq Scan on road_segments_partitioned_389 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.465..0.467 rows=6 loops=1)

398. 0.443 0.443 ↑ 56.7 24 1

Seq Scan on road_segments_partitioned_390 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.440..0.443 rows=24 loops=1)

399. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_391 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

400. 3.920 3.920 ↑ 1.0 25,428 1

Seq Scan on road_segments_partitioned_392 (cost=0.00..2,729.80 rows=25,428 width=16) (actual time=0.023..3.920 rows=25,428 loops=1)

401. 3.551 3.551 ↑ 1.0 22,794 1

Seq Scan on road_segments_partitioned_393 (cost=0.00..2,447.40 rows=22,794 width=16) (actual time=0.062..3.551 rows=22,794 loops=1)

402. 1.248 1.248 ↑ 2.8 494 1

Seq Scan on road_segments_partitioned_394 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.673..1.248 rows=494 loops=1)

403. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_395 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.018..0.018 rows=0 loops=1)

404. 0.459 0.459 ↑ 37.8 36 1

Seq Scan on road_segments_partitioned_396 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.456..0.459 rows=36 loops=1)

405. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_397 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

406. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_398 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

407. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_399 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

408. 126.190 126.190 ↑ 1.0 383,067 1

Seq Scan on road_segments_partitioned_400 (cost=0.00..41,128.20 rows=383,112 width=16) (actual time=0.528..126.190 rows=383,067 loops=1)

409. 29.792 29.792 ↑ 1.0 95,046 1

Seq Scan on road_segments_partitioned_401 (cost=0.00..10,205.40 rows=95,064 width=16) (actual time=0.518..29.792 rows=95,046 loops=1)

410. 13.185 13.185 ↑ 1.0 42,496 1

Seq Scan on road_segments_partitioned_402 (cost=0.00..4,569.80 rows=42,568 width=16) (actual time=0.575..13.185 rows=42,496 loops=1)

411. 1.115 1.115 ↑ 2.3 591 1

Seq Scan on road_segments_partitioned_403 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.489..1.115 rows=591 loops=1)

412. 0.539 0.539 ↑ 7.6 178 1

Seq Scan on road_segments_partitioned_404 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.516..0.539 rows=178 loops=1)

413. 3.960 3.960 ↑ 1.0 10,432 1

Seq Scan on road_segments_partitioned_405 (cost=0.00..1,120.20 rows=10,432 width=16) (actual time=0.444..3.960 rows=10,432 loops=1)

414. 13.971 13.971 ↑ 1.0 46,725 1

Seq Scan on road_segments_partitioned_406 (cost=0.00..5,016.50 rows=46,725 width=16) (actual time=0.430..13.971 rows=46,725 loops=1)

415. 8.401 8.401 ↑ 1.0 25,401 1

Seq Scan on road_segments_partitioned_407 (cost=0.00..2,730.20 rows=25,432 width=16) (actual time=0.475..8.401 rows=25,401 loops=1)

416. 1.198 1.198 ↑ 1.5 905 1

Seq Scan on road_segments_partitioned_408 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.476..1.198 rows=905 loops=1)

417. 1.779 1.779 ↑ 1.0 2,920 1

Seq Scan on road_segments_partitioned_409 (cost=0.00..321.20 rows=2,992 width=16) (actual time=0.451..1.779 rows=2,920 loops=1)

418. 26.112 26.112 ↑ 1.0 82,802 1

Seq Scan on road_segments_partitioned_410 (cost=0.00..8,891.40 rows=82,824 width=16) (actual time=0.491..26.112 rows=82,802 loops=1)

419. 171.905 171.905 ↑ 1.0 536,292 1

Seq Scan on road_segments_partitioned_411 (cost=0.00..57,573.20 rows=536,292 width=16) (actual time=0.561..171.905 rows=536,292 loops=1)

420. 352.605 352.605 ↑ 1.0 1,109,670 1

Seq Scan on road_segments_partitioned_412 (cost=0.00..119,127.00 rows=1,109,670 width=16) (actual time=0.528..352.605 rows=1,109,670 loops=1)

421. 633.182 633.182 ↑ 1.0 2,008,688 1

Seq Scan on road_segments_partitioned_413 (cost=0.00..215,638.80 rows=2,008,688 width=16) (actual time=0.058..633.182 rows=2,008,688 loops=1)

422. 0.033 0.033 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_414 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.033..0.033 rows=0 loops=1)

423. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_415 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

424. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_416 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

425. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_417 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

426. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_418 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.009 rows=0 loops=1)

427. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_419 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

428. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_420 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

429. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_421 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

430. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_422 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

431. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_423 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

432. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_424 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

433. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_425 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

434. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_426 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.009 rows=0 loops=1)

435. 27.441 27.441 ↑ 1.0 90,481 1

Seq Scan on road_segments_partitioned_427 (cost=0.00..9,714.10 rows=90,481 width=16) (actual time=0.500..27.441 rows=90,481 loops=1)

436. 14.404 14.404 ↑ 1.0 18,377 1

Seq Scan on road_segments_partitioned_428 (cost=0.00..1,985.60 rows=18,496 width=16) (actual time=0.513..14.404 rows=18,377 loops=1)

437. 2.660 2.660 ↑ 1.0 17,806 1

Seq Scan on road_segments_partitioned_429 (cost=0.00..1,911.60 rows=17,806 width=16) (actual time=0.053..2.660 rows=17,806 loops=1)

438. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_430 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.016..0.016 rows=0 loops=1)

439. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_431 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

440. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_432 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

441. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_433 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

442. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_434 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

443. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_435 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

444. 1.030 1.030 ↑ 4.1 335 1

Seq Scan on road_segments_partitioned_436 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.494..1.030 rows=335 loops=1)

445. 0.488 0.488 ↑ 5.7 240 1

Seq Scan on road_segments_partitioned_437 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.459..0.488 rows=240 loops=1)

446. 1.103 1.103 ↑ 2.5 545 1

Seq Scan on road_segments_partitioned_438 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.477..1.103 rows=545 loops=1)

447. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_439 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.012..0.012 rows=0 loops=1)

448. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_440 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

449. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_441 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

450. 61.367 61.367 ↑ 1.0 209,258 1

Seq Scan on road_segments_partitioned_442 (cost=0.00..22,469.40 rows=209,304 width=16) (actual time=0.471..61.367 rows=209,258 loops=1)

451. 1.011 1.011 ↑ 1.3 1,024 1

Seq Scan on road_segments_partitioned_443 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.436..1.011 rows=1,024 loops=1)

452. 31.721 31.721 ↑ 1.0 106,587 1

Seq Scan on road_segments_partitioned_444 (cost=0.00..11,446.40 rows=106,624 width=16) (actual time=0.482..31.721 rows=106,587 loops=1)

453. 24.934 24.934 ↑ 1.0 168,276 1

Seq Scan on road_segments_partitioned_445 (cost=0.00..18,065.60 rows=168,276 width=16) (actual time=0.054..24.934 rows=168,276 loops=1)

454. 42.157 42.157 ↑ 1.0 162,125 1

Seq Scan on road_segments_partitioned_446 (cost=0.00..17,405.50 rows=162,125 width=16) (actual time=0.631..42.157 rows=162,125 loops=1)

455. 46.025 46.025 ↑ 1.0 162,515 1

Seq Scan on road_segments_partitioned_447 (cost=0.00..17,446.50 rows=162,515 width=16) (actual time=0.521..46.025 rows=162,515 loops=1)

456. 31.782 31.782 ↑ 1.0 114,829 1

Seq Scan on road_segments_partitioned_448 (cost=0.00..12,337.00 rows=114,920 width=16) (actual time=0.592..31.782 rows=114,829 loops=1)

457. 4.090 4.090 ↑ 1.0 13,785 1

Seq Scan on road_segments_partitioned_449 (cost=0.00..1,489.20 rows=13,872 width=16) (actual time=0.481..4.090 rows=13,785 loops=1)

458. 2.226 2.226 ↑ 1.0 5,815 1

Seq Scan on road_segments_partitioned_450 (cost=0.00..627.80 rows=5,848 width=16) (actual time=0.446..2.226 rows=5,815 loops=1)

459. 2.155 2.155 ↑ 1.0 5,424 1

Seq Scan on road_segments_partitioned_451 (cost=0.00..582.40 rows=5,424 width=16) (actual time=0.478..2.155 rows=5,424 loops=1)

460. 35.734 35.734 ↑ 1.0 132,200 1

Seq Scan on road_segments_partitioned_452 (cost=0.00..14,193.00 rows=132,200 width=16) (actual time=0.477..35.734 rows=132,200 loops=1)

461. 9.197 9.197 ↑ 1.0 34,612 1

Seq Scan on road_segments_partitioned_453 (cost=0.00..3,723.00 rows=34,680 width=16) (actual time=0.523..9.197 rows=34,612 loops=1)

462. 667.569 667.569 ↑ 1.0 2,022,442 1

Seq Scan on road_segments_partitioned_454 (cost=0.00..217,115.20 rows=2,022,442 width=16) (actual time=0.054..667.569 rows=2,022,442 loops=1)

463. 450.604 450.604 ↑ 1.0 1,368,868 1

Seq Scan on road_segments_partitioned_455 (cost=0.00..146,952.80 rows=1,368,868 width=16) (actual time=0.058..450.604 rows=1,368,868 loops=1)

464. 161.230 161.230 ↑ 1.0 548,814 1

Seq Scan on road_segments_partitioned_456 (cost=0.00..58,917.40 rows=548,814 width=16) (actual time=0.555..161.230 rows=548,814 loops=1)

465. 45.190 45.190 ↑ 1.0 152,639 1

Seq Scan on road_segments_partitioned_457 (cost=0.00..16,386.90 rows=152,639 width=16) (actual time=0.481..45.190 rows=152,639 loops=1)

466. 0.029 0.029 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_458 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.029..0.029 rows=0 loops=1)

467. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_459 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

468. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_460 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

469. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_461 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

470. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_462 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

471. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_463 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

472. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_464 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

473. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_465 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.010 rows=0 loops=1)

474. 1.627 1.627 ↑ 1.0 2,520 1

Seq Scan on road_segments_partitioned_466 (cost=0.00..277.40 rows=2,584 width=16) (actual time=0.494..1.627 rows=2,520 loops=1)

475. 2.868 2.868 ↑ 1.0 9,477 1

Seq Scan on road_segments_partitioned_467 (cost=0.00..1,022.00 rows=9,520 width=16) (actual time=0.447..2.868 rows=9,477 loops=1)

476. 5.749 5.749 ↑ 1.0 17,810 1

Seq Scan on road_segments_partitioned_468 (cost=0.00..1,912.60 rows=17,816 width=16) (actual time=0.485..5.749 rows=17,810 loops=1)

477. 11.640 11.640 ↑ 1.0 23,822 1

Seq Scan on road_segments_partitioned_469 (cost=0.00..2,569.60 rows=23,936 width=16) (actual time=0.430..11.640 rows=23,822 loops=1)

478. 1.897 1.897 ↑ 1.0 3,797 1

Seq Scan on road_segments_partitioned_470 (cost=0.00..408.80 rows=3,808 width=16) (actual time=0.476..1.897 rows=3,797 loops=1)

479. 0.456 0.456 ↑ 13.2 103 1

Seq Scan on road_segments_partitioned_471 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.446..0.456 rows=103 loops=1)

480. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_472 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

481. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_473 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

482. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_474 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

483. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_475 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

484. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_476 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.016..0.016 rows=0 loops=1)

485. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_477 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

486. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_478 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

487. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_479 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

488. 0.432 0.432 ↑ 10.5 130 1

Seq Scan on road_segments_partitioned_480 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.420..0.432 rows=130 loops=1)

489. 0.909 0.909 ↑ 3.9 352 1

Seq Scan on road_segments_partitioned_481 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.436..0.909 rows=352 loops=1)

490. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_482 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

491. 0.395 0.395 ↑ 10.8 126 1

Seq Scan on road_segments_partitioned_483 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.384..0.395 rows=126 loops=1)

492. 47.028 47.028 ↑ 1.0 153,344 1

Seq Scan on road_segments_partitioned_484 (cost=0.00..16,462.40 rows=153,344 width=16) (actual time=0.455..47.028 rows=153,344 loops=1)

493. 1.071 1.071 ↑ 1.8 766 1

Seq Scan on road_segments_partitioned_485 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.440..1.071 rows=766 loops=1)

494. 0.420 0.420 ↑ 85.0 16 1

Seq Scan on road_segments_partitioned_486 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.418..0.420 rows=16 loops=1)

495. 1.255 1.255 ↑ 1.1 1,258 1

Seq Scan on road_segments_partitioned_487 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.449..1.255 rows=1,258 loops=1)

496. 1.252 1.252 ↑ 1.0 1,852 1

Seq Scan on road_segments_partitioned_488 (cost=0.00..204.40 rows=1,904 width=16) (actual time=0.460..1.252 rows=1,852 loops=1)

497. 81.539 81.539 ↑ 1.0 278,594 1

Seq Scan on road_segments_partitioned_489 (cost=0.00..29,908.40 rows=278,594 width=16) (actual time=0.479..81.539 rows=278,594 loops=1)

498. 241.638 241.638 ↑ 1.0 767,598 1

Seq Scan on road_segments_partitioned_490 (cost=0.00..82,404.80 rows=767,598 width=16) (actual time=0.564..241.638 rows=767,598 loops=1)

499. 172.585 172.585 ↑ 1.0 472,251 1

Seq Scan on road_segments_partitioned_491 (cost=0.00..50,698.10 rows=472,251 width=16) (actual time=0.530..172.585 rows=472,251 loops=1)

500. 56.889 56.889 ↑ 1.0 191,702 1

Seq Scan on road_segments_partitioned_492 (cost=0.00..20,580.20 rows=191,702 width=16) (actual time=0.512..56.889 rows=191,702 loops=1)

501. 48.900 48.900 ↑ 1.0 156,629 1

Seq Scan on road_segments_partitioned_493 (cost=0.00..16,814.90 rows=156,629 width=16) (actual time=0.513..48.900 rows=156,629 loops=1)

502. 184.852 184.852 ↑ 1.0 548,922 1

Seq Scan on road_segments_partitioned_494 (cost=0.00..58,940.20 rows=549,032 width=16) (actual time=0.490..184.852 rows=548,922 loops=1)

503. 72.194 72.194 ↑ 1.0 242,830 1

Seq Scan on road_segments_partitioned_495 (cost=0.00..26,069.00 rows=242,830 width=16) (actual time=0.523..72.194 rows=242,830 loops=1)

504. 66.299 66.299 ↑ 1.0 462,591 1

Seq Scan on road_segments_partitioned_496 (cost=0.00..49,661.10 rows=462,591 width=16) (actual time=0.056..66.299 rows=462,591 loops=1)

505. 119.421 119.421 ↑ 1.0 379,309 1

Seq Scan on road_segments_partitioned_497 (cost=0.00..40,720.90 rows=379,309 width=16) (actual time=0.056..119.421 rows=379,309 loops=1)

506. 52.320 52.320 ↑ 1.0 168,047 1

Seq Scan on road_segments_partitioned_498 (cost=0.00..18,040.70 rows=168,047 width=16) (actual time=0.523..52.320 rows=168,047 loops=1)

507. 486.829 486.829 ↑ 1.0 1,474,632 1

Seq Scan on road_segments_partitioned_499 (cost=0.00..158,306.20 rows=1,474,632 width=16) (actual time=0.540..486.829 rows=1,474,632 loops=1)

508. 0.038 0.038 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_500 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.038..0.038 rows=0 loops=1)

509. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_501 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

510. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_502 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

511. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_503 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

512. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_504 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

513. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_505 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

514. 1.031 1.031 ↑ 2.5 542 1

Seq Scan on road_segments_partitioned_506 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.539..1.031 rows=542 loops=1)

515. 1.163 1.163 ↑ 1.3 1,073 1

Seq Scan on road_segments_partitioned_507 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.405..1.163 rows=1,073 loops=1)

516. 2.965 2.965 ↑ 1.0 7,527 1

Seq Scan on road_segments_partitioned_508 (cost=0.00..808.70 rows=7,527 width=16) (actual time=0.449..2.965 rows=7,527 loops=1)

517. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_509 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

518. 0.930 0.930 ↑ 3.0 453 1

Seq Scan on road_segments_partitioned_510 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.458..0.930 rows=453 loops=1)

519. 13.244 13.244 ↑ 1.0 32,165 1

Seq Scan on road_segments_partitioned_511 (cost=0.00..3,453.50 rows=32,165 width=16) (actual time=0.469..13.244 rows=32,165 loops=1)

520. 2.812 2.812 ↑ 1.0 6,490 1

Seq Scan on road_segments_partitioned_512 (cost=0.00..700.80 rows=6,528 width=16) (actual time=0.461..2.812 rows=6,490 loops=1)

521. 0.524 0.524 ↑ 13.6 100 1

Seq Scan on road_segments_partitioned_513 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.515..0.524 rows=100 loops=1)

522. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_514 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

523. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_515 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

524. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_516 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

525. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_517 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

526. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_518 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

527. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_519 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

528. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_520 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

529. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_521 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

530. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_522 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

531. 0.840 0.840 ↑ 3.5 393 1

Seq Scan on road_segments_partitioned_523 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.402..0.840 rows=393 loops=1)

532. 1.216 1.216 ↑ 1.5 888 1

Seq Scan on road_segments_partitioned_524 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.469..1.216 rows=888 loops=1)

533. 21.654 21.654 ↑ 1.0 75,129 1

Seq Scan on road_segments_partitioned_525 (cost=0.00..8,065.90 rows=75,129 width=16) (actual time=0.418..21.654 rows=75,129 loops=1)

534. 10.800 10.800 ↑ 1.0 73,452 1

Seq Scan on road_segments_partitioned_526 (cost=0.00..7,886.20 rows=73,452 width=16) (actual time=0.054..10.800 rows=73,452 loops=1)

535. 1.658 1.658 ↑ 1.0 2,854 1

Seq Scan on road_segments_partitioned_527 (cost=0.00..306.60 rows=2,856 width=16) (actual time=0.609..1.658 rows=2,854 loops=1)

536. 1.200 1.200 ↑ 1.1 1,246 1

Seq Scan on road_segments_partitioned_528 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.469..1.200 rows=1,246 loops=1)

537. 1.030 1.030 ↑ 2.7 498 1

Seq Scan on road_segments_partitioned_529 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.508..1.030 rows=498 loops=1)

538. 1.290 1.290 ↑ 1.1 1,908 1

Seq Scan on road_segments_partitioned_530 (cost=0.00..219.00 rows=2,040 width=16) (actual time=0.470..1.290 rows=1,908 loops=1)

539. 2.144 2.144 ↑ 1.0 6,114 1

Seq Scan on road_segments_partitioned_531 (cost=0.00..657.00 rows=6,120 width=16) (actual time=0.504..2.144 rows=6,114 loops=1)

540. 5.362 5.362 ↑ 1.0 15,546 1

Seq Scan on road_segments_partitioned_532 (cost=0.00..1,679.00 rows=15,640 width=16) (actual time=0.449..5.362 rows=15,546 loops=1)

541. 1.647 1.647 ↑ 1.0 2,892 1

Seq Scan on road_segments_partitioned_533 (cost=0.00..321.20 rows=2,992 width=16) (actual time=0.497..1.647 rows=2,892 loops=1)

542. 41.567 41.567 ↑ 1.0 129,119 1

Seq Scan on road_segments_partitioned_534 (cost=0.00..13,861.90 rows=129,119 width=16) (actual time=0.476..41.567 rows=129,119 loops=1)

543. 140.439 140.439 ↑ 1.0 429,849 1

Seq Scan on road_segments_partitioned_535 (cost=0.00..46,145.90 rows=429,849 width=16) (actual time=0.564..140.439 rows=429,849 loops=1)

544. 24.765 24.765 ↑ 1.0 68,230 1

Seq Scan on road_segments_partitioned_536 (cost=0.00..7,329.20 rows=68,272 width=16) (actual time=0.502..24.765 rows=68,230 loops=1)

545. 28.374 28.374 ↑ 1.0 87,007 1

Seq Scan on road_segments_partitioned_537 (cost=0.00..9,340.70 rows=87,007 width=16) (actual time=0.540..28.374 rows=87,007 loops=1)

546. 1.112 1.112 ↑ 1.9 715 1

Seq Scan on road_segments_partitioned_538 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.438..1.112 rows=715 loops=1)

547. 225.735 225.735 ↑ 1.0 679,176 1

Seq Scan on road_segments_partitioned_539 (cost=0.00..72,912.40 rows=679,184 width=16) (actual time=0.026..225.735 rows=679,176 loops=1)

548. 50.253 50.253 ↑ 1.0 182,016 1

Seq Scan on road_segments_partitioned_540 (cost=0.00..19,540.60 rows=182,016 width=16) (actual time=0.462..50.253 rows=182,016 loops=1)

549. 172.060 172.060 ↑ 1.0 536,271 1

Seq Scan on road_segments_partitioned_541 (cost=0.00..57,571.10 rows=536,271 width=16) (actual time=0.469..172.060 rows=536,271 loops=1)

550. 15.778 15.778 ↑ 1.0 49,345 1

Seq Scan on road_segments_partitioned_542 (cost=0.00..5,297.50 rows=49,345 width=16) (actual time=0.505..15.778 rows=49,345 loops=1)

551. 0.032 0.032 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_543 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.032..0.032 rows=0 loops=1)

552. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_544 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

553. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_545 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

554. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_546 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

555. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_547 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.009 rows=0 loops=1)

556. 1.176 1.176 ↑ 1.0 1,446 1

Seq Scan on road_segments_partitioned_548 (cost=0.00..160.60 rows=1,496 width=16) (actual time=0.500..1.176 rows=1,446 loops=1)

557. 4.367 4.367 ↑ 1.0 15,311 1

Seq Scan on road_segments_partitioned_549 (cost=0.00..1,649.80 rows=15,368 width=16) (actual time=0.441..4.367 rows=15,311 loops=1)

558. 1.333 1.333 ↑ 1.0 1,555 1

Seq Scan on road_segments_partitioned_550 (cost=0.00..175.20 rows=1,632 width=16) (actual time=0.525..1.333 rows=1,555 loops=1)

559. 0.974 0.974 ↑ 3.3 417 1

Seq Scan on road_segments_partitioned_551 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.499..0.974 rows=417 loops=1)

560. 2.113 2.113 ↑ 1.0 4,622 1

Seq Scan on road_segments_partitioned_552 (cost=0.00..496.40 rows=4,624 width=16) (actual time=0.498..2.113 rows=4,622 loops=1)

561. 5.817 5.817 ↑ 1.0 37,678 1

Seq Scan on road_segments_partitioned_553 (cost=0.00..4,045.80 rows=37,678 width=16) (actual time=0.046..5.817 rows=37,678 loops=1)

562. 4.812 4.812 ↑ 1.0 32,024 1

Seq Scan on road_segments_partitioned_554 (cost=0.00..3,438.40 rows=32,024 width=16) (actual time=0.060..4.812 rows=32,024 loops=1)

563. 1.203 1.203 ↑ 4.9 280 1

Seq Scan on road_segments_partitioned_555 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.647..1.203 rows=280 loops=1)

564. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_556 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.019..0.019 rows=0 loops=1)

565. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_557 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

566. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_558 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

567. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_559 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

568. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_560 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.012..0.012 rows=0 loops=1)

569. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_561 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

570. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_562 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

571. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_563 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

572. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_564 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

573. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_565 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

574. 1.044 1.044 ↑ 2.3 584 1

Seq Scan on road_segments_partitioned_566 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.463..1.044 rows=584 loops=1)

575. 13.264 13.264 ↑ 1.0 87,865 1

Seq Scan on road_segments_partitioned_567 (cost=0.00..9,433.50 rows=87,865 width=16) (actual time=0.027..13.264 rows=87,865 loops=1)

576. 12.206 12.206 ↑ 1.0 83,008 1

Seq Scan on road_segments_partitioned_568 (cost=0.00..8,920.60 rows=83,096 width=16) (actual time=0.054..12.206 rows=83,008 loops=1)

577. 2.115 2.115 ↑ 1.0 4,176 1

Seq Scan on road_segments_partitioned_569 (cost=0.00..452.60 rows=4,216 width=16) (actual time=0.665..2.115 rows=4,176 loops=1)

578. 1.992 1.992 ↑ 1.0 2,480 1

Seq Scan on road_segments_partitioned_570 (cost=0.00..277.40 rows=2,584 width=16) (actual time=0.430..1.992 rows=2,480 loops=1)

579. 1.213 1.213 ↑ 1.2 1,092 1

Seq Scan on road_segments_partitioned_571 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.499..1.213 rows=1,092 loops=1)

580. 0.493 0.493 ↑ 9.1 150 1

Seq Scan on road_segments_partitioned_572 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.472..0.493 rows=150 loops=1)

581. 1.317 1.317 ↑ 1.1 1,204 1

Seq Scan on road_segments_partitioned_573 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.467..1.317 rows=1,204 loops=1)

582. 12.678 12.678 ↑ 1.0 25,820 1

Seq Scan on road_segments_partitioned_574 (cost=0.00..2,774.00 rows=25,840 width=16) (actual time=0.520..12.678 rows=25,820 loops=1)

583. 2.535 2.535 ↑ 1.0 6,940 1

Seq Scan on road_segments_partitioned_575 (cost=0.00..759.20 rows=7,072 width=16) (actual time=0.550..2.535 rows=6,940 loops=1)

584. 1.186 1.186 ↑ 2.0 683 1

Seq Scan on road_segments_partitioned_576 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.509..1.186 rows=683 loops=1)

585. 7.749 7.749 ↑ 1.0 29,812 1

Seq Scan on road_segments_partitioned_577 (cost=0.00..3,212.00 rows=29,920 width=16) (actual time=0.453..7.749 rows=29,812 loops=1)

586. 184.993 184.993 ↑ 1.0 559,505 1

Seq Scan on road_segments_partitioned_578 (cost=0.00..60,065.50 rows=559,505 width=16) (actual time=0.508..184.993 rows=559,505 loops=1)

587. 122.797 122.797 ↑ 1.0 431,591 1

Seq Scan on road_segments_partitioned_579 (cost=0.00..46,340.40 rows=431,664 width=16) (actual time=0.509..122.797 rows=431,591 loops=1)

588. 1.492 1.492 ↑ 1.1 1,801 1

Seq Scan on road_segments_partitioned_580 (cost=0.00..204.40 rows=1,904 width=16) (actual time=0.577..1.492 rows=1,801 loops=1)

589. 24.595 24.595 ↑ 1.0 183,952 1

Seq Scan on road_segments_partitioned_581 (cost=0.00..19,748.20 rows=183,952 width=16) (actual time=0.024..24.595 rows=183,952 loops=1)

590. 236.014 236.014 ↑ 1.0 1,613,644 1

Seq Scan on road_segments_partitioned_582 (cost=0.00..173,230.40 rows=1,613,644 width=16) (actual time=0.054..236.014 rows=1,613,644 loops=1)

591. 10.046 10.046 ↑ 1.0 30,006 1

Seq Scan on road_segments_partitioned_583 (cost=0.00..3,226.60 rows=30,056 width=16) (actual time=0.652..10.046 rows=30,006 loops=1)

592. 259.221 259.221 ↑ 1.0 820,868 1

Seq Scan on road_segments_partitioned_584 (cost=0.00..88,122.80 rows=820,868 width=16) (actual time=0.483..259.221 rows=820,868 loops=1)

593. 233.766 233.766 ↑ 1.0 753,953 1

Seq Scan on road_segments_partitioned_585 (cost=0.00..80,939.30 rows=753,953 width=16) (actual time=0.485..233.766 rows=753,953 loops=1)

594. 0.032 0.032 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_586 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.032..0.032 rows=0 loops=1)

595. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_587 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

596. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_588 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

597. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_589 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

598. 4.574 4.574 ↑ 1.0 12,078 1

Seq Scan on road_segments_partitioned_590 (cost=0.00..1,296.80 rows=12,078 width=16) (actual time=0.428..4.574 rows=12,078 loops=1)

599. 0.654 0.654 ↑ 34.0 40 1

Seq Scan on road_segments_partitioned_591 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.650..0.654 rows=40 loops=1)

600. 0.447 0.447 ↑ 151.1 9 1

Seq Scan on road_segments_partitioned_592 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.446..0.447 rows=9 loops=1)

601. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_593 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

602. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_594 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

603. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_595 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

604. 5.701 5.701 ↑ 1.0 19,250 1

Seq Scan on road_segments_partitioned_596 (cost=0.00..2,073.20 rows=19,312 width=16) (actual time=0.473..5.701 rows=19,250 loops=1)

605. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_597 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.016..0.016 rows=0 loops=1)

606. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_598 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.017..0.017 rows=0 loops=1)

607. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_599 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

608. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_600 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

609. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_601 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

610. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_602 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.009 rows=0 loops=1)

611. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_603 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

612. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_604 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

613. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_605 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

614. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_606 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

615. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_607 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

616. 0.516 0.516 ↑ 6.8 199 1

Seq Scan on road_segments_partitioned_608 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.487..0.516 rows=199 loops=1)

617. 24.541 24.541 ↑ 1.0 77,957 1

Seq Scan on road_segments_partitioned_609 (cost=0.00..8,380.40 rows=78,064 width=16) (actual time=0.736..24.541 rows=77,957 loops=1)

618. 98.248 98.248 ↑ 1.0 324,809 1

Seq Scan on road_segments_partitioned_610 (cost=0.00..34,869.90 rows=324,809 width=16) (actual time=0.560..98.248 rows=324,809 loops=1)

619. 1.102 1.102 ↑ 4.4 311 1

Seq Scan on road_segments_partitioned_611 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.573..1.102 rows=311 loops=1)

620. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_612 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

621. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_613 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.016..0.017 rows=0 loops=1)

622. 0.430 0.430 ↑ 18.9 72 1

Seq Scan on road_segments_partitioned_614 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.422..0.430 rows=72 loops=1)

623. 2.057 2.057 ↑ 1.0 4,588 1

Seq Scan on road_segments_partitioned_615 (cost=0.00..496.40 rows=4,624 width=16) (actual time=0.446..2.057 rows=4,588 loops=1)

624. 2.731 2.731 ↑ 1.0 8,271 1

Seq Scan on road_segments_partitioned_616 (cost=0.00..890.60 rows=8,296 width=16) (actual time=0.504..2.731 rows=8,271 loops=1)

625. 1.097 1.097 ↑ 2.1 648 1

Seq Scan on road_segments_partitioned_617 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.448..1.097 rows=648 loops=1)

626. 0.520 0.520 ↑ 6.5 210 1

Seq Scan on road_segments_partitioned_618 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.479..0.520 rows=210 loops=1)

627. 2.509 2.509 ↑ 1.0 6,349 1

Seq Scan on road_segments_partitioned_619 (cost=0.00..686.20 rows=6,392 width=16) (actual time=0.470..2.509 rows=6,349 loops=1)

628. 11.419 11.419 ↑ 1.0 35,181 1

Seq Scan on road_segments_partitioned_620 (cost=0.00..3,781.40 rows=35,224 width=16) (actual time=0.502..11.419 rows=35,181 loops=1)

629. 448.613 448.613 ↑ 1.0 1,359,939 1

Seq Scan on road_segments_partitioned_621 (cost=0.00..145,993.90 rows=1,359,939 width=16) (actual time=0.548..448.613 rows=1,359,939 loops=1)

630. 156.313 156.313 ↑ 1.0 520,764 1

Seq Scan on road_segments_partitioned_622 (cost=0.00..55,906.40 rows=520,764 width=16) (actual time=0.475..156.313 rows=520,764 loops=1)

631. 159.018 159.018 ↑ 1.0 516,096 1

Seq Scan on road_segments_partitioned_623 (cost=0.00..55,404.60 rows=516,096 width=16) (actual time=0.465..159.018 rows=516,096 loops=1)

632. 737.680 737.680 ↑ 1.0 2,261,820 1

Seq Scan on road_segments_partitioned_624 (cost=0.00..242,814.00 rows=2,261,820 width=16) (actual time=0.526..737.680 rows=2,261,820 loops=1)

633. 252.775 252.775 ↑ 1.0 808,573 1

Seq Scan on road_segments_partitioned_625 (cost=0.00..86,803.30 rows=808,573 width=16) (actual time=0.513..252.775 rows=808,573 loops=1)

634. 474.888 474.888 ↑ 1.0 1,453,322 1

Seq Scan on road_segments_partitioned_626 (cost=0.00..156,019.20 rows=1,453,322 width=16) (actual time=0.480..474.888 rows=1,453,322 loops=1)

635. 392.786 392.786 ↑ 1.0 1,234,667 1

Seq Scan on road_segments_partitioned_627 (cost=0.00..132,545.70 rows=1,234,667 width=16) (actual time=0.662..392.786 rows=1,234,667 loops=1)

636. 81.832 81.832 ↑ 1.0 272,293 1

Seq Scan on road_segments_partitioned_628 (cost=0.00..29,232.30 rows=272,293 width=16) (actual time=0.855..81.832 rows=272,293 loops=1)

637. 0.038 0.038 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_629 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.037..0.038 rows=0 loops=1)

638. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_630 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

639. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_631 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.016..0.016 rows=0 loops=1)

640. 16.171 16.171 ↑ 1.0 52,244 1

Seq Scan on road_segments_partitioned_632 (cost=0.00..5,609.40 rows=52,244 width=16) (actual time=0.488..16.171 rows=52,244 loops=1)

641. 0.031 0.031 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_633 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.031..0.031 rows=0 loops=1)

642. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_634 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.011..0.011 rows=0 loops=1)

643. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_635 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

644. 0.023 0.023 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_636 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.023..0.023 rows=0 loops=1)

645. 5.219 5.219 ↑ 1.0 15,921 1

Seq Scan on road_segments_partitioned_637 (cost=0.00..1,710.10 rows=15,921 width=16) (actual time=0.462..5.219 rows=15,921 loops=1)

646. 11.378 11.378 ↑ 1.0 7,693 1

Seq Scan on road_segments_partitioned_638 (cost=0.00..832.20 rows=7,752 width=16) (actual time=0.446..11.378 rows=7,693 loops=1)

647. 0.026 0.026 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_639 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.026..0.026 rows=0 loops=1)

648. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_640 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

649. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_641 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

650. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_642 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

651. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_643 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

652. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_644 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

653. 0.493 0.493 ↑ 13.6 100 1

Seq Scan on road_segments_partitioned_645 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.484..0.493 rows=100 loops=1)

654. 1.247 1.247 ↑ 1.0 800 1

Seq Scan on road_segments_partitioned_646 (cost=0.00..86.00 rows=800 width=16) (actual time=0.482..1.247 rows=800 loops=1)

655. 1.103 1.103 ↑ 1.1 1,200 1

Seq Scan on road_segments_partitioned_647 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.479..1.103 rows=1,200 loops=1)

656. 1.022 1.022 ↑ 3.1 440 1

Seq Scan on road_segments_partitioned_648 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.513..1.022 rows=440 loops=1)

657. 1.666 1.666 ↑ 1.0 2,345 1

Seq Scan on road_segments_partitioned_649 (cost=0.00..262.80 rows=2,448 width=16) (actual time=0.452..1.666 rows=2,345 loops=1)

658. 1.979 1.979 ↑ 1.0 3,979 1

Seq Scan on road_segments_partitioned_650 (cost=0.00..427.90 rows=3,979 width=16) (actual time=0.482..1.979 rows=3,979 loops=1)

659. 55.536 55.536 ↑ 1.0 160,905 1

Seq Scan on road_segments_partitioned_651 (cost=0.00..17,274.50 rows=160,905 width=16) (actual time=0.473..55.536 rows=160,905 loops=1)

660. 0.535 0.535 ↑ 8.0 169 1

Seq Scan on road_segments_partitioned_652 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.512..0.535 rows=169 loops=1)

661. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_653 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

662. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_654 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

663. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_655 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

664. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_656 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.008..0.008 rows=0 loops=1)

665. 2.753 2.753 ↑ 1.0 1,601 1

Seq Scan on road_segments_partitioned_657 (cost=0.00..175.20 rows=1,632 width=16) (actual time=0.456..2.753 rows=1,601 loops=1)

666. 3.241 3.241 ↑ 1.0 8,041 1

Seq Scan on road_segments_partitioned_658 (cost=0.00..876.00 rows=8,160 width=16) (actual time=0.654..3.241 rows=8,041 loops=1)

667. 1.996 1.996 ↑ 1.0 4,884 1

Seq Scan on road_segments_partitioned_659 (cost=0.00..525.60 rows=4,896 width=16) (actual time=0.468..1.996 rows=4,884 loops=1)

668. 2.417 2.417 ↑ 1.0 5,238 1

Seq Scan on road_segments_partitioned_660 (cost=0.00..569.40 rows=5,304 width=16) (actual time=0.477..2.417 rows=5,238 loops=1)

669. 6.398 6.398 ↑ 1.0 21,902 1

Seq Scan on road_segments_partitioned_661 (cost=0.00..2,365.20 rows=22,032 width=16) (actual time=0.267..6.398 rows=21,902 loops=1)

670. 1.588 1.588 ↑ 1.0 2,539 1

Seq Scan on road_segments_partitioned_662 (cost=0.00..277.40 rows=2,584 width=16) (actual time=0.461..1.588 rows=2,539 loops=1)

671. 2.708 2.708 ↑ 1.0 6,638 1

Seq Scan on road_segments_partitioned_663 (cost=0.00..715.40 rows=6,664 width=16) (actual time=0.489..2.708 rows=6,638 loops=1)

672. 337.041 337.041 ↑ 1.0 1,025,347 1

Seq Scan on road_segments_partitioned_664 (cost=0.00..110,074.70 rows=1,025,347 width=16) (actual time=0.547..337.041 rows=1,025,347 loops=1)

673. 76.863 76.863 ↑ 1.0 217,233 1

Seq Scan on road_segments_partitioned_665 (cost=0.00..23,321.30 rows=217,233 width=16) (actual time=0.067..76.863 rows=217,233 loops=1)

674. 1.366 1.366 ↑ 1.1 1,549 1

Seq Scan on road_segments_partitioned_666 (cost=0.00..175.20 rows=1,632 width=16) (actual time=0.494..1.366 rows=1,549 loops=1)

675. 240.656 240.656 ↑ 1.0 729,890 1

Seq Scan on road_segments_partitioned_667 (cost=0.00..78,356.00 rows=729,890 width=16) (actual time=0.448..240.656 rows=729,890 loops=1)

676. 233.933 233.933 ↑ 1.0 753,641 1

Seq Scan on road_segments_partitioned_668 (cost=0.00..80,906.10 rows=753,641 width=16) (actual time=0.538..233.933 rows=753,641 loops=1)

677. 96.977 96.977 ↑ 1.0 324,112 1

Seq Scan on road_segments_partitioned_669 (cost=0.00..34,795.20 rows=324,112 width=16) (actual time=0.456..96.977 rows=324,112 loops=1)

678. 1,082.266 1,082.266 ↑ 1.0 3,144,907 1

Seq Scan on road_segments_partitioned_670 (cost=0.00..337,615.70 rows=3,144,907 width=16) (actual time=0.557..1,082.266 rows=3,144,907 loops=1)

679. 318.436 318.436 ↑ 1.0 1,014,771 1

Seq Scan on road_segments_partitioned_671 (cost=0.00..108,939.10 rows=1,014,771 width=16) (actual time=0.575..318.436 rows=1,014,771 loops=1)

680. 0.039 0.039 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_672 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.039..0.039 rows=0 loops=1)

681. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_673 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.012..0.012 rows=0 loops=1)

682. 10.095 10.095 ↑ 1.0 33,504 1

Seq Scan on road_segments_partitioned_674 (cost=0.00..3,606.20 rows=33,592 width=16) (actual time=0.456..10.095 rows=33,504 loops=1)

683. 0.480 0.480 ↑ 90.7 15 1

Seq Scan on road_segments_partitioned_675 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.478..0.480 rows=15 loops=1)

684. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_676 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

685. 0.407 0.407 ↑ 61.8 22 1

Seq Scan on road_segments_partitioned_677 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.405..0.407 rows=22 loops=1)

686. 0.475 0.475 ↑ 75.6 18 1

Seq Scan on road_segments_partitioned_678 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.473..0.475 rows=18 loops=1)

687. 9.983 9.983 ↑ 1.0 27,660 1

Seq Scan on road_segments_partitioned_679 (cost=0.00..2,978.40 rows=27,744 width=16) (actual time=0.406..9.983 rows=27,660 loops=1)

688. 1.185 1.185 ↑ 2.0 682 1

Seq Scan on road_segments_partitioned_680 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.486..1.185 rows=682 loops=1)

689. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_681 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.021..0.021 rows=0 loops=1)

690. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_682 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

691. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_683 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.014 rows=0 loops=1)

692. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_684 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

693. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_685 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

694. 1.044 1.044 ↑ 2.3 600 1

Seq Scan on road_segments_partitioned_686 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.449..1.044 rows=600 loops=1)

695. 1.138 1.138 ↑ 1.0 1,340 1

Seq Scan on road_segments_partitioned_687 (cost=0.00..144.00 rows=1,340 width=16) (actual time=0.456..1.138 rows=1,340 loops=1)

696. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_688 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

697. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_689 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

698. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_690 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

699. 0.937 0.937 ↑ 3.8 360 1

Seq Scan on road_segments_partitioned_691 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.483..0.937 rows=360 loops=1)

700. 1.109 1.109 ↑ 1.6 857 1

Seq Scan on road_segments_partitioned_692 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.434..1.109 rows=857 loops=1)

701. 30.014 30.014 ↑ 1.0 98,544 1

Seq Scan on road_segments_partitioned_693 (cost=0.00..10,585.00 rows=98,600 width=16) (actual time=0.436..30.014 rows=98,544 loops=1)

702. 0.918 0.918 ↑ 3.3 410 1

Seq Scan on road_segments_partitioned_694 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.473..0.918 rows=410 loops=1)

703. 0.444 0.444 ↑ 34.9 39 1

Seq Scan on road_segments_partitioned_695 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.440..0.444 rows=39 loops=1)

704. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_696 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.013..0.013 rows=0 loops=1)

705. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_697 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

706. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_698 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

707. 1.925 1.925 ↑ 1.0 4,623 1

Seq Scan on road_segments_partitioned_699 (cost=0.00..496.40 rows=4,624 width=16) (actual time=0.527..1.925 rows=4,623 loops=1)

708. 1.541 1.541 ↑ 1.0 2,860 1

Seq Scan on road_segments_partitioned_700 (cost=0.00..321.20 rows=2,992 width=16) (actual time=0.441..1.541 rows=2,860 loops=1)

709. 1.605 1.605 ↑ 1.0 2,505 1

Seq Scan on road_segments_partitioned_701 (cost=0.00..277.40 rows=2,584 width=16) (actual time=0.555..1.605 rows=2,505 loops=1)

710. 0.527 0.527 ↑ 6.9 197 1

Seq Scan on road_segments_partitioned_702 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.502..0.527 rows=197 loops=1)

711. 2.946 2.946 ↑ 1.0 8,633 1

Seq Scan on road_segments_partitioned_703 (cost=0.00..934.40 rows=8,704 width=16) (actual time=0.400..2.946 rows=8,633 loops=1)

712. 2.243 2.243 ↑ 1.0 3,925 1

Seq Scan on road_segments_partitioned_704 (cost=0.00..423.40 rows=3,944 width=16) (actual time=0.455..2.243 rows=3,925 loops=1)

713. 1.784 1.784 ↑ 1.0 3,612 1

Seq Scan on road_segments_partitioned_705 (cost=0.00..394.20 rows=3,672 width=16) (actual time=0.425..1.784 rows=3,612 loops=1)

714. 240.497 240.497 ↑ 1.0 677,642 1

Seq Scan on road_segments_partitioned_706 (cost=0.00..72,747.20 rows=677,642 width=16) (actual time=0.029..240.497 rows=677,642 loops=1)

715. 327.251 327.251 ↑ 1.0 922,944 1

Seq Scan on road_segments_partitioned_707 (cost=0.00..99,081.40 rows=922,944 width=16) (actual time=0.063..327.251 rows=922,944 loops=1)

716. 112.208 112.208 ↑ 1.0 354,528 1

Seq Scan on road_segments_partitioned_708 (cost=0.00..38,059.80 rows=354,528 width=16) (actual time=0.588..112.208 rows=354,528 loops=1)

717. 245.410 245.410 ↑ 1.0 777,189 1

Seq Scan on road_segments_partitioned_709 (cost=0.00..83,433.90 rows=777,189 width=16) (actual time=0.473..245.410 rows=777,189 loops=1)

718. 455.940 455.940 ↑ 1.0 1,416,569 1

Seq Scan on road_segments_partitioned_710 (cost=0.00..152,072.90 rows=1,416,569 width=16) (actual time=0.483..455.940 rows=1,416,569 loops=1)

719. 84.916 84.916 ↑ 1.0 279,039 1

Seq Scan on road_segments_partitioned_711 (cost=0.00..29,955.90 rows=279,039 width=16) (actual time=0.587..84.916 rows=279,039 loops=1)

720. 924.942 924.942 ↑ 1.0 2,731,902 1

Seq Scan on road_segments_partitioned_712 (cost=0.00..293,278.20 rows=2,731,902 width=16) (actual time=0.573..924.942 rows=2,731,902 loops=1)

721. 3,232.635 3,232.635 ↓ 1.0 9,580,356 1

Seq Scan on road_segments_partitioned_713 (cost=0.00..1,028,475.80 rows=9,580,318 width=16) (actual time=0.538..3,232.635 rows=9,580,356 loops=1)

722. 0.033 0.033 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_714 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.033..0.033 rows=0 loops=1)

723. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_715 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

724. 0.550 0.550 ↑ 226.7 6 1

Seq Scan on road_segments_partitioned_716 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.549..0.550 rows=6 loops=1)

725. 9.527 9.527 ↑ 1.0 28,724 1

Seq Scan on road_segments_partitioned_717 (cost=0.00..3,084.40 rows=28,724 width=16) (actual time=0.409..9.527 rows=28,724 loops=1)

726. 0.513 0.513 ↑ 27.2 50 1

Seq Scan on road_segments_partitioned_718 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.509..0.513 rows=50 loops=1)

727. 0.536 0.536 ↑ 97.1 14 1

Seq Scan on road_segments_partitioned_719 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.535..0.536 rows=14 loops=1)

728. 20.335 20.335 ↑ 1.0 63,574 1

Seq Scan on road_segments_partitioned_720 (cost=0.00..6,832.80 rows=63,648 width=16) (actual time=0.415..20.335 rows=63,574 loops=1)

729. 2.934 2.934 ↑ 1.0 4,768 1

Seq Scan on road_segments_partitioned_721 (cost=0.00..512.80 rows=4,768 width=16) (actual time=0.494..2.934 rows=4,768 loops=1)

730. 1.826 1.826 ↑ 1.1 2,197 1

Seq Scan on road_segments_partitioned_722 (cost=0.00..248.20 rows=2,312 width=16) (actual time=0.492..1.826 rows=2,197 loops=1)

731. 0.984 0.984 ↑ 1.6 861 1

Seq Scan on road_segments_partitioned_723 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.413..0.984 rows=861 loops=1)

732. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_724 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.015..0.015 rows=0 loops=1)

733. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_725 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

734. 0.892 0.892 ↑ 3.4 400 1

Seq Scan on road_segments_partitioned_726 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.414..0.892 rows=400 loops=1)

735. 1.215 1.215 ↑ 1.0 1,360 1

Seq Scan on road_segments_partitioned_727 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.469..1.215 rows=1,360 loops=1)

736. 1.046 1.046 ↑ 1.0 700 1

Seq Scan on road_segments_partitioned_728 (cost=0.00..76.00 rows=700 width=16) (actual time=0.450..1.046 rows=700 loops=1)

737. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_729 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

738. 0.024 0.024 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_730 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.024..0.024 rows=0 loops=1)

739. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_731 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.010..0.010 rows=0 loops=1)

740. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_732 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

741. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_733 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

742. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_734 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

743. 15.593 15.593 ↑ 1.0 51,446 1

Seq Scan on road_segments_partitioned_735 (cost=0.00..5,523.60 rows=51,446 width=16) (actual time=0.472..15.593 rows=51,446 loops=1)

744. 10.645 10.645 ↑ 1.0 30,409 1

Seq Scan on road_segments_partitioned_736 (cost=0.00..3,270.40 rows=30,464 width=16) (actual time=0.523..10.645 rows=30,409 loops=1)

745. 1.235 1.235 ↑ 1.6 825 1

Seq Scan on road_segments_partitioned_737 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.548..1.235 rows=825 loops=1)

746. 0.461 0.461 ↑ 45.3 30 1

Seq Scan on road_segments_partitioned_738 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.458..0.461 rows=30 loops=1)

747. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_739 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.014..0.014 rows=0 loops=1)

748. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on road_segments_partitioned_740 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.009..0.009 rows=0 loops=1)

749. 1.905 1.905 ↑ 1.0 2,024 1

Seq Scan on road_segments_partitioned_741 (cost=0.00..219.00 rows=2,040 width=16) (actual time=0.465..1.905 rows=2,024 loops=1)

750. 0.493 0.493 ↑ 21.9 62 1

Seq Scan on road_segments_partitioned_742 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.488..0.493 rows=62 loops=1)

751. 0.521 0.521 ↑ 6.0 225 1

Seq Scan on road_segments_partitioned_743 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.452..0.521 rows=225 loops=1)

752. 0.967 0.967 ↑ 4.3 318 1

Seq Scan on road_segments_partitioned_744 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.516..0.967 rows=318 loops=1)

753. 1.291 1.291 ↑ 1.1 1,290 1

Seq Scan on road_segments_partitioned_745 (cost=0.00..146.00 rows=1,360 width=16) (actual time=0.511..1.291 rows=1,290 loops=1)

754. 4.483 4.483 ↑ 1.0 13,732 1

Seq Scan on road_segments_partitioned_746 (cost=0.00..1,474.60 rows=13,736 width=16) (actual time=0.486..4.483 rows=13,732