explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4qaI

Settings
# exclusive inclusive rows x rows loops node
1. 5,054.932 11,671.700 ↑ 250.6 6,946 1

Gather (cost=10,540.00..358,232.13 rows=1,740,970 width=226) (actual time=11,026.178..11,671.700 rows=6,946 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
  • Functions: 18360
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 6854.875 ms, Inlining 0.000 ms, Optimization 955.698 ms, Emission 19184.272 ms, Total 26994.844 ms"Execution Time: 17935.360 ms
2. 73.428 6,616.768 ↑ 323.5 1,736 4 / 4

Parallel Hash Join (cost=9,540.00..183,135.13 rows=561,603 width=226) (actual time=6,498.268..6,616.768 rows=1,736 loops=4)

  • Hash Cond: (a_1209.link_id = b_1209.link_id)
3. 44.014 564.549 ↓ 3.6 217,777 4 / 4

Parallel Append (cost=0.28..71,856.47 rows=60,165 width=226) (actual time=0.826..564.549 rows=217,777 loops=4)

4. 38.395 38.395 ↓ 28.0 69,651 1 / 4

Parallel Index Only Scan using road_network_partitioned2_12_link_id_street_name_road_km__idx10 on road_network_partitioned2_1209 a_1209 (cost=0.41..2,699.89 rows=2,485 width=226) (actual time=0.111..153.578 rows=69,651 loops=1)

  • Heap Fetches: 69651
5. 28.698 28.698 ↓ 14.6 42,965 1 / 4

Parallel Index Scan using road_network_partitioned2_1047_pkey on road_network_partitioned2_1047 a_1047 (cost=0.28..1,798.59 rows=2,935 width=226) (actual time=0.074..114.793 rows=42,965 loops=1)

6. 18.021 18.021 ↓ 13.5 34,047 1 / 4

Parallel Index Scan using road_network_partitioned2_797_pkey on road_network_partitioned2_797 a_797 (cost=0.28..1,530.38 rows=2,529 width=226) (actual time=0.036..72.086 rows=34,047 loops=1)

7. 13.368 13.368 ↓ 14.3 31,667 1 / 4

Parallel Index Scan using road_network_partitioned2_928_pkey on road_network_partitioned2_928 a_928 (cost=0.28..1,355.00 rows=2,218 width=226) (actual time=0.029..53.474 rows=31,667 loops=1)

8. 16.288 16.288 ↓ 20.1 31,075 1 / 4

Parallel Index Only Scan using road_network_partitioned2_107_link_id_street_name_road_km__idx8 on road_network_partitioned2_1077 a_1077 (cost=0.28..1,342.05 rows=1,548 width=226) (actual time=0.069..65.153 rows=31,075 loops=1)

  • Heap Fetches: 31075
9. 15.662 15.662 ↓ 19.3 25,516 1 / 4

Parallel Index Only Scan using road_network_partitioned2_755_link_id_street_name_road_km_r_idx on road_network_partitioned2_755 a_755 (cost=0.28..1,138.19 rows=1,319 width=226) (actual time=0.086..62.646 rows=25,516 loops=1)

  • Heap Fetches: 25516
10. 9.236 9.236 ↓ 10.4 12,521 1 / 4

Parallel Index Scan using road_network_partitioned2_1210_pkey on road_network_partitioned2_1210 a_1210 (cost=0.28..724.15 rows=1,209 width=226) (actual time=0.028..36.946 rows=12,521 loops=1)

11. 6.618 6.618 ↓ 13.4 15,065 1 / 4

Parallel Index Scan using road_network_partitioned2_1208_pkey on road_network_partitioned2_1208 a_1208 (cost=0.28..677.49 rows=1,121 width=226) (actual time=0.028..26.473 rows=15,065 loops=1)

12. 2.285 2.285 ↓ 9.5 10,585 1 / 4

Parallel Index Scan using road_network_partitioned2_839_pkey on road_network_partitioned2_839 a_839 (cost=0.28..664.90 rows=1,118 width=226) (actual time=0.046..9.142 rows=10,585 loops=1)

13. 9.846 9.846 ↓ 10.7 10,842 1 / 4

Parallel Index Scan using road_network_partitioned2_1421_pkey on road_network_partitioned2_1421 a_1421 (cost=0.28..613.30 rows=1,015 width=226) (actual time=0.035..39.384 rows=10,842 loops=1)

14. 5.127 5.127 ↓ 12.8 12,191 1 / 4

Parallel Index Scan using road_network_partitioned2_1166_pkey on road_network_partitioned2_1166 a_1166 (cost=0.28..582.36 rows=950 width=226) (actual time=0.025..20.506 rows=12,191 loops=1)

15. 9.621 9.621 ↓ 12.6 11,954 1 / 4

Parallel Index Scan using road_network_partitioned2_796_pkey on road_network_partitioned2_796 a_796 (cost=0.28..580.36 rows=950 width=226) (actual time=0.037..38.485 rows=11,954 loops=1)

16. 4.081 4.081 ↓ 11.2 10,144 1 / 4

Parallel Index Scan using road_network_partitioned2_1087_pkey on road_network_partitioned2_1087 a_1087 (cost=0.28..543.94 rows=903 width=226) (actual time=0.030..16.325 rows=10,144 loops=1)

17. 5.119 5.119 ↓ 9.5 8,419 1 / 4

Parallel Index Scan using road_network_partitioned2_1012_pkey on road_network_partitioned2_1012 a_1012 (cost=0.28..516.82 rows=882 width=226) (actual time=0.042..20.477 rows=8,419 loops=1)

18. 3.393 3.393 ↓ 12.0 10,083 1 / 4

Parallel Index Scan using road_network_partitioned2_1167_pkey on road_network_partitioned2_1167 a_1167 (cost=0.28..505.58 rows=841 width=226) (actual time=0.041..13.574 rows=10,083 loops=1)

19. 1.955 1.955 ↓ 10.2 8,792 1 / 4

Parallel Index Scan using road_network_partitioned2_1336_pkey on road_network_partitioned2_1336 a_1336 (cost=0.28..504.12 rows=859 width=226) (actual time=0.047..7.820 rows=8,792 loops=1)

20. 1.759 1.759 ↓ 9.4 7,949 1 / 4

Parallel Index Scan using road_network_partitioned2_881_pkey on road_network_partitioned2_881 a_881 (cost=0.28..495.17 rows=844 width=226) (actual time=0.038..7.036 rows=7,949 loops=1)

21. 5.939 5.939 ↓ 10.1 7,610 1 / 4

Parallel Index Scan using road_network_partitioned2_1337_pkey on road_network_partitioned2_1337 a_1337 (cost=0.28..445.93 rows=753 width=226) (actual time=2.151..23.756 rows=7,610 loops=1)

22. 4.099 4.099 ↓ 12.3 9,135 1 / 4

Parallel Index Scan using road_network_partitioned2_713_pkey on road_network_partitioned2_713 a_713 (cost=0.28..445.16 rows=744 width=226) (actual time=0.033..16.396 rows=9,135 loops=1)

23. 3.674 3.674 ↓ 11.9 8,878 1 / 4

Parallel Index Scan using road_network_partitioned2_1005_pkey on road_network_partitioned2_1005 a_1005 (cost=0.28..443.16 rows=744 width=226) (actual time=0.038..14.697 rows=8,878 loops=1)

24. 7.839 7.839 ↓ 9.9 7,191 1 / 4

Parallel Index Scan using road_network_partitioned2_1211_pkey on road_network_partitioned2_1211 a_1211 (cost=0.28..431.22 rows=729 width=226) (actual time=0.031..31.356 rows=7,191 loops=1)

25. 4.396 4.396 ↓ 10.6 7,700 1 / 4

Parallel Index Scan using road_network_partitioned2_1127_pkey on road_network_partitioned2_1127 a_1127 (cost=0.28..429.63 rows=726 width=226) (actual time=0.045..17.584 rows=7,700 loops=1)

26. 5.090 5.090 ↓ 12.7 8,894 1 / 4

Parallel Index Scan using road_network_partitioned2_1126_pkey on road_network_partitioned2_1126 a_1126 (cost=0.28..420.34 rows=700 width=226) (actual time=0.038..20.362 rows=8,894 loops=1)

27. 2.436 2.436 ↓ 8.2 5,610 1 / 4

Parallel Index Scan using road_network_partitioned2_964_pkey on road_network_partitioned2_964 a_964 (cost=0.28..407.98 rows=688 width=226) (actual time=0.048..9.743 rows=5,610 loops=1)

28. 3.795 3.795 ↓ 11.8 7,988 1 / 4

Parallel Index Scan using road_network_partitioned2_754_pkey on road_network_partitioned2_754 a_754 (cost=0.28..406.22 rows=679 width=226) (actual time=0.043..15.181 rows=7,988 loops=1)

29. 8.366 8.366 ↓ 13.4 8,655 1 / 4

Parallel Index Scan using road_network_partitioned2_1125_pkey on road_network_partitioned2_1125 a_1125 (cost=0.28..390.16 rows=644 width=226) (actual time=0.029..33.462 rows=8,655 loops=1)

30. 3.672 3.672 ↓ 13.5 8,596 1 / 4

Parallel Index Scan using road_network_partitioned2_1006_pkey on road_network_partitioned2_1006 a_1006 (cost=0.28..383.98 rows=638 width=226) (actual time=0.030..14.689 rows=8,596 loops=1)

31. 4.704 4.704 ↓ 11.0 7,030 1 / 4

Parallel Index Scan using road_network_partitioned2_970_pkey on road_network_partitioned2_970 a_970 (cost=0.28..382.98 rows=638 width=226) (actual time=0.042..18.815 rows=7,030 loops=1)

32. 1.258 1.258 ↓ 9.7 6,070 1 / 4

Parallel Index Scan using road_network_partitioned2_923_pkey on road_network_partitioned2_923 a_923 (cost=0.28..374.62 rows=626 width=226) (actual time=0.028..5.034 rows=6,070 loops=1)

33. 4.061 4.061 ↓ 10.4 6,029 1 / 4

Parallel Index Scan using road_network_partitioned2_1168_pkey on road_network_partitioned2_1168 a_1168 (cost=0.28..352.80 rows=582 width=226) (actual time=0.028..16.243 rows=6,029 loops=1)

34. 3.058 3.058 ↓ 9.3 5,359 1 / 4

Parallel Index Scan using road_network_partitioned2_1379_pkey on road_network_partitioned2_1379 a_1379 (cost=0.28..345.21 rows=579 width=226) (actual time=0.042..12.234 rows=5,359 loops=1)

35. 5.550 5.550 ↓ 12.5 6,821 1 / 4

Parallel Index Scan using road_network_partitioned2_1165_pkey on road_network_partitioned2_1165 a_1165 (cost=0.28..333.14 rows=544 width=226) (actual time=0.042..22.201 rows=6,821 loops=1)

36. 3.019 3.019 ↓ 8.6 4,711 1 / 4

Parallel Index Scan using road_network_partitioned2_1086_pkey on road_network_partitioned2_1086 a_1086 (cost=0.28..320.32 rows=550 width=226) (actual time=0.032..12.077 rows=4,711 loops=1)

37. 1.366 1.366 ↓ 13.0 6,696 1 / 4

Parallel Index Scan using road_network_partitioned2_1206_pkey on road_network_partitioned2_1206 a_1206 (cost=0.28..314.26 rows=515 width=226) (actual time=0.031..5.464 rows=6,696 loops=1)

38. 3.181 3.181 ↓ 12.6 6,324 1 / 4

Parallel Index Scan using road_network_partitioned2_1207_pkey on road_network_partitioned2_1207 a_1207 (cost=0.28..309.91 rows=503 width=226) (actual time=0.032..12.726 rows=6,324 loops=1)

39. 0.987 0.987 ↓ 9.2 4,798 1 / 4

Parallel Index Scan using road_network_partitioned2_1003_pkey on road_network_partitioned2_1003 a_1003 (cost=0.28..305.03 rows=524 width=226) (actual time=0.046..3.948 rows=4,798 loops=1)

40. 3.206 3.206 ↓ 12.5 6,046 1 / 4

Parallel Index Scan using road_network_partitioned2_1035_pkey on road_network_partitioned2_1035 a_1035 (cost=0.28..301.38 rows=485 width=226) (actual time=0.038..12.823 rows=6,046 loops=1)

41. 3.455 3.455 ↓ 8.7 4,431 1 / 4

Parallel Index Scan using road_network_partitioned2_921_pkey on road_network_partitioned2_921 a_921 (cost=0.28..298.08 rows=509 width=226) (actual time=0.044..13.821 rows=4,431 loops=1)

42. 0.903 0.903 ↓ 9.2 4,578 1 / 4

Parallel Index Scan using road_network_partitioned2_1046_pkey on road_network_partitioned2_1046 a_1046 (cost=0.28..294.32 rows=500 width=226) (actual time=0.029..3.612 rows=4,578 loops=1)

43. 3.061 3.061 ↓ 11.3 5,498 1 / 4

Parallel Index Scan using road_network_partitioned2_670_pkey on road_network_partitioned2_670 a_670 (cost=0.28..293.38 rows=485 width=226) (actual time=0.019..12.243 rows=5,498 loops=1)

44. 3.147 3.147 ↓ 11.7 5,587 1 / 4

Parallel Index Scan using road_network_partitioned2_1124_pkey on road_network_partitioned2_1124 a_1124 (cost=0.28..291.20 rows=479 width=226) (actual time=0.039..12.589 rows=5,587 loops=1)

45. 3.929 3.929 ↓ 7.7 3,883 1 / 4

Parallel Index Scan using road_network_partitioned2_1045_pkey on road_network_partitioned2_1045 a_1045 (cost=0.28..290.91 rows=503 width=226) (actual time=0.040..15.715 rows=3,883 loops=1)

46. 0.723 0.723 ↓ 7.0 3,451 1 / 4

Parallel Index Scan using road_network_partitioned2_1338_pkey on road_network_partitioned2_1338 a_1338 (cost=0.28..286.14 rows=494 width=226) (actual time=0.033..2.893 rows=3,451 loops=1)

47. 3.744 3.744 ↓ 6.9 3,294 1 / 4

Parallel Index Scan using road_network_partitioned2_1128_pkey on road_network_partitioned2_1128 a_1128 (cost=0.28..275.02 rows=474 width=226) (actual time=0.018..14.978 rows=3,294 loops=1)

48. 1.538 1.538 ↓ 10.3 4,775 1 / 4

Parallel Index Scan using road_network_partitioned2_1088_pkey on road_network_partitioned2_1088 a_1088 (cost=0.28..274.67 rows=462 width=226) (actual time=0.045..6.154 rows=4,775 loops=1)

49. 1.868 1.868 ↓ 8.3 3,865 1 / 4

Parallel Index Scan using road_network_partitioned2_838_pkey on road_network_partitioned2_838 a_838 (cost=0.28..273.84 rows=468 width=226) (actual time=0.050..7.473 rows=3,865 loops=1)

50. 5.939 5.939 ↓ 9.4 4,353 1 / 4

Parallel Index Scan using road_network_partitioned2_1004_pkey on road_network_partitioned2_1004 a_1004 (cost=0.28..272.26 rows=465 width=226) (actual time=0.062..23.754 rows=4,353 loops=1)

51. 3.617 3.617 ↓ 10.6 4,654 1 / 4

Parallel Index Scan using road_network_partitioned2_1085_pkey on road_network_partitioned2_1085 a_1085 (cost=0.28..261.55 rows=441 width=226) (actual time=0.030..14.469 rows=4,654 loops=1)

52. 4.005 4.005 ↓ 12.6 5,341 1 / 4

Parallel Index Scan using road_network_partitioned2_1123_pkey on road_network_partitioned2_1123 a_1123 (cost=0.28..259.02 rows=424 width=226) (actual time=0.032..16.020 rows=5,341 loops=1)

53. 2.901 2.901 ↓ 10.1 4,372 1 / 4

Parallel Index Scan using road_network_partitioned2_712_pkey on road_network_partitioned2_712 a_712 (cost=0.28..257.37 rows=435 width=226) (actual time=0.039..11.604 rows=4,372 loops=1)

54. 1.272 1.272 ↓ 7.8 3,268 1 / 4

Parallel Index Scan using road_network_partitioned2_963_pkey on road_network_partitioned2_963 a_963 (cost=0.28..244.84 rows=418 width=226) (actual time=0.044..5.088 rows=3,268 loops=1)

55. 0.900 0.900 ↓ 10.6 4,317 1 / 4

Parallel Index Scan using road_network_partitioned2_929_pkey on road_network_partitioned2_929 a_929 (cost=0.28..242.07 rows=409 width=226) (actual time=0.038..3.601 rows=4,317 loops=1)

56. 1.675 1.675 ↓ 10.6 4,288 1 / 4

Parallel Index Scan using road_network_partitioned2_1163_pkey on road_network_partitioned2_1163 a_1163 (cost=0.28..240.90 rows=403 width=226) (actual time=0.033..6.700 rows=4,288 loops=1)

57. 0.749 0.749 ↓ 7.6 3,048 1 / 4

Parallel Index Scan using road_network_partitioned2_879_pkey on road_network_partitioned2_879 a_879 (cost=0.28..236.90 rows=403 width=226) (actual time=0.031..2.995 rows=3,048 loops=1)

58. 0.976 0.976 ↓ 7.5 3,001 1 / 4

Parallel Index Scan using road_network_partitioned2_922_pkey on road_network_partitioned2_922 a_922 (cost=0.28..236.31 rows=400 width=226) (actual time=0.019..3.902 rows=3,001 loops=1)

59. 0.776 0.776 ↓ 9.6 3,854 1 / 4

Parallel Index Scan using road_network_partitioned2_1081_pkey on road_network_partitioned2_1081 a_1081 (cost=0.28..235.31 rows=400 width=226) (actual time=0.016..3.105 rows=3,854 loops=1)

60. 2.833 2.833 ↓ 9.7 3,845 1 / 4

Parallel Index Scan using road_network_partitioned2_971_pkey on road_network_partitioned2_971 a_971 (cost=0.28..234.72 rows=397 width=226) (actual time=0.025..11.330 rows=3,845 loops=1)

61. 0.826 0.826 ↓ 9.8 3,865 1 / 4

Parallel Index Scan using road_network_partitioned2_1013_pkey on road_network_partitioned2_1013 a_1013 (cost=0.28..232.13 rows=394 width=226) (actual time=0.045..3.302 rows=3,865 loops=1)

62. 4.773 4.773 ↓ 8.3 3,184 1 / 4

Parallel Index Scan using road_network_partitioned2_880_pkey on road_network_partitioned2_880 a_880 (cost=0.28..227.78 rows=382 width=226) (actual time=0.049..19.092 rows=3,184 loops=1)

63. 2.896 2.896 ↓ 12.2 4,575 1 / 4

Parallel Index Scan using road_network_partitioned2_1205_pkey on road_network_partitioned2_1205 a_1205 (cost=0.28..225.01 rows=374 width=226) (actual time=0.033..11.582 rows=4,575 loops=1)

64. 0.784 0.784 ↓ 11.6 4,330 1 / 4

Parallel Index Scan using road_network_partitioned2_1164_pkey on road_network_partitioned2_1164 a_1164 (cost=0.28..223.01 rows=374 width=226) (actual time=0.030..3.135 rows=4,330 loops=1)

65. 3.697 3.697 ↓ 9.3 3,449 1 / 4

Parallel Index Scan using road_network_partitioned2_1044_pkey on road_network_partitioned2_1044 a_1044 (cost=0.28..220.42 rows=371 width=226) (actual time=0.019..14.790 rows=3,449 loops=1)

66. 4.147 4.147 ↓ 13.1 4,772 1 / 4

Parallel Index Scan using road_network_partitioned2_1034_pkey on road_network_partitioned2_1034 a_1034 (cost=0.28..220.25 rows=365 width=226) (actual time=0.043..16.587 rows=4,772 loops=1)

67. 1.496 1.496 ↓ 9.2 3,391 1 / 4

Parallel Index Scan using road_network_partitioned2_1252_pkey on road_network_partitioned2_1252 a_1252 (cost=0.28..217.84 rows=368 width=226) (actual time=0.052..5.986 rows=3,391 loops=1)

68. 0.658 0.658 ↓ 9.5 3,461 1 / 4

Parallel Index Scan using road_network_partitioned2_961_pkey on road_network_partitioned2_961 a_961 (cost=0.28..217.25 rows=365 width=226) (actual time=0.023..2.631 rows=3,461 loops=1)

69. 1.488 1.488 ↓ 11.9 4,216 1 / 4

Parallel Index Scan using road_network_partitioned2_1038_pkey on road_network_partitioned2_1038 a_1038 (cost=0.28..212.89 rows=353 width=226) (actual time=0.039..5.953 rows=4,216 loops=1)

70. 2.775 2.775 ↓ 12.1 4,132 1 / 4

Parallel Index Scan using road_network_partitioned2_1122_pkey on road_network_partitioned2_1122 a_1122 (cost=0.28..208.54 rows=341 width=226) (actual time=0.020..11.098 rows=4,132 loops=1)

71. 0.617 0.617 ↓ 7.5 2,663 1 / 4

Parallel Index Scan using road_network_partitioned2_1169_pkey on road_network_partitioned2_1169 a_1169 (cost=0.28..206.89 rows=353 width=226) (actual time=0.044..2.469 rows=2,663 loops=1)

72. 0.506 0.506 ↓ 6.5 2,293 1 / 4

Parallel Index Scan using road_network_partitioned2_1171_pkey on road_network_partitioned2_1171 a_1171 (cost=0.28..203.89 rows=353 width=226) (actual time=0.040..2.025 rows=2,293 loops=1)

73. 0.790 0.790 ↓ 12.3 4,018 1 / 4

Parallel Index Scan using road_network_partitioned2_328_pkey on road_network_partitioned2_328 a_328 (cost=0.28..197.60 rows=326 width=226) (actual time=0.041..3.162 rows=4,018 loops=1)

74. 4.196 4.196 ↓ 11.8 3,842 1 / 4

Parallel Index Scan using road_network_partitioned2_992_pkey on road_network_partitioned2_992 a_992 (cost=0.28..197.60 rows=326 width=226) (actual time=0.044..16.785 rows=3,842 loops=1)

75. 3.982 3.982 ↓ 10.8 3,471 1 / 4

Parallel Index Scan using road_network_partitioned2_1042_pkey on road_network_partitioned2_1042 a_1042 (cost=0.28..193.42 rows=321 width=226) (actual time=0.029..15.927 rows=3,471 loops=1)

76. 2.537 2.537 ↓ 12.9 4,107 1 / 4

Parallel Index Scan using road_network_partitioned2_499_pkey on road_network_partitioned2_499 a_499 (cost=0.28..192.83 rows=318 width=226) (actual time=0.036..10.146 rows=4,107 loops=1)

77. 1.616 1.616 ↓ 9.9 3,031 1 / 4

Parallel Index Scan using road_network_partitioned2_1002_pkey on road_network_partitioned2_1002 a_1002 (cost=0.28..184.48 rows=306 width=226) (actual time=0.042..6.465 rows=3,031 loops=1)

78. 1.317 1.317 ↓ 9.7 2,874 1 / 4

Parallel Index Scan using road_network_partitioned2_1130_pkey on road_network_partitioned2_1130 a_1130 (cost=0.27..180.71 rows=297 width=226) (actual time=0.037..5.266 rows=2,874 loops=1)

79. 1.637 1.637 ↓ 11.8 3,438 1 / 4

Parallel Index Scan using road_network_partitioned2_627_pkey on road_network_partitioned2_627 a_627 (cost=0.27..178.53 rows=291 width=226) (actual time=0.027..6.546 rows=3,438 loops=1)

80. 4.740 4.740 ↓ 12.6 3,618 1 / 4

Parallel Index Scan using road_network_partitioned2_1089_pkey on road_network_partitioned2_1089 a_1089 (cost=0.27..176.94 rows=288 width=226) (actual time=0.045..18.961 rows=3,618 loops=1)

81. 1.640 1.640 ↓ 11.4 3,263 1 / 4

Parallel Index Scan using road_network_partitioned2_1011_pkey on road_network_partitioned2_1011 a_1011 (cost=0.27..175.36 rows=285 width=226) (actual time=0.042..6.561 rows=3,263 loops=1)

82. 2.611 2.611 ↓ 10.7 3,011 1 / 4

Parallel Index Scan using road_network_partitioned2_886_pkey on road_network_partitioned2_886 a_886 (cost=0.27..172.77 rows=282 width=226) (actual time=0.045..10.445 rows=3,011 loops=1)

83. 0.492 0.492 ↓ 8.0 2,352 1 / 4

Parallel Index Scan using road_network_partitioned2_1335_pkey on road_network_partitioned2_1335 a_1335 (cost=0.27..171.12 rows=294 width=226) (actual time=0.034..1.969 rows=2,352 loops=1)

84. 0.660 0.660 ↓ 12.9 3,534 1 / 4

Parallel Index Scan using road_network_partitioned2_753_pkey on road_network_partitioned2_753 a_753 (cost=0.27..169.00 rows=274 width=226) (actual time=0.027..2.640 rows=3,534 loops=1)

85. 2.591 2.591 ↓ 11.5 3,163 1 / 4

Parallel Index Scan using road_network_partitioned2_1056_pkey on road_network_partitioned2_1056 a_1056 (cost=0.27..168.00 rows=274 width=226) (actual time=0.021..10.366 rows=3,163 loops=1)

86. 0.530 0.530 ↓ 10.2 2,814 1 / 4

Parallel Index Scan using road_network_partitioned2_1084_pkey on road_network_partitioned2_1084 a_1084 (cost=0.27..166.59 rows=276 width=226) (actual time=0.035..2.121 rows=2,814 loops=1)

87. 0.480 0.480 ↓ 7.4 2,115 1 / 4

Parallel Index Scan using road_network_partitioned2_1380_pkey on road_network_partitioned2_1380 a_1380 (cost=0.27..165.36 rows=285 width=226) (actual time=0.038..1.920 rows=2,115 loops=1)

88. 1.550 1.550 ↓ 10.0 2,744 1 / 4

Parallel Index Scan using road_network_partitioned2_1014_pkey on road_network_partitioned2_1014 a_1014 (cost=0.27..164.00 rows=274 width=226) (actual time=0.027..6.201 rows=2,744 loops=1)

89. 2.602 2.602 ↓ 10.8 2,826 1 / 4

Parallel Index Scan using road_network_partitioned2_930_pkey on road_network_partitioned2_930 a_930 (cost=0.27..160.65 rows=262 width=226) (actual time=0.043..10.409 rows=2,826 loops=1)

90. 1.056 1.056 ↓ 9.8 2,598 1 / 4

Parallel Index Scan using road_network_partitioned2_1043_pkey on road_network_partitioned2_1043 a_1043 (cost=0.27..158.24 rows=265 width=226) (actual time=0.031..4.225 rows=2,598 loops=1)

91. 1.016 1.016 ↓ 11.5 2,909 1 / 4

Parallel Index Scan using road_network_partitioned2_370_pkey on road_network_partitioned2_370 a_370 (cost=0.27..153.88 rows=253 width=226) (actual time=0.042..4.066 rows=2,909 loops=1)

92. 2.658 2.658 ↓ 9.3 2,389 1 / 4

Parallel Index Scan using road_network_partitioned2_1422_pkey on road_network_partitioned2_1422 a_1422 (cost=0.27..151.47 rows=256 width=226) (actual time=0.025..10.632 rows=2,389 loops=1)

93. 1.297 1.297 ↓ 10.7 2,641 1 / 4

Parallel Index Scan using road_network_partitioned2_887_pkey on road_network_partitioned2_887 a_887 (cost=0.27..148.71 rows=247 width=226) (actual time=0.034..5.189 rows=2,641 loops=1)

94. 0.468 0.468 ↓ 9.7 2,413 1 / 4

Parallel Index Scan using road_network_partitioned2_1078_pkey on road_network_partitioned2_1078 a_1078 (cost=0.27..147.29 rows=250 width=226) (actual time=0.036..1.871 rows=2,413 loops=1)

95. 5.569 5.569 ↓ 1.9 467 4 / 4

Parallel Index Scan using road_network_partitioned2_1129_pkey on road_network_partitioned2_1129 a_1129 (cost=0.27..146.29 rows=250 width=226) (actual time=0.886..5.569 rows=467 loops=4)

96. 0.631 0.631 ↓ 7.1 1,601 2 / 4

Parallel Index Scan using road_network_partitioned2_413_pkey on road_network_partitioned2_413 a_413 (cost=0.27..143.59 rows=226 width=226) (actual time=0.019..1.261 rows=1,601 loops=2)

97. 0.363 0.363 ↓ 7.3 1,789 1 / 4

Parallel Index Scan using road_network_partitioned2_962_pkey on road_network_partitioned2_962 a_962 (cost=0.27..143.12 rows=244 width=226) (actual time=0.023..1.451 rows=1,789 loops=1)

98. 3.555 3.555 ↓ 9.0 2,136 1 / 4

Parallel Index Scan using road_network_partitioned2_920_pkey on road_network_partitioned2_920 a_920 (cost=0.27..139.94 rows=238 width=226) (actual time=0.034..14.219 rows=2,136 loops=1)

99. 3.168 3.168 ↓ 9.2 2,184 1 / 4

Parallel Index Scan using road_network_partitioned2_1080_pkey on road_network_partitioned2_1080 a_1080 (cost=0.27..139.94 rows=238 width=226) (actual time=0.022..12.671 rows=2,184 loops=1)

100. 0.346 0.346 ↓ 7.6 1,795 1 / 4

Parallel Index Scan using road_network_partitioned2_669_pkey on road_network_partitioned2_669 a_669 (cost=0.27..138.35 rows=235 width=226) (actual time=0.017..1.382 rows=1,795 loops=1)

101. 1.272 1.272 ↓ 11.4 2,556 1 / 4

Parallel Index Scan using road_network_partitioned2_626_pkey on road_network_partitioned2_626 a_626 (cost=0.27..136.00 rows=224 width=226) (actual time=0.022..5.087 rows=2,556 loops=1)

102. 1.315 1.315 ↓ 9.1 2,095 1 / 4

Parallel Index Scan using road_network_partitioned2_1172_pkey on road_network_partitioned2_1172 a_1172 (cost=0.27..135.17 rows=229 width=226) (actual time=0.024..5.261 rows=2,095 loops=1)

103. 1.470 1.470 ↓ 11.9 2,589 1 / 4

Parallel Index Scan using road_network_partitioned2_1037_pkey on road_network_partitioned2_1037 a_1037 (cost=0.27..131.82 rows=218 width=226) (actual time=0.018..5.882 rows=2,589 loops=1)

104. 0.431 0.431 ↓ 11.7 2,519 1 / 4

Parallel Index Scan using road_network_partitioned2_1212_pkey on road_network_partitioned2_1212 a_1212 (cost=0.27..131.23 rows=215 width=226) (actual time=0.025..1.724 rows=2,519 loops=1)

105. 0.313 0.313 ↓ 7.8 1,709 1 / 4

Parallel Index Scan using road_network_partitioned2_837_pkey on road_network_partitioned2_837 a_837 (cost=0.27..128.82 rows=218 width=226) (actual time=0.022..1.251 rows=1,709 loops=1)

106. 0.819 0.819 ↓ 11.3 2,391 1 / 4

Parallel Index Scan using road_network_partitioned2_327_pkey on road_network_partitioned2_327 a_327 (cost=0.27..126.64 rows=212 width=226) (actual time=0.018..3.276 rows=2,391 loops=1)

107. 1.186 1.186 ↓ 7.8 1,657 1 / 4

Parallel Index Scan using road_network_partitioned2_878_pkey on road_network_partitioned2_878 a_878 (cost=0.27..125.64 rows=212 width=226) (actual time=0.021..4.743 rows=1,657 loops=1)

108. 0.367 0.367 ↓ 10.8 2,281 1 / 4

Parallel Index Scan using road_network_partitioned2_965_pkey on road_network_partitioned2_965 a_965 (cost=0.27..125.64 rows=212 width=226) (actual time=0.027..1.467 rows=2,281 loops=1)

109. 3.137 3.137 ↓ 10.9 2,270 1 / 4

Parallel Index Scan using road_network_partitioned2_888_pkey on road_network_partitioned2_888 a_888 (cost=0.27..124.05 rows=209 width=226) (actual time=0.017..12.547 rows=2,270 loops=1)

110. 0.521 0.521 ↓ 10.7 2,201 1 / 4

Parallel Index Scan using road_network_partitioned2_1121_pkey on road_network_partitioned2_1121 a_1121 (cost=0.27..122.47 rows=206 width=226) (actual time=0.024..2.083 rows=2,201 loops=1)

111. 1.254 1.254 ↓ 13.7 2,666 1 / 4

Parallel Index Scan using road_network_partitioned2_1076_pkey on road_network_partitioned2_1076 a_1076 (cost=0.27..121.11 rows=194 width=226) (actual time=0.021..5.017 rows=2,666 loops=1)

112. 0.331 0.331 ↓ 9.7 1,976 1 / 4

Parallel Index Scan using road_network_partitioned2_412_pkey on road_network_partitioned2_412 a_412 (cost=0.27..120.88 rows=203 width=226) (actual time=0.016..1.325 rows=1,976 loops=1)

113. 0.483 0.483 ↓ 5.1 1,063 1 / 4

Parallel Index Scan using road_network_partitioned2_1170_pkey on road_network_partitioned2_1170 a_1170 (cost=0.27..120.05 rows=209 width=226) (actual time=0.018..1.931 rows=1,063 loops=1)

114. 0.385 0.385 ↓ 11.6 2,295 1 / 4

Parallel Index Scan using road_network_partitioned2_1036_pkey on road_network_partitioned2_1036 a_1036 (cost=0.27..119.70 rows=197 width=226) (actual time=0.023..1.541 rows=2,295 loops=1)

115. 0.869 0.869 ↓ 10.8 2,069 1 / 4

Parallel Index Scan using road_network_partitioned2_801_pkey on road_network_partitioned2_801 a_801 (cost=0.27..114.52 rows=191 width=226) (actual time=0.025..3.475 rows=2,069 loops=1)

116. 1.039 1.039 ↓ 8.9 1,669 1 / 4

Parallel Index Scan using road_network_partitioned2_960_pkey on road_network_partitioned2_960 a_960 (cost=0.27..112.94 rows=188 width=226) (actual time=0.023..4.157 rows=1,669 loops=1)

117. 1.318 1.318 ↓ 10.4 1,964 1 / 4

Parallel Index Scan using road_network_partitioned2_993_pkey on road_network_partitioned2_993 a_993 (cost=0.27..112.94 rows=188 width=226) (actual time=0.032..5.272 rows=1,964 loops=1)

118. 0.660 0.660 ↓ 13.0 2,373 1 / 4

Parallel Index Scan using road_network_partitioned2_585_pkey on road_network_partitioned2_585 a_585 (cost=0.27..111.76 rows=182 width=226) (actual time=0.025..2.641 rows=2,373 loops=1)

119. 0.465 0.465 ↓ 10.3 1,911 1 / 4

Parallel Index Scan using road_network_partitioned2_1032_pkey on road_network_partitioned2_1032 a_1032 (cost=0.27..111.35 rows=185 width=226) (actual time=0.019..1.858 rows=1,911 loops=1)

120. 0.663 0.663 ↓ 9.1 1,665 1 / 4

Parallel Index Scan using road_network_partitioned2_1079_pkey on road_network_partitioned2_1079 a_1079 (cost=0.27..109.76 rows=182 width=226) (actual time=0.031..2.653 rows=1,665 loops=1)

121. 1.264 1.264 ↓ 9.2 1,616 1 / 4

Parallel Index Scan using road_network_partitioned2_1055_pkey on road_network_partitioned2_1055 a_1055 (cost=0.27..106.58 rows=176 width=226) (actual time=0.021..5.055 rows=1,616 loops=1)

122. 0.242 0.242 ↓ 7.5 1,346 1 / 4

Parallel Index Scan using road_network_partitioned2_1378_pkey on road_network_partitioned2_1378 a_1378 (cost=0.27..106.17 rows=179 width=226) (actual time=0.033..0.970 rows=1,346 loops=1)

123. 2.042 2.042 ↓ 11.9 2,073 1 / 4

Parallel Index Scan using road_network_partitioned2_795_pkey on road_network_partitioned2_795 a_795 (cost=0.27..104.99 rows=174 width=226) (actual time=0.022..8.169 rows=2,073 loops=1)

124. 0.228 0.228 ↓ 7.7 1,352 1 / 4

Parallel Index Scan using road_network_partitioned2_844_pkey on road_network_partitioned2_844 a_844 (cost=0.27..104.58 rows=176 width=226) (actual time=0.025..0.910 rows=1,352 loops=1)

125. 1.831 1.831 ↓ 11.2 1,918 1 / 4

Parallel Index Scan using road_network_partitioned2_455_pkey on road_network_partitioned2_455 a_455 (cost=0.27..103.40 rows=171 width=226) (actual time=0.016..7.323 rows=1,918 loops=1)

126. 0.295 0.295 ↓ 10.4 1,775 1 / 4

Parallel Index Scan using road_network_partitioned2_584_pkey on road_network_partitioned2_584 a_584 (cost=0.27..103.40 rows=171 width=226) (actual time=0.023..1.182 rows=1,775 loops=1)

127. 1.576 1.576 ↓ 10.4 1,786 1 / 4

Parallel Index Scan using road_network_partitioned2_751_pkey on road_network_partitioned2_751 a_751 (cost=0.27..103.40 rows=171 width=226) (actual time=0.015..6.304 rows=1,786 loops=1)

128. 0.289 0.289 ↓ 10.6 1,815 1 / 4

Parallel Index Scan using road_network_partitioned2_1162_pkey on road_network_partitioned2_1162 a_1162 (cost=0.27..103.40 rows=171 width=226) (actual time=0.027..1.157 rows=1,815 loops=1)

129. 2.103 2.103 ↓ 10.1 1,694 1 / 4

Parallel Index Scan using road_network_partitioned2_1082_pkey on road_network_partitioned2_1082 a_1082 (cost=0.27..101.82 rows=168 width=226) (actual time=0.024..8.411 rows=1,694 loops=1)

130. 3.595 3.595 ↓ 9.6 1,589 1 / 4

Parallel Index Scan using road_network_partitioned2_836_pkey on road_network_partitioned2_836 a_836 (cost=0.27..100.23 rows=165 width=226) (actual time=0.015..14.381 rows=1,589 loops=1)

131. 0.238 0.238 ↓ 8.8 1,423 1 / 4

Parallel Index Scan using road_network_partitioned2_919_pkey on road_network_partitioned2_919 a_919 (cost=0.27..98.64 rows=162 width=226) (actual time=0.017..0.953 rows=1,423 loops=1)

132. 0.480 0.480 ↓ 11.3 1,823 1 / 4

Parallel Index Scan using road_network_partitioned2_972_pkey on road_network_partitioned2_972 a_972 (cost=0.27..98.64 rows=162 width=226) (actual time=0.022..1.918 rows=1,823 loops=1)

133. 0.635 0.635 ↓ 9.3 1,455 1 / 4

Parallel Index Scan using road_network_partitioned2_1249_pkey on road_network_partitioned2_1249 a_1249 (cost=0.27..95.46 rows=156 width=226) (actual time=0.015..2.542 rows=1,455 loops=1)

134. 0.212 0.212 ↓ 8.6 1,318 1 / 4

Parallel Index Scan using road_network_partitioned2_454_pkey on road_network_partitioned2_454 a_454 (cost=0.27..92.87 rows=153 width=226) (actual time=0.021..0.848 rows=1,318 loops=1)

135. 2.061 2.061 ↓ 10.6 1,555 1 / 4

Parallel Index Scan using road_network_partitioned2_1120_pkey on road_network_partitioned2_1120 a_1120 (cost=0.27..90.69 rows=147 width=226) (actual time=0.024..8.243 rows=1,555 loops=1)

136. 0.220 0.220 ↓ 9.0 1,348 1 / 4

Parallel Index Scan using road_network_partitioned2_709_pkey on road_network_partitioned2_709 a_709 (cost=0.27..90.28 rows=150 width=226) (actual time=0.028..0.878 rows=1,348 loops=1)

137. 4.136 4.136 ↓ 10.6 1,496 1 / 4

Parallel Index Scan using road_network_partitioned2_145_pkey on road_network_partitioned2_145 a_145 (cost=0.27..87.52 rows=141 width=226) (actual time=0.016..16.543 rows=1,496 loops=1)

138. 0.256 0.256 ↓ 11.8 1,664 1 / 4

Parallel Index Scan using road_network_partitioned2_752_pkey on road_network_partitioned2_752 a_752 (cost=0.27..87.52 rows=141 width=226) (actual time=0.022..1.022 rows=1,664 loops=1)

139. 1.019 1.019 ↓ 10.3 1,418 1 / 4

Parallel Index Scan using road_network_partitioned2_624_pkey on road_network_partitioned2_624 a_624 (cost=0.27..85.93 rows=138 width=226) (actual time=0.016..4.077 rows=1,418 loops=1)

140. 0.173 0.173 ↓ 8.1 1,039 1 / 4

Parallel Index Scan using road_network_partitioned2_877_pkey on road_network_partitioned2_877 a_877 (cost=0.27..77.16 rows=129 width=226) (actual time=0.022..0.691 rows=1,039 loops=1)

141. 0.194 0.194 ↓ 8.8 1,108 1 / 4

Parallel Index Scan using road_network_partitioned2_710_pkey on road_network_partitioned2_710 a_710 (cost=0.27..75.57 rows=126 width=226) (actual time=0.017..0.776 rows=1,108 loops=1)

142. 0.217 0.217 ↓ 8.6 1,065 1 / 4

Parallel Index Scan using road_network_partitioned2_711_pkey on road_network_partitioned2_711 a_711 (cost=0.27..73.99 rows=124 width=226) (actual time=0.022..0.868 rows=1,065 loops=1)

143. 1.070 1.070 ↓ 8.5 1,050 1 / 4

Parallel Index Scan using road_network_partitioned2_802_pkey on road_network_partitioned2_802 a_802 (cost=0.27..73.99 rows=124 width=226) (actual time=0.015..4.280 rows=1,050 loops=1)

144. 0.167 0.167 ↓ 8.4 1,013 1 / 4

Parallel Index Scan using road_network_partitioned2_1001_pkey on road_network_partitioned2_1001 a_1001 (cost=0.27..72.40 rows=121 width=226) (actual time=0.017..0.668 rows=1,013 loops=1)

145. 0.185 0.185 ↓ 8.9 1,073 1 / 4

Parallel Index Scan using road_network_partitioned2_1015_pkey on road_network_partitioned2_1015 a_1015 (cost=0.27..72.40 rows=121 width=226) (actual time=0.028..0.739 rows=1,073 loops=1)

146. 0.180 0.180 ↓ 9.4 1,106 1 / 4

Parallel Index Scan using road_network_partitioned2_541_pkey on road_network_partitioned2_541 a_541 (cost=0.27..70.81 rows=118 width=226) (actual time=0.032..0.720 rows=1,106 loops=1)

147. 0.978 0.978 ↓ 10.1 1,197 1 / 4

Parallel Index Scan using road_network_partitioned2_582_pkey on road_network_partitioned2_582 a_582 (cost=0.27..70.81 rows=118 width=226) (actual time=0.019..3.912 rows=1,197 loops=1)

148. 0.174 0.174 ↓ 9.6 1,104 1 / 4

Parallel Index Scan using road_network_partitioned2_668_pkey on road_network_partitioned2_668 a_668 (cost=0.27..69.22 rows=115 width=226) (actual time=0.017..0.698 rows=1,104 loops=1)

149. 0.169 0.169 ↓ 9.3 1,047 1 / 4

Parallel Index Scan using road_network_partitioned2_889_pkey on road_network_partitioned2_889 a_889 (cost=0.27..67.63 rows=112 width=226) (actual time=0.022..0.677 rows=1,047 loops=1)

150. 0.144 0.144 ↓ 8.2 849 1 / 4

Parallel Index Scan using road_network_partitioned2_973_pkey on road_network_partitioned2_973 a_973 (cost=0.27..62.87 rows=103 width=226) (actual time=0.018..0.575 rows=849 loops=1)

151. 0.610 0.610 ↓ 10.5 1,084 1 / 4

Parallel Index Scan using road_network_partitioned2_990_pkey on road_network_partitioned2_990 a_990 (cost=0.27..62.87 rows=103 width=226) (actual time=0.024..2.439 rows=1,084 loops=1)

152. 0.800 0.800 ↓ 13.8 1,341 1 / 4

Parallel Index Scan using road_network_partitioned2_671_pkey on road_network_partitioned2_671 a_671 (cost=0.27..62.69 rows=97 width=226) (actual time=0.017..3.199 rows=1,341 loops=1)

153. 0.110 0.110 ↓ 6.3 650 1 / 4

Parallel Index Scan using road_network_partitioned2_843_pkey on road_network_partitioned2_843 a_843 (cost=0.27..61.87 rows=103 width=226) (actual time=0.030..0.438 rows=650 loops=1)

154. 2.092 2.092 ↓ 11.3 1,134 1 / 4

Parallel Index Scan using road_network_partitioned2_456_pkey on road_network_partitioned2_456 a_456 (cost=0.27..61.28 rows=100 width=226) (actual time=0.018..8.369 rows=1,134 loops=1)

155. 0.138 0.138 ↓ 7.9 788 1 / 4

Parallel Index Scan using road_network_partitioned2_918_pkey on road_network_partitioned2_918 a_918 (cost=0.27..61.28 rows=100 width=226) (actual time=0.019..0.553 rows=788 loops=1)

156. 0.160 0.160 ↓ 10.0 999 1 / 4

Parallel Index Scan using road_network_partitioned2_989_pkey on road_network_partitioned2_989 a_989 (cost=0.27..61.28 rows=100 width=226) (actual time=0.018..0.640 rows=999 loops=1)

157. 0.134 0.134 ↓ 8.0 795 1 / 4

Parallel Index Scan using road_network_partitioned2_1250_pkey on road_network_partitioned2_1250 a_1250 (cost=0.27..61.28 rows=100 width=226) (actual time=0.026..0.535 rows=795 loops=1)

158. 0.148 0.148 ↓ 9.3 902 1 / 4

Parallel Index Scan using road_network_partitioned2_759_pkey on road_network_partitioned2_759 a_759 (cost=0.27..59.69 rows=97 width=226) (actual time=0.020..0.594 rows=902 loops=1)

159. 0.144 0.144 ↓ 8.7 845 1 / 4

Parallel Index Scan using road_network_partitioned2_950_pkey on road_network_partitioned2_950 a_950 (cost=0.27..59.69 rows=97 width=226) (actual time=0.038..0.577 rows=845 loops=1)

160. 0.137 0.137 ↓ 8.6 835 1 / 4

Parallel Index Scan using road_network_partitioned2_1083_pkey on road_network_partitioned2_1083 a_1083 (cost=0.27..59.69 rows=97 width=226) (actual time=0.016..0.546 rows=835 loops=1)

161. 0.197 0.197 ↓ 14.7 1,336 1 / 4

Parallel Index Scan using road_network_partitioned2_103_pkey on road_network_partitioned2_103 a_103 (cost=0.27..59.51 rows=91 width=226) (actual time=0.026..0.786 rows=1,336 loops=1)

162. 2.748 2.748 ↓ 8.9 835 1 / 4

Parallel Index Scan using road_network_partitioned2_931_pkey on road_network_partitioned2_931 a_931 (cost=0.27..58.10 rows=94 width=226) (actual time=0.016..10.993 rows=835 loops=1)

163. 0.167 0.167 ↓ 9.9 930 1 / 4

Parallel Index Scan using road_network_partitioned2_946_pkey on road_network_partitioned2_946 a_946 (cost=0.27..58.10 rows=94 width=226) (actual time=0.018..0.668 rows=930 loops=1)

164. 0.135 0.135 ↓ 9.7 885 1 / 4

Parallel Index Scan using road_network_partitioned2_188_pkey on road_network_partitioned2_188 a_188 (cost=0.27..56.51 rows=91 width=226) (actual time=0.017..0.541 rows=885 loops=1)

165. 0.930 0.930 ↓ 10.5 953 1 / 4

Parallel Index Scan using road_network_partitioned2_794_pkey on road_network_partitioned2_794 a_794 (cost=0.27..56.51 rows=91 width=226) (actual time=0.018..3.720 rows=953 loops=1)

166. 0.162 0.162 ↓ 11.5 1,045 1 / 4

Parallel Index Scan using road_network_partitioned2_1118_pkey on road_network_partitioned2_1118 a_1118 (cost=0.27..56.51 rows=91 width=226) (actual time=0.037..0.648 rows=1,045 loops=1)

167. 0.144 0.144 ↓ 10.7 940 1 / 4

Parallel Index Scan using road_network_partitioned2_845_pkey on road_network_partitioned2_845 a_845 (cost=0.27..54.92 rows=88 width=226) (actual time=0.015..0.575 rows=940 loops=1)

168. 0.507 0.507 ↓ 8.5 744 1 / 4

Parallel Index Scan using road_network_partitioned2_959_pkey on road_network_partitioned2_959 a_959 (cost=0.27..54.92 rows=88 width=226) (actual time=0.033..2.028 rows=744 loops=1)

169. 0.116 0.116 ↓ 9.3 760 1 / 4

Parallel Index Scan using road_network_partitioned2_369_pkey on road_network_partitioned2_369 a_369 (cost=0.27..51.75 rows=82 width=226) (actual time=0.013..0.462 rows=760 loops=1)

170. 0.135 0.135 ↓ 10.3 845 1 / 4

Parallel Index Scan using road_network_partitioned2_793_pkey on road_network_partitioned2_793 a_793 (cost=0.27..51.75 rows=82 width=226) (actual time=0.025..0.541 rows=845 loops=1)

171. 0.636 0.636 ↓ 6.5 555 1 / 4

Parallel Index Scan using road_network_partitioned2_876_pkey on road_network_partitioned2_876 a_876 (cost=0.27..51.34 rows=85 width=226) (actual time=0.022..2.543 rows=555 loops=1)

172. 0.133 0.133 ↓ 10.4 824 1 / 4

Parallel Index Scan using road_network_partitioned2_625_pkey on road_network_partitioned2_625 a_625 (cost=0.27..50.16 rows=79 width=226) (actual time=0.016..0.533 rows=824 loops=1)

173. 0.115 0.115 ↓ 8.8 692 1 / 4

Parallel Index Scan using road_network_partitioned2_834_pkey on road_network_partitioned2_834 a_834 (cost=0.27..50.16 rows=79 width=226) (actual time=0.021..0.459 rows=692 loops=1)

174. 0.568 0.568 ↓ 12.5 984 1 / 4

Parallel Index Scan using road_network_partitioned2_1119_pkey on road_network_partitioned2_1119 a_1119 (cost=0.27..50.16 rows=79 width=226) (actual time=0.022..2.271 rows=984 loops=1)

175. 0.140 0.140 ↓ 9.7 767 1 / 4

Parallel Index Scan using road_network_partitioned2_1213_pkey on road_network_partitioned2_1213 a_1213 (cost=0.27..50.16 rows=79 width=226) (actual time=0.019..0.559 rows=767 loops=1)

176. 0.889 0.889 ↓ 9.7 734 1 / 4

Parallel Index Scan using road_network_partitioned2_1054_pkey on road_network_partitioned2_1054 a_1054 (cost=0.27..48.57 rows=76 width=226) (actual time=0.013..3.558 rows=734 loops=1)

177. 0.100 0.100 ↓ 7.4 585 1 / 4

Parallel Index Scan using road_network_partitioned2_667_pkey on road_network_partitioned2_667 a_667 (cost=0.27..48.16 rows=79 width=226) (actual time=0.020..0.398 rows=585 loops=1)

178. 0.110 0.110 ↓ 8.7 658 1 / 4

Parallel Index Scan using road_network_partitioned2_1000_pkey on road_network_partitioned2_1000 a_1000 (cost=0.27..47.57 rows=76 width=226) (actual time=0.023..0.441 rows=658 loops=1)

179. 0.234 0.234 ↓ 11.8 875 1 / 4

Parallel Index Scan using road_network_partitioned2_1204_pkey on road_network_partitioned2_1204 a_1204 (cost=0.27..46.98 rows=74 width=226) (actual time=0.021..0.935 rows=875 loops=1)

180. 0.121 0.121 ↓ 9.3 688 1 / 4

Parallel Index Scan using road_network_partitioned2_1117_pkey on road_network_partitioned2_1117 a_1117 (cost=0.27..45.98 rows=74 width=226) (actual time=0.022..0.484 rows=688 loops=1)

181. 0.960 0.960 ↓ 12.0 855 1 / 4

Parallel Index Scan using road_network_partitioned2_610_pkey on road_network_partitioned2_610 a_610 (cost=0.27..45.39 rows=71 width=226) (actual time=0.015..3.839 rows=855 loops=1)

182. 0.100 0.100 ↓ 8.0 594 1 / 4

Parallel Index Scan using road_network_partitioned2_708_pkey on road_network_partitioned2_708 a_708 (cost=0.27..44.98 rows=74 width=226) (actual time=0.022..0.401 rows=594 loops=1)

183. 0.105 0.105 ↓ 8.3 611 1 / 4

Parallel Index Scan using road_network_partitioned2_835_pkey on road_network_partitioned2_835 a_835 (cost=0.27..44.98 rows=74 width=226) (actual time=0.015..0.421 rows=611 loops=1)

184. 1.353 1.353 ↓ 9.9 670 1 / 4

Parallel Index Scan using road_network_partitioned2_1018_pkey on road_network_partitioned2_1018 a_1018 (cost=0.27..43.80 rows=68 width=226) (actual time=5.016..5.413 rows=670 loops=1)

185. 0.096 0.096 ↓ 9.1 644 1 / 4

Parallel Index Scan using road_network_partitioned2_490_pkey on road_network_partitioned2_490 a_490 (cost=0.27..43.39 rows=71 width=226) (actual time=0.015..0.384 rows=644 loops=1)

186. 0.102 0.102 ↓ 8.5 605 1 / 4

Parallel Index Scan using road_network_partitioned2_494_pkey on road_network_partitioned2_494 a_494 (cost=0.27..43.39 rows=71 width=226) (actual time=0.022..0.409 rows=605 loops=1)

187. 0.118 0.118 ↓ 11.3 735 1 / 4

Parallel Index Scan using road_network_partitioned2_1253_pkey on road_network_partitioned2_1253 a_1253 (cost=0.27..42.21 rows=65 width=226) (actual time=0.021..0.473 rows=735 loops=1)

188. 0.092 0.092 ↓ 10.0 649 1 / 4

Parallel Index Scan using road_network_partitioned2_285_pkey on road_network_partitioned2_285 a_285 (cost=0.27..41.21 rows=65 width=226) (actual time=0.019..0.369 rows=649 loops=1)

189. 1.203 1.203 ↓ 11.7 728 1 / 4

Parallel Index Scan using road_network_partitioned2_621_pkey on road_network_partitioned2_621 a_621 (cost=0.27..40.63 rows=62 width=226) (actual time=0.017..4.812 rows=728 loops=1)

190. 0.073 0.073 ↓ 6.6 428 1 / 4

Parallel Index Scan using road_network_partitioned2_1041_pkey on road_network_partitioned2_1041 a_1041 (cost=0.27..40.21 rows=65 width=226) (actual time=0.020..0.293 rows=428 loops=1)

191. 0.100 0.100 ↓ 9.9 615 1 / 4

Parallel Index Scan using road_network_partitioned2_953_pkey on road_network_partitioned2_953 a_953 (cost=0.27..39.63 rows=62 width=226) (actual time=0.020..0.399 rows=615 loops=1)

192. 0.056 0.056 ↓ 5.6 348 1 / 4

Parallel Index Scan using road_network_partitioned2_411_pkey on road_network_partitioned2_411 a_411 (cost=0.27..38.63 rows=62 width=226) (actual time=0.012..0.225 rows=348 loops=1)

193. 0.074 0.074 ↓ 7.1 439 1 / 4

Parallel Index Scan using road_network_partitioned2_623_pkey on road_network_partitioned2_623 a_623 (cost=0.27..38.63 rows=62 width=226) (actual time=0.027..0.295 rows=439 loops=1)

194. 0.095 0.095 ↓ 8.7 539 1 / 4

Parallel Index Scan using road_network_partitioned2_707_pkey on road_network_partitioned2_707 a_707 (cost=0.27..38.63 rows=62 width=226) (actual time=0.021..0.380 rows=539 loops=1)

195. 0.109 0.109 ↓ 10.7 629 1 / 4

Parallel Index Scan using road_network_partitioned2_540_pkey on road_network_partitioned2_540 a_540 (cost=0.27..38.04 rows=59 width=226) (actual time=0.023..0.436 rows=629 loops=1)

196. 2.460 2.460 ↓ 5.6 328 1 / 4

Parallel Index Only Scan using road_network_partitioned2_954_link_id_street_name_road_km_r_idx on road_network_partitioned2_954 a_954 (cost=0.27..37.04 rows=59 width=226) (actual time=0.066..9.839 rows=328 loops=1)

  • Heap Fetches: 328
197. 0.109 0.109 ↓ 12.4 655 1 / 4

Parallel Index Scan using road_network_partitioned2_457_pkey on road_network_partitioned2_457 a_457 (cost=0.27..34.86 rows=53 width=226) (actual time=0.014..0.435 rows=655 loops=1)

198. 0.097 0.097 ↓ 11.9 633 1 / 4

Parallel Index Scan using road_network_partitioned2_1074_pkey on road_network_partitioned2_1074 a_1074 (cost=0.27..34.86 rows=53 width=226) (actual time=0.020..0.387 rows=633 loops=1)

199. 0.076 0.076 ↓ 8.4 445 1 / 4

Parallel Index Scan using road_network_partitioned2_498_pkey on road_network_partitioned2_498 a_498 (cost=0.27..33.86 rows=53 width=226) (actual time=0.018..0.306 rows=445 loops=1)

200. 0.080 0.080 ↓ 9.6 509 1 / 4

Parallel Index Scan using road_network_partitioned2_622_pkey on road_network_partitioned2_622 a_622 (cost=0.27..33.86 rows=53 width=226) (actual time=0.022..0.319 rows=509 loops=1)

201. 0.102 0.102 ↓ 9.9 524 1 / 4

Parallel Index Scan using road_network_partitioned2_750_pkey on road_network_partitioned2_750 a_750 (cost=0.27..33.86 rows=53 width=226) (actual time=0.018..0.410 rows=524 loops=1)

202. 1.027 1.027 ↓ 9.1 483 1 / 4

Parallel Index Scan using road_network_partitioned2_976_pkey on road_network_partitioned2_976 a_976 (cost=0.27..33.86 rows=53 width=226) (actual time=0.016..4.108 rows=483 loops=1)

203. 0.079 0.079 ↓ 9.1 483 1 / 4

Parallel Index Scan using road_network_partitioned2_1016_pkey on road_network_partitioned2_1016 a_1016 (cost=0.27..33.86 rows=53 width=226) (actual time=0.014..0.316 rows=483 loops=1)

204. 0.069 0.069 ↓ 7.9 419 1 / 4

Parallel Index Scan using road_network_partitioned2_1017_pkey on road_network_partitioned2_1017 a_1017 (cost=0.27..33.86 rows=53 width=226) (actual time=0.018..0.276 rows=419 loops=1)

205. 0.353 0.353 ↓ 6.8 341 1 / 4

Parallel Index Only Scan using road_network_partitioned2_146_link_id_street_name_road_km_r_idx on road_network_partitioned2_146 a_146 (cost=0.27..32.27 rows=50 width=226) (actual time=1.193..1.412 rows=341 loops=1)

  • Heap Fetches: 341
206. 0.058 0.058 ↓ 7.5 374 1 / 4

Parallel Index Scan using road_network_partitioned2_368_pkey on road_network_partitioned2_368 a_368 (cost=0.27..32.27 rows=50 width=226) (actual time=0.016..0.233 rows=374 loops=1)

207. 0.093 0.093 ↓ 9.8 488 1 / 4

Parallel Index Scan using road_network_partitioned2_535_pkey on road_network_partitioned2_535 a_535 (cost=0.27..32.27 rows=50 width=226) (actual time=0.015..0.374 rows=488 loops=1)

208. 0.090 0.090 ↓ 11.5 576 1 / 4

Parallel Index Scan using road_network_partitioned2_891_pkey on road_network_partitioned2_891 a_891 (cost=0.27..32.27 rows=50 width=226) (actual time=0.029..0.360 rows=576 loops=1)

209. 0.645 0.645 ↓ 8.5 426 1 / 4

Parallel Index Scan using road_network_partitioned2_945_pkey on road_network_partitioned2_945 a_945 (cost=0.27..32.27 rows=50 width=226) (actual time=0.012..2.582 rows=426 loops=1)

210. 0.066 0.066 ↓ 7.5 375 1 / 4

Parallel Index Scan using road_network_partitioned2_991_pkey on road_network_partitioned2_991 a_991 (cost=0.27..32.27 rows=50 width=226) (actual time=0.015..0.263 rows=375 loops=1)

211. 0.094 0.094 ↓ 10.5 527 1 / 4

Parallel Index Scan using road_network_partitioned2_1033_pkey on road_network_partitioned2_1033 a_1033 (cost=0.27..32.27 rows=50 width=226) (actual time=0.025..0.376 rows=527 loops=1)

212. 0.072 0.072 ↓ 8.5 425 1 / 4

Parallel Index Scan using road_network_partitioned2_1377_pkey on road_network_partitioned2_1377 a_1377 (cost=0.27..32.27 rows=50 width=226) (actual time=0.017..0.289 rows=425 loops=1)

213. 0.444 0.444 ↓ 5.9 294 1 / 4

Parallel Index Scan using road_network_partitioned2_951_pkey on road_network_partitioned2_951 a_951 (cost=0.27..31.27 rows=50 width=226) (actual time=0.016..1.776 rows=294 loops=1)

214. 0.085 0.085 ↓ 10.3 484 1 / 4

Parallel Index Scan using road_network_partitioned2_578_pkey on road_network_partitioned2_578 a_578 (cost=0.27..30.68 rows=47 width=226) (actual time=0.016..0.340 rows=484 loops=1)

215. 0.076 0.076 ↓ 9.6 452 1 / 4

Parallel Index Scan using road_network_partitioned2_1031_pkey on road_network_partitioned2_1031 a_1031 (cost=0.27..30.68 rows=47 width=226) (actual time=0.014..0.303 rows=452 loops=1)

216. 0.060 0.060 ↓ 6.9 324 1 / 4

Parallel Index Scan using road_network_partitioned2_875_pkey on road_network_partitioned2_875 a_875 (cost=0.27..29.68 rows=47 width=226) (actual time=0.023..0.241 rows=324 loops=1)

217. 0.678 0.678 ↓ 6.8 319 1 / 4

Parallel Index Scan using road_network_partitioned2_917_pkey on road_network_partitioned2_917 a_917 (cost=0.27..29.68 rows=47 width=226) (actual time=0.028..2.711 rows=319 loops=1)

218. 0.071 0.071 ↓ 10.4 458 1 / 4

Parallel Index Scan using road_network_partitioned2_269_pkey on road_network_partitioned2_269 a_269 (cost=0.27..29.09 rows=44 width=226) (actual time=0.015..0.283 rows=458 loops=1)

219. 0.066 0.066 ↓ 9.2 407 1 / 4

Parallel Index Scan using road_network_partitioned2_491_pkey on road_network_partitioned2_491 a_491 (cost=0.27..29.09 rows=44 width=226) (actual time=0.012..0.262 rows=407 loops=1)

220. 0.061 0.061 ↓ 9.0 398 1 / 4

Parallel Index Scan using road_network_partitioned2_628_pkey on road_network_partitioned2_628 a_628 (cost=0.27..29.09 rows=44 width=226) (actual time=0.012..0.246 rows=398 loops=1)

221. 0.064 0.064 ↓ 9.6 422 1 / 4

Parallel Index Scan using road_network_partitioned2_664_pkey on road_network_partitioned2_664 a_664 (cost=0.27..29.09 rows=44 width=226) (actual time=0.017..0.257 rows=422 loops=1)

222. 0.068 0.068 ↓ 9.5 416 1 / 4

Parallel Index Scan using road_network_partitioned2_706_pkey on road_network_partitioned2_706 a_706 (cost=0.27..29.09 rows=44 width=226) (actual time=0.019..0.272 rows=416 loops=1)

223. 0.117 0.117 ↓ 8.0 350 1 / 4

Parallel Index Scan using road_network_partitioned2_874_pkey on road_network_partitioned2_874 a_874 (cost=0.27..29.09 rows=44 width=226) (actual time=0.239..0.467 rows=350 loops=1)

224. 0.315 0.315 ↓ 8.5 347 1 / 4

Parallel Index Only Scan using road_network_partitioned2_493_link_id_street_name_road_km_r_idx on road_network_partitioned2_493 a_493 (cost=0.27..27.51 rows=41 width=226) (actual time=0.981..1.259 rows=347 loops=1)

  • Heap Fetches: 347
225. 0.685 0.685 ↓ 8.5 349 1 / 4

Parallel Index Scan using road_network_partitioned2_583_pkey on road_network_partitioned2_583 a_583 (cost=0.27..27.51 rows=41 width=226) (actual time=0.018..2.739 rows=349 loops=1)

226. 0.052 0.052 ↓ 7.9 325 1 / 4

Parallel Index Scan using road_network_partitioned2_495_pkey on road_network_partitioned2_495 a_495 (cost=0.27..26.51 rows=41 width=226) (actual time=0.018..0.207 rows=325 loops=1)

227. 0.067 0.067 ↓ 11.9 452 1 / 4

Parallel Index Scan using road_network_partitioned2_427_pkey on road_network_partitioned2_427 a_427 (cost=0.27..25.92 rows=38 width=226) (actual time=0.017..0.266 rows=452 loops=1)

228. 0.068 0.068 ↓ 12.8 485 1 / 4

Parallel Index Scan using road_network_partitioned2_489_pkey on road_network_partitioned2_489 a_489 (cost=0.27..25.92 rows=38 width=226) (actual time=0.015..0.272 rows=485 loops=1)

229. 0.840 0.840 ↓ 9.7 369 1 / 4

Parallel Index Scan using road_network_partitioned2_579_pkey on road_network_partitioned2_579 a_579 (cost=0.27..25.92 rows=38 width=226) (actual time=3.141..3.361 rows=369 loops=1)

230. 0.056 0.056 ↓ 9.4 357 1 / 4

Parallel Index Scan using road_network_partitioned2_974_pkey on road_network_partitioned2_974 a_974 (cost=0.27..25.92 rows=38 width=226) (actual time=0.019..0.225 rows=357 loops=1)

231. 0.069 0.069 ↓ 10.7 408 1 / 4

Parallel Index Scan using road_network_partitioned2_988_pkey on road_network_partitioned2_988 a_988 (cost=0.27..25.92 rows=38 width=226) (actual time=0.012..0.274 rows=408 loops=1)

232. 0.047 0.047 ↓ 9.3 324 1 / 4

Parallel Index Scan using road_network_partitioned2_230_pkey on road_network_partitioned2_230 a_230 (cost=0.27..23.33 rows=35 width=226) (actual time=0.017..0.189 rows=324 loops=1)

233. 0.049 0.049 ↓ 9.2 321 1 / 4

Parallel Index Scan using road_network_partitioned2_492_pkey on road_network_partitioned2_492 a_492 (cost=0.27..23.33 rows=35 width=226) (actual time=0.020..0.197 rows=321 loops=1)

234. 0.054 0.054 ↓ 8.8 309 1 / 4

Parallel Index Scan using road_network_partitioned2_748_pkey on road_network_partitioned2_748 a_748 (cost=0.27..23.33 rows=35 width=226) (actual time=0.013..0.216 rows=309 loops=1)

235. 0.049 0.049 ↓ 9.8 314 1 / 4

Parallel Index Scan using road_network_partitioned2_620_pkey on road_network_partitioned2_620 a_620 (cost=0.27..21.74 rows=32 width=226) (actual time=0.013..0.195 rows=314 loops=1)

236. 0.051 0.051 ↓ 9.2 293 1 / 4

Parallel Index Scan using road_network_partitioned2_790_pkey on road_network_partitioned2_790 a_790 (cost=0.27..21.74 rows=32 width=226) (actual time=0.019..0.206 rows=293 loops=1)

237. 0.063 0.063 ↓ 11.8 342 1 / 4

Parallel Index Scan using road_network_partitioned2_467_pkey on road_network_partitioned2_467 a_467 (cost=0.27..21.15 rows=29 width=226) (actual time=0.011..0.252 rows=342 loops=1)

238. 0.048 0.048 ↓ 10.6 306 1 / 4

Parallel Index Scan using road_network_partitioned2_1292_pkey on road_network_partitioned2_1292 a_1292 (cost=0.27..20.15 rows=29 width=226) (actual time=0.020..0.192 rows=306 loops=1)

239. 0.048 0.048 ↓ 4.3 253 1 / 4

Parallel Index Scan using road_network_partitioned2_552_pkey on road_network_partitioned2_552 a_552 (cost=0.14..33.91 rows=59 width=226) (actual time=0.017..0.192 rows=253 loops=1)

240. 0.055 0.055 ↓ 5.1 268 1 / 4

Parallel Index Scan using road_network_partitioned2_410_pkey on road_network_partitioned2_410 a_410 (cost=0.14..30.74 rows=53 width=226) (actual time=0.014..0.219 rows=268 loops=1)

241. 0.042 0.042 ↓ 3.7 194 1 / 4

Parallel Index Scan using road_network_partitioned2_909_pkey on road_network_partitioned2_909 a_909 (cost=0.14..30.74 rows=53 width=226) (actual time=0.014..0.168 rows=194 loops=1)

242. 0.032 0.032 ↓ 3.0 151 1 / 4

Parallel Index Scan using road_network_partitioned2_890_pkey on road_network_partitioned2_890 a_890 (cost=0.14..29.15 rows=50 width=226) (actual time=0.013..0.128 rows=151 loops=1)

243. 0.043 0.043 ↓ 5.0 219 1 / 4

Parallel Index Scan using road_network_partitioned2_496_pkey on road_network_partitioned2_496 a_496 (cost=0.14..25.97 rows=44 width=226) (actual time=0.015..0.172 rows=219 loops=1)

244. 0.044 0.044 ↓ 6.8 279 1 / 4

Parallel Index Scan using road_network_partitioned2_243_pkey on road_network_partitioned2_243 a_243 (cost=0.14..24.38 rows=41 width=226) (actual time=0.015..0.177 rows=279 loops=1)

245. 0.044 0.044 ↓ 6.3 258 1 / 4

Parallel Index Scan using road_network_partitioned2_497_pkey on road_network_partitioned2_497 a_497 (cost=0.14..24.38 rows=41 width=226) (actual time=0.021..0.176 rows=258 loops=1)

246. 0.047 0.047 ↓ 6.2 256 1 / 4

Parallel Index Scan using road_network_partitioned2_955_pkey on road_network_partitioned2_955 a_955 (cost=0.14..24.38 rows=41 width=226) (actual time=0.015..0.188 rows=256 loops=1)

247. 0.034 0.034 ↓ 4.3 176 1 / 4

Parallel Index Scan using road_network_partitioned2_996_pkey on road_network_partitioned2_996 a_996 (cost=0.14..24.38 rows=41 width=226) (actual time=0.012..0.134 rows=176 loops=1)

248. 0.730 0.730 ↓ 3.2 120 1 / 4

Parallel Index Only Scan using road_network_partitioned2_268_link_id_street_name_road_km_r_idx on road_network_partitioned2_268 a_268 (cost=0.14..22.79 rows=38 width=226) (actual time=2.830..2.919 rows=120 loops=1)

  • Heap Fetches: 120
249. 0.030 0.030 ↓ 4.0 153 1 / 4

Parallel Index Scan using road_network_partitioned2_453_pkey on road_network_partitioned2_453 a_453 (cost=0.14..22.79 rows=38 width=226) (actual time=0.015..0.119 rows=153 loops=1)

250. 0.043 0.043 ↓ 6.9 263 1 / 4

Parallel Index Scan using road_network_partitioned2_539_pkey on road_network_partitioned2_539 a_539 (cost=0.14..22.79 rows=38 width=226) (actual time=0.012..0.172 rows=263 loops=1)

251. 0.036 0.036 ↓ 5.4 206 1 / 4

Parallel Index Scan using road_network_partitioned2_581_pkey on road_network_partitioned2_581 a_581 (cost=0.14..22.79 rows=38 width=226) (actual time=0.016..0.145 rows=206 loops=1)

252. 0.046 0.046 ↓ 7.3 277 1 / 4

Parallel Index Scan using road_network_partitioned2_958_pkey on road_network_partitioned2_958 a_958 (cost=0.14..22.79 rows=38 width=226) (actual time=0.018..0.184 rows=277 loops=1)

253. 0.747 0.747 ↓ 2.9 100 1 / 4

Parallel Index Only Scan using road_network_partitioned2_233_link_id_street_name_road_km_r_idx on road_network_partitioned2_233 a_233 (cost=0.14..21.20 rows=35 width=226) (actual time=2.906..2.989 rows=100 loops=1)

  • Heap Fetches: 100
254. 0.040 0.040 ↓ 6.8 239 1 / 4

Parallel Index Scan using road_network_partitioned2_448_pkey on road_network_partitioned2_448 a_448 (cost=0.14..21.20 rows=35 width=226) (actual time=0.020..0.159 rows=239 loops=1)

255. 0.040 0.040 ↓ 6.6 231 1 / 4

Parallel Index Scan using road_network_partitioned2_791_pkey on road_network_partitioned2_791 a_791 (cost=0.14..21.20 rows=35 width=226) (actual time=0.012..0.160 rows=231 loops=1)

256. 0.047 0.047 ↓ 7.6 267 1 / 4

Parallel Index Scan using road_network_partitioned2_792_pkey on road_network_partitioned2_792 a_792 (cost=0.14..21.20 rows=35 width=226) (actual time=0.014..0.189 rows=267 loops=1)

257. 0.040 0.040 ↓ 5.7 200 1 / 4

Parallel Index Scan using road_network_partitioned2_832_pkey on road_network_partitioned2_832 a_832 (cost=0.14..21.20 rows=35 width=226) (actual time=0.013..0.161 rows=200 loops=1)

258. 0.043 0.043 ↓ 6.1 214 1 / 4

Parallel Index Scan using road_network_partitioned2_870_pkey on road_network_partitioned2_870 a_870 (cost=0.14..21.20 rows=35 width=226) (actual time=0.020..0.170 rows=214 loops=1)

259. 0.040 0.040 ↓ 6.5 229 1 / 4

Parallel Index Scan using road_network_partitioned2_892_pkey on road_network_partitioned2_892 a_892 (cost=0.14..21.20 rows=35 width=226) (actual time=0.016..0.160 rows=229 loops=1)

260. 0.034 0.034 ↓ 3.6 126 1 / 4

Parallel Index Only Scan using road_network_partitioned2_913_link_id_street_name_road_km_r_idx on road_network_partitioned2_913 a_913 (cost=0.14..21.20 rows=35 width=226) (actual time=0.040..0.137 rows=126 loops=1)

  • Heap Fetches: 126
261. 0.038 0.038 ↓ 6.1 215 1 / 4

Parallel Index Scan using road_network_partitioned2_998_pkey on road_network_partitioned2_998 a_998 (cost=0.14..21.20 rows=35 width=226) (actual time=0.011..0.151 rows=215 loops=1)

262. 0.029 0.029 ↓ 4.8 167 1 / 4

Parallel Index Scan using road_network_partitioned2_999_pkey on road_network_partitioned2_999 a_999 (cost=0.14..21.20 rows=35 width=226) (actual time=0.017..0.118 rows=167 loops=1)

263. 0.031 0.031 ↓ 6.7 213 1 / 4

Parallel Index Scan using road_network_partitioned2_147_pkey on road_network_partitioned2_147 a_147 (cost=0.14..19.61 rows=32 width=226) (actual time=0.011..0.123 rows=213 loops=1)

264. 0.040 0.040 ↓ 8.7 278 1 / 4

Parallel Index Scan using road_network_partitioned2_365_pkey on road_network_partitioned2_365 a_365 (cost=0.14..19.61 rows=32 width=226) (actual time=0.012..0.161 rows=278 loops=1)

265. 0.037 0.037 ↓ 6.8 219 1 / 4

Parallel Index Scan using road_network_partitioned2_367_pkey on road_network_partitioned2_367 a_367 (cost=0.14..19.61 rows=32 width=226) (actual time=0.018..0.147 rows=219 loops=1)

266. 0.042 0.042 ↓ 8.4 268 1 / 4

Parallel Index Scan using road_network_partitioned2_651_pkey on road_network_partitioned2_651 a_651 (cost=0.14..19.61 rows=32 width=226) (actual time=0.012..0.168 rows=268 loops=1)

267. 0.032 0.032 ↓ 4.4 140 1 / 4

Parallel Index Only Scan using road_network_partitioned2_666_link_id_street_name_road_km_r_idx on road_network_partitioned2_666 a_666 (cost=0.14..19.61 rows=32 width=226) (actual time=0.041..0.126 rows=140 loops=1)

  • Heap Fetches: 140
268. 0.039 0.039 ↓ 6.8 217 1 / 4

Parallel Index Scan using road_network_partitioned2_833_pkey on road_network_partitioned2_833 a_833 (cost=0.14..19.61 rows=32 width=226) (actual time=0.012..0.155 rows=217 loops=1)

269. 0.030 0.030 ↓ 5.3 171 1 / 4

Parallel Index Scan using road_network_partitioned2_1040_pkey on road_network_partitioned2_1040 a_1040 (cost=0.14..19.61 rows=32 width=226) (actual time=0.013..0.122 rows=171 loops=1)

270. 0.214 0.214 ↓ 2.8 80 1 / 4

Parallel Index Only Scan using road_network_partitioned2_72_link_id_street_name_road_km_ro_idx on road_network_partitioned2_72 a_72 (cost=0.14..18.02 rows=29 width=226) (actual time=0.705..0.855 rows=80 loops=1)

  • Heap Fetches: 80
271. 0.005 0.005 ↑ 4.8 6 1 / 4

Parallel Index Only Scan using road_network_partitioned2_104_link_id_street_name_road_km_r_idx on road_network_partitioned2_104 a_104 (cost=0.14..18.02 rows=29 width=226) (actual time=0.016..0.019 rows=6 loops=1)

  • Heap Fetches: 6
272. 0.007 0.007 ↑ 1.5 19 1 / 4

Parallel Index Only Scan using road_network_partitioned2_105_link_id_street_name_road_km_r_idx on road_network_partitioned2_105 a_105 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.030 rows=19 loops=1)

  • Heap Fetches: 19
273. 0.769 0.769 ↓ 2.1 61 1 / 4

Parallel Index Only Scan using road_network_partitioned2_106_link_id_street_name_road_km_r_idx on road_network_partitioned2_106 a_106 (cost=0.14..18.02 rows=29 width=226) (actual time=3.039..3.078 rows=61 loops=1)

  • Heap Fetches: 61
274. 0.320 0.320 ↓ 1.8 51 1 / 4

Parallel Index Only Scan using road_network_partitioned2_107_link_id_street_name_road_km_r_idx on road_network_partitioned2_107 a_107 (cost=0.14..18.02 rows=29 width=226) (actual time=1.255..1.279 rows=51 loops=1)

  • Heap Fetches: 51
275. 0.007 0.007 ↑ 1.4 21 1 / 4

Parallel Index Only Scan using road_network_partitioned2_108_link_id_street_name_road_km_r_idx on road_network_partitioned2_108 a_108 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.029 rows=21 loops=1)

  • Heap Fetches: 21
276. 0.012 0.012 ↓ 1.7 49 1 / 4

Parallel Index Only Scan using road_network_partitioned2_109_link_id_street_name_road_km_r_idx on road_network_partitioned2_109 a_109 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.047 rows=49 loops=1)

  • Heap Fetches: 49
277. 0.005 0.005 ↑ 14.5 2 1 / 4

Parallel Index Only Scan using road_network_partitioned2_114_link_id_street_name_road_km_r_idx on road_network_partitioned2_114 a_114 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.019 rows=2 loops=1)

  • Heap Fetches: 2
278. 0.165 0.165 ↓ 1.1 33 1 / 4

Parallel Index Only Scan using road_network_partitioned2_115_link_id_street_name_road_km_r_idx on road_network_partitioned2_115 a_115 (cost=0.14..18.02 rows=29 width=226) (actual time=0.639..0.658 rows=33 loops=1)

  • Heap Fetches: 33
279. 0.221 0.221 ↑ 1.0 29 1 / 4

Parallel Index Only Scan using road_network_partitioned2_144_link_id_street_name_road_km_r_idx on road_network_partitioned2_144 a_144 (cost=0.14..18.02 rows=29 width=226) (actual time=0.867..0.882 rows=29 loops=1)

  • Heap Fetches: 29
280. 0.725 0.725 ↑ 4.1 7 1 / 4

Parallel Index Only Scan using road_network_partitioned2_148_link_id_street_name_road_km_r_idx on road_network_partitioned2_148 a_148 (cost=0.14..18.02 rows=29 width=226) (actual time=2.896..2.900 rows=7 loops=1)

  • Heap Fetches: 7
281. 0.014 0.014 ↓ 1.8 53 1 / 4

Parallel Index Only Scan using road_network_partitioned2_149_link_id_street_name_road_km_r_idx on road_network_partitioned2_149 a_149 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.055 rows=53 loops=1)

  • Heap Fetches: 53
282. 0.266 0.266 ↓ 2.0 58 1 / 4

Parallel Index Only Scan using road_network_partitioned2_150_link_id_street_name_road_km_r_idx on road_network_partitioned2_150 a_150 (cost=0.14..18.02 rows=29 width=226) (actual time=1.035..1.063 rows=58 loops=1)

  • Heap Fetches: 58
283. 0.005 0.005 ↑ 7.2 4 1 / 4

Parallel Index Only Scan using road_network_partitioned2_151_link_id_street_name_road_km_r_idx on road_network_partitioned2_151 a_151 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.021 rows=4 loops=1)

  • Heap Fetches: 4
284. 0.024 0.024 ↓ 4.4 129 1 / 4

Parallel Index Only Scan using road_network_partitioned2_156_link_id_street_name_road_km_r_idx on road_network_partitioned2_156 a_156 (cost=0.14..18.02 rows=29 width=226) (actual time=0.032..0.096 rows=129 loops=1)

  • Heap Fetches: 129
285. 0.136 0.136 ↓ 1.4 41 1 / 4

Parallel Index Only Scan using road_network_partitioned2_157_link_id_street_name_road_km_r_idx on road_network_partitioned2_157 a_157 (cost=0.14..18.02 rows=29 width=226) (actual time=0.521..0.543 rows=41 loops=1)

  • Heap Fetches: 41
286. 0.011 0.011 ↑ 1.2 25 1 / 4

Parallel Index Only Scan using road_network_partitioned2_183_link_id_street_name_road_km_r_idx on road_network_partitioned2_183 a_183 (cost=0.14..18.02 rows=29 width=226) (actual time=0.028..0.042 rows=25 loops=1)

  • Heap Fetches: 25
287. 0.348 0.348 ↓ 3.8 111 1 / 4

Parallel Index Only Scan using road_network_partitioned2_187_link_id_street_name_road_km_r_idx on road_network_partitioned2_187 a_187 (cost=0.14..18.02 rows=29 width=226) (actual time=1.314..1.393 rows=111 loops=1)

  • Heap Fetches: 111
288. 0.702 0.702 ↑ 1.2 24 1 / 4

Parallel Index Only Scan using road_network_partitioned2_189_link_id_street_name_road_km_r_idx on road_network_partitioned2_189 a_189 (cost=0.14..18.02 rows=29 width=226) (actual time=2.794..2.807 rows=24 loops=1)

  • Heap Fetches: 24
289. 0.550 0.550 ↓ 3.5 102 1 / 4

Parallel Index Only Scan using road_network_partitioned2_190_link_id_street_name_road_km_r_idx on road_network_partitioned2_190 a_190 (cost=0.14..18.02 rows=29 width=226) (actual time=2.126..2.200 rows=102 loops=1)

  • Heap Fetches: 102
290. 0.014 0.014 ↑ 1.6 18 1 / 4

Parallel Index Only Scan using road_network_partitioned2_191_link_id_street_name_road_km_r_idx on road_network_partitioned2_191 a_191 (cost=0.14..18.02 rows=29 width=226) (actual time=0.035..0.055 rows=18 loops=1)

  • Heap Fetches: 18
291. 0.010 0.010 ↓ 1.1 31 1 / 4

Parallel Index Only Scan using road_network_partitioned2_192_link_id_street_name_road_km_r_idx on road_network_partitioned2_192 a_192 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.040 rows=31 loops=1)

  • Heap Fetches: 31
292. 0.005 0.005 ↑ 7.2 4 1 / 4

Parallel Index Only Scan using road_network_partitioned2_198_link_id_street_name_road_km_r_idx on road_network_partitioned2_198 a_198 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.022 rows=4 loops=1)

  • Heap Fetches: 4
293. 0.026 0.026 ↓ 3.6 103 1 / 4

Parallel Index Only Scan using road_network_partitioned2_199_link_id_street_name_road_km_r_idx on road_network_partitioned2_199 a_199 (cost=0.14..18.02 rows=29 width=226) (actual time=0.034..0.105 rows=103 loops=1)

  • Heap Fetches: 103
294. 0.018 0.018 ↑ 29.0 1 1 / 4

Parallel Index Only Scan using road_network_partitioned2_201_link_id_street_name_road_km_r_idx on road_network_partitioned2_201 a_201 (cost=0.14..18.02 rows=29 width=226) (actual time=0.071..0.072 rows=1 loops=1)

  • Heap Fetches: 1
295. 0.009 0.009 ↑ 1.4 21 1 / 4

Parallel Index Only Scan using road_network_partitioned2_224_link_id_street_name_road_km_r_idx on road_network_partitioned2_224 a_224 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.038 rows=21 loops=1)

  • Heap Fetches: 21
296. 0.006 0.006 ↑ 4.8 6 1 / 4

Parallel Index Only Scan using road_network_partitioned2_225_link_id_street_name_road_km_r_idx on road_network_partitioned2_225 a_225 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.023 rows=6 loops=1)

  • Heap Fetches: 6
297. 0.151 0.151 ↓ 1.1 32 1 / 4

Parallel Index Only Scan using road_network_partitioned2_226_link_id_street_name_road_km_r_idx on road_network_partitioned2_226 a_226 (cost=0.14..18.02 rows=29 width=226) (actual time=0.594..0.606 rows=32 loops=1)

  • Heap Fetches: 32
298. 0.006 0.006 ↑ 1.5 19 1 / 4

Parallel Index Only Scan using road_network_partitioned2_227_link_id_street_name_road_km_r_idx on road_network_partitioned2_227 a_227 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.026 rows=19 loops=1)

  • Heap Fetches: 19
299. 0.160 0.160 ↓ 1.1 33 1 / 4

Parallel Index Only Scan using road_network_partitioned2_229_link_id_street_name_road_km_r_idx on road_network_partitioned2_229 a_229 (cost=0.14..18.02 rows=29 width=226) (actual time=0.618..0.640 rows=33 loops=1)

  • Heap Fetches: 33
300. 0.039 0.039 ↓ 8.9 258 1 / 4

Parallel Index Scan using road_network_partitioned2_231_pkey on road_network_partitioned2_231 a_231 (cost=0.14..18.02 rows=29 width=226) (actual time=0.012..0.156 rows=258 loops=1)

301. 0.014 0.014 ↓ 1.9 55 1 / 4

Parallel Index Only Scan using road_network_partitioned2_232_link_id_street_name_road_km_r_idx on road_network_partitioned2_232 a_232 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.056 rows=55 loops=1)

  • Heap Fetches: 55
302. 0.015 0.015 ↓ 2.1 62 1 / 4

Parallel Index Only Scan using road_network_partitioned2_240_link_id_street_name_road_km_r_idx on road_network_partitioned2_240 a_240 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.062 rows=62 loops=1)

  • Heap Fetches: 62
303. 0.132 0.132 ↓ 2.2 64 1 / 4

Parallel Index Only Scan using road_network_partitioned2_241_link_id_street_name_road_km_r_idx on road_network_partitioned2_241 a_241 (cost=0.14..18.02 rows=29 width=226) (actual time=0.481..0.526 rows=64 loops=1)

  • Heap Fetches: 64
304. 0.714 0.714 ↓ 3.6 104 1 / 4

Parallel Index Only Scan using road_network_partitioned2_242_link_id_street_name_road_km_r_idx on road_network_partitioned2_242 a_242 (cost=0.14..18.02 rows=29 width=226) (actual time=2.800..2.854 rows=104 loops=1)

  • Heap Fetches: 104
305. 0.009 0.009 ↑ 1.5 19 1 / 4

Parallel Index Only Scan using road_network_partitioned2_266_link_id_street_name_road_km_r_idx on road_network_partitioned2_266 a_266 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.037 rows=19 loops=1)

  • Heap Fetches: 19
306. 0.018 0.018 ↓ 1.3 39 1 / 4

Parallel Index Only Scan using road_network_partitioned2_267_link_id_street_name_road_km_r_idx on road_network_partitioned2_267 a_267 (cost=0.14..18.02 rows=29 width=226) (actual time=0.038..0.074 rows=39 loops=1)

  • Heap Fetches: 39
307. 1.381 1.381 ↓ 4.4 128 1 / 4

Parallel Index Only Scan using road_network_partitioned2_270_link_id_street_name_road_km_r_idx on road_network_partitioned2_270 a_270 (cost=0.14..18.02 rows=29 width=226) (actual time=5.458..5.525 rows=128 loops=1)

  • Heap Fetches: 128
308. 0.037 0.037 ↓ 7.0 204 1 / 4

Parallel Index Scan using road_network_partitioned2_271_pkey on road_network_partitioned2_271 a_271 (cost=0.14..18.02 rows=29 width=226) (actual time=0.024..0.150 rows=204 loops=1)

309. 0.012 0.012 ↓ 1.6 45 1 / 4

Parallel Index Only Scan using road_network_partitioned2_272_link_id_street_name_road_km_r_idx on road_network_partitioned2_272 a_272 (cost=0.14..18.02 rows=29 width=226) (actual time=0.028..0.049 rows=45 loops=1)

  • Heap Fetches: 45
310. 0.026 0.026 ↓ 5.4 157 1 / 4

Parallel Index Scan using road_network_partitioned2_273_pkey on road_network_partitioned2_273 a_273 (cost=0.14..18.02 rows=29 width=226) (actual time=0.013..0.105 rows=157 loops=1)

311. 0.024 0.024 ↓ 2.0 58 1 / 4

Parallel Index Only Scan using road_network_partitioned2_274_link_id_street_name_road_km_r_idx on road_network_partitioned2_274 a_274 (cost=0.14..18.02 rows=29 width=226) (actual time=0.038..0.094 rows=58 loops=1)

  • Heap Fetches: 58
312. 0.008 0.008 ↑ 4.8 6 1 / 4

Parallel Index Only Scan using road_network_partitioned2_275_link_id_street_name_road_km_r_idx on road_network_partitioned2_275 a_275 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.032 rows=6 loops=1)

  • Heap Fetches: 6
313. 0.242 0.242 ↓ 3.0 87 1 / 4

Parallel Index Only Scan using road_network_partitioned2_276_link_id_street_name_road_km_r_idx on road_network_partitioned2_276 a_276 (cost=0.14..18.02 rows=29 width=226) (actual time=0.905..0.969 rows=87 loops=1)

  • Heap Fetches: 87
314. 0.012 0.012 ↑ 1.1 26 1 / 4

Parallel Index Only Scan using road_network_partitioned2_277_link_id_street_name_road_km_r_idx on road_network_partitioned2_277 a_277 (cost=0.14..18.02 rows=29 width=226) (actual time=0.027..0.047 rows=26 loops=1)

  • Heap Fetches: 26
315. 0.220 0.220 ↓ 1.6 45 1 / 4

Parallel Index Only Scan using road_network_partitioned2_282_link_id_street_name_road_km_r_idx on road_network_partitioned2_282 a_282 (cost=0.14..18.02 rows=29 width=226) (actual time=0.774..0.881 rows=45 loops=1)

  • Heap Fetches: 45
316. 0.186 0.186 ↓ 1.5 44 1 / 4

Parallel Index Only Scan using road_network_partitioned2_283_link_id_street_name_road_km_r_idx on road_network_partitioned2_283 a_283 (cost=0.14..18.02 rows=29 width=226) (actual time=0.715..0.746 rows=44 loops=1)

  • Heap Fetches: 44
317. 0.022 0.022 ↓ 3.7 106 1 / 4

Parallel Index Only Scan using road_network_partitioned2_284_link_id_street_name_road_km_r_idx on road_network_partitioned2_284 a_284 (cost=0.14..18.02 rows=29 width=226) (actual time=0.023..0.088 rows=106 loops=1)

  • Heap Fetches: 106
318. 0.836 0.836 ↓ 3.1 89 1 / 4

Parallel Index Only Scan using road_network_partitioned2_306_link_id_street_name_road_km_r_idx on road_network_partitioned2_306 a_306 (cost=0.14..18.02 rows=29 width=226) (actual time=3.301..3.345 rows=89 loops=1)

  • Heap Fetches: 89
319. 0.026 0.026 ↓ 1.5 44 1 / 4

Parallel Index Only Scan using road_network_partitioned2_307_link_id_street_name_road_km_r_idx on road_network_partitioned2_307 a_307 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.106 rows=44 loops=1)

  • Heap Fetches: 44
320. 0.017 0.017 ↑ 5.8 5 1 / 4

Parallel Index Only Scan using road_network_partitioned2_308_link_id_street_name_road_km_r_idx on road_network_partitioned2_308 a_308 (cost=0.14..18.02 rows=29 width=226) (actual time=0.065..0.069 rows=5 loops=1)

  • Heap Fetches: 5
321. 0.008 0.008 ↑ 2.6 11 1 / 4

Parallel Index Only Scan using road_network_partitioned2_309_link_id_street_name_road_km_r_idx on road_network_partitioned2_309 a_309 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.033 rows=11 loops=1)

  • Heap Fetches: 11
322. 0.028 0.028 ↓ 5.3 155 1 / 4

Parallel Index Scan using road_network_partitioned2_310_pkey on road_network_partitioned2_310 a_310 (cost=0.14..18.02 rows=29 width=226) (actual time=0.010..0.111 rows=155 loops=1)

323. 0.009 0.009 ↓ 1.1 32 1 / 4

Parallel Index Only Scan using road_network_partitioned2_311_link_id_street_name_road_km_r_idx on road_network_partitioned2_311 a_311 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.036 rows=32 loops=1)

  • Heap Fetches: 32
324. 0.005 0.005 ↑ 4.8 6 1 / 4

Parallel Index Only Scan using road_network_partitioned2_312_link_id_street_name_road_km_r_idx on road_network_partitioned2_312 a_312 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.022 rows=6 loops=1)

  • Heap Fetches: 6
325. 0.642 0.642 ↓ 2.8 81 1 / 4

Parallel Index Only Scan using road_network_partitioned2_313_link_id_street_name_road_km_r_idx on road_network_partitioned2_313 a_313 (cost=0.14..18.02 rows=29 width=226) (actual time=2.524..2.570 rows=81 loops=1)

  • Heap Fetches: 81
326. 0.235 0.235 ↓ 1.7 49 1 / 4

Parallel Index Only Scan using road_network_partitioned2_314_link_id_street_name_road_km_r_idx on road_network_partitioned2_314 a_314 (cost=0.14..18.02 rows=29 width=226) (actual time=0.916..0.940 rows=49 loops=1)

  • Heap Fetches: 49
327. 0.013 0.013 ↓ 2.4 70 1 / 4

Parallel Index Only Scan using road_network_partitioned2_315_link_id_street_name_road_km_r_idx on road_network_partitioned2_315 a_315 (cost=0.14..18.02 rows=29 width=226) (actual time=0.022..0.054 rows=70 loops=1)

  • Heap Fetches: 70
328. 0.014 0.014 ↓ 1.9 54 1 / 4

Parallel Index Only Scan using road_network_partitioned2_317_link_id_street_name_road_km_r_idx on road_network_partitioned2_317 a_317 (cost=0.14..18.02 rows=29 width=226) (actual time=0.026..0.057 rows=54 loops=1)

  • Heap Fetches: 54
329. 0.974 0.974 ↓ 5.0 144 1 / 4

Parallel Index Only Scan using road_network_partitioned2_318_link_id_street_name_road_km_r_idx on road_network_partitioned2_318 a_318 (cost=0.14..18.02 rows=29 width=226) (actual time=3.698..3.894 rows=144 loops=1)

  • Heap Fetches: 144
330. 0.195 0.195 ↑ 1.5 19 1 / 4

Parallel Index Only Scan using road_network_partitioned2_319_link_id_street_name_road_km_r_idx on road_network_partitioned2_319 a_319 (cost=0.14..18.02 rows=29 width=226) (actual time=0.773..0.781 rows=19 loops=1)

  • Heap Fetches: 19
331. 0.216 0.216 ↓ 1.6 47 1 / 4

Parallel Index Only Scan using road_network_partitioned2_320_link_id_street_name_road_km_r_idx on road_network_partitioned2_320 a_320 (cost=0.14..18.02 rows=29 width=226) (actual time=0.835..0.864 rows=47 loops=1)

  • Heap Fetches: 47
332. 0.183 0.183 ↓ 1.3 39 1 / 4

Parallel Index Only Scan using road_network_partitioned2_323_link_id_street_name_road_km_r_idx on road_network_partitioned2_323 a_323 (cost=0.14..18.02 rows=29 width=226) (actual time=0.714..0.733 rows=39 loops=1)

  • Heap Fetches: 39
333. 0.022 0.022 ↓ 3.2 94 1 / 4

Parallel Index Only Scan using road_network_partitioned2_324_link_id_street_name_road_km_r_idx on road_network_partitioned2_324 a_324 (cost=0.14..18.02 rows=29 width=226) (actual time=0.030..0.088 rows=94 loops=1)

  • Heap Fetches: 94
334. 0.007 0.007 ↑ 3.6 8 1 / 4

Parallel Index Only Scan using road_network_partitioned2_325_link_id_street_name_road_km_r_idx on road_network_partitioned2_325 a_325 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.029 rows=8 loops=1)

  • Heap Fetches: 8
335. 0.165 0.165 ↓ 2.7 79 1 / 4

Parallel Index Only Scan using road_network_partitioned2_326_link_id_street_name_road_km_r_idx on road_network_partitioned2_326 a_326 (cost=0.14..18.02 rows=29 width=226) (actual time=0.621..0.661 rows=79 loops=1)

  • Heap Fetches: 79
336. 0.030 0.030 ↓ 7.6 220 1 / 4

Parallel Index Scan using road_network_partitioned2_346_pkey on road_network_partitioned2_346 a_346 (cost=0.14..18.02 rows=29 width=226) (actual time=0.010..0.121 rows=220 loops=1)

337. 0.014 0.014 ↓ 2.2 65 1 / 4

Parallel Index Only Scan using road_network_partitioned2_347_link_id_street_name_road_km_r_idx on road_network_partitioned2_347 a_347 (cost=0.14..18.02 rows=29 width=226) (actual time=0.021..0.055 rows=65 loops=1)

  • Heap Fetches: 65
338. 0.312 0.312 ↓ 3.8 110 1 / 4

Parallel Index Only Scan using road_network_partitioned2_348_link_id_street_name_road_km_r_idx on road_network_partitioned2_348 a_348 (cost=0.14..18.02 rows=29 width=226) (actual time=1.185..1.248 rows=110 loops=1)

  • Heap Fetches: 110
339. 0.204 0.204 ↓ 2.2 64 1 / 4

Parallel Index Only Scan using road_network_partitioned2_349_link_id_street_name_road_km_r_idx on road_network_partitioned2_349 a_349 (cost=0.14..18.02 rows=29 width=226) (actual time=0.782..0.818 rows=64 loops=1)

  • Heap Fetches: 64
340. 0.178 0.178 ↓ 2.8 81 1 / 4

Parallel Index Only Scan using road_network_partitioned2_350_link_id_street_name_road_km_r_idx on road_network_partitioned2_350 a_350 (cost=0.14..18.02 rows=29 width=226) (actual time=0.662..0.713 rows=81 loops=1)

  • Heap Fetches: 81
341. 0.007 0.007 ↑ 2.9 10 1 / 4

Parallel Index Only Scan using road_network_partitioned2_351_link_id_street_name_road_km_r_idx on road_network_partitioned2_351 a_351 (cost=0.14..18.02 rows=29 width=226) (actual time=0.022..0.028 rows=10 loops=1)

  • Heap Fetches: 10
342. 0.504 0.504 ↓ 4.3 124 1 / 4

Parallel Index Only Scan using road_network_partitioned2_352_link_id_street_name_road_km_r_idx on road_network_partitioned2_352 a_352 (cost=0.14..18.02 rows=29 width=226) (actual time=1.943..2.015 rows=124 loops=1)

  • Heap Fetches: 124
343. 0.015 0.015 ↓ 1.7 48 1 / 4

Parallel Index Only Scan using road_network_partitioned2_353_link_id_street_name_road_km_r_idx on road_network_partitioned2_353 a_353 (cost=0.14..18.02 rows=29 width=226) (actual time=0.032..0.061 rows=48 loops=1)

  • Heap Fetches: 48
344. 0.009 0.009 ↓ 1.3 37 1 / 4

Parallel Index Only Scan using road_network_partitioned2_354_link_id_street_name_road_km_r_idx on road_network_partitioned2_354 a_354 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.035 rows=37 loops=1)

  • Heap Fetches: 37
345. 0.005 0.005 ↑ 5.8 5 1 / 4

Parallel Index Only Scan using road_network_partitioned2_355_link_id_street_name_road_km_r_idx on road_network_partitioned2_355 a_355 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.020 rows=5 loops=1)

  • Heap Fetches: 5
346. 0.024 0.024 ↓ 5.6 162 1 / 4

Parallel Index Scan using road_network_partitioned2_358_pkey on road_network_partitioned2_358 a_358 (cost=0.14..18.02 rows=29 width=226) (actual time=0.010..0.095 rows=162 loops=1)

347. 0.008 0.008 ↑ 1.3 23 1 / 4

Parallel Index Only Scan using road_network_partitioned2_359_link_id_street_name_road_km_r_idx on road_network_partitioned2_359 a_359 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.033 rows=23 loops=1)

  • Heap Fetches: 23
348. 0.021 0.021 ↓ 3.3 96 1 / 4

Parallel Index Only Scan using road_network_partitioned2_360_link_id_street_name_road_km_r_idx on road_network_partitioned2_360 a_360 (cost=0.14..18.02 rows=29 width=226) (actual time=0.027..0.082 rows=96 loops=1)

  • Heap Fetches: 96
349. 0.005 0.005 ↑ 2.6 11 1 / 4

Parallel Index Only Scan using road_network_partitioned2_361_link_id_street_name_road_km_r_idx on road_network_partitioned2_361 a_361 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.022 rows=11 loops=1)

  • Heap Fetches: 11
350. 0.010 0.010 ↑ 1.9 15 1 / 4

Parallel Index Only Scan using road_network_partitioned2_362_link_id_street_name_road_km_r_idx on road_network_partitioned2_362 a_362 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.039 rows=15 loops=1)

  • Heap Fetches: 15
351. 0.772 0.772 ↓ 3.9 113 1 / 4

Parallel Index Only Scan using road_network_partitioned2_363_link_id_street_name_road_km_r_idx on road_network_partitioned2_363 a_363 (cost=0.14..18.02 rows=29 width=226) (actual time=3.024..3.087 rows=113 loops=1)

  • Heap Fetches: 113
352. 0.323 0.323 ↓ 2.1 60 1 / 4

Parallel Index Only Scan using road_network_partitioned2_364_link_id_street_name_road_km_r_idx on road_network_partitioned2_364 a_364 (cost=0.14..18.02 rows=29 width=226) (actual time=1.254..1.292 rows=60 loops=1)

  • Heap Fetches: 60
353. 0.029 0.029 ↓ 6.6 190 1 / 4

Parallel Index Scan using road_network_partitioned2_366_pkey on road_network_partitioned2_366 a_366 (cost=0.14..18.02 rows=29 width=226) (actual time=0.011..0.115 rows=190 loops=1)

354. 0.004 0.004 ↑ 9.7 3 1 / 4

Parallel Index Only Scan using road_network_partitioned2_387_link_id_street_name_road_km_r_idx on road_network_partitioned2_387 a_387 (cost=0.14..18.02 rows=29 width=226) (actual time=0.014..0.015 rows=3 loops=1)

  • Heap Fetches: 3
355. 0.014 0.014 ↓ 1.4 40 1 / 4

Parallel Index Only Scan using road_network_partitioned2_388_link_id_street_name_road_km_r_idx on road_network_partitioned2_388 a_388 (cost=0.14..18.02 rows=29 width=226) (actual time=0.031..0.056 rows=40 loops=1)

  • Heap Fetches: 40
356. 0.018 0.018 ↑ 29.0 1 1 / 4

Parallel Index Only Scan using road_network_partitioned2_389_link_id_street_name_road_km_r_idx on road_network_partitioned2_389 a_389 (cost=0.14..18.02 rows=29 width=226) (actual time=0.072..0.073 rows=1 loops=1)

  • Heap Fetches: 1
357. 0.005 0.005 ↑ 7.2 4 1 / 4

Parallel Index Only Scan using road_network_partitioned2_390_link_id_street_name_road_km_r_idx on road_network_partitioned2_390 a_390 (cost=0.14..18.02 rows=29 width=226) (actual time=0.016..0.020 rows=4 loops=1)

  • Heap Fetches: 4
358. 0.010 0.010 ↓ 1.8 52 1 / 4

Parallel Index Only Scan using road_network_partitioned2_392_link_id_street_name_road_km_r_idx on road_network_partitioned2_392 a_392 (cost=0.14..18.02 rows=29 width=226) (actual time=0.015..0.039 rows=52 loops=1)

  • Heap Fetches: 52
359. 0.014 0.014 ↓ 2.4 69 1 / 4

Parallel Index Only Scan using road_network_partitioned2_393_link_id_street_name_road_km_r_idx on road_network_partitioned2_393 a_393 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.057 rows=69 loops=1)

  • Heap Fetches: 69
360. 0.009 0.009 ↑ 1.1 26 1 / 4

Parallel Index Only Scan using road_network_partitioned2_394_link_id_street_name_road_km_r_idx on road_network_partitioned2_394 a_394 (cost=0.14..18.02 rows=29 width=226) (actual time=0.023..0.036 rows=26 loops=1)

  • Heap Fetches: 26
361. 0.005 0.005 ↑ 7.2 4 1 / 4

Parallel Index Only Scan using road_network_partitioned2_396_link_id_street_name_road_km_r_idx on road_network_partitioned2_396 a_396 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.020 rows=4 loops=1)

  • Heap Fetches: 4
362. 0.025 0.025 ↓ 5.4 157 1 / 4

Parallel Index Scan using road_network_partitioned2_400_pkey on road_network_partitioned2_400 a_400 (cost=0.14..18.02 rows=29 width=226) (actual time=0.015..0.098 rows=157 loops=1)

363. 0.016 0.016 ↓ 2.1 62 1 / 4

Parallel Index Only Scan using road_network_partitioned2_401_link_id_street_name_road_km_r_idx on road_network_partitioned2_401 a_401 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.065 rows=62 loops=1)

  • Heap Fetches: 62
364. 0.017 0.017 ↓ 3.5 102 1 / 4

Parallel Index Only Scan using road_network_partitioned2_402_link_id_street_name_road_km_r_idx on road_network_partitioned2_402 a_402 (cost=0.14..18.02 rows=29 width=226) (actual time=0.021..0.068 rows=102 loops=1)

  • Heap Fetches: 102
365. 0.007 0.007 ↑ 1.1 26 1 / 4

Parallel Index Only Scan using road_network_partitioned2_403_link_id_street_name_road_km_r_idx on road_network_partitioned2_403 a_403 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.030 rows=26 loops=1)

  • Heap Fetches: 26
366. 0.005 0.005 ↑ 2.2 13 1 / 4

Parallel Index Only Scan using road_network_partitioned2_404_link_id_street_name_road_km_r_idx on road_network_partitioned2_404 a_404 (cost=0.14..18.02 rows=29 width=226) (actual time=0.016..0.021 rows=13 loops=1)

  • Heap Fetches: 13
367. 0.026 0.026 ↓ 5.2 151 1 / 4

Parallel Index Scan using road_network_partitioned2_405_pkey on road_network_partitioned2_405 a_405 (cost=0.14..18.02 rows=29 width=226) (actual time=0.013..0.104 rows=151 loops=1)

368. 0.049 0.049 ↓ 4.9 141 1 / 4

Parallel Index Only Scan using road_network_partitioned2_406_link_id_street_name_road_km_r_idx on road_network_partitioned2_406 a_406 (cost=0.14..18.02 rows=29 width=226) (actual time=0.046..0.196 rows=141 loops=1)

  • Heap Fetches: 141
369. 0.024 0.024 ↓ 3.8 110 1 / 4

Parallel Index Only Scan using road_network_partitioned2_407_link_id_street_name_road_km_r_idx on road_network_partitioned2_407 a_407 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.095 rows=110 loops=1)

  • Heap Fetches: 110
370. 0.015 0.015 ↓ 2.6 75 1 / 4

Parallel Index Only Scan using road_network_partitioned2_408_link_id_street_name_road_km_r_idx on road_network_partitioned2_408 a_408 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.061 rows=75 loops=1)

  • Heap Fetches: 75
371. 0.217 0.217 ↓ 4.0 116 1 / 4

Parallel Index Only Scan using road_network_partitioned2_409_link_id_street_name_road_km_r_idx on road_network_partitioned2_409 a_409 (cost=0.14..18.02 rows=29 width=226) (actual time=0.808..0.867 rows=116 loops=1)

  • Heap Fetches: 116
372. 0.720 0.720 ↓ 2.1 60 1 / 4

Parallel Index Only Scan using road_network_partitioned2_428_link_id_street_name_road_km_r_idx on road_network_partitioned2_428 a_428 (cost=0.14..18.02 rows=29 width=226) (actual time=2.846..2.881 rows=60 loops=1)

  • Heap Fetches: 60
373. 0.561 0.561 ↓ 1.3 37 1 / 4

Parallel Index Only Scan using road_network_partitioned2_429_link_id_street_name_road_km_r_idx on road_network_partitioned2_429 a_429 (cost=0.14..18.02 rows=29 width=226) (actual time=2.222..2.245 rows=37 loops=1)

  • Heap Fetches: 37
374. 0.009 0.009 ↑ 1.1 27 1 / 4

Parallel Index Only Scan using road_network_partitioned2_436_link_id_street_name_road_km_r_idx on road_network_partitioned2_436 a_436 (cost=0.14..18.02 rows=29 width=226) (actual time=0.022..0.036 rows=27 loops=1)

  • Heap Fetches: 27
375. 0.006 0.006 ↑ 1.8 16 1 / 4

Parallel Index Only Scan using road_network_partitioned2_437_link_id_street_name_road_km_r_idx on road_network_partitioned2_437 a_437 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.025 rows=16 loops=1)

  • Heap Fetches: 16
376. 0.011 0.011 ↓ 1.2 36 1 / 4

Parallel Index Only Scan using road_network_partitioned2_438_link_id_street_name_road_km_r_idx on road_network_partitioned2_438 a_438 (cost=0.14..18.02 rows=29 width=226) (actual time=0.026..0.042 rows=36 loops=1)

  • Heap Fetches: 36
377. 0.033 0.033 ↓ 7.2 208 1 / 4

Parallel Index Scan using road_network_partitioned2_442_pkey on road_network_partitioned2_442 a_442 (cost=0.14..18.02 rows=29 width=226) (actual time=0.011..0.130 rows=208 loops=1)

378. 0.014 0.014 ↑ 1.1 26 1 / 4

Parallel Index Only Scan using road_network_partitioned2_443_link_id_street_name_road_km_r_idx on road_network_partitioned2_443 a_443 (cost=0.14..18.02 rows=29 width=226) (actual time=0.035..0.056 rows=26 loops=1)

  • Heap Fetches: 26
379. 0.017 0.017 ↓ 2.3 66 1 / 4

Parallel Index Only Scan using road_network_partitioned2_444_link_id_street_name_road_km_r_idx on road_network_partitioned2_444 a_444 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.069 rows=66 loops=1)

  • Heap Fetches: 66
380. 0.018 0.018 ↓ 3.2 93 1 / 4

Parallel Index Only Scan using road_network_partitioned2_445_link_id_street_name_road_km_r_idx on road_network_partitioned2_445 a_445 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.070 rows=93 loops=1)

  • Heap Fetches: 93
381. 0.025 0.025 ↓ 4.4 127 1 / 4

Parallel Index Only Scan using road_network_partitioned2_446_link_id_street_name_road_km_r_idx on road_network_partitioned2_446 a_446 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.100 rows=127 loops=1)

  • Heap Fetches: 127
382. 0.027 0.027 ↓ 6.0 175 1 / 4

Parallel Index Scan using road_network_partitioned2_447_pkey on road_network_partitioned2_447 a_447 (cost=0.14..18.02 rows=29 width=226) (actual time=0.009..0.109 rows=175 loops=1)

383. 0.024 0.024 ↓ 3.8 109 1 / 4

Parallel Index Only Scan using road_network_partitioned2_449_link_id_street_name_road_km_r_idx on road_network_partitioned2_449 a_449 (cost=0.14..18.02 rows=29 width=226) (actual time=0.038..0.096 rows=109 loops=1)

  • Heap Fetches: 109
384. 0.032 0.032 ↓ 4.3 125 1 / 4

Parallel Index Only Scan using road_network_partitioned2_450_link_id_street_name_road_km_r_idx on road_network_partitioned2_450 a_450 (cost=0.14..18.02 rows=29 width=226) (actual time=0.030..0.127 rows=125 loops=1)

  • Heap Fetches: 125
385. 0.026 0.026 ↓ 5.9 170 1 / 4

Parallel Index Scan using road_network_partitioned2_451_pkey on road_network_partitioned2_451 a_451 (cost=0.14..18.02 rows=29 width=226) (actual time=0.010..0.106 rows=170 loops=1)

386. 0.511 0.511 ↓ 4.2 121 1 / 4

Parallel Index Only Scan using road_network_partitioned2_452_link_id_street_name_road_km_r_idx on road_network_partitioned2_452 a_452 (cost=0.14..18.02 rows=29 width=226) (actual time=1.967..2.043 rows=121 loops=1)

  • Heap Fetches: 121
387. 0.011 0.011 ↓ 1.2 35 1 / 4

Parallel Index Only Scan using road_network_partitioned2_466_link_id_street_name_road_km_r_idx on road_network_partitioned2_466 a_466 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.046 rows=35 loops=1)

  • Heap Fetches: 35
388. 0.019 0.019 ↓ 3.3 97 1 / 4

Parallel Index Only Scan using road_network_partitioned2_468_link_id_street_name_road_km_r_idx on road_network_partitioned2_468 a_468 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.078 rows=97 loops=1)

  • Heap Fetches: 97
389. 0.498 0.498 ↓ 4.1 118 1 / 4

Parallel Index Only Scan using road_network_partitioned2_469_link_id_street_name_road_km_r_idx on road_network_partitioned2_469 a_469 (cost=0.14..18.02 rows=29 width=226) (actual time=1.914..1.994 rows=118 loops=1)

  • Heap Fetches: 118
390. 0.031 0.031 ↓ 6.1 177 1 / 4

Parallel Index Scan using road_network_partitioned2_470_pkey on road_network_partitioned2_470 a_470 (cost=0.14..18.02 rows=29 width=226) (actual time=0.010..0.123 rows=177 loops=1)

391. 0.008 0.008 ↑ 1.2 24 1 / 4

Parallel Index Only Scan using road_network_partitioned2_471_link_id_street_name_road_km_r_idx on road_network_partitioned2_471 a_471 (cost=0.14..18.02 rows=29 width=226) (actual time=0.022..0.031 rows=24 loops=1)

  • Heap Fetches: 24
392. 0.006 0.006 ↑ 4.1 7 1 / 4

Parallel Index Only Scan using road_network_partitioned2_480_link_id_street_name_road_km_r_idx on road_network_partitioned2_480 a_480 (cost=0.14..18.02 rows=29 width=226) (actual time=0.022..0.025 rows=7 loops=1)

  • Heap Fetches: 7
393. 0.006 0.006 ↑ 1.8 16 1 / 4

Parallel Index Only Scan using road_network_partitioned2_481_link_id_street_name_road_km_r_idx on road_network_partitioned2_481 a_481 (cost=0.14..18.02 rows=29 width=226) (actual time=0.017..0.024 rows=16 loops=1)

  • Heap Fetches: 16
394. 0.009 0.009 ↑ 1.6 18 1 / 4

Parallel Index Only Scan using road_network_partitioned2_483_link_id_street_name_road_km_r_idx on road_network_partitioned2_483 a_483 (cost=0.14..18.02 rows=29 width=226) (actual time=0.024..0.036 rows=18 loops=1)

  • Heap Fetches: 18
395. 0.034 0.034 ↓ 5.2 151 1 / 4

Parallel Index Only Scan using road_network_partitioned2_484_link_id_street_name_road_km_r_idx on road_network_partitioned2_484 a_484 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.135 rows=151 loops=1)

  • Heap Fetches: 151
396. 0.013 0.013 ↓ 1.2 35 1 / 4

Parallel Index Only Scan using road_network_partitioned2_485_link_id_street_name_road_km_r_idx on road_network_partitioned2_485 a_485 (cost=0.14..18.02 rows=29 width=226) (actual time=0.023..0.053 rows=35 loops=1)

  • Heap Fetches: 35
397. 0.004 0.004 ↑ 14.5 2 1 / 4

Parallel Index Only Scan using road_network_partitioned2_486_link_id_street_name_road_km_r_idx on road_network_partitioned2_486 a_486 (cost=0.14..18.02 rows=29 width=226) (actual time=0.015..0.017 rows=2 loops=1)

  • Heap Fetches: 2
398. 0.009 0.009 ↑ 1.7 17 1 / 4

Parallel Index Only Scan using road_network_partitioned2_487_link_id_street_name_road_km_r_idx on road_network_partitioned2_487 a_487 (cost=0.14..18.02 rows=29 width=226) (actual time=0.030..0.037 rows=17 loops=1)

  • Heap Fetches: 17
399. 0.015 0.015 ↓ 1.1 33 1 / 4

Parallel Index Only Scan using road_network_partitioned2_488_link_id_street_name_road_km_r_idx on road_network_partitioned2_488 a_488 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.059 rows=33 loops=1)

  • Heap Fetches: 33
400. 0.221 0.221 ↓ 3.6 103 1 / 4

Parallel Index Only Scan using road_network_partitioned2_506_link_id_street_name_road_km_r_idx on road_network_partitioned2_506 a_506 (cost=0.14..18.02 rows=29 width=226) (actual time=0.828..0.882 rows=103 loops=1)

  • Heap Fetches: 103
401. 0.200 0.200 ↓ 1.2 36 1 / 4

Parallel Index Only Scan using road_network_partitioned2_507_link_id_street_name_road_km_r_idx on road_network_partitioned2_507 a_507 (cost=0.14..18.02 rows=29 width=226) (actual time=0.782..0.798 rows=36 loops=1)

  • Heap Fetches: 36
402. 0.565 0.565 ↓ 4.0 116 1 / 4

Parallel Index Only Scan using road_network_partitioned2_508_link_id_street_name_road_km_r_idx on road_network_partitioned2_508 a_508 (cost=0.14..18.02 rows=29 width=226) (actual time=2.188..2.258 rows=116 loops=1)

  • Heap Fetches: 116
403. 0.010 0.010 ↑ 1.3 23 1 / 4

Parallel Index Only Scan using road_network_partitioned2_510_link_id_street_name_road_km_r_idx on road_network_partitioned2_510 a_510 (cost=0.14..18.02 rows=29 width=226) (actual time=0.030..0.039 rows=23 loops=1)

  • Heap Fetches: 23
404. 0.026 0.026 ↓ 4.9 142 1 / 4

Parallel Index Scan using road_network_partitioned2_511_pkey on road_network_partitioned2_511 a_511 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.105 rows=142 loops=1)

405. 0.068 0.068 ↓ 5.5 159 1 / 4

Parallel Index Scan using road_network_partitioned2_512_pkey on road_network_partitioned2_512 a_512 (cost=0.14..18.02 rows=29 width=226) (actual time=0.010..0.273 rows=159 loops=1)

406. 0.009 0.009 ↑ 1.5 19 1 / 4

Parallel Index Only Scan using road_network_partitioned2_513_link_id_street_name_road_km_r_idx on road_network_partitioned2_513 a_513 (cost=0.14..18.02 rows=29 width=226) (actual time=0.022..0.034 rows=19 loops=1)

  • Heap Fetches: 19
407. 0.009 0.009 ↑ 1.2 24 1 / 4

Parallel Index Only Scan using road_network_partitioned2_523_link_id_street_name_road_km_r_idx on road_network_partitioned2_523 a_523 (cost=0.14..18.02 rows=29 width=226) (actual time=0.023..0.035 rows=24 loops=1)

  • Heap Fetches: 24
408. 0.018 0.018 ↓ 1.8 53 1 / 4

Parallel Index Only Scan using road_network_partitioned2_524_link_id_street_name_road_km_r_idx on road_network_partitioned2_524 a_524 (cost=0.14..18.02 rows=29 width=226) (actual time=0.030..0.072 rows=53 loops=1)

  • Heap Fetches: 53
409. 0.121 0.121 ↓ 4.6 133 1 / 4

Parallel Index Only Scan using road_network_partitioned2_525_link_id_street_name_road_km_r_idx on road_network_partitioned2_525 a_525 (cost=0.14..18.02 rows=29 width=226) (actual time=0.408..0.486 rows=133 loops=1)

  • Heap Fetches: 133
410. 0.023 0.023 ↓ 3.5 102 1 / 4

Parallel Index Only Scan using road_network_partitioned2_526_link_id_street_name_road_km_r_idx on road_network_partitioned2_526 a_526 (cost=0.14..18.02 rows=29 width=226) (actual time=0.036..0.092 rows=102 loops=1)

  • Heap Fetches: 102
411. 0.206 0.206 ↓ 2.8 80 1 / 4

Parallel Index Only Scan using road_network_partitioned2_527_link_id_street_name_road_km_r_idx on road_network_partitioned2_527 a_527 (cost=0.14..18.02 rows=29 width=226) (actual time=0.759..0.826 rows=80 loops=1)

  • Heap Fetches: 80
412. 0.007 0.007 ↑ 1.7 17 1 / 4

Parallel Index Only Scan using road_network_partitioned2_528_link_id_street_name_road_km_r_idx on road_network_partitioned2_528 a_528 (cost=0.14..18.02 rows=29 width=226) (actual time=0.023..0.029 rows=17 loops=1)

  • Heap Fetches: 17
413. 0.006 0.006 ↑ 4.1 7 1 / 4

Parallel Index Only Scan using road_network_partitioned2_529_link_id_street_name_road_km_r_idx on road_network_partitioned2_529 a_529 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.023 rows=7 loops=1)

  • Heap Fetches: 7
414. 0.206 0.206 ↓ 2.1 62 1 / 4

Parallel Index Only Scan using road_network_partitioned2_530_link_id_street_name_road_km_r_idx on road_network_partitioned2_530 a_530 (cost=0.14..18.02 rows=29 width=226) (actual time=0.788..0.823 rows=62 loops=1)

  • Heap Fetches: 62
415. 0.193 0.193 ↓ 1.9 54 1 / 4

Parallel Index Only Scan using road_network_partitioned2_531_link_id_street_name_road_km_r_idx on road_network_partitioned2_531 a_531 (cost=0.14..18.02 rows=29 width=226) (actual time=0.745..0.773 rows=54 loops=1)

  • Heap Fetches: 54
416. 0.964 0.964 ↓ 3.0 86 1 / 4

Parallel Index Only Scan using road_network_partitioned2_532_link_id_street_name_road_km_r_idx on road_network_partitioned2_532 a_532 (cost=0.14..18.02 rows=29 width=226) (actual time=3.796..3.854 rows=86 loops=1)

  • Heap Fetches: 86
417. 0.560 0.560 ↓ 2.7 79 1 / 4

Parallel Index Only Scan using road_network_partitioned2_533_link_id_street_name_road_km_r_idx on road_network_partitioned2_533 a_533 (cost=0.14..18.02 rows=29 width=226) (actual time=2.198..2.239 rows=79 loops=1)

  • Heap Fetches: 79
418. 0.023 0.023 ↓ 5.0 144 1 / 4

Parallel Index Scan using road_network_partitioned2_534_pkey on road_network_partitioned2_534 a_534 (cost=0.14..18.02 rows=29 width=226) (actual time=0.016..0.092 rows=144 loops=1)

419. 0.034 0.034 ↓ 7.3 212 1 / 4

Parallel Index Scan using road_network_partitioned2_536_pkey on road_network_partitioned2_536 a_536 (cost=0.14..18.02 rows=29 width=226) (actual time=0.015..0.135 rows=212 loops=1)

420. 0.031 0.031 ↓ 6.9 200 1 / 4

Parallel Index Scan using road_network_partitioned2_537_pkey on road_network_partitioned2_537 a_537 (cost=0.14..18.02 rows=29 width=226) (actual time=0.012..0.125 rows=200 loops=1)

421. 0.025 0.025 ↓ 3.5 101 1 / 4

Parallel Index Only Scan using road_network_partitioned2_538_link_id_street_name_road_km_r_idx on road_network_partitioned2_538 a_538 (cost=0.14..18.02 rows=29 width=226) (actual time=0.032..0.101 rows=101 loops=1)

  • Heap Fetches: 101
422. 0.028 0.028 ↓ 5.6 162 1 / 4

Parallel Index Scan using road_network_partitioned2_542_pkey on road_network_partitioned2_542 a_542 (cost=0.14..18.02 rows=29 width=226) (actual time=0.014..0.112 rows=162 loops=1)

423. 0.015 0.015 ↓ 1.8 51 1 / 4

Parallel Index Only Scan using road_network_partitioned2_548_link_id_street_name_road_km_r_idx on road_network_partitioned2_548 a_548 (cost=0.14..18.02 rows=29 width=226) (actual time=0.033..0.061 rows=51 loops=1)

  • Heap Fetches: 51
424. 0.200 0.200 ↓ 4.8 138 1 / 4

Parallel Index Only Scan using road_network_partitioned2_549_link_id_street_name_road_km_r_idx on road_network_partitioned2_549 a_549 (cost=0.14..18.02 rows=29 width=226) (actual time=0.721..0.799 rows=138 loops=1)

  • Heap Fetches: 138
425. 0.011 0.011 ↑ 1.0 28 1 / 4

Parallel Index Only Scan using road_network_partitioned2_550_link_id_street_name_road_km_r_idx on road_network_partitioned2_550 a_550 (cost=0.14..18.02 rows=29 width=226) (actual time=0.028..0.045 rows=28 loops=1)

  • Heap Fetches: 28
426. 0.200 0.200 ↓ 1.3 39 1 / 4

Parallel Index Only Scan using road_network_partitioned2_551_link_id_street_name_road_km_r_idx on road_network_partitioned2_551 a_551 (cost=0.14..18.02 rows=29 width=226) (actual time=0.769..0.798 rows=39 loops=1)

  • Heap Fetches: 39
427. 0.093 0.093 ↓ 4.3 124 1 / 4

Parallel Index Only Scan using road_network_partitioned2_553_link_id_street_name_road_km_r_idx on road_network_partitioned2_553 a_553 (cost=0.14..18.02 rows=29 width=226) (actual time=0.306..0.374 rows=124 loops=1)

  • Heap Fetches: 124
428. 0.033 0.033 ↓ 8.1 234 1 / 4

Parallel Index Scan using road_network_partitioned2_554_pkey on road_network_partitioned2_554 a_554 (cost=0.14..18.02 rows=29 width=226) (actual time=0.013..0.132 rows=234 loops=1)

429. 0.011 0.011 ↑ 1.4 20 1 / 4

Parallel Index Only Scan using road_network_partitioned2_555_link_id_street_name_road_km_r_idx on road_network_partitioned2_555 a_555 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.042 rows=20 loops=1)

  • Heap Fetches: 20
430. 0.157 0.157 ↓ 1.5 43 1 / 4

Parallel Index Only Scan using road_network_partitioned2_566_link_id_street_name_road_km_r_idx on road_network_partitioned2_566 a_566 (cost=0.14..18.02 rows=29 width=226) (actual time=0.601..0.628 rows=43 loops=1)

  • Heap Fetches: 43
431. 0.024 0.024 ↓ 4.0 117 1 / 4

Parallel Index Only Scan using road_network_partitioned2_567_link_id_street_name_road_km_r_idx on road_network_partitioned2_567 a_567 (cost=0.14..18.02 rows=29 width=226) (actual time=0.033..0.095 rows=117 loops=1)

  • Heap Fetches: 117
432. 0.287 0.287 ↓ 4.8 140 1 / 4

Parallel Index Only Scan using road_network_partitioned2_568_link_id_street_name_road_km_r_idx on road_network_partitioned2_568 a_568 (cost=0.14..18.02 rows=29 width=226) (actual time=1.069..1.149 rows=140 loops=1)

  • Heap Fetches: 140
433. 0.022 0.022 ↓ 2.7 79 1 / 4

Parallel Index Only Scan using road_network_partitioned2_569_link_id_street_name_road_km_r_idx on road_network_partitioned2_569 a_569 (cost=0.14..18.02 rows=29 width=226) (actual time=0.034..0.090 rows=79 loops=1)

  • Heap Fetches: 79
434. 0.141 0.141 ↓ 1.4 42 1 / 4

Parallel Index Only Scan using road_network_partitioned2_570_link_id_street_name_road_km_r_idx on road_network_partitioned2_570 a_570 (cost=0.14..18.02 rows=29 width=226) (actual time=0.545..0.566 rows=42 loops=1)

  • Heap Fetches: 42
435. 0.009 0.009 ↑ 1.2 24 1 / 4

Parallel Index Only Scan using road_network_partitioned2_571_link_id_street_name_road_km_r_idx on road_network_partitioned2_571 a_571 (cost=0.14..18.02 rows=29 width=226) (actual time=0.026..0.036 rows=24 loops=1)

  • Heap Fetches: 24
436. 0.007 0.007 ↑ 2.9 10 1 / 4

Parallel Index Only Scan using road_network_partitioned2_572_link_id_street_name_road_km_r_idx on road_network_partitioned2_572 a_572 (cost=0.14..18.02 rows=29 width=226) (actual time=0.023..0.027 rows=10 loops=1)

  • Heap Fetches: 10
437. 0.015 0.015 ↓ 2.4 71 1 / 4

Parallel Index Only Scan using road_network_partitioned2_573_link_id_street_name_road_km_r_idx on road_network_partitioned2_573 a_573 (cost=0.14..18.02 rows=29 width=226) (actual time=0.023..0.062 rows=71 loops=1)

  • Heap Fetches: 71
438. 0.025 0.025 ↓ 5.2 152 1 / 4

Parallel Index Scan using road_network_partitioned2_574_pkey on road_network_partitioned2_574 a_574 (cost=0.14..18.02 rows=29 width=226) (actual time=0.009..0.098 rows=152 loops=1)

439. 0.152 0.152 ↓ 3.0 86 1 / 4

Parallel Index Only Scan using road_network_partitioned2_575_link_id_street_name_road_km_r_idx on road_network_partitioned2_575 a_575 (cost=0.14..18.02 rows=29 width=226) (actual time=0.565..0.610 rows=86 loops=1)

  • Heap Fetches: 86
440. 0.019 0.019 ↓ 2.7 78 1 / 4

Parallel Index Only Scan using road_network_partitioned2_576_link_id_street_name_road_km_r_idx on road_network_partitioned2_576 a_576 (cost=0.14..18.02 rows=29 width=226) (actual time=0.027..0.078 rows=78 loops=1)

  • Heap Fetches: 78
441. 0.032 0.032 ↓ 4.7 137 1 / 4

Parallel Index Only Scan using road_network_partitioned2_577_link_id_street_name_road_km_r_idx on road_network_partitioned2_577 a_577 (cost=0.14..18.02 rows=29 width=226) (actual time=0.042..0.127 rows=137 loops=1)

  • Heap Fetches: 137
442. 0.201 0.201 ↓ 4.6 132 1 / 4

Parallel Index Only Scan using road_network_partitioned2_580_link_id_street_name_road_km_r_idx on road_network_partitioned2_580 a_580 (cost=0.14..18.02 rows=29 width=226) (actual time=0.722..0.805 rows=132 loops=1)

  • Heap Fetches: 132
443. 0.022 0.022 ↓ 3.5 102 1 / 4

Parallel Index Only Scan using road_network_partitioned2_590_link_id_street_name_road_km_r_idx on road_network_partitioned2_590 a_590 (cost=0.14..18.02 rows=29 width=226) (actual time=0.027..0.089 rows=102 loops=1)

  • Heap Fetches: 102
444. 0.005 0.005 ↑ 3.6 8 1 / 4

Parallel Index Only Scan using road_network_partitioned2_591_link_id_street_name_road_km_r_idx on road_network_partitioned2_591 a_591 (cost=0.14..18.02 rows=29 width=226) (actual time=0.017..0.020 rows=8 loops=1)

  • Heap Fetches: 8
445. 0.005 0.005 ↑ 29.0 1 1 / 4

Parallel Index Only Scan using road_network_partitioned2_592_link_id_street_name_road_km_r_idx on road_network_partitioned2_592 a_592 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.019 rows=1 loops=1)

  • Heap Fetches: 1
446. 0.128 0.128 ↓ 1.2 35 1 / 4

Parallel Index Only Scan using road_network_partitioned2_596_link_id_street_name_road_km_r_idx on road_network_partitioned2_596 a_596 (cost=0.14..18.02 rows=29 width=226) (actual time=0.482..0.511 rows=35 loops=1)

  • Heap Fetches: 35
447. 0.196 0.196 ↓ 2.2 64 1 / 4

Parallel Index Only Scan using road_network_partitioned2_608_link_id_street_name_road_km_r_idx on road_network_partitioned2_608 a_608 (cost=0.14..18.02 rows=29 width=226) (actual time=0.732..0.782 rows=64 loops=1)

  • Heap Fetches: 64
448. 0.354 0.354 ↓ 4.9 143 1 / 4

Parallel Index Only Scan using road_network_partitioned2_609_link_id_street_name_road_km_r_idx on road_network_partitioned2_609 a_609 (cost=0.14..18.02 rows=29 width=226) (actual time=1.339..1.417 rows=143 loops=1)

  • Heap Fetches: 143
449. 0.009 0.009 ↑ 1.3 22 1 / 4

Parallel Index Only Scan using road_network_partitioned2_611_link_id_street_name_road_km_r_idx on road_network_partitioned2_611 a_611 (cost=0.14..18.02 rows=29 width=226) (actual time=0.017..0.037 rows=22 loops=1)

  • Heap Fetches: 22
450. 0.006 0.006 ↑ 4.8 6 1 / 4

Parallel Index Only Scan using road_network_partitioned2_614_link_id_street_name_road_km_r_idx on road_network_partitioned2_614 a_614 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.023 rows=6 loops=1)

  • Heap Fetches: 6
451. 0.084 0.084 ↓ 2.0 59 1 / 4

Parallel Index Only Scan using road_network_partitioned2_615_link_id_street_name_road_km_r_idx on road_network_partitioned2_615 a_615 (cost=0.14..18.02 rows=29 width=226) (actual time=0.299..0.336 rows=59 loops=1)

  • Heap Fetches: 59
452. 0.669 0.669 ↓ 2.1 61 1 / 4

Parallel Index Only Scan using road_network_partitioned2_616_link_id_street_name_road_km_r_idx on road_network_partitioned2_616 a_616 (cost=0.14..18.02 rows=29 width=226) (actual time=2.641..2.675 rows=61 loops=1)

  • Heap Fetches: 61
453. 0.255 0.255 ↓ 1.9 55 1 / 4

Parallel Index Only Scan using road_network_partitioned2_617_link_id_street_name_road_km_r_idx on road_network_partitioned2_617 a_617 (cost=0.14..18.02 rows=29 width=226) (actual time=0.989..1.020 rows=55 loops=1)

  • Heap Fetches: 55
454. 0.675 0.675 ↓ 1.1 31 1 / 4

Parallel Index Only Scan using road_network_partitioned2_618_link_id_street_name_road_km_r_idx on road_network_partitioned2_618 a_618 (cost=0.14..18.02 rows=29 width=226) (actual time=2.685..2.701 rows=31 loops=1)

  • Heap Fetches: 31
455. 0.673 0.673 ↓ 4.5 131 1 / 4

Parallel Index Only Scan using road_network_partitioned2_619_link_id_street_name_road_km_r_idx on road_network_partitioned2_619 a_619 (cost=0.14..18.02 rows=29 width=226) (actual time=2.619..2.693 rows=131 loops=1)

  • Heap Fetches: 131
456. 0.039 0.039 ↓ 9.2 266 1 / 4

Parallel Index Scan using road_network_partitioned2_632_pkey on road_network_partitioned2_632 a_632 (cost=0.14..18.02 rows=29 width=226) (actual time=0.011..0.157 rows=266 loops=1)

457. 0.008 0.008 ↑ 1.0 29 1 / 4

Parallel Index Only Scan using road_network_partitioned2_637_link_id_street_name_road_km_r_idx on road_network_partitioned2_637 a_637 (cost=0.14..18.02 rows=29 width=226) (actual time=0.017..0.031 rows=29 loops=1)

  • Heap Fetches: 29
458. 0.006 0.006 ↑ 1.9 15 1 / 4

Parallel Index Only Scan using road_network_partitioned2_638_link_id_street_name_road_km_r_idx on road_network_partitioned2_638 a_638 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.024 rows=15 loops=1)

  • Heap Fetches: 15
459. 0.005 0.005 ↑ 5.8 5 1 / 4

Parallel Index Only Scan using road_network_partitioned2_645_link_id_street_name_road_km_r_idx on road_network_partitioned2_645 a_645 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.021 rows=5 loops=1)

  • Heap Fetches: 5
460. 0.014 0.014 ↓ 1.4 40 1 / 4

Parallel Index Only Scan using road_network_partitioned2_646_link_id_street_name_road_km_r_idx on road_network_partitioned2_646 a_646 (cost=0.14..18.02 rows=29 width=226) (actual time=0.033..0.057 rows=40 loops=1)

  • Heap Fetches: 40
461. 0.034 0.034 ↓ 2.1 60 1 / 4

Parallel Index Only Scan using road_network_partitioned2_647_link_id_street_name_road_km_r_idx on road_network_partitioned2_647 a_647 (cost=0.14..18.02 rows=29 width=226) (actual time=0.028..0.134 rows=60 loops=1)

  • Heap Fetches: 60
462. 0.659 0.659 ↑ 1.3 22 1 / 4

Parallel Index Only Scan using road_network_partitioned2_648_link_id_street_name_road_km_r_idx on road_network_partitioned2_648 a_648 (cost=0.14..18.02 rows=29 width=226) (actual time=2.629..2.638 rows=22 loops=1)

  • Heap Fetches: 22
463. 0.338 0.338 ↓ 4.8 140 1 / 4

Parallel Index Only Scan using road_network_partitioned2_649_link_id_street_name_road_km_r_idx on road_network_partitioned2_649 a_649 (cost=0.14..18.02 rows=29 width=226) (actual time=1.275..1.350 rows=140 loops=1)

  • Heap Fetches: 140
464. 0.034 0.034 ↓ 5.6 161 1 / 4

Parallel Index Scan using road_network_partitioned2_650_pkey on road_network_partitioned2_650 a_650 (cost=0.14..18.02 rows=29 width=226) (actual time=0.024..0.136 rows=161 loops=1)

465. 0.010 0.010 ↓ 1.3 37 1 / 4

Parallel Index Only Scan using road_network_partitioned2_652_link_id_street_name_road_km_r_idx on road_network_partitioned2_652 a_652 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.039 rows=37 loops=1)

  • Heap Fetches: 37
466. 0.009 0.009 ↓ 1.2 36 1 / 4

Parallel Index Only Scan using road_network_partitioned2_657_link_id_street_name_road_km_r_idx on road_network_partitioned2_657 a_657 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.035 rows=36 loops=1)

  • Heap Fetches: 36
467. 0.018 0.018 ↓ 3.0 86 1 / 4

Parallel Index Only Scan using road_network_partitioned2_658_link_id_street_name_road_km_r_idx on road_network_partitioned2_658 a_658 (cost=0.14..18.02 rows=29 width=226) (actual time=0.027..0.071 rows=86 loops=1)

  • Heap Fetches: 86
468. 0.015 0.015 ↓ 2.1 62 1 / 4

Parallel Index Only Scan using road_network_partitioned2_659_link_id_street_name_road_km_r_idx on road_network_partitioned2_659 a_659 (cost=0.14..18.02 rows=29 width=226) (actual time=0.031..0.062 rows=62 loops=1)

  • Heap Fetches: 62
469. 0.015 0.015 ↓ 2.0 58 1 / 4

Parallel Index Only Scan using road_network_partitioned2_660_link_id_street_name_road_km_r_idx on road_network_partitioned2_660 a_660 (cost=0.14..18.02 rows=29 width=226) (actual time=0.032..0.062 rows=58 loops=1)

  • Heap Fetches: 58
470. 0.032 0.032 ↓ 6.8 198 1 / 4

Parallel Index Scan using road_network_partitioned2_661_pkey on road_network_partitioned2_661 a_661 (cost=0.14..18.02 rows=29 width=226) (actual time=0.014..0.128 rows=198 loops=1)

471. 0.027 0.027 ↓ 5.3 154 1 / 4

Parallel Index Scan using road_network_partitioned2_662_pkey on road_network_partitioned2_662 a_662 (cost=0.14..18.02 rows=29 width=226) (actual time=0.010..0.109 rows=154 loops=1)

472. 0.262 0.262 ↓ 5.0 146 1 / 4

Parallel Index Only Scan using road_network_partitioned2_663_link_id_street_name_road_km_r_idx on road_network_partitioned2_663 a_663 (cost=0.14..18.02 rows=29 width=226) (actual time=0.964..1.047 rows=146 loops=1)

  • Heap Fetches: 146
473. 0.029 0.029 ↓ 5.3 153 1 / 4

Parallel Index Scan using road_network_partitioned2_665_pkey on road_network_partitioned2_665 a_665 (cost=0.14..18.02 rows=29 width=226) (actual time=0.013..0.118 rows=153 loops=1)

474. 0.032 0.032 ↓ 6.6 191 1 / 4

Parallel Index Scan using road_network_partitioned2_674_pkey on road_network_partitioned2_674 a_674 (cost=0.14..18.02 rows=29 width=226) (actual time=0.011..0.126 rows=191 loops=1)

475. 0.007 0.007 ↑ 1.9 15 1 / 4

Parallel Index Only Scan using road_network_partitioned2_675_link_id_street_name_road_km_r_idx on road_network_partitioned2_675 a_675 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.028 rows=15 loops=1)

  • Heap Fetches: 15
476. 0.006 0.006 ↑ 2.6 11 1 / 4

Parallel Index Only Scan using road_network_partitioned2_677_link_id_street_name_road_km_r_idx on road_network_partitioned2_677 a_677 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.025 rows=11 loops=1)

  • Heap Fetches: 11
477. 0.010 0.010 ↑ 1.6 18 1 / 4

Parallel Index Only Scan using road_network_partitioned2_678_link_id_street_name_road_km_r_idx on road_network_partitioned2_678 a_678 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.040 rows=18 loops=1)

  • Heap Fetches: 18
478. 0.019 0.019 ↓ 3.3 96 1 / 4

Parallel Index Only Scan using road_network_partitioned2_679_link_id_street_name_road_km_r_idx on road_network_partitioned2_679 a_679 (cost=0.14..18.02 rows=29 width=226) (actual time=0.026..0.075 rows=96 loops=1)

  • Heap Fetches: 96
479. 0.006 0.006 ↑ 1.3 22 1 / 4

Parallel Index Only Scan using road_network_partitioned2_680_link_id_street_name_road_km_r_idx on road_network_partitioned2_680 a_680 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.026 rows=22 loops=1)

  • Heap Fetches: 22
480. 0.008 0.008 ↓ 1.0 30 1 / 4

Parallel Index Only Scan using road_network_partitioned2_686_link_id_street_name_road_km_r_idx on road_network_partitioned2_686 a_686 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.032 rows=30 loops=1)

  • Heap Fetches: 30
481. 0.016 0.016 ↓ 2.3 67 1 / 4

Parallel Index Only Scan using road_network_partitioned2_687_link_id_street_name_road_km_r_idx on road_network_partitioned2_687 a_687 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.065 rows=67 loops=1)

  • Heap Fetches: 67
482. 0.007 0.007 ↑ 2.4 12 1 / 4

Parallel Index Only Scan using road_network_partitioned2_691_link_id_street_name_road_km_r_idx on road_network_partitioned2_691 a_691 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.030 rows=12 loops=1)

  • Heap Fetches: 12
483. 0.012 0.012 ↓ 1.4 40 1 / 4

Parallel Index Only Scan using road_network_partitioned2_692_link_id_street_name_road_km_r_idx on road_network_partitioned2_692 a_692 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.048 rows=40 loops=1)

  • Heap Fetches: 40
484. 0.701 0.701 ↓ 5.0 145 1 / 4

Parallel Index Only Scan using road_network_partitioned2_693_link_id_street_name_road_km_r_idx on road_network_partitioned2_693 a_693 (cost=0.14..18.02 rows=29 width=226) (actual time=2.716..2.803 rows=145 loops=1)

  • Heap Fetches: 145
485. 0.008 0.008 ↑ 1.0 29 1 / 4

Parallel Index Only Scan using road_network_partitioned2_694_link_id_street_name_road_km_r_idx on road_network_partitioned2_694 a_694 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.033 rows=29 loops=1)

  • Heap Fetches: 29
486. 0.005 0.005 ↑ 9.7 3 1 / 4

Parallel Index Only Scan using road_network_partitioned2_695_link_id_street_name_road_km_r_idx on road_network_partitioned2_695 a_695 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.021 rows=3 loops=1)

  • Heap Fetches: 3
487. 0.716 0.716 ↓ 3.7 106 1 / 4

Parallel Index Only Scan using road_network_partitioned2_699_link_id_street_name_road_km_r_idx on road_network_partitioned2_699 a_699 (cost=0.14..18.02 rows=29 width=226) (actual time=2.804..2.862 rows=106 loops=1)

  • Heap Fetches: 106
488. 0.019 0.019 ↓ 2.1 60 1 / 4

Parallel Index Only Scan using road_network_partitioned2_700_link_id_street_name_road_km_r_idx on road_network_partitioned2_700 a_700 (cost=0.14..18.02 rows=29 width=226) (actual time=0.035..0.078 rows=60 loops=1)

  • Heap Fetches: 60
489. 0.085 0.085 ↓ 2.8 80 1 / 4

Parallel Index Only Scan using road_network_partitioned2_701_link_id_street_name_road_km_r_idx on road_network_partitioned2_701 a_701 (cost=0.14..18.02 rows=29 width=226) (actual time=0.030..0.339 rows=80 loops=1)

  • Heap Fetches: 80
490. 0.006 0.006 ↑ 3.6 8 1 / 4

Parallel Index Only Scan using road_network_partitioned2_702_link_id_street_name_road_km_r_idx on road_network_partitioned2_702 a_702 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.023 rows=8 loops=1)

  • Heap Fetches: 8
491. 0.481 0.481 ↓ 2.7 79 1 / 4

Parallel Index Only Scan using road_network_partitioned2_703_link_id_street_name_road_km_r_idx on road_network_partitioned2_703 a_703 (cost=0.14..18.02 rows=29 width=226) (actual time=1.875..1.922 rows=79 loops=1)

  • Heap Fetches: 79
492. 0.430 0.430 ↓ 3.5 101 1 / 4

Parallel Index Only Scan using road_network_partitioned2_704_link_id_street_name_road_km_r_idx on road_network_partitioned2_704 a_704 (cost=0.14..18.02 rows=29 width=226) (actual time=1.658..1.722 rows=101 loops=1)

  • Heap Fetches: 101
493. 0.025 0.025 ↓ 5.3 155 1 / 4

Parallel Index Scan using road_network_partitioned2_705_pkey on road_network_partitioned2_705 a_705 (cost=0.14..18.02 rows=29 width=226) (actual time=0.011..0.100 rows=155 loops=1)

494. 0.005 0.005 ↑ 9.7 3 1 / 4

Parallel Index Only Scan using road_network_partitioned2_716_link_id_street_name_road_km_r_idx on road_network_partitioned2_716 a_716 (cost=0.14..18.02 rows=29 width=226) (actual time=0.017..0.019 rows=3 loops=1)

  • Heap Fetches: 3
495. 0.019 0.019 ↓ 2.6 74 1 / 4

Parallel Index Only Scan using road_network_partitioned2_717_link_id_street_name_road_km_r_idx on road_network_partitioned2_717 a_717 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.078 rows=74 loops=1)

  • Heap Fetches: 74
496. 0.011 0.011 ↑ 1.2 25 1 / 4

Parallel Index Only Scan using road_network_partitioned2_718_link_id_street_name_road_km_r_idx on road_network_partitioned2_718 a_718 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.044 rows=25 loops=1)

  • Heap Fetches: 25
497. 0.009 0.009 ↑ 4.1 7 1 / 4

Parallel Index Only Scan using road_network_partitioned2_719_link_id_street_name_road_km_r_idx on road_network_partitioned2_719 a_719 (cost=0.14..18.02 rows=29 width=226) (actual time=0.031..0.035 rows=7 loops=1)

  • Heap Fetches: 7
498. 0.054 0.054 ↓ 6.2 180 1 / 4

Parallel Index Scan using road_network_partitioned2_720_pkey on road_network_partitioned2_720 a_720 (cost=0.14..18.02 rows=29 width=226) (actual time=0.010..0.217 rows=180 loops=1)

499. 0.011 0.011 ↓ 1.2 36 1 / 4

Parallel Index Only Scan using road_network_partitioned2_721_link_id_street_name_road_km_r_idx on road_network_partitioned2_721 a_721 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.046 rows=36 loops=1)

  • Heap Fetches: 36
500. 0.018 0.018 ↓ 2.7 79 1 / 4

Parallel Index Only Scan using road_network_partitioned2_722_link_id_street_name_road_km_r_idx on road_network_partitioned2_722 a_722 (cost=0.14..18.02 rows=29 width=226) (actual time=0.026..0.073 rows=79 loops=1)

  • Heap Fetches: 79
501. 0.018 0.018 ↓ 1.9 54 1 / 4

Parallel Index Only Scan using road_network_partitioned2_723_link_id_street_name_road_km_r_idx on road_network_partitioned2_723 a_723 (cost=0.14..18.02 rows=29 width=226) (actual time=0.047..0.071 rows=54 loops=1)

  • Heap Fetches: 54
502. 0.007 0.007 ↑ 1.4 20 1 / 4

Parallel Index Only Scan using road_network_partitioned2_726_link_id_street_name_road_km_r_idx on road_network_partitioned2_726 a_726 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.028 rows=20 loops=1)

  • Heap Fetches: 20
503. 0.125 0.125 ↓ 2.3 68 1 / 4

Parallel Index Only Scan using road_network_partitioned2_727_link_id_street_name_road_km_r_idx on road_network_partitioned2_727 a_727 (cost=0.14..18.02 rows=29 width=226) (actual time=0.469..0.500 rows=68 loops=1)

  • Heap Fetches: 68
504. 0.555 0.555 ↓ 1.2 35 1 / 4

Parallel Index Only Scan using road_network_partitioned2_728_link_id_street_name_road_km_r_idx on road_network_partitioned2_728 a_728 (cost=0.14..18.02 rows=29 width=226) (actual time=2.203..2.219 rows=35 loops=1)

  • Heap Fetches: 35
505. 0.016 0.016 ↓ 1.7 50 1 / 4

Parallel Index Only Scan using road_network_partitioned2_735_link_id_street_name_road_km_r_idx on road_network_partitioned2_735 a_735 (cost=0.14..18.02 rows=29 width=226) (actual time=0.030..0.065 rows=50 loops=1)

  • Heap Fetches: 50
506. 0.127 0.127 ↓ 2.1 61 1 / 4

Parallel Index Only Scan using road_network_partitioned2_736_link_id_street_name_road_km_r_idx on road_network_partitioned2_736 a_736 (cost=0.14..18.02 rows=29 width=226) (actual time=0.474..0.506 rows=61 loops=1)

  • Heap Fetches: 61
507. 0.491 0.491 ↓ 2.1 60 1 / 4

Parallel Index Only Scan using road_network_partitioned2_737_link_id_street_name_road_km_r_idx on road_network_partitioned2_737 a_737 (cost=0.14..18.02 rows=29 width=226) (actual time=1.927..1.965 rows=60 loops=1)

  • Heap Fetches: 60
508. 0.005 0.005 ↑ 5.8 5 1 / 4

Parallel Index Only Scan using road_network_partitioned2_738_link_id_street_name_road_km_r_idx on road_network_partitioned2_738 a_738 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.021 rows=5 loops=1)

  • Heap Fetches: 5
509. 0.259 0.259 ↓ 2.2 63 1 / 4

Parallel Index Only Scan using road_network_partitioned2_741_link_id_street_name_road_km_r_idx on road_network_partitioned2_741 a_741 (cost=0.14..18.02 rows=29 width=226) (actual time=0.998..1.034 rows=63 loops=1)

  • Heap Fetches: 63
510. 0.624 0.624 ↑ 3.2 9 1 / 4

Parallel Index Only Scan using road_network_partitioned2_742_link_id_street_name_road_km_r_idx on road_network_partitioned2_742 a_742 (cost=0.14..18.02 rows=29 width=226) (actual time=2.491..2.495 rows=9 loops=1)

  • Heap Fetches: 9
511. 0.011 0.011 ↓ 1.1 32 1 / 4

Parallel Index Only Scan using road_network_partitioned2_743_link_id_street_name_road_km_r_idx on road_network_partitioned2_743 a_743 (cost=0.14..18.02 rows=29 width=226) (actual time=0.024..0.044 rows=32 loops=1)

  • Heap Fetches: 32
512. 0.010 0.010 ↑ 1.4 21 1 / 4

Parallel Index Only Scan using road_network_partitioned2_744_link_id_street_name_road_km_r_idx on road_network_partitioned2_744 a_744 (cost=0.14..18.02 rows=29 width=226) (actual time=0.030..0.041 rows=21 loops=1)

  • Heap Fetches: 21
513. 0.018 0.018 ↓ 2.6 76 1 / 4

Parallel Index Only Scan using road_network_partitioned2_745_link_id_street_name_road_km_r_idx on road_network_partitioned2_745 a_745 (cost=0.14..18.02 rows=29 width=226) (actual time=0.024..0.072 rows=76 loops=1)

  • Heap Fetches: 76
514. 0.028 0.028 ↓ 5.6 161 1 / 4

Parallel Index Scan using road_network_partitioned2_746_pkey on road_network_partitioned2_746 a_746 (cost=0.14..18.02 rows=29 width=226) (actual time=0.016..0.112 rows=161 loops=1)

515. 0.645 0.645 ↓ 4.7 137 1 / 4

Parallel Index Only Scan using road_network_partitioned2_747_link_id_street_name_road_km_r_idx on road_network_partitioned2_747 a_747 (cost=0.14..18.02 rows=29 width=226) (actual time=2.494..2.581 rows=137 loops=1)

  • Heap Fetches: 137
516. 0.056 0.056 ↓ 6.7 193 1 / 4

Parallel Index Scan using road_network_partitioned2_749_pkey on road_network_partitioned2_749 a_749 (cost=0.14..18.02 rows=29 width=226) (actual time=0.012..0.223 rows=193 loops=1)

517. 0.042 0.042 ↓ 8.1 236 1 / 4

Parallel Index Scan using road_network_partitioned2_758_pkey on road_network_partitioned2_758 a_758 (cost=0.14..18.02 rows=29 width=226) (actual time=0.017..0.167 rows=236 loops=1)

518. 0.030 0.030 ↓ 3.9 112 1 / 4

Parallel Index Only Scan using road_network_partitioned2_760_link_id_street_name_road_km_r_idx on road_network_partitioned2_760 a_760 (cost=0.14..18.02 rows=29 width=226) (actual time=0.038..0.122 rows=112 loops=1)

  • Heap Fetches: 112
519. 0.463 0.463 ↓ 3.0 88 1 / 4

Parallel Index Only Scan using road_network_partitioned2_761_link_id_street_name_road_km_r_idx on road_network_partitioned2_761 a_761 (cost=0.14..18.02 rows=29 width=226) (actual time=1.788..1.851 rows=88 loops=1)

  • Heap Fetches: 88
520. 0.025 0.025 ↓ 5.5 159 1 / 4

Parallel Index Scan using road_network_partitioned2_762_pkey on road_network_partitioned2_762 a_762 (cost=0.14..18.02 rows=29 width=226) (actual time=0.010..0.099 rows=159 loops=1)

521. 0.018 0.018 ↓ 2.1 60 1 / 4

Parallel Index Only Scan using road_network_partitioned2_763_link_id_street_name_road_km_r_idx on road_network_partitioned2_763 a_763 (cost=0.14..18.02 rows=29 width=226) (actual time=0.028..0.073 rows=60 loops=1)

  • Heap Fetches: 60
522. 0.009 0.009 ↑ 1.3 22 1 / 4

Parallel Index Only Scan using road_network_partitioned2_764_link_id_street_name_road_km_r_idx on road_network_partitioned2_764 a_764 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.037 rows=22 loops=1)

  • Heap Fetches: 22
523. 0.951 0.951 ↓ 3.3 95 1 / 4

Parallel Index Only Scan using road_network_partitioned2_765_link_id_street_name_road_km_r_idx on road_network_partitioned2_765 a_765 (cost=0.14..18.02 rows=29 width=226) (actual time=3.743..3.805 rows=95 loops=1)

  • Heap Fetches: 95
524. 0.008 0.008 ↑ 7.2 4 1 / 4

Parallel Index Only Scan using road_network_partitioned2_766_link_id_street_name_road_km_r_idx on road_network_partitioned2_766 a_766 (cost=0.14..18.02 rows=29 width=226) (actual time=0.030..0.032 rows=4 loops=1)

  • Heap Fetches: 4
525. 0.938 0.938 ↓ 1.9 55 1 / 4

Parallel Index Only Scan using road_network_partitioned2_767_link_id_street_name_road_km_r_idx on road_network_partitioned2_767 a_767 (cost=0.14..18.02 rows=29 width=226) (actual time=3.654..3.751 rows=55 loops=1)

  • Heap Fetches: 55
526. 0.012 0.012 ↓ 1.2 35 1 / 4

Parallel Index Only Scan using road_network_partitioned2_768_link_id_street_name_road_km_r_idx on road_network_partitioned2_768 a_768 (cost=0.14..18.02 rows=29 width=226) (actual time=0.027..0.048 rows=35 loops=1)

  • Heap Fetches: 35
527. 0.482 0.482 ↓ 2.5 73 1 / 4

Parallel Index Only Scan using road_network_partitioned2_778_link_id_street_name_road_km_r_idx on road_network_partitioned2_778 a_778 (cost=0.14..18.02 rows=29 width=226) (actual time=1.869..1.929 rows=73 loops=1)

  • Heap Fetches: 73
528. 0.015 0.015 ↓ 1.7 48 1 / 4

Parallel Index Only Scan using road_network_partitioned2_779_link_id_street_name_road_km_r_idx on road_network_partitioned2_779 a_779 (cost=0.14..18.02 rows=29 width=226) (actual time=0.028..0.058 rows=48 loops=1)

  • Heap Fetches: 48
529. 0.014 0.014 ↓ 1.4 41 1 / 4

Parallel Index Only Scan using road_network_partitioned2_780_link_id_street_name_road_km_r_idx on road_network_partitioned2_780 a_780 (cost=0.14..18.02 rows=29 width=226) (actual time=0.035..0.057 rows=41 loops=1)

  • Heap Fetches: 41
530. 0.008 0.008 ↑ 4.1 7 1 / 4

Parallel Index Only Scan using road_network_partitioned2_782_link_id_street_name_road_km_r_idx on road_network_partitioned2_782 a_782 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.032 rows=7 loops=1)

  • Heap Fetches: 7
531. 0.218 0.218 ↓ 2.0 57 1 / 4

Parallel Index Only Scan using road_network_partitioned2_783_link_id_street_name_road_km_r_idx on road_network_partitioned2_783 a_783 (cost=0.14..18.02 rows=29 width=226) (actual time=0.833..0.874 rows=57 loops=1)

  • Heap Fetches: 57
532. 0.771 0.771 ↓ 1.0 30 1 / 4

Parallel Index Only Scan using road_network_partitioned2_784_link_id_street_name_road_km_r_idx on road_network_partitioned2_784 a_784 (cost=0.14..18.02 rows=29 width=226) (actual time=3.070..3.086 rows=30 loops=1)

  • Heap Fetches: 30
533. 0.774 0.774 ↓ 1.7 50 1 / 4

Parallel Index Only Scan using road_network_partitioned2_785_link_id_street_name_road_km_r_idx on road_network_partitioned2_785 a_785 (cost=0.14..18.02 rows=29 width=226) (actual time=2.983..3.098 rows=50 loops=1)

  • Heap Fetches: 50
534. 0.015 0.015 ↓ 1.6 46 1 / 4

Parallel Index Only Scan using road_network_partitioned2_786_link_id_street_name_road_km_r_idx on road_network_partitioned2_786 a_786 (cost=0.14..18.02 rows=29 width=226) (actual time=0.027..0.060 rows=46 loops=1)

  • Heap Fetches: 46
535. 0.017 0.017 ↓ 2.0 57 1 / 4

Parallel Index Only Scan using road_network_partitioned2_787_link_id_street_name_road_km_r_idx on road_network_partitioned2_787 a_787 (cost=0.14..18.02 rows=29 width=226) (actual time=0.033..0.069 rows=57 loops=1)

  • Heap Fetches: 57
536. 0.059 0.059 ↓ 5.0 145 1 / 4

Parallel Index Only Scan using road_network_partitioned2_788_link_id_street_name_road_km_r_idx on road_network_partitioned2_788 a_788 (cost=0.14..18.02 rows=29 width=226) (actual time=0.042..0.234 rows=145 loops=1)

  • Heap Fetches: 145
537. 0.033 0.033 ↓ 6.6 192 1 / 4

Parallel Index Scan using road_network_partitioned2_789_pkey on road_network_partitioned2_789 a_789 (cost=0.14..18.02 rows=29 width=226) (actual time=0.013..0.132 rows=192 loops=1)

538. 0.208 0.208 ↓ 2.1 61 1 / 4

Parallel Index Only Scan using road_network_partitioned2_803_link_id_street_name_road_km_r_idx on road_network_partitioned2_803 a_803 (cost=0.14..18.02 rows=29 width=226) (actual time=0.776..0.834 rows=61 loops=1)

  • Heap Fetches: 61
539. 0.190 0.190 ↓ 1.8 51 1 / 4

Parallel Index Only Scan using road_network_partitioned2_804_link_id_street_name_road_km_r_idx on road_network_partitioned2_804 a_804 (cost=0.14..18.02 rows=29 width=226) (actual time=0.725..0.758 rows=51 loops=1)

  • Heap Fetches: 51
540. 0.242 0.242 ↓ 3.2 94 1 / 4

Parallel Index Only Scan using road_network_partitioned2_807_link_id_street_name_road_km_r_idx on road_network_partitioned2_807 a_807 (cost=0.14..18.02 rows=29 width=226) (actual time=0.906..0.967 rows=94 loops=1)

  • Heap Fetches: 94
541. 0.017 0.017 ↓ 2.4 70 1 / 4

Parallel Index Only Scan using road_network_partitioned2_808_link_id_street_name_road_km_r_idx on road_network_partitioned2_808 a_808 (cost=0.14..18.02 rows=29 width=226) (actual time=0.032..0.066 rows=70 loops=1)

  • Heap Fetches: 70
542. 0.007 0.007 ↑ 1.9 15 1 / 4

Parallel Index Only Scan using road_network_partitioned2_820_link_id_street_name_road_km_r_idx on road_network_partitioned2_820 a_820 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.029 rows=15 loops=1)

  • Heap Fetches: 15
543. 0.027 0.027 ↓ 5.9 171 1 / 4

Parallel Index Scan using road_network_partitioned2_821_pkey on road_network_partitioned2_821 a_821 (cost=0.14..18.02 rows=29 width=226) (actual time=0.010..0.108 rows=171 loops=1)

544. 0.009 0.009 ↓ 1.3 38 1 / 4

Parallel Index Only Scan using road_network_partitioned2_822_link_id_street_name_road_km_r_idx on road_network_partitioned2_822 a_822 (cost=0.14..18.02 rows=29 width=226) (actual time=0.018..0.037 rows=38 loops=1)

  • Heap Fetches: 38
545. 0.012 0.012 ↓ 1.2 35 1 / 4

Parallel Index Only Scan using road_network_partitioned2_823_link_id_street_name_road_km_r_idx on road_network_partitioned2_823 a_823 (cost=0.14..18.02 rows=29 width=226) (actual time=0.031..0.048 rows=35 loops=1)

  • Heap Fetches: 35
546. 0.009 0.009 ↑ 1.5 19 1 / 4

Parallel Index Only Scan using road_network_partitioned2_824_link_id_street_name_road_km_r_idx on road_network_partitioned2_824 a_824 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.034 rows=19 loops=1)

  • Heap Fetches: 19
547. 0.265 0.265 ↑ 1.3 23 1 / 4

Parallel Index Only Scan using road_network_partitioned2_825_link_id_street_name_road_km_r_idx on road_network_partitioned2_825 a_825 (cost=0.14..18.02 rows=29 width=226) (actual time=1.052..1.061 rows=23 loops=1)

  • Heap Fetches: 23
548. 0.411 0.411 ↓ 2.1 61 1 / 4

Parallel Index Only Scan using road_network_partitioned2_826_link_id_street_name_road_km_r_idx on road_network_partitioned2_826 a_826 (cost=0.14..18.02 rows=29 width=226) (actual time=1.611..1.646 rows=61 loops=1)

  • Heap Fetches: 61
549. 0.014 0.014 ↓ 1.9 55 1 / 4

Parallel Index Only Scan using road_network_partitioned2_827_link_id_street_name_road_km_r_idx on road_network_partitioned2_827 a_827 (cost=0.14..18.02 rows=29 width=226) (actual time=0.027..0.055 rows=55 loops=1)

  • Heap Fetches: 55
550. 0.031 0.031 ↓ 5.2 151 1 / 4

Parallel Index Only Scan using road_network_partitioned2_828_link_id_street_name_road_km_r_idx on road_network_partitioned2_828 a_828 (cost=0.14..18.02 rows=29 width=226) (actual time=0.036..0.124 rows=151 loops=1)

  • Heap Fetches: 151
551. 0.010 0.010 ↓ 1.1 31 1 / 4

Parallel Index Only Scan using road_network_partitioned2_829_link_id_street_name_road_km_r_idx on road_network_partitioned2_829 a_829 (cost=0.14..18.02 rows=29 width=226) (actual time=0.024..0.041 rows=31 loops=1)

  • Heap Fetches: 31
552. 0.030 0.030 ↓ 4.0 117 1 / 4

Parallel Index Only Scan using road_network_partitioned2_830_link_id_street_name_road_km_r_idx on road_network_partitioned2_830 a_830 (cost=0.14..18.02 rows=29 width=226) (actual time=0.030..0.121 rows=117 loops=1)

  • Heap Fetches: 117
553. 0.035 0.035 ↓ 4.7 136 1 / 4

Parallel Index Only Scan using road_network_partitioned2_831_link_id_street_name_road_km_r_idx on road_network_partitioned2_831 a_831 (cost=0.14..18.02 rows=29 width=226) (actual time=0.034..0.138 rows=136 loops=1)

  • Heap Fetches: 136
554. 0.038 0.038 ↓ 8.7 253 1 / 4

Parallel Index Scan using road_network_partitioned2_846_pkey on road_network_partitioned2_846 a_846 (cost=0.14..18.02 rows=29 width=226) (actual time=0.011..0.151 rows=253 loops=1)

555. 0.006 0.006 ↑ 2.2 13 1 / 4

Parallel Index Only Scan using road_network_partitioned2_847_link_id_street_name_road_km_r_idx on road_network_partitioned2_847 a_847 (cost=0.14..18.02 rows=29 width=226) (actual time=0.017..0.023 rows=13 loops=1)

  • Heap Fetches: 13
556. 0.006 0.006 ↑ 14.5 2 1 / 4

Parallel Index Only Scan using road_network_partitioned2_848_link_id_street_name_road_km_r_idx on road_network_partitioned2_848 a_848 (cost=0.14..18.02 rows=29 width=226) (actual time=0.023..0.025 rows=2 loops=1)

  • Heap Fetches: 2
557. 0.155 0.155 ↓ 3.1 90 1 / 4

Parallel Index Only Scan using road_network_partitioned2_849_link_id_street_name_road_km_r_idx on road_network_partitioned2_849 a_849 (cost=0.14..18.02 rows=29 width=226) (actual time=0.572..0.622 rows=90 loops=1)

  • Heap Fetches: 90
558. 0.008 0.008 ↑ 1.3 23 1 / 4

Parallel Index Only Scan using road_network_partitioned2_862_link_id_street_name_road_km_r_idx on road_network_partitioned2_862 a_862 (cost=0.14..18.02 rows=29 width=226) (actual time=0.021..0.033 rows=23 loops=1)

  • Heap Fetches: 23
559. 0.466 0.466 ↓ 3.8 111 1 / 4

Parallel Index Only Scan using road_network_partitioned2_863_link_id_street_name_road_km_r_idx on road_network_partitioned2_863 a_863 (cost=0.14..18.02 rows=29 width=226) (actual time=1.804..1.863 rows=111 loops=1)

  • Heap Fetches: 111
560. 0.015 0.015 ↓ 2.5 72 1 / 4

Parallel Index Only Scan using road_network_partitioned2_865_link_id_street_name_road_km_r_idx on road_network_partitioned2_865 a_865 (cost=0.14..18.02 rows=29 width=226) (actual time=0.022..0.062 rows=72 loops=1)

  • Heap Fetches: 72
561. 0.162 0.162 ↓ 3.7 107 1 / 4

Parallel Index Only Scan using road_network_partitioned2_866_link_id_street_name_road_km_r_idx on road_network_partitioned2_866 a_866 (cost=0.14..18.02 rows=29 width=226) (actual time=0.590..0.649 rows=107 loops=1)

  • Heap Fetches: 107
562. 0.500 0.500 ↓ 1.7 50 1 / 4

Parallel Index Only Scan using road_network_partitioned2_867_link_id_street_name_road_km_r_idx on road_network_partitioned2_867 a_867 (cost=0.14..18.02 rows=29 width=226) (actual time=1.960..1.999 rows=50 loops=1)

  • Heap Fetches: 50
563. 0.011 0.011 ↑ 1.4 21 1 / 4

Parallel Index Only Scan using road_network_partitioned2_868_link_id_street_name_road_km_r_idx on road_network_partitioned2_868 a_868 (cost=0.14..18.02 rows=29 width=226) (actual time=0.028..0.045 rows=21 loops=1)

  • Heap Fetches: 21
564. 0.018 0.018 ↓ 2.1 60 1 / 4

Parallel Index Only Scan using road_network_partitioned2_869_link_id_street_name_road_km_r_idx on road_network_partitioned2_869 a_869 (cost=0.14..18.02 rows=29 width=226) (actual time=0.034..0.070 rows=60 loops=1)

  • Heap Fetches: 60
565. 0.022 0.022 ↓ 2.7 77 1 / 4

Parallel Index Only Scan using road_network_partitioned2_871_link_id_street_name_road_km_r_idx on road_network_partitioned2_871 a_871 (cost=0.14..18.02 rows=29 width=226) (actual time=0.022..0.089 rows=77 loops=1)

  • Heap Fetches: 77
566. 0.026 0.026 ↓ 4.1 120 1 / 4

Parallel Index Only Scan using road_network_partitioned2_872_link_id_street_name_road_km_r_idx on road_network_partitioned2_872 a_872 (cost=0.14..18.02 rows=29 width=226) (actual time=0.031..0.104 rows=120 loops=1)

  • Heap Fetches: 120
567. 0.496 0.496 ↓ 5.2 151 1 / 4

Parallel Index Only Scan using road_network_partitioned2_873_link_id_street_name_road_km_r_idx on road_network_partitioned2_873 a_873 (cost=0.14..18.02 rows=29 width=226) (actual time=1.890..1.983 rows=151 loops=1)

  • Heap Fetches: 151
568. 0.034 0.034 ↓ 7.9 229 1 / 4

Parallel Index Scan using road_network_partitioned2_885_pkey on road_network_partitioned2_885 a_885 (cost=0.14..18.02 rows=29 width=226) (actual time=0.012..0.134 rows=229 loops=1)

569. 0.013 0.013 ↑ 1.3 23 1 / 4

Parallel Index Only Scan using road_network_partitioned2_893_link_id_street_name_road_km_r_idx on road_network_partitioned2_893 a_893 (cost=0.14..18.02 rows=29 width=226) (actual time=0.022..0.052 rows=23 loops=1)

  • Heap Fetches: 23
570. 0.013 0.013 ↑ 1.4 20 1 / 4

Parallel Index Only Scan using road_network_partitioned2_894_link_id_street_name_road_km_r_idx on road_network_partitioned2_894 a_894 (cost=0.14..18.02 rows=29 width=226) (actual time=0.023..0.052 rows=20 loops=1)

  • Heap Fetches: 20
571. 0.021 0.021 ↓ 1.6 46 1 / 4

Parallel Index Only Scan using road_network_partitioned2_895_link_id_street_name_road_km_r_idx on road_network_partitioned2_895 a_895 (cost=0.14..18.02 rows=29 width=226) (actual time=0.026..0.082 rows=46 loops=1)

  • Heap Fetches: 46
572. 0.056 0.056 ↑ 1.0 28 1 / 4

Parallel Index Only Scan using road_network_partitioned2_896_link_id_street_name_road_km_r_idx on road_network_partitioned2_896 a_896 (cost=0.14..18.02 rows=29 width=226) (actual time=0.193..0.225 rows=28 loops=1)

  • Heap Fetches: 28
573. 0.005 0.005 ↑ 7.2 4 1 / 4

Parallel Index Only Scan using road_network_partitioned2_897_link_id_street_name_road_km_r_idx on road_network_partitioned2_897 a_897 (cost=0.14..18.02 rows=29 width=226) (actual time=0.017..0.019 rows=4 loops=1)

  • Heap Fetches: 4
574. 0.006 0.006 ↑ 5.8 5 1 / 4

Parallel Index Only Scan using road_network_partitioned2_898_link_id_street_name_road_km_r_idx on road_network_partitioned2_898 a_898 (cost=0.14..18.02 rows=29 width=226) (actual time=0.022..0.024 rows=5 loops=1)

  • Heap Fetches: 5
575. 0.009 0.009 ↑ 3.6 8 1 / 4

Parallel Index Only Scan using road_network_partitioned2_899_link_id_street_name_road_km_r_idx on road_network_partitioned2_899 a_899 (cost=0.14..18.02 rows=29 width=226) (actual time=0.034..0.037 rows=8 loops=1)

  • Heap Fetches: 8
576. 0.738 0.738 ↓ 1.5 44 1 / 4

Parallel Index Only Scan using road_network_partitioned2_901_link_id_street_name_road_km_r_idx on road_network_partitioned2_901 a_901 (cost=0.14..18.02 rows=29 width=226) (actual time=2.926..2.952 rows=44 loops=1)

  • Heap Fetches: 44
577. 0.006 0.006 ↑ 1.4 21 1 / 4

Parallel Index Only Scan using road_network_partitioned2_902_link_id_street_name_road_km_r_idx on road_network_partitioned2_902 a_902 (cost=0.14..18.02 rows=29 width=226) (actual time=0.017..0.025 rows=21 loops=1)

  • Heap Fetches: 21
578. 0.006 0.006 ↑ 14.5 2 1 / 4

Parallel Index Only Scan using road_network_partitioned2_904_link_id_street_name_road_km_r_idx on road_network_partitioned2_904 a_904 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.026 rows=2 loops=1)

  • Heap Fetches: 2
579. 0.021 0.021 ↓ 2.9 84 1 / 4

Parallel Index Only Scan using road_network_partitioned2_905_link_id_street_name_road_km_r_idx on road_network_partitioned2_905 a_905 (cost=0.14..18.02 rows=29 width=226) (actual time=0.034..0.085 rows=84 loops=1)

  • Heap Fetches: 84
580. 0.656 0.656 ↓ 3.3 97 1 / 4

Parallel Index Only Scan using road_network_partitioned2_906_link_id_street_name_road_km_r_idx on road_network_partitioned2_906 a_906 (cost=0.14..18.02 rows=29 width=226) (actual time=2.555..2.623 rows=97 loops=1)

  • Heap Fetches: 97
581. 0.037 0.037 ↓ 8.6 249 1 / 4

Parallel Index Scan using road_network_partitioned2_907_pkey on road_network_partitioned2_907 a_907 (cost=0.14..18.02 rows=29 width=226) (actual time=0.011..0.148 rows=249 loops=1)

582. 0.384 0.384 ↓ 4.7 135 1 / 4

Parallel Index Only Scan using road_network_partitioned2_908_link_id_street_name_road_km_r_idx on road_network_partitioned2_908 a_908 (cost=0.14..18.02 rows=29 width=226) (actual time=1.464..1.534 rows=135 loops=1)

  • Heap Fetches: 135
583. 0.007 0.007 ↑ 2.4 12 1 / 4

Parallel Index Only Scan using road_network_partitioned2_910_link_id_street_name_road_km_r_idx on road_network_partitioned2_910 a_910 (cost=0.14..18.02 rows=29 width=226) (actual time=0.022..0.027 rows=12 loops=1)

  • Heap Fetches: 12
584. 0.016 0.016 ↓ 1.8 52 1 / 4

Parallel Index Only Scan using road_network_partitioned2_911_link_id_street_name_road_km_r_idx on road_network_partitioned2_911 a_911 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.064 rows=52 loops=1)

  • Heap Fetches: 52
585. 0.030 0.030 ↓ 4.2 121 1 / 4

Parallel Index Only Scan using road_network_partitioned2_912_link_id_street_name_road_km_r_idx on road_network_partitioned2_912 a_912 (cost=0.14..18.02 rows=29 width=226) (actual time=0.037..0.120 rows=121 loops=1)

  • Heap Fetches: 121
586. 0.363 0.363 ↓ 5.1 149 1 / 4

Parallel Index Only Scan using road_network_partitioned2_914_link_id_street_name_road_km_r_idx on road_network_partitioned2_914 a_914 (cost=0.14..18.02 rows=29 width=226) (actual time=1.351..1.451 rows=149 loops=1)

  • Heap Fetches: 149
587. 0.485 0.485 ↓ 4.6 132 1 / 4

Parallel Index Only Scan using road_network_partitioned2_915_link_id_street_name_road_km_r_idx on road_network_partitioned2_915 a_915 (cost=0.14..18.02 rows=29 width=226) (actual time=1.863..1.942 rows=132 loops=1)

  • Heap Fetches: 132
588. 0.035 0.035 ↓ 8.2 237 1 / 4

Parallel Index Scan using road_network_partitioned2_916_pkey on road_network_partitioned2_916 a_916 (cost=0.14..18.02 rows=29 width=226) (actual time=0.012..0.139 rows=237 loops=1)

589. 0.006 0.006 ↑ 2.6 11 1 / 4

Parallel Index Only Scan using road_network_partitioned2_932_link_id_street_name_road_km_r_idx on road_network_partitioned2_932 a_932 (cost=0.14..18.02 rows=29 width=226) (actual time=0.021..0.025 rows=11 loops=1)

  • Heap Fetches: 11
590. 0.033 0.033 ↓ 6.6 191 1 / 4

Parallel Index Scan using road_network_partitioned2_934_pkey on road_network_partitioned2_934 a_934 (cost=0.14..18.02 rows=29 width=226) (actual time=0.011..0.133 rows=191 loops=1)

591. 0.011 0.011 ↓ 1.4 40 1 / 4

Parallel Index Only Scan using road_network_partitioned2_935_link_id_street_name_road_km_r_idx on road_network_partitioned2_935 a_935 (cost=0.14..18.02 rows=29 width=226) (actual time=0.024..0.044 rows=40 loops=1)

  • Heap Fetches: 40
592. 0.013 0.013 ↓ 1.9 55 1 / 4

Parallel Index Only Scan using road_network_partitioned2_936_link_id_street_name_road_km_r_idx on road_network_partitioned2_936 a_936 (cost=0.14..18.02 rows=29 width=226) (actual time=0.019..0.051 rows=55 loops=1)

  • Heap Fetches: 55
593. 0.009 0.009 ↓ 1.2 35 1 / 4

Parallel Index Only Scan using road_network_partitioned2_937_link_id_street_name_road_km_r_idx on road_network_partitioned2_937 a_937 (cost=0.14..18.02 rows=29 width=226) (actual time=0.020..0.038 rows=35 loops=1)

  • Heap Fetches: 35
594. 0.018 0.018 ↓ 2.0 58 1 / 4

Parallel Index Only Scan using road_network_partitioned2_938_link_id_street_name_road_km_r_idx on road_network_partitioned2_938 a_938 (cost=0.14..18.02 rows=29 width=226) (actual time=0.028..0.070 rows=58 loops=1)

  • Heap Fetches: 58
595. 0.674 0.674 ↓ 2.6 76 1 / 4

Parallel Index Only Scan using road_network_partitioned2_939_link_id_street_name_road_km_r_idx on road_network_partitioned2_939 a_939 (cost=0.14..18.02 rows=29 width=226) (actual time=2.649..2.697 rows=76 loops=1)

  • Heap Fetches: 76
596. 0.009 0.009 ↑ 1.0 29 1 / 4

Parallel Index Only Scan using road_network_partitioned2_940_link_id_street_name_road_km_r_idx on road_network_partitioned2_940 a_940 (cost=0.14..18.02 rows=29 width=226) (actual time=0.024..0.038 rows=29 loops=1)

  • Heap Fetches: 29
597. 0.019 0.019 ↓ 3.1 89 1 / 4

Parallel Index Only Scan using road_network_partitioned2_941_link_id_street_name_road_km_r_idx on road_network_partitioned2_941 a_941 (cost=0.14..18.02 rows=29 width=226) (actual time=0.029..0.077 rows=89 loops=1)

  • Heap Fetches: 89
598. 0.751 0.751 ↓ 1.5 43 1 / 4

Parallel Index Only Scan using road_network_partitioned2_942_link_id_street_name_road_km_r_idx on road_network_partitioned2_942 a_942 (cost=0.14..18.02 rows=29 width=226) (actual time=2.981..3.003 rows=43 loops=1)

  • Heap Fetches: 43
599. 0.007 0.007 ↑ 2.6 11 1 / 4

Parallel Index Only Scan using road_network_partitioned2_943_link_id_street_name_road_km_r_idx on road_network_partitioned2_943 a_943 (cost=0.14..18.02 rows=29 width=226) (actual time=0.024..0.029 rows=11 loops=1)

  • Heap Fetches: 11
600. 0.114 0.114 ↓ 5.6 161 1 / 4

Parallel Index Scan using road_network_partitioned2_944_pkey on road_network_partitioned2_944 a_944 (cost=0.14..18.02 rows=29 width=226) (actual time=0.330..0.454 rows=161 loops=1)

601. 0.030 0.030 ↓ 5.4 158 1 / 4

Parallel Index Scan using road_network_partitioned2_947_pkey on road_network_partitioned2_947 a_947 (cost=0.14..18.02 rows=29 width=226) (actual time=0.015..0.121 rows=158 loops=1)

602. 0.017 0.017 ↑ 1.2 24 1 / 4

Parallel Index Only Scan using road_network_partitioned2_948_link_id_street_name_road_km_r_idx on road_network_partitioned2_948 a_948 (cost=0.14..18.02 rows=29 width=226) (actual time=0.027..0.067 rows=24 loops=1)

  • Heap Fetches: 24
603. 0.567 0.567 ↓ 3.6 105 1 / 4

Parallel Index Only Scan using road_network_partitioned2_949_link_id_street_name_road_km_r_idx on road_network_partitioned2_949 a_949 (cost=0.14..18.02 rows=29 width=226) (actual time=2.198..2.266 rows=105 loops=1)

  • Heap Fetches: 105
604. 0.487 0.487 ↓ 5.1 149 1 / 4

Parallel Index Only Scan using road_network_partitioned2_952_link_id_street_name_road_km_r_idx on road_network_partitioned2_952 a_952 (cost=0.14..18.02 rows=29 width=226) (actual time=1.842..1.949 rows=149 loops=1)

  • Heap Fetches: 149
605. 0.036 0.036 ↓ 4.5 130 1 / 4

Parallel Index Only Scan using road_network_partitioned2_956_link_id_street_name_road_km_r_idx on road_network_partitioned2_956 a_956 (cost=0.14..18.02 rows=29 width=226) (actual time=0.042..0.145 rows=130 loops=1)

  • Heap Fetches: 130
606. 0.425 0.425 ↓ 3.2 93 1 / 4

Parallel Index Only Scan using road_network_partitioned2_957_link_id_street_name_road_km_r_idx on road_network_partitioned2_957 a_957 (cost=0.14..18.02 rows=29 width=226) (actual time=1.636..1.701 rows=93 loops=1)

  • Heap Fetches: 93
607. 0.668 0.668 ↓ 3.8 111 1 / 4

Parallel Index Only Scan using road_network_partitioned2_975_link_id_street_name_road_km_r_idx on road_network_partitioned2_975 a_975 (cost=0.14..18.02 rows=29 width=226) (actual time=2.609..2.673 rows=111 loops=1)

  • Heap Fetches: 111
608. 0.011 0.011 ↑ 1.0 29 1 / 4

Parallel Index Only Scan using road_network_partitioned2_977_link_id_street_name_road_km_r_idx on road_network_partitioned2_977 a_977 (cost=0.14..18.02 rows=29 width=226) (actual time=0.025..0.042 rows=29 loops=1)

  • Heap Fetches: 29
609. 0.032 0.032 ↓ 4.4 129 1 / 4

Parallel Index Only Scan using road_network_partitioned2_994_link_id_street_name_road_km_r_idx on road_network_partitioned2_994 a_994 (cost=0.14..18.02 rows=29 width=226) (actual time=0.028..0.128 rows=129 loops=1)

  • Heap Fetches: 129
610. 0.009 0.009 ↓ 1.0 30 1 / 4

Parallel Index Only Scan using road_network_partitioned2_995_link_id_street_name_road_km_r_idx on road_network_partitioned2_995 a_995 (cost=0.14..18.02 rows=29 width=226) (actual time=0.021..0.038 rows=30 loops=1)

  • Heap Fetches: 30
611. 0.259 0.259 ↓ 4.0 116 1 / 4

Parallel Index Only Scan using road_network_partitioned2_997_link_id_street_name_road_km_r_idx on road_network_partitioned2_997 a_997 (cost=0.14..18.02 rows=29 width=226) (actual time=0.947..1.036 rows=116 loops=1)

  • Heap Fetches: 116
612. 0.607 0.607 ↓ 3.4 98 1 / 4

Parallel Index Only Scan using road_network_partitioned2_10_link_id_street_name_road_km__idx11 on road_network_partitioned2_1019 a_1019 (cost=0.14..18.02 rows=29 width=226) (actual time=2.362..2.429 rows=98 loops=1)

  • Heap Fetches: 98
613. 0.030 0.030 ↓ 5.6 161 1 / 4

Parallel Index Scan using road_network_partitioned2_1039_pkey on road_network_partitioned2_1039 a_1039 (cost=0.14..18.02 rows=29 width=226) (actual time=0.014..0.121 rows=161 loops=1)

614. 0.020 0.020 ↓ 3.4 99 1 / 4

Parallel Index Only Scan using road_network_partitioned2_105_link_id_street_name_road_km__idx8 on road_network_partitioned2_1057 a_1057 (cost=0.14..18.02 rows=29 width=226) (actual time=0.031..0.079 rows=99 loops=1)

  • Heap Fetches: 99
615. 0.019 0.019 ↓ 2.5 73 1 / 4

Parallel Index Only Scan using road_network_partitioned2_107_link_id_street_name_road_km__idx4 on road_network_partitioned2_1073 a_1073 (cost=0.14..18.02 rows=29 width=226) (actual time=0.041..0.076 rows=73 loops=1)

  • Heap Fetches: 73
616. 0.041 0.041 ↓ 8.7 253 1 / 4

Parallel Index Scan using road_network_partitioned2_1075_pkey on road_network_partitioned2_1075 a_1075 (cost=0.14..18.02 rows=29 width=226) (actual time=0.016..0.163 rows=253 loops=1)

617. 0.189 0.189 ↓ 2.8 82 1 / 4

Parallel Index Only Scan using road_network_partitioned2_121_link_id_street_name_road_km__idx5 on road_network_partitioned2_1214 a_1214 (cost=0.14..18.02 rows=29 width=226) (actual time=0.036..0.754 rows=82 loops=1)

  • Heap Fetches: 82
618. 0.040 0.040 ↓ 9.4 274 1 / 4

Parallel Index Scan using road_network_partitioned2_1251_pkey on road_network_partitioned2_1251 a_1251 (cost=0.14..18.02 rows=29 width=226) (actual time=0.012..0.159 rows=274 loops=1)

619. 0.022 0.022 ↑ 29.0 1 1 / 4

Parallel Index Only Scan using road_network_partitioned2_129_link_id_street_name_road_km__idx4 on road_network_partitioned2_1293 a_1293 (cost=0.14..18.02 rows=29 width=226) (actual time=0.089..0.089 rows=1 loops=1)

  • Heap Fetches: 1
620. 0.270 0.270 ↓ 3.7 106 1 / 4

Parallel Index Only Scan using road_network_partitioned2_142_link_id_street_name_road_km__idx1 on road_network_partitioned2_1420 a_1420 (cost=0.14..18.02 rows=29 width=226) (actual time=1.010..1.079 rows=106 loops=1)

  • Heap Fetches: 106
621. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_0_link_id_street_name_road_km_roa_idx on road_network_partitioned2_0 a (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
622. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_1_link_id_street_name_road_km_roa_idx on road_network_partitioned2_1 a_1 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
623. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_2_link_id_street_name_road_km_roa_idx on road_network_partitioned2_2 a_2 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
624. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_3_link_id_street_name_road_km_roa_idx on road_network_partitioned2_3 a_3 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
625. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_4_link_id_street_name_road_km_roa_idx on road_network_partitioned2_4 a_4 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
626. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_5_link_id_street_name_road_km_roa_idx on road_network_partitioned2_5 a_5 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
627. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_6_link_id_street_name_road_km_roa_idx on road_network_partitioned2_6 a_6 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
628. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_7_link_id_street_name_road_km_roa_idx on road_network_partitioned2_7 a_7 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
629. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_8_link_id_street_name_road_km_roa_idx on road_network_partitioned2_8 a_8 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
630. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_9_link_id_street_name_road_km_roa_idx on road_network_partitioned2_9 a_9 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
631. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_10_link_id_street_name_road_km_ro_idx on road_network_partitioned2_10 a_10 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
632. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_11_link_id_street_name_road_km_ro_idx on road_network_partitioned2_11 a_11 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
633. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_12_link_id_street_name_road_km_ro_idx on road_network_partitioned2_12 a_12 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
634. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_13_link_id_street_name_road_km_ro_idx on road_network_partitioned2_13 a_13 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
635. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_14_link_id_street_name_road_km_ro_idx on road_network_partitioned2_14 a_14 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
636. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_15_link_id_street_name_road_km_ro_idx on road_network_partitioned2_15 a_15 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
637. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_16_link_id_street_name_road_km_ro_idx on road_network_partitioned2_16 a_16 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
638. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_17_link_id_street_name_road_km_ro_idx on road_network_partitioned2_17 a_17 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
639. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_18_link_id_street_name_road_km_ro_idx on road_network_partitioned2_18 a_18 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
640. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_19_link_id_street_name_road_km_ro_idx on road_network_partitioned2_19 a_19 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.003 rows=0 loops=1)

  • Heap Fetches: 0
641. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_20_link_id_street_name_road_km_ro_idx on road_network_partitioned2_20 a_20 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
642. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_21_link_id_street_name_road_km_ro_idx on road_network_partitioned2_21 a_21 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
643. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_22_link_id_street_name_road_km_ro_idx on road_network_partitioned2_22 a_22 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
644. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_23_link_id_street_name_road_km_ro_idx on road_network_partitioned2_23 a_23 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
645. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_24_link_id_street_name_road_km_ro_idx on road_network_partitioned2_24 a_24 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
646. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_25_link_id_street_name_road_km_ro_idx on road_network_partitioned2_25 a_25 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
647. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_26_link_id_street_name_road_km_ro_idx on road_network_partitioned2_26 a_26 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
648. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_27_link_id_street_name_road_km_ro_idx on road_network_partitioned2_27 a_27 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
649. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_28_link_id_street_name_road_km_ro_idx on road_network_partitioned2_28 a_28 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
650. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_29_link_id_street_name_road_km_ro_idx on road_network_partitioned2_29 a_29 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
651. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_30_link_id_street_name_road_km_ro_idx on road_network_partitioned2_30 a_30 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
652. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_31_link_id_street_name_road_km_ro_idx on road_network_partitioned2_31 a_31 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
653. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_32_link_id_street_name_road_km_ro_idx on road_network_partitioned2_32 a_32 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
654. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_33_link_id_street_name_road_km_ro_idx on road_network_partitioned2_33 a_33 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
655. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_34_link_id_street_name_road_km_ro_idx on road_network_partitioned2_34 a_34 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
656. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_35_link_id_street_name_road_km_ro_idx on road_network_partitioned2_35 a_35 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
657. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_36_link_id_street_name_road_km_ro_idx on road_network_partitioned2_36 a_36 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
658. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_37_link_id_street_name_road_km_ro_idx on road_network_partitioned2_37 a_37 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
659. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_38_link_id_street_name_road_km_ro_idx on road_network_partitioned2_38 a_38 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
660. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_39_link_id_street_name_road_km_ro_idx on road_network_partitioned2_39 a_39 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
661. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_40_link_id_street_name_road_km_ro_idx on road_network_partitioned2_40 a_40 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
662. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_41_link_id_street_name_road_km_ro_idx on road_network_partitioned2_41 a_41 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
663. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_42_link_id_street_name_road_km_ro_idx on road_network_partitioned2_42 a_42 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
664. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_43_link_id_street_name_road_km_ro_idx on road_network_partitioned2_43 a_43 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
665. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_44_link_id_street_name_road_km_ro_idx on road_network_partitioned2_44 a_44 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
666. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_45_link_id_street_name_road_km_ro_idx on road_network_partitioned2_45 a_45 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
667. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_46_link_id_street_name_road_km_ro_idx on road_network_partitioned2_46 a_46 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
668. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_47_link_id_street_name_road_km_ro_idx on road_network_partitioned2_47 a_47 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
669. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_48_link_id_street_name_road_km_ro_idx on road_network_partitioned2_48 a_48 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
670. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_49_link_id_street_name_road_km_ro_idx on road_network_partitioned2_49 a_49 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
671. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_50_link_id_street_name_road_km_ro_idx on road_network_partitioned2_50 a_50 (cost=0.14..17.02 rows=29 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Heap Fetches: 0
672. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_51_link_id_street_name_road_km_ro_idx on road_network_partitioned2_51 a_51 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
673. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_52_link_id_street_name_road_km_ro_idx on road_network_partitioned2_52 a_52 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
674. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_53_link_id_street_name_road_km_ro_idx on road_network_partitioned2_53 a_53 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
675. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_54_link_id_street_name_road_km_ro_idx on road_network_partitioned2_54 a_54 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
676. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_55_link_id_street_name_road_km_ro_idx on road_network_partitioned2_55 a_55 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
677. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_56_link_id_street_name_road_km_ro_idx on road_network_partitioned2_56 a_56 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
678. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_57_link_id_street_name_road_km_ro_idx on road_network_partitioned2_57 a_57 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
679. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_58_link_id_street_name_road_km_ro_idx on road_network_partitioned2_58 a_58 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
680. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_59_link_id_street_name_road_km_ro_idx on road_network_partitioned2_59 a_59 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
681. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_60_link_id_street_name_road_km_ro_idx on road_network_partitioned2_60 a_60 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
682. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_61_link_id_street_name_road_km_ro_idx on road_network_partitioned2_61 a_61 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
683. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_62_link_id_street_name_road_km_ro_idx on road_network_partitioned2_62 a_62 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
684. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_63_link_id_street_name_road_km_ro_idx on road_network_partitioned2_63 a_63 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
685. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_64_link_id_street_name_road_km_ro_idx on road_network_partitioned2_64 a_64 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
686. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_65_link_id_street_name_road_km_ro_idx on road_network_partitioned2_65 a_65 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
687. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_66_link_id_street_name_road_km_ro_idx on road_network_partitioned2_66 a_66 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
688. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_67_link_id_street_name_road_km_ro_idx on road_network_partitioned2_67 a_67 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
689. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_68_link_id_street_name_road_km_ro_idx on road_network_partitioned2_68 a_68 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
690. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_69_link_id_street_name_road_km_ro_idx on road_network_partitioned2_69 a_69 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
691. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_70_link_id_street_name_road_km_ro_idx on road_network_partitioned2_70 a_70 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
692. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_71_link_id_street_name_road_km_ro_idx on road_network_partitioned2_71 a_71 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
693. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_73_link_id_street_name_road_km_ro_idx on road_network_partitioned2_73 a_73 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
694. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_74_link_id_street_name_road_km_ro_idx on road_network_partitioned2_74 a_74 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
695. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_75_link_id_street_name_road_km_ro_idx on road_network_partitioned2_75 a_75 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
696. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_76_link_id_street_name_road_km_ro_idx on road_network_partitioned2_76 a_76 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
697. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_77_link_id_street_name_road_km_ro_idx on road_network_partitioned2_77 a_77 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
698. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_78_link_id_street_name_road_km_ro_idx on road_network_partitioned2_78 a_78 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
699. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_79_link_id_street_name_road_km_ro_idx on road_network_partitioned2_79 a_79 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
700. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_80_link_id_street_name_road_km_ro_idx on road_network_partitioned2_80 a_80 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
701. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_81_link_id_street_name_road_km_ro_idx on road_network_partitioned2_81 a_81 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
702. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_82_link_id_street_name_road_km_ro_idx on road_network_partitioned2_82 a_82 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
703. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_83_link_id_street_name_road_km_ro_idx on road_network_partitioned2_83 a_83 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
704. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_84_link_id_street_name_road_km_ro_idx on road_network_partitioned2_84 a_84 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.003 rows=0 loops=1)

  • Heap Fetches: 0
705. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_85_link_id_street_name_road_km_ro_idx on road_network_partitioned2_85 a_85 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
706. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_86_link_id_street_name_road_km_ro_idx on road_network_partitioned2_86 a_86 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
707. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_87_link_id_street_name_road_km_ro_idx on road_network_partitioned2_87 a_87 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
708. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_88_link_id_street_name_road_km_ro_idx on road_network_partitioned2_88 a_88 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
709. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_89_link_id_street_name_road_km_ro_idx on road_network_partitioned2_89 a_89 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
710. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_90_link_id_street_name_road_km_ro_idx on road_network_partitioned2_90 a_90 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
711. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_91_link_id_street_name_road_km_ro_idx on road_network_partitioned2_91 a_91 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
712. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_92_link_id_street_name_road_km_ro_idx on road_network_partitioned2_92 a_92 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
713. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_93_link_id_street_name_road_km_ro_idx on road_network_partitioned2_93 a_93 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
714. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_94_link_id_street_name_road_km_ro_idx on road_network_partitioned2_94 a_94 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
715. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_95_link_id_street_name_road_km_ro_idx on road_network_partitioned2_95 a_95 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
716. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_96_link_id_street_name_road_km_ro_idx on road_network_partitioned2_96 a_96 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
717. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_97_link_id_street_name_road_km_ro_idx on road_network_partitioned2_97 a_97 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
718. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_98_link_id_street_name_road_km_ro_idx on road_network_partitioned2_98 a_98 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0
719. 0.001 0.001 ↓ 0.0 0 1 / 4

Parallel Index Only Scan using road_network_partitioned2_99_link_id_street_name_road_km_ro_idx on road_network_partitioned2_99 a_99 (cost=0.14..17.02 rows=29 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Heap Fetches: 0