explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8k8r

Settings
# exclusive inclusive rows x rows loops node
1. 149.306 10,064.377 ↓ 8.7 120,509 1

Merge Join (cost=282.48..109,304.94 rows=13,793 width=36) (actual time=4,944.679..10,064.377 rows=120,509 loops=1)

  • Merge Cond: ((road_network_partitioned2_cell_1386.lon = road_network_partitioned3_cell_1426.lon) AND (road_network_partitioned2_cell_1386.lat = road_network_partitioned3_cell_1426.lat) AND (road_network_partitioned2_cell_1386.link_id = road_network_partitioned3_cell_1426.link_id))
  • Functions: 3002
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 247.751 ms, Inlining 0.000 ms, Optimization 128.557 ms, Emission 1973.098 ms, Total 2349.406 ms
2. 60.369 7,309.308 ↑ 1.1 871,109 1

Append (cost=269.23..89,446.37 rows=915,218 width=36) (actual time=2,149.160..7,309.308 rows=871,109 loops=1)

3. 0.003 0.112 ↓ 0.0 0 1

Merge Append (cost=5.62..456.87 rows=1,700 width=230) (actual time=0.111..0.112 rows=0 loops=1)

  • Sort Key: road_network_partitioned2_cell_1386.lon, road_network_partitioned2_cell_1386.lat, road_network_partitioned2_cell_1386.link_id
4. 0.009 0.009 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1386_pkey on road_network_partitioned2_cell_1386 (cost=0.14..11.89 rows=50 width=230) (actual time=0.009..0.009 rows=0 loops=1)

5. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1344_pkey on road_network_partitioned2_cell_1344 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

6. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1302_pkey on road_network_partitioned2_cell_1302 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

7. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1260_pkey on road_network_partitioned2_cell_1260 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

8. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1218_pkey on road_network_partitioned2_cell_1218 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

9. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1176_pkey on road_network_partitioned2_cell_1176 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

10. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1134_pkey on road_network_partitioned2_cell_1134 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.004 rows=0 loops=1)

11. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1092_pkey on road_network_partitioned2_cell_1092 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

12. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1050_pkey on road_network_partitioned2_cell_1050 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

13. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1008_pkey on road_network_partitioned2_cell_1008 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

14. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_966_pkey on road_network_partitioned2_cell_966 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

15. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_924_pkey on road_network_partitioned2_cell_924 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

16. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_882_pkey on road_network_partitioned2_cell_882 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

17. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_840_pkey on road_network_partitioned2_cell_840 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

18. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_798_pkey on road_network_partitioned2_cell_798 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

19. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_756_pkey on road_network_partitioned2_cell_756 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

20. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_714_pkey on road_network_partitioned2_cell_714 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

21. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_672_pkey on road_network_partitioned2_cell_672 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

22. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_630_pkey on road_network_partitioned2_cell_630 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

23. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_588_pkey on road_network_partitioned2_cell_588 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

24. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_546_pkey on road_network_partitioned2_cell_546 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

25. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_504_pkey on road_network_partitioned2_cell_504 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

26. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_462_pkey on road_network_partitioned2_cell_462 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

27. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_420_pkey on road_network_partitioned2_cell_420 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

28. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_378_pkey on road_network_partitioned2_cell_378 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

29. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_336_pkey on road_network_partitioned2_cell_336 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

30. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_294_pkey on road_network_partitioned2_cell_294 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

31. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_252_pkey on road_network_partitioned2_cell_252 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

32. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_210_pkey on road_network_partitioned2_cell_210 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

33. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_168_pkey on road_network_partitioned2_cell_168 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

34. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_126_pkey on road_network_partitioned2_cell_126 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

35. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_84_pkey on road_network_partitioned2_cell_84 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

36. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_42_pkey on road_network_partitioned2_cell_42 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

37. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_0_pkey on road_network_partitioned2_cell_0 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

38. 0.047 2,149.247 ↑ 5.3 362 1

Merge Append (cost=5.63..462.05 rows=1,902 width=198) (actual time=2,149.047..2,149.247 rows=362 loops=1)

  • Sort Key: road_network_partitioned2_cell_1387.lon, road_network_partitioned2_cell_1387.lat, road_network_partitioned2_cell_1387.link_id
39. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1387_pkey on road_network_partitioned2_cell_1387 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

40. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1345_pkey on road_network_partitioned2_cell_1345 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

41. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1303_pkey on road_network_partitioned2_cell_1303 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

42. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1261_pkey on road_network_partitioned2_cell_1261 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

43. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1219_pkey on road_network_partitioned2_cell_1219 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

44. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1177_pkey on road_network_partitioned2_cell_1177 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

45. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1135_pkey on road_network_partitioned2_cell_1135 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

46. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1093_pkey on road_network_partitioned2_cell_1093 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

47. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1051_pkey on road_network_partitioned2_cell_1051 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

48. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1009_pkey on road_network_partitioned2_cell_1009 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

49. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_967_pkey on road_network_partitioned2_cell_967 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

50. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_925_pkey on road_network_partitioned2_cell_925 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

51. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_883_pkey on road_network_partitioned2_cell_883 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

52. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_841_pkey on road_network_partitioned2_cell_841 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

53. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_799_pkey on road_network_partitioned2_cell_799 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

54. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_757_pkey on road_network_partitioned2_cell_757 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

55. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_715_pkey on road_network_partitioned2_cell_715 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

56. 2,148.822 2,148.822 ↑ 1.4 36 1

Index Scan using road_network_partitioned2_cell_673_pkey on road_network_partitioned2_cell_673 (cost=0.14..12.89 rows=50 width=230) (actual time=2,148.804..2,148.822 rows=36 loops=1)

57. 0.151 0.151 ↑ 1.0 68 1

Index Scan using road_network_partitioned2_cell_631_pkey on road_network_partitioned2_cell_631 (cost=0.14..7.16 rows=68 width=29) (actual time=0.121..0.151 rows=68 loops=1)

58. 0.114 0.114 ↑ 1.0 234 1

Index Scan using road_network_partitioned2_cell_589_pkey on road_network_partitioned2_cell_589 (cost=0.14..12.65 rows=234 width=28) (actual time=0.010..0.114 rows=234 loops=1)

59. 0.016 0.016 ↑ 2.8 18 1

Index Scan using road_network_partitioned2_cell_547_pkey on road_network_partitioned2_cell_547 (cost=0.14..12.89 rows=50 width=230) (actual time=0.008..0.016 rows=18 loops=1)

60. 0.009 0.009 ↑ 8.3 6 1

Index Scan using road_network_partitioned2_cell_505_pkey on road_network_partitioned2_cell_505 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.009 rows=6 loops=1)

61. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_463_pkey on road_network_partitioned2_cell_463 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

62. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_421_pkey on road_network_partitioned2_cell_421 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

63. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_379_pkey on road_network_partitioned2_cell_379 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

64. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_337_pkey on road_network_partitioned2_cell_337 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

65. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_295_pkey on road_network_partitioned2_cell_295 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

66. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_253_pkey on road_network_partitioned2_cell_253 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

67. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_211_pkey on road_network_partitioned2_cell_211 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

68. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_169_pkey on road_network_partitioned2_cell_169 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

69. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_127_pkey on road_network_partitioned2_cell_127 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

70. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_85_pkey on road_network_partitioned2_cell_85 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

71. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_43_pkey on road_network_partitioned2_cell_43 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

72. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1_pkey on road_network_partitioned2_cell_1 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

73. 0.329 2.085 ↑ 1.4 3,070 1

Merge Append (cost=5.79..631.98 rows=4,362 width=90) (actual time=0.176..2.085 rows=3,070 loops=1)

  • Sort Key: road_network_partitioned2_cell_1388.lon, road_network_partitioned2_cell_1388.lat, road_network_partitioned2_cell_1388.link_id
74. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1388_pkey on road_network_partitioned2_cell_1388 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

75. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1346_pkey on road_network_partitioned2_cell_1346 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

76. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1304_pkey on road_network_partitioned2_cell_1304 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

77. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1262_pkey on road_network_partitioned2_cell_1262 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

78. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1220_pkey on road_network_partitioned2_cell_1220 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

79. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1178_pkey on road_network_partitioned2_cell_1178 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

80. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1136_pkey on road_network_partitioned2_cell_1136 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

81. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1094_pkey on road_network_partitioned2_cell_1094 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

82. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1052_pkey on road_network_partitioned2_cell_1052 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

83. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1010_pkey on road_network_partitioned2_cell_1010 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

84. 0.009 0.009 ↑ 12.5 4 1

Index Scan using road_network_partitioned2_cell_968_pkey on road_network_partitioned2_cell_968 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.009 rows=4 loops=1)

85. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_926_pkey on road_network_partitioned2_cell_926 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

86. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_884_pkey on road_network_partitioned2_cell_884 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

87. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_842_pkey on road_network_partitioned2_cell_842 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

88. 0.100 0.100 ↑ 1.0 203 1

Index Scan using road_network_partitioned2_cell_800_pkey on road_network_partitioned2_cell_800 (cost=0.14..11.19 rows=203 width=24) (actual time=0.008..0.100 rows=203 loops=1)

89. 1.176 1.176 ↑ 1.0 2,132 1

Index Scan using road_network_partitioned2_cell_758_pkey on road_network_partitioned2_cell_758 (cost=0.28..111.26 rows=2,132 width=27) (actual time=0.010..1.176 rows=2,132 loops=1)

90. 0.132 0.132 ↑ 1.0 250 1

Index Scan using road_network_partitioned2_cell_716_pkey on road_network_partitioned2_cell_716 (cost=0.14..16.89 rows=250 width=29) (actual time=0.011..0.132 rows=250 loops=1)

91. 0.074 0.074 ↑ 1.0 137 1

Index Scan using road_network_partitioned2_cell_674_pkey on road_network_partitioned2_cell_674 (cost=0.14..12.20 rows=137 width=30) (actual time=0.008..0.074 rows=137 loops=1)

92. 0.020 0.020 ↑ 1.4 37 1

Index Scan using road_network_partitioned2_cell_632_pkey on road_network_partitioned2_cell_632 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.020 rows=37 loops=1)

93. 0.021 0.021 ↑ 2.9 17 1

Index Scan using road_network_partitioned2_cell_590_pkey on road_network_partitioned2_cell_590 (cost=0.14..12.89 rows=50 width=230) (actual time=0.016..0.021 rows=17 loops=1)

94. 0.059 0.059 ↑ 1.0 103 1

Index Scan using road_network_partitioned2_cell_548_pkey on road_network_partitioned2_cell_548 (cost=0.14..8.69 rows=103 width=33) (actual time=0.010..0.059 rows=103 loops=1)

95. 0.068 0.068 ↑ 1.0 135 1

Index Scan using road_network_partitioned2_cell_506_pkey on road_network_partitioned2_cell_506 (cost=0.14..9.17 rows=135 width=30) (actual time=0.009..0.068 rows=135 loops=1)

96. 0.024 0.024 ↑ 1.0 52 1

Index Scan using road_network_partitioned2_cell_464_pkey on road_network_partitioned2_cell_464 (cost=0.14..4.92 rows=52 width=22) (actual time=0.007..0.024 rows=52 loops=1)

97. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_422_pkey on road_network_partitioned2_cell_422 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

98. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_380_pkey on road_network_partitioned2_cell_380 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

99. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_338_pkey on road_network_partitioned2_cell_338 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

100. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_296_pkey on road_network_partitioned2_cell_296 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

101. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_254_pkey on road_network_partitioned2_cell_254 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

102. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_212_pkey on road_network_partitioned2_cell_212 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

103. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_170_pkey on road_network_partitioned2_cell_170 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

104. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_128_pkey on road_network_partitioned2_cell_128 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

105. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_86_pkey on road_network_partitioned2_cell_86 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

106. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_44_pkey on road_network_partitioned2_cell_44 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

107. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_2_pkey on road_network_partitioned2_cell_2 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

108. 4.359 29.140 ↑ 1.0 40,766 1

Merge Append (cost=6.61..3,517.34 rows=41,942 width=30) (actual time=0.180..29.140 rows=40,766 loops=1)

  • Sort Key: road_network_partitioned2_cell_1389.lon, road_network_partitioned2_cell_1389.lat, road_network_partitioned2_cell_1389.link_id
109. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1389_pkey on road_network_partitioned2_cell_1389 (cost=0.14..11.89 rows=50 width=230) (actual time=0.005..0.005 rows=0 loops=1)

110. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1347_pkey on road_network_partitioned2_cell_1347 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

111. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1305_pkey on road_network_partitioned2_cell_1305 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

112. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1263_pkey on road_network_partitioned2_cell_1263 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

113. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1221_pkey on road_network_partitioned2_cell_1221 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

114. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1179_pkey on road_network_partitioned2_cell_1179 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

115. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1137_pkey on road_network_partitioned2_cell_1137 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

116. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1095_pkey on road_network_partitioned2_cell_1095 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

117. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1053_pkey on road_network_partitioned2_cell_1053 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

118. 1.012 1.012 ↑ 1.0 1,818 1

Index Scan using road_network_partitioned2_cell_1011_pkey on road_network_partitioned2_cell_1011 (cost=0.28..100.55 rows=1,818 width=23) (actual time=0.013..1.012 rows=1,818 loops=1)

119. 4.970 4.970 ↑ 1.0 8,385 1

Index Scan using road_network_partitioned2_cell_969_pkey on road_network_partitioned2_cell_969 (cost=0.29..431.06 rows=8,385 width=24) (actual time=0.012..4.970 rows=8,385 loops=1)

120. 7.222 7.222 ↑ 1.0 12,507 1

Index Scan using road_network_partitioned2_cell_927_pkey on road_network_partitioned2_cell_927 (cost=0.29..547.89 rows=12,507 width=23) (actual time=0.010..7.222 rows=12,507 loops=1)

121. 9.368 9.368 ↑ 1.0 14,804 1

Index Scan using road_network_partitioned2_cell_885_pkey on road_network_partitioned2_cell_885 (cost=0.29..639.34 rows=14,804 width=24) (actual time=0.009..9.368 rows=14,804 loops=1)

122. 0.635 0.635 ↑ 1.0 1,093 1

Index Scan using road_network_partitioned2_cell_843_pkey on road_network_partitioned2_cell_843 (cost=0.28..75.67 rows=1,093 width=24) (actual time=0.011..0.635 rows=1,093 loops=1)

123. 0.829 0.829 ↑ 1.0 1,265 1

Index Scan using road_network_partitioned2_cell_801_pkey on road_network_partitioned2_cell_801 (cost=0.28..88.25 rows=1,265 width=26) (actual time=0.011..0.829 rows=1,265 loops=1)

124. 0.521 0.521 ↑ 1.0 657 1

Index Scan using road_network_partitioned2_cell_759_pkey on road_network_partitioned2_cell_759 (cost=0.28..42.13 rows=657 width=27) (actual time=0.010..0.521 rows=657 loops=1)

125. 0.009 0.009 ↑ 6.2 8 1

Index Scan using road_network_partitioned2_cell_717_pkey on road_network_partitioned2_cell_717 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.009 rows=8 loops=1)

126. 0.029 0.029 ↑ 1.4 36 1

Index Scan using road_network_partitioned2_cell_675_pkey on road_network_partitioned2_cell_675 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.029 rows=36 loops=1)

127. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_633_pkey on road_network_partitioned2_cell_633 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

128. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_591_pkey on road_network_partitioned2_cell_591 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

129. 0.022 0.022 ↑ 1.7 30 1

Index Scan using road_network_partitioned2_cell_549_pkey on road_network_partitioned2_cell_549 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.022 rows=30 loops=1)

130. 0.053 0.053 ↑ 1.0 92 1

Index Scan using road_network_partitioned2_cell_507_pkey on road_network_partitioned2_cell_507 (cost=0.14..8.52 rows=92 width=34) (actual time=0.007..0.053 rows=92 loops=1)

131. 0.047 0.047 ↑ 1.0 71 1

Index Scan using road_network_partitioned2_cell_465_pkey on road_network_partitioned2_cell_465 (cost=0.14..6.21 rows=71 width=29) (actual time=0.008..0.047 rows=71 loops=1)

132. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_423_pkey on road_network_partitioned2_cell_423 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

133. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_381_pkey on road_network_partitioned2_cell_381 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

134. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_339_pkey on road_network_partitioned2_cell_339 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

135. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_297_pkey on road_network_partitioned2_cell_297 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

136. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_255_pkey on road_network_partitioned2_cell_255 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

137. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_213_pkey on road_network_partitioned2_cell_213 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

138. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_171_pkey on road_network_partitioned2_cell_171 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

139. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_129_pkey on road_network_partitioned2_cell_129 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

140. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_87_pkey on road_network_partitioned2_cell_87 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

141. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_45_pkey on road_network_partitioned2_cell_45 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

142. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_3_pkey on road_network_partitioned2_cell_3 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

143. 2.848 18.467 ↑ 1.0 26,648 1

Merge Append (cost=6.48..2,558.78 rows=27,803 width=35) (actual time=0.213..18.467 rows=26,648 loops=1)

  • Sort Key: road_network_partitioned2_cell_1390.lon, road_network_partitioned2_cell_1390.lat, road_network_partitioned2_cell_1390.link_id
144. 0.007 0.007 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1390_pkey on road_network_partitioned2_cell_1390 (cost=0.14..11.89 rows=50 width=230) (actual time=0.007..0.007 rows=0 loops=1)

145. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1348_pkey on road_network_partitioned2_cell_1348 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

146. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1306_pkey on road_network_partitioned2_cell_1306 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

147. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1264_pkey on road_network_partitioned2_cell_1264 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

148. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1222_pkey on road_network_partitioned2_cell_1222 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

149. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1180_pkey on road_network_partitioned2_cell_1180 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

150. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1138_pkey on road_network_partitioned2_cell_1138 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

151. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1096_pkey on road_network_partitioned2_cell_1096 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

152. 0.024 0.024 ↑ 3.6 14 1

Index Scan using road_network_partitioned2_cell_1054_pkey on road_network_partitioned2_cell_1054 (cost=0.14..12.89 rows=50 width=230) (actual time=0.020..0.024 rows=14 loops=1)

153. 2.822 2.822 ↑ 1.0 4,979 1

Index Scan using road_network_partitioned2_cell_1012_pkey on road_network_partitioned2_cell_1012 (cost=0.28..276.97 rows=4,979 width=25) (actual time=0.013..2.822 rows=4,979 loops=1)

154. 2.965 2.965 ↑ 1.0 5,068 1

Index Scan using road_network_partitioned2_cell_970_pkey on road_network_partitioned2_cell_970 (cost=0.28..285.30 rows=5,068 width=26) (actual time=0.017..2.965 rows=5,068 loops=1)

155. 2.906 2.906 ↑ 1.0 4,905 1

Index Scan using road_network_partitioned2_cell_928_pkey on road_network_partitioned2_cell_928 (cost=0.28..262.86 rows=4,905 width=25) (actual time=0.010..2.906 rows=4,905 loops=1)

156. 4.825 4.825 ↑ 1.0 8,032 1

Index Scan using road_network_partitioned2_cell_886_pkey on road_network_partitioned2_cell_886 (cost=0.28..385.76 rows=8,032 width=26) (actual time=0.010..4.825 rows=8,032 loops=1)

157. 1.151 1.151 ↑ 1.0 2,099 1

Index Scan using road_network_partitioned2_cell_844_pkey on road_network_partitioned2_cell_844 (cost=0.28..107.77 rows=2,099 width=27) (actual time=0.011..1.151 rows=2,099 loops=1)

158. 0.572 0.572 ↑ 1.0 1,038 1

Index Scan using road_network_partitioned2_cell_802_pkey on road_network_partitioned2_cell_802 (cost=0.28..62.85 rows=1,038 width=25) (actual time=0.012..0.572 rows=1,038 loops=1)

159. 0.084 0.084 ↑ 1.0 148 1

Index Scan using road_network_partitioned2_cell_760_pkey on road_network_partitioned2_cell_760 (cost=0.14..14.37 rows=148 width=29) (actual time=0.008..0.084 rows=148 loops=1)

160. 0.040 0.040 ↑ 1.0 55 1

Index Scan using road_network_partitioned2_cell_718_pkey on road_network_partitioned2_cell_718 (cost=0.14..9.97 rows=55 width=31) (actual time=0.008..0.040 rows=55 loops=1)

161. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_676_pkey on road_network_partitioned2_cell_676 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

162. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_634_pkey on road_network_partitioned2_cell_634 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

163. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_592_pkey on road_network_partitioned2_cell_592 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

164. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_550_pkey on road_network_partitioned2_cell_550 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

165. 0.020 0.020 ↑ 1.6 31 1

Index Scan using road_network_partitioned2_cell_508_pkey on road_network_partitioned2_cell_508 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.020 rows=31 loops=1)

166. 0.034 0.034 ↑ 1.0 58 1

Index Scan using road_network_partitioned2_cell_466_pkey on road_network_partitioned2_cell_466 (cost=0.14..6.01 rows=58 width=31) (actual time=0.008..0.034 rows=58 loops=1)

167. 0.105 0.105 ↑ 1.0 221 1

Index Scan using road_network_partitioned2_cell_424_pkey on road_network_partitioned2_cell_424 (cost=0.14..12.46 rows=221 width=26) (actual time=0.010..0.105 rows=221 loops=1)

168. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_382_pkey on road_network_partitioned2_cell_382 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

169. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_340_pkey on road_network_partitioned2_cell_340 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

170. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_298_pkey on road_network_partitioned2_cell_298 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

171. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_256_pkey on road_network_partitioned2_cell_256 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

172. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_214_pkey on road_network_partitioned2_cell_214 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

173. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_172_pkey on road_network_partitioned2_cell_172 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

174. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_130_pkey on road_network_partitioned2_cell_130 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

175. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_88_pkey on road_network_partitioned2_cell_88 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

176. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_46_pkey on road_network_partitioned2_cell_46 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

177. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_4_pkey on road_network_partitioned2_cell_4 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

178. 1.955 12.561 ↑ 1.1 18,074 1

Merge Append (cost=6.48..1,823.65 rows=19,151 width=38) (actual time=0.213..12.561 rows=18,074 loops=1)

  • Sort Key: road_network_partitioned2_cell_1391.lon, road_network_partitioned2_cell_1391.lat, road_network_partitioned2_cell_1391.link_id
179. 0.007 0.007 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1391_pkey on road_network_partitioned2_cell_1391 (cost=0.14..11.89 rows=50 width=230) (actual time=0.007..0.007 rows=0 loops=1)

180. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1349_pkey on road_network_partitioned2_cell_1349 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

181. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1307_pkey on road_network_partitioned2_cell_1307 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

182. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1265_pkey on road_network_partitioned2_cell_1265 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

183. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1223_pkey on road_network_partitioned2_cell_1223 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

184. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1181_pkey on road_network_partitioned2_cell_1181 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

185. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1139_pkey on road_network_partitioned2_cell_1139 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

186. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1097_pkey on road_network_partitioned2_cell_1097 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

187. 0.455 0.455 ↑ 1.0 764 1

Index Scan using road_network_partitioned2_cell_1055_pkey on road_network_partitioned2_cell_1055 (cost=0.28..38.73 rows=764 width=25) (actual time=0.021..0.455 rows=764 loops=1)

188. 2.854 2.854 ↑ 1.0 4,567 1

Index Scan using road_network_partitioned2_cell_1013_pkey on road_network_partitioned2_cell_1013 (cost=0.28..237.79 rows=4,567 width=25) (actual time=0.013..2.854 rows=4,567 loops=1)

189. 2.048 2.048 ↑ 1.0 3,648 1

Index Scan using road_network_partitioned2_cell_971_pkey on road_network_partitioned2_cell_971 (cost=0.28..196.00 rows=3,648 width=25) (actual time=0.010..2.048 rows=3,648 loops=1)

190. 2.074 2.074 ↑ 1.0 3,543 1

Index Scan using road_network_partitioned2_cell_929_pkey on road_network_partitioned2_cell_929 (cost=0.28..185.43 rows=3,543 width=26) (actual time=0.018..2.074 rows=3,543 loops=1)

191. 1.889 1.889 ↑ 1.0 3,333 1

Index Scan using road_network_partitioned2_cell_887_pkey on road_network_partitioned2_cell_887 (cost=0.28..179.28 rows=3,333 width=27) (actual time=0.009..1.889 rows=3,333 loops=1)

192. 0.808 0.808 ↑ 1.0 1,457 1

Index Scan using road_network_partitioned2_cell_845_pkey on road_network_partitioned2_cell_845 (cost=0.28..79.13 rows=1,457 width=27) (actual time=0.009..0.808 rows=1,457 loops=1)

193. 0.044 0.044 ↑ 1.0 73 1

Index Scan using road_network_partitioned2_cell_803_pkey on road_network_partitioned2_cell_803 (cost=0.14..8.24 rows=73 width=28) (actual time=0.008..0.044 rows=73 loops=1)

194. 0.089 0.089 ↑ 1.0 166 1

Index Scan using road_network_partitioned2_cell_761_pkey on road_network_partitioned2_cell_761 (cost=0.14..15.63 rows=166 width=31) (actual time=0.010..0.089 rows=166 loops=1)

195. 0.074 0.074 ↑ 1.0 143 1

Index Scan using road_network_partitioned2_cell_719_pkey on road_network_partitioned2_cell_719 (cost=0.14..10.29 rows=143 width=28) (actual time=0.009..0.074 rows=143 loops=1)

196. 0.017 0.017 ↑ 2.2 23 1

Index Scan using road_network_partitioned2_cell_677_pkey on road_network_partitioned2_cell_677 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.017 rows=23 loops=1)

197. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_635_pkey on road_network_partitioned2_cell_635 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

198. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_593_pkey on road_network_partitioned2_cell_593 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

199. 0.047 0.047 ↑ 1.0 83 1

Index Scan using road_network_partitioned2_cell_551_pkey on road_network_partitioned2_cell_551 (cost=0.14..6.39 rows=83 width=25) (actual time=0.008..0.047 rows=83 loops=1)

200. 0.061 0.061 ↑ 1.0 113 1

Index Scan using road_network_partitioned2_cell_509_pkey on road_network_partitioned2_cell_509 (cost=0.14..9.84 rows=113 width=29) (actual time=0.007..0.061 rows=113 loops=1)

201. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_467_pkey on road_network_partitioned2_cell_467 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

202. 0.080 0.080 ↑ 1.0 161 1

Index Scan using road_network_partitioned2_cell_425_pkey on road_network_partitioned2_cell_425 (cost=0.14..10.56 rows=161 width=32) (actual time=0.008..0.080 rows=161 loops=1)

203. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_383_pkey on road_network_partitioned2_cell_383 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

204. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_341_pkey on road_network_partitioned2_cell_341 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

205. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_299_pkey on road_network_partitioned2_cell_299 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

206. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_257_pkey on road_network_partitioned2_cell_257 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

207. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_215_pkey on road_network_partitioned2_cell_215 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

208. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_173_pkey on road_network_partitioned2_cell_173 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

209. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_131_pkey on road_network_partitioned2_cell_131 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

210. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_89_pkey on road_network_partitioned2_cell_89 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

211. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_47_pkey on road_network_partitioned2_cell_47 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

212. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_5_pkey on road_network_partitioned2_cell_5 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

213. 0.831 5.224 ↑ 1.1 7,795 1

Merge Append (cost=6.46..1,020.58 rows=8,960 width=54) (actual time=0.198..5.224 rows=7,795 loops=1)

  • Sort Key: road_network_partitioned2_cell_1392.lon, road_network_partitioned2_cell_1392.lat, road_network_partitioned2_cell_1392.link_id
214. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1392_pkey on road_network_partitioned2_cell_1392 (cost=0.14..11.89 rows=50 width=230) (actual time=0.005..0.005 rows=0 loops=1)

215. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1350_pkey on road_network_partitioned2_cell_1350 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

216. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1308_pkey on road_network_partitioned2_cell_1308 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

217. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1266_pkey on road_network_partitioned2_cell_1266 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

218. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1224_pkey on road_network_partitioned2_cell_1224 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

219. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1182_pkey on road_network_partitioned2_cell_1182 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

220. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1140_pkey on road_network_partitioned2_cell_1140 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

221. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1098_pkey on road_network_partitioned2_cell_1098 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

222. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1056_pkey on road_network_partitioned2_cell_1056 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

223. 0.765 0.765 ↑ 1.0 1,358 1

Index Scan using road_network_partitioned2_cell_1014_pkey on road_network_partitioned2_cell_1014 (cost=0.28..84.65 rows=1,358 width=26) (actual time=0.015..0.765 rows=1,358 loops=1)

224. 0.783 0.783 ↑ 1.0 1,411 1

Index Scan using road_network_partitioned2_cell_972_pkey on road_network_partitioned2_cell_972 (cost=0.28..76.44 rows=1,411 width=26) (actual time=0.011..0.783 rows=1,411 loops=1)

225. 0.826 0.826 ↑ 1.0 1,472 1

Index Scan using road_network_partitioned2_cell_930_pkey on road_network_partitioned2_cell_930 (cost=0.28..80.36 rows=1,472 width=26) (actual time=0.015..0.826 rows=1,472 loops=1)

226. 1.084 1.084 ↑ 1.0 1,972 1

Index Scan using road_network_partitioned2_cell_888_pkey on road_network_partitioned2_cell_888 (cost=0.28..102.86 rows=1,972 width=26) (actual time=0.011..1.084 rows=1,972 loops=1)

227. 0.299 0.299 ↑ 1.0 527 1

Index Scan using road_network_partitioned2_cell_846_pkey on road_network_partitioned2_cell_846 (cost=0.28..34.18 rows=527 width=27) (actual time=0.010..0.299 rows=527 loops=1)

228. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_804_pkey on road_network_partitioned2_cell_804 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

229. 0.027 0.027 ↑ 1.0 52 1

Index Scan using road_network_partitioned2_cell_762_pkey on road_network_partitioned2_cell_762 (cost=0.14..5.92 rows=52 width=38) (actual time=0.007..0.027 rows=52 loops=1)

230. 0.009 0.009 ↑ 4.2 12 1

Index Scan using road_network_partitioned2_cell_720_pkey on road_network_partitioned2_cell_720 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.009 rows=12 loops=1)

231. 0.072 0.072 ↑ 1.0 141 1

Index Scan using road_network_partitioned2_cell_678_pkey on road_network_partitioned2_cell_678 (cost=0.14..10.26 rows=141 width=31) (actual time=0.008..0.072 rows=141 loops=1)

232. 0.008 0.008 ↑ 6.2 8 1

Index Scan using road_network_partitioned2_cell_636_pkey on road_network_partitioned2_cell_636 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.008 rows=8 loops=1)

233. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_594_pkey on road_network_partitioned2_cell_594 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

234. 0.010 0.010 ↑ 3.3 15 1

Index Scan using road_network_partitioned2_cell_552_pkey on road_network_partitioned2_cell_552 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.010 rows=15 loops=1)

235. 0.118 0.118 ↑ 1.0 215 1

Index Scan using road_network_partitioned2_cell_510_pkey on road_network_partitioned2_cell_510 (cost=0.14..26.37 rows=215 width=28) (actual time=0.010..0.118 rows=215 loops=1)

236. 0.052 0.052 ↑ 1.0 93 1

Index Scan using road_network_partitioned2_cell_468_pkey on road_network_partitioned2_cell_468 (cost=0.14..8.54 rows=93 width=31) (actual time=0.008..0.052 rows=93 loops=1)

237. 0.275 0.275 ↑ 1.0 519 1

Index Scan using road_network_partitioned2_cell_426_pkey on road_network_partitioned2_cell_426 (cost=0.28..29.06 rows=519 width=28) (actual time=0.011..0.275 rows=519 loops=1)

238. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_384_pkey on road_network_partitioned2_cell_384 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

239. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_342_pkey on road_network_partitioned2_cell_342 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

240. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_300_pkey on road_network_partitioned2_cell_300 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.004 rows=0 loops=1)

241. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_258_pkey on road_network_partitioned2_cell_258 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

242. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_216_pkey on road_network_partitioned2_cell_216 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

243. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_174_pkey on road_network_partitioned2_cell_174 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

244. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_132_pkey on road_network_partitioned2_cell_132 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

245. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_90_pkey on road_network_partitioned2_cell_90 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

246. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_48_pkey on road_network_partitioned2_cell_48 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

247. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_6_pkey on road_network_partitioned2_cell_6 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

248. 0.306 1.946 ↑ 1.4 2,876 1

Merge Append (cost=6.05..594.80 rows=3,934 width=87) (actual time=0.201..1.946 rows=2,876 loops=1)

  • Sort Key: road_network_partitioned2_cell_1393.lon, road_network_partitioned2_cell_1393.lat, road_network_partitioned2_cell_1393.link_id
249. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1393_pkey on road_network_partitioned2_cell_1393 (cost=0.14..11.89 rows=50 width=230) (actual time=0.005..0.005 rows=0 loops=1)

250. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1351_pkey on road_network_partitioned2_cell_1351 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

251. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1309_pkey on road_network_partitioned2_cell_1309 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

252. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1267_pkey on road_network_partitioned2_cell_1267 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

253. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1225_pkey on road_network_partitioned2_cell_1225 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

254. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1183_pkey on road_network_partitioned2_cell_1183 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

255. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1141_pkey on road_network_partitioned2_cell_1141 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

256. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1099_pkey on road_network_partitioned2_cell_1099 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

257. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1057_pkey on road_network_partitioned2_cell_1057 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

258. 0.116 0.116 ↑ 1.0 193 1

Index Scan using road_network_partitioned2_cell_1015_pkey on road_network_partitioned2_cell_1015 (cost=0.14..13.04 rows=193 width=27) (actual time=0.014..0.116 rows=193 loops=1)

259. 0.352 0.352 ↑ 1.0 645 1

Index Scan using road_network_partitioned2_cell_973_pkey on road_network_partitioned2_cell_973 (cost=0.28..37.95 rows=645 width=26) (actual time=0.014..0.352 rows=645 loops=1)

260. 0.232 0.232 ↑ 1.0 428 1

Index Scan using road_network_partitioned2_cell_931_pkey on road_network_partitioned2_cell_931 (cost=0.27..32.69 rows=428 width=26) (actual time=0.016..0.232 rows=428 loops=1)

261. 0.364 0.364 ↑ 1.0 681 1

Index Scan using road_network_partitioned2_cell_889_pkey on road_network_partitioned2_cell_889 (cost=0.28..41.49 rows=681 width=28) (actual time=0.012..0.364 rows=681 loops=1)

262. 0.054 0.054 ↑ 1.0 95 1

Index Scan using road_network_partitioned2_cell_847_pkey on road_network_partitioned2_cell_847 (cost=0.14..11.57 rows=95 width=30) (actual time=0.008..0.054 rows=95 loops=1)

263. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_805_pkey on road_network_partitioned2_cell_805 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

264. 0.008 0.008 ↑ 8.3 6 1

Index Scan using road_network_partitioned2_cell_763_pkey on road_network_partitioned2_cell_763 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.008 rows=6 loops=1)

265. 0.022 0.022 ↑ 1.2 40 1

Index Scan using road_network_partitioned2_cell_721_pkey on road_network_partitioned2_cell_721 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.022 rows=40 loops=1)

266. 0.033 0.033 ↑ 1.0 64 1

Index Scan using road_network_partitioned2_cell_679_pkey on road_network_partitioned2_cell_679 (cost=0.14..6.10 rows=64 width=27) (actual time=0.007..0.033 rows=64 loops=1)

267. 0.030 0.030 ↑ 1.0 51 1

Index Scan using road_network_partitioned2_cell_637_pkey on road_network_partitioned2_cell_637 (cost=0.14..5.90 rows=51 width=31) (actual time=0.008..0.030 rows=51 loops=1)

268. 0.026 0.026 ↑ 1.1 46 1

Index Scan using road_network_partitioned2_cell_595_pkey on road_network_partitioned2_cell_595 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.026 rows=46 loops=1)

269. 0.109 0.109 ↑ 1.0 208 1

Index Scan using road_network_partitioned2_cell_553_pkey on road_network_partitioned2_cell_553 (cost=0.14..14.26 rows=208 width=27) (actual time=0.009..0.109 rows=208 loops=1)

270. 0.082 0.082 ↑ 1.0 154 1

Index Scan using road_network_partitioned2_cell_511_pkey on road_network_partitioned2_cell_511 (cost=0.14..12.45 rows=154 width=28) (actual time=0.009..0.082 rows=154 loops=1)

271. 0.066 0.066 ↑ 1.0 120 1

Index Scan using road_network_partitioned2_cell_469_pkey on road_network_partitioned2_cell_469 (cost=0.14..10.94 rows=120 width=30) (actual time=0.009..0.066 rows=120 loops=1)

272. 0.083 0.083 ↑ 1.0 145 1

Index Scan using road_network_partitioned2_cell_427_pkey on road_network_partitioned2_cell_427 (cost=0.14..11.32 rows=145 width=28) (actual time=0.008..0.083 rows=145 loops=1)

273. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_385_pkey on road_network_partitioned2_cell_385 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.004 rows=0 loops=1)

274. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_343_pkey on road_network_partitioned2_cell_343 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

275. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_301_pkey on road_network_partitioned2_cell_301 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

276. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_259_pkey on road_network_partitioned2_cell_259 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

277. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_217_pkey on road_network_partitioned2_cell_217 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

278. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_175_pkey on road_network_partitioned2_cell_175 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

279. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_133_pkey on road_network_partitioned2_cell_133 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

280. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_91_pkey on road_network_partitioned2_cell_91 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

281. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_49_pkey on road_network_partitioned2_cell_49 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

282. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_7_pkey on road_network_partitioned2_cell_7 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

283. 0.138 0.910 ↑ 2.0 1,236 1

Merge Append (cost=5.77..507.82 rows=2,488 width=146) (actual time=0.170..0.910 rows=1,236 loops=1)

  • Sort Key: road_network_partitioned2_cell_1394.lon, road_network_partitioned2_cell_1394.lat, road_network_partitioned2_cell_1394.link_id
284. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1394_pkey on road_network_partitioned2_cell_1394 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

285. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1352_pkey on road_network_partitioned2_cell_1352 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

286. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1310_pkey on road_network_partitioned2_cell_1310 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

287. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1268_pkey on road_network_partitioned2_cell_1268 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

288. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1226_pkey on road_network_partitioned2_cell_1226 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

289. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1184_pkey on road_network_partitioned2_cell_1184 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

290. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1142_pkey on road_network_partitioned2_cell_1142 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

291. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1100_pkey on road_network_partitioned2_cell_1100 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

292. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1058_pkey on road_network_partitioned2_cell_1058 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

293. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1016_pkey on road_network_partitioned2_cell_1016 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

294. 0.357 0.357 ↑ 1.0 661 1

Index Scan using road_network_partitioned2_cell_974_pkey on road_network_partitioned2_cell_974 (cost=0.28..42.19 rows=661 width=26) (actual time=0.012..0.357 rows=661 loops=1)

295. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_932_pkey on road_network_partitioned2_cell_932 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

296. 0.043 0.043 ↑ 1.0 79 1

Index Scan using road_network_partitioned2_cell_890_pkey on road_network_partitioned2_cell_890 (cost=0.14..7.33 rows=79 width=29) (actual time=0.008..0.043 rows=79 loops=1)

297. 0.035 0.035 ↑ 1.2 49 1

Index Scan using road_network_partitioned2_cell_848_pkey on road_network_partitioned2_cell_848 (cost=0.14..15.04 rows=60 width=230) (actual time=0.007..0.035 rows=49 loops=1)

298. 0.007 0.007 ↑ 25.0 2 1

Index Scan using road_network_partitioned2_cell_806_pkey on road_network_partitioned2_cell_806 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.007 rows=2 loops=1)

299. 0.020 0.020 ↑ 2.6 19 1

Index Scan using road_network_partitioned2_cell_764_pkey on road_network_partitioned2_cell_764 (cost=0.14..12.89 rows=50 width=230) (actual time=0.012..0.020 rows=19 loops=1)

300. 0.073 0.073 ↑ 1.0 132 1

Index Scan using road_network_partitioned2_cell_722_pkey on road_network_partitioned2_cell_722 (cost=0.14..10.12 rows=132 width=26) (actual time=0.011..0.073 rows=132 loops=1)

301. 0.030 0.030 ↓ 1.1 55 1

Index Scan using road_network_partitioned2_cell_680_pkey on road_network_partitioned2_cell_680 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.030 rows=55 loops=1)

302. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_638_pkey on road_network_partitioned2_cell_638 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

303. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_596_pkey on road_network_partitioned2_cell_596 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

304. 0.008 0.008 ↑ 6.2 8 1

Index Scan using road_network_partitioned2_cell_554_pkey on road_network_partitioned2_cell_554 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.008 rows=8 loops=1)

305. 0.035 0.035 ↑ 1.0 55 1

Index Scan using road_network_partitioned2_cell_512_pkey on road_network_partitioned2_cell_512 (cost=0.14..9.97 rows=55 width=28) (actual time=0.007..0.035 rows=55 loops=1)

306. 0.052 0.052 ↑ 1.0 101 1

Index Scan using road_network_partitioned2_cell_470_pkey on road_network_partitioned2_cell_470 (cost=0.14..7.66 rows=101 width=26) (actual time=0.008..0.052 rows=101 loops=1)

307. 0.028 0.028 ↑ 1.0 49 1

Index Scan using road_network_partitioned2_cell_428_pkey on road_network_partitioned2_cell_428 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.028 rows=49 loops=1)

308. 0.016 0.016 ↑ 1.9 26 1

Index Scan using road_network_partitioned2_cell_386_pkey on road_network_partitioned2_cell_386 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.016 rows=26 loops=1)

309. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_344_pkey on road_network_partitioned2_cell_344 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

310. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_302_pkey on road_network_partitioned2_cell_302 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

311. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_260_pkey on road_network_partitioned2_cell_260 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

312. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_218_pkey on road_network_partitioned2_cell_218 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

313. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_176_pkey on road_network_partitioned2_cell_176 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

314. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_134_pkey on road_network_partitioned2_cell_134 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

315. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_92_pkey on road_network_partitioned2_cell_92 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

316. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_50_pkey on road_network_partitioned2_cell_50 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

317. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_8_pkey on road_network_partitioned2_cell_8 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

318. 0.268 1.715 ↑ 1.5 2,509 1

Merge Append (cost=6.04..599.88 rows=3,826 width=101) (actual time=0.159..1.715 rows=2,509 loops=1)

  • Sort Key: road_network_partitioned2_cell_1395.lon, road_network_partitioned2_cell_1395.lat, road_network_partitioned2_cell_1395.link_id
319. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1395_pkey on road_network_partitioned2_cell_1395 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

320. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1353_pkey on road_network_partitioned2_cell_1353 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

321. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1311_pkey on road_network_partitioned2_cell_1311 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

322. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1269_pkey on road_network_partitioned2_cell_1269 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

323. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1227_pkey on road_network_partitioned2_cell_1227 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

324. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1185_pkey on road_network_partitioned2_cell_1185 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

325. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1143_pkey on road_network_partitioned2_cell_1143 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

326. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1101_pkey on road_network_partitioned2_cell_1101 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

327. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1059_pkey on road_network_partitioned2_cell_1059 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

328. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1017_pkey on road_network_partitioned2_cell_1017 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

329. 0.599 0.599 ↑ 1.0 1,080 1

Index Scan using road_network_partitioned2_cell_975_pkey on road_network_partitioned2_cell_975 (cost=0.28..59.48 rows=1,080 width=26) (actual time=0.013..0.599 rows=1,080 loops=1)

330. 0.159 0.159 ↑ 1.0 315 1

Index Scan using road_network_partitioned2_cell_933_pkey on road_network_partitioned2_cell_933 (cost=0.27..20.00 rows=315 width=27) (actual time=0.010..0.159 rows=315 loops=1)

331. 0.109 0.109 ↑ 1.0 202 1

Index Scan using road_network_partitioned2_cell_891_pkey on road_network_partitioned2_cell_891 (cost=0.14..13.17 rows=202 width=31) (actual time=0.010..0.109 rows=202 loops=1)

332. 0.332 0.332 ↑ 1.0 630 1

Index Scan using road_network_partitioned2_cell_849_pkey on road_network_partitioned2_cell_849 (cost=0.28..36.72 rows=630 width=26) (actual time=0.011..0.332 rows=630 loops=1)

333. 0.046 0.046 ↑ 1.0 77 1

Index Scan using road_network_partitioned2_cell_807_pkey on road_network_partitioned2_cell_807 (cost=0.14..7.30 rows=77 width=26) (actual time=0.008..0.046 rows=77 loops=1)

334. 0.067 0.067 ↑ 1.0 122 1

Index Scan using road_network_partitioned2_cell_765_pkey on road_network_partitioned2_cell_765 (cost=0.14..9.97 rows=122 width=27) (actual time=0.008..0.067 rows=122 loops=1)

335. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_723_pkey on road_network_partitioned2_cell_723 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

336. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_681_pkey on road_network_partitioned2_cell_681 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

337. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_639_pkey on road_network_partitioned2_cell_639 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

338. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_597_pkey on road_network_partitioned2_cell_597 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

339. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_555_pkey on road_network_partitioned2_cell_555 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

340. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_513_pkey on road_network_partitioned2_cell_513 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

341. 0.017 0.017 ↑ 2.2 23 1

Index Scan using road_network_partitioned2_cell_471_pkey on road_network_partitioned2_cell_471 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.017 rows=23 loops=1)

342. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_429_pkey on road_network_partitioned2_cell_429 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

343. 0.030 0.030 ↑ 1.2 42 1

Index Scan using road_network_partitioned2_cell_387_pkey on road_network_partitioned2_cell_387 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.030 rows=42 loops=1)

344. 0.011 0.011 ↑ 2.8 18 1

Index Scan using road_network_partitioned2_cell_345_pkey on road_network_partitioned2_cell_345 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.011 rows=18 loops=1)

345. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_303_pkey on road_network_partitioned2_cell_303 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

346. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_261_pkey on road_network_partitioned2_cell_261 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

347. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_219_pkey on road_network_partitioned2_cell_219 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

348. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_177_pkey on road_network_partitioned2_cell_177 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

349. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_135_pkey on road_network_partitioned2_cell_135 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

350. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_93_pkey on road_network_partitioned2_cell_93 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

351. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_51_pkey on road_network_partitioned2_cell_51 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

352. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_9_pkey on road_network_partitioned2_cell_9 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

353. 0.069 0.513 ↑ 3.2 661 1

Merge Append (cost=5.63..476.78 rows=2,094 width=176) (actual time=0.148..0.513 rows=661 loops=1)

  • Sort Key: road_network_partitioned2_cell_1396.lon, road_network_partitioned2_cell_1396.lat, road_network_partitioned2_cell_1396.link_id
354. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1396_pkey on road_network_partitioned2_cell_1396 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.005 rows=0 loops=1)

355. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1354_pkey on road_network_partitioned2_cell_1354 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

356. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1312_pkey on road_network_partitioned2_cell_1312 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

357. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1270_pkey on road_network_partitioned2_cell_1270 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

358. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1228_pkey on road_network_partitioned2_cell_1228 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

359. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1186_pkey on road_network_partitioned2_cell_1186 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

360. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1144_pkey on road_network_partitioned2_cell_1144 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

361. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1102_pkey on road_network_partitioned2_cell_1102 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

362. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1060_pkey on road_network_partitioned2_cell_1060 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

363. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1018_pkey on road_network_partitioned2_cell_1018 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

364. 0.137 0.137 ↑ 1.0 251 1

Index Scan using road_network_partitioned2_cell_976_pkey on road_network_partitioned2_cell_976 (cost=0.14..19.91 rows=251 width=23) (actual time=0.013..0.137 rows=251 loops=1)

365. 0.019 0.019 ↑ 1.6 32 1

Index Scan using road_network_partitioned2_cell_934_pkey on road_network_partitioned2_cell_934 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.019 rows=32 loops=1)

366. 0.007 0.007 ↑ 16.7 3 1

Index Scan using road_network_partitioned2_cell_892_pkey on road_network_partitioned2_cell_892 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.007 rows=3 loops=1)

367. 0.019 0.019 ↑ 1.9 27 1

Index Scan using road_network_partitioned2_cell_850_pkey on road_network_partitioned2_cell_850 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.019 rows=27 loops=1)

368. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_808_pkey on road_network_partitioned2_cell_808 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

369. 0.033 0.033 ↑ 1.0 62 1

Index Scan using road_network_partitioned2_cell_766_pkey on road_network_partitioned2_cell_766 (cost=0.14..6.07 rows=62 width=28) (actual time=0.007..0.033 rows=62 loops=1)

370. 0.013 0.013 ↑ 2.1 24 1

Index Scan using road_network_partitioned2_cell_724_pkey on road_network_partitioned2_cell_724 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.013 rows=24 loops=1)

371. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_682_pkey on road_network_partitioned2_cell_682 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

372. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_640_pkey on road_network_partitioned2_cell_640 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

373. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_598_pkey on road_network_partitioned2_cell_598 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

374. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_556_pkey on road_network_partitioned2_cell_556 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

375. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_514_pkey on road_network_partitioned2_cell_514 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

376. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_472_pkey on road_network_partitioned2_cell_472 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

377. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_430_pkey on road_network_partitioned2_cell_430 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

378. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_388_pkey on road_network_partitioned2_cell_388 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

379. 0.018 0.018 ↑ 1.6 31 1

Index Scan using road_network_partitioned2_cell_346_pkey on road_network_partitioned2_cell_346 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.018 rows=31 loops=1)

380. 0.119 0.119 ↑ 1.0 231 1

Index Scan using road_network_partitioned2_cell_304_pkey on road_network_partitioned2_cell_304 (cost=0.14..12.61 rows=231 width=23) (actual time=0.009..0.119 rows=231 loops=1)

381. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_262_pkey on road_network_partitioned2_cell_262 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

382. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_220_pkey on road_network_partitioned2_cell_220 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

383. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_178_pkey on road_network_partitioned2_cell_178 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

384. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_136_pkey on road_network_partitioned2_cell_136 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

385. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_94_pkey on road_network_partitioned2_cell_94 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

386. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_52_pkey on road_network_partitioned2_cell_52 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

387. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_10_pkey on road_network_partitioned2_cell_10 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

388. 0.029 0.288 ↑ 6.3 288 1

Merge Append (cost=5.63..456.87 rows=1,810 width=206) (actual time=0.133..0.288 rows=288 loops=1)

  • Sort Key: road_network_partitioned2_cell_1397.lon, road_network_partitioned2_cell_1397.lat, road_network_partitioned2_cell_1397.link_id
389. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1397_pkey on road_network_partitioned2_cell_1397 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

390. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1355_pkey on road_network_partitioned2_cell_1355 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

391. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1313_pkey on road_network_partitioned2_cell_1313 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

392. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1271_pkey on road_network_partitioned2_cell_1271 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

393. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1229_pkey on road_network_partitioned2_cell_1229 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

394. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1187_pkey on road_network_partitioned2_cell_1187 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

395. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1145_pkey on road_network_partitioned2_cell_1145 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

396. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1103_pkey on road_network_partitioned2_cell_1103 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

397. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1061_pkey on road_network_partitioned2_cell_1061 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

398. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1019_pkey on road_network_partitioned2_cell_1019 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

399. 0.016 0.016 ↑ 2.9 17 1

Index Scan using road_network_partitioned2_cell_977_pkey on road_network_partitioned2_cell_977 (cost=0.14..12.89 rows=50 width=230) (actual time=0.009..0.016 rows=17 loops=1)

400. 0.029 0.029 ↑ 1.0 59 1

Index Scan using road_network_partitioned2_cell_935_pkey on road_network_partitioned2_cell_935 (cost=0.14..5.02 rows=59 width=21) (actual time=0.008..0.029 rows=59 loops=1)

401. 0.017 0.017 ↑ 2.3 22 1

Index Scan using road_network_partitioned2_cell_893_pkey on road_network_partitioned2_cell_893 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.017 rows=22 loops=1)

402. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_851_pkey on road_network_partitioned2_cell_851 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

403. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_809_pkey on road_network_partitioned2_cell_809 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

404. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_767_pkey on road_network_partitioned2_cell_767 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

405. 0.013 0.013 ↑ 2.2 23 1

Index Scan using road_network_partitioned2_cell_725_pkey on road_network_partitioned2_cell_725 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.013 rows=23 loops=1)

406. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_683_pkey on road_network_partitioned2_cell_683 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

407. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_641_pkey on road_network_partitioned2_cell_641 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

408. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_599_pkey on road_network_partitioned2_cell_599 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

409. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_557_pkey on road_network_partitioned2_cell_557 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

410. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_515_pkey on road_network_partitioned2_cell_515 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

411. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_473_pkey on road_network_partitioned2_cell_473 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

412. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_431_pkey on road_network_partitioned2_cell_431 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

413. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_389_pkey on road_network_partitioned2_cell_389 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

414. 0.017 0.017 ↑ 3.1 16 1

Index Scan using road_network_partitioned2_cell_347_pkey on road_network_partitioned2_cell_347 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.017 rows=16 loops=1)

415. 0.082 0.082 ↑ 1.0 151 1

Index Scan using road_network_partitioned2_cell_305_pkey on road_network_partitioned2_cell_305 (cost=0.14..11.41 rows=151 width=27) (actual time=0.009..0.082 rows=151 loops=1)

416. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_263_pkey on road_network_partitioned2_cell_263 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

417. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_221_pkey on road_network_partitioned2_cell_221 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

418. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_179_pkey on road_network_partitioned2_cell_179 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

419. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_137_pkey on road_network_partitioned2_cell_137 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

420. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_95_pkey on road_network_partitioned2_cell_95 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

421. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_53_pkey on road_network_partitioned2_cell_53 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

422. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_11_pkey on road_network_partitioned2_cell_11 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

423. 0.029 0.264 ↑ 7.4 243 1

Merge Append (cost=5.63..458.83 rows=1,787 width=209) (actual time=0.128..0.264 rows=243 loops=1)

  • Sort Key: road_network_partitioned2_cell_1398.lon, road_network_partitioned2_cell_1398.lat, road_network_partitioned2_cell_1398.link_id
424. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1398_pkey on road_network_partitioned2_cell_1398 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

425. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1356_pkey on road_network_partitioned2_cell_1356 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

426. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1314_pkey on road_network_partitioned2_cell_1314 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

427. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1272_pkey on road_network_partitioned2_cell_1272 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

428. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1230_pkey on road_network_partitioned2_cell_1230 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

429. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1188_pkey on road_network_partitioned2_cell_1188 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

430. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1146_pkey on road_network_partitioned2_cell_1146 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

431. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1104_pkey on road_network_partitioned2_cell_1104 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

432. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1062_pkey on road_network_partitioned2_cell_1062 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

433. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1020_pkey on road_network_partitioned2_cell_1020 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

434. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_978_pkey on road_network_partitioned2_cell_978 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

435. 0.022 0.022 ↑ 1.4 35 1

Index Scan using road_network_partitioned2_cell_936_pkey on road_network_partitioned2_cell_936 (cost=0.14..12.89 rows=50 width=230) (actual time=0.009..0.022 rows=35 loops=1)

436. 0.020 0.020 ↑ 2.9 17 1

Index Scan using road_network_partitioned2_cell_894_pkey on road_network_partitioned2_cell_894 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.020 rows=17 loops=1)

437. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_852_pkey on road_network_partitioned2_cell_852 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

438. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_810_pkey on road_network_partitioned2_cell_810 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

439. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_768_pkey on road_network_partitioned2_cell_768 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

440. 0.038 0.038 ↑ 1.0 75 1

Index Scan using road_network_partitioned2_cell_726_pkey on road_network_partitioned2_cell_726 (cost=0.14..6.27 rows=75 width=29) (actual time=0.007..0.038 rows=75 loops=1)

441. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_684_pkey on road_network_partitioned2_cell_684 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

442. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_642_pkey on road_network_partitioned2_cell_642 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

443. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_600_pkey on road_network_partitioned2_cell_600 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

444. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_558_pkey on road_network_partitioned2_cell_558 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

445. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_516_pkey on road_network_partitioned2_cell_516 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

446. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_474_pkey on road_network_partitioned2_cell_474 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

447. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_432_pkey on road_network_partitioned2_cell_432 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

448. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_390_pkey on road_network_partitioned2_cell_390 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

449. 0.008 0.008 ↑ 12.5 4 1

Index Scan using road_network_partitioned2_cell_348_pkey on road_network_partitioned2_cell_348 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.008 rows=4 loops=1)

450. 0.064 0.064 ↑ 1.0 112 1

Index Scan using road_network_partitioned2_cell_306_pkey on road_network_partitioned2_cell_306 (cost=0.14..13.82 rows=112 width=28) (actual time=0.007..0.064 rows=112 loops=1)

451. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_264_pkey on road_network_partitioned2_cell_264 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

452. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_222_pkey on road_network_partitioned2_cell_222 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

453. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_180_pkey on road_network_partitioned2_cell_180 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

454. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_138_pkey on road_network_partitioned2_cell_138 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

455. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_96_pkey on road_network_partitioned2_cell_96 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

456. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_54_pkey on road_network_partitioned2_cell_54 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

457. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_12_pkey on road_network_partitioned2_cell_12 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

458. 0.038 0.324 ↑ 5.3 331 1

Merge Append (cost=5.63..459.78 rows=1,764 width=211) (actual time=0.141..0.324 rows=331 loops=1)

  • Sort Key: road_network_partitioned2_cell_1399.lon, road_network_partitioned2_cell_1399.lat, road_network_partitioned2_cell_1399.link_id
459. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1399_pkey on road_network_partitioned2_cell_1399 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

460. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1357_pkey on road_network_partitioned2_cell_1357 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

461. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1315_pkey on road_network_partitioned2_cell_1315 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

462. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1273_pkey on road_network_partitioned2_cell_1273 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

463. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1231_pkey on road_network_partitioned2_cell_1231 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

464. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1189_pkey on road_network_partitioned2_cell_1189 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

465. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1147_pkey on road_network_partitioned2_cell_1147 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

466. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1105_pkey on road_network_partitioned2_cell_1105 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

467. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1063_pkey on road_network_partitioned2_cell_1063 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

468. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1021_pkey on road_network_partitioned2_cell_1021 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

469. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_979_pkey on road_network_partitioned2_cell_979 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

470. 0.028 0.028 ↑ 1.0 49 1

Index Scan using road_network_partitioned2_cell_937_pkey on road_network_partitioned2_cell_937 (cost=0.14..12.89 rows=50 width=230) (actual time=0.009..0.028 rows=49 loops=1)

471. 0.019 0.019 ↑ 1.7 29 1

Index Scan using road_network_partitioned2_cell_895_pkey on road_network_partitioned2_cell_895 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.019 rows=29 loops=1)

472. 0.029 0.029 ↑ 2.2 23 1

Index Scan using road_network_partitioned2_cell_853_pkey on road_network_partitioned2_cell_853 (cost=0.14..12.89 rows=50 width=230) (actual time=0.011..0.029 rows=23 loops=1)

473. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_811_pkey on road_network_partitioned2_cell_811 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

474. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_769_pkey on road_network_partitioned2_cell_769 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

475. 0.012 0.012 ↑ 2.1 24 1

Index Scan using road_network_partitioned2_cell_727_pkey on road_network_partitioned2_cell_727 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.012 rows=24 loops=1)

476. 0.024 0.024 ↑ 1.2 42 1

Index Scan using road_network_partitioned2_cell_685_pkey on road_network_partitioned2_cell_685 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.024 rows=42 loops=1)

477. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_643_pkey on road_network_partitioned2_cell_643 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

478. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_601_pkey on road_network_partitioned2_cell_601 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

479. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_559_pkey on road_network_partitioned2_cell_559 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

480. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_517_pkey on road_network_partitioned2_cell_517 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

481. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_475_pkey on road_network_partitioned2_cell_475 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

482. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_433_pkey on road_network_partitioned2_cell_433 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

483. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_391_pkey on road_network_partitioned2_cell_391 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

484. 0.056 0.056 ↑ 1.0 112 1

Index Scan using road_network_partitioned2_cell_349_pkey on road_network_partitioned2_cell_349 (cost=0.14..8.82 rows=112 width=30) (actual time=0.008..0.056 rows=112 loops=1)

485. 0.038 0.038 ↑ 1.0 52 1

Index Scan using road_network_partitioned2_cell_307_pkey on road_network_partitioned2_cell_307 (cost=0.14..10.92 rows=52 width=28) (actual time=0.007..0.038 rows=52 loops=1)

486. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_265_pkey on road_network_partitioned2_cell_265 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

487. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_223_pkey on road_network_partitioned2_cell_223 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

488. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_181_pkey on road_network_partitioned2_cell_181 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

489. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_139_pkey on road_network_partitioned2_cell_139 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

490. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_97_pkey on road_network_partitioned2_cell_97 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

491. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_55_pkey on road_network_partitioned2_cell_55 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

492. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_13_pkey on road_network_partitioned2_cell_13 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

493. 0.043 0.323 ↑ 5.3 334 1

Merge Append (cost=5.63..450.42 rows=1,756 width=206) (actual time=0.150..0.323 rows=334 loops=1)

  • Sort Key: road_network_partitioned2_cell_1400.lon, road_network_partitioned2_cell_1400.lat, road_network_partitioned2_cell_1400.link_id
494. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1400_pkey on road_network_partitioned2_cell_1400 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

495. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1358_pkey on road_network_partitioned2_cell_1358 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

496. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1316_pkey on road_network_partitioned2_cell_1316 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

497. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1274_pkey on road_network_partitioned2_cell_1274 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

498. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1232_pkey on road_network_partitioned2_cell_1232 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

499. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1190_pkey on road_network_partitioned2_cell_1190 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

500. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1148_pkey on road_network_partitioned2_cell_1148 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

501. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1106_pkey on road_network_partitioned2_cell_1106 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

502. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1064_pkey on road_network_partitioned2_cell_1064 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

503. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1022_pkey on road_network_partitioned2_cell_1022 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

504. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_980_pkey on road_network_partitioned2_cell_980 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

505. 0.013 0.013 ↑ 2.8 18 1

Index Scan using road_network_partitioned2_cell_938_pkey on road_network_partitioned2_cell_938 (cost=0.14..12.89 rows=50 width=230) (actual time=0.008..0.013 rows=18 loops=1)

506. 0.038 0.038 ↑ 1.0 63 1

Index Scan using road_network_partitioned2_cell_896_pkey on road_network_partitioned2_cell_896 (cost=0.14..8.08 rows=63 width=21) (actual time=0.008..0.038 rows=63 loops=1)

507. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_854_pkey on road_network_partitioned2_cell_854 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

508. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_812_pkey on road_network_partitioned2_cell_812 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.004 rows=0 loops=1)

509. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_770_pkey on road_network_partitioned2_cell_770 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

510. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_728_pkey on road_network_partitioned2_cell_728 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

511. 0.030 0.030 ↑ 1.0 60 1

Index Scan using road_network_partitioned2_cell_686_pkey on road_network_partitioned2_cell_686 (cost=0.14..6.04 rows=60 width=29) (actual time=0.007..0.030 rows=60 loops=1)

512. 0.010 0.010 ↑ 2.5 20 1

Index Scan using road_network_partitioned2_cell_644_pkey on road_network_partitioned2_cell_644 (cost=0.14..12.89 rows=50 width=230) (actual time=0.005..0.010 rows=20 loops=1)

513. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_602_pkey on road_network_partitioned2_cell_602 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

514. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_560_pkey on road_network_partitioned2_cell_560 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

515. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_518_pkey on road_network_partitioned2_cell_518 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

516. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_476_pkey on road_network_partitioned2_cell_476 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

517. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_434_pkey on road_network_partitioned2_cell_434 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

518. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_392_pkey on road_network_partitioned2_cell_392 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

519. 0.043 0.043 ↑ 1.0 83 1

Index Scan using road_network_partitioned2_cell_350_pkey on road_network_partitioned2_cell_350 (cost=0.14..7.39 rows=83 width=30) (actual time=0.008..0.043 rows=83 loops=1)

520. 0.006 0.006 ↑ 50.0 1 1

Index Scan using road_network_partitioned2_cell_308_pkey on road_network_partitioned2_cell_308 (cost=0.14..12.89 rows=50 width=230) (actual time=0.005..0.006 rows=1 loops=1)

521. 0.011 0.011 ↑ 3.6 14 1

Index Scan using road_network_partitioned2_cell_266_pkey on road_network_partitioned2_cell_266 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.011 rows=14 loops=1)

522. 0.030 0.030 ↑ 1.4 35 1

Index Scan using road_network_partitioned2_cell_224_pkey on road_network_partitioned2_cell_224 (cost=0.14..12.89 rows=50 width=230) (actual time=0.013..0.030 rows=35 loops=1)

523. 0.025 0.025 ↑ 1.2 40 1

Index Scan using road_network_partitioned2_cell_182_pkey on road_network_partitioned2_cell_182 (cost=0.14..12.89 rows=50 width=230) (actual time=0.008..0.025 rows=40 loops=1)

524. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_140_pkey on road_network_partitioned2_cell_140 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

525. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_98_pkey on road_network_partitioned2_cell_98 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

526. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_56_pkey on road_network_partitioned2_cell_56 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

527. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_14_pkey on road_network_partitioned2_cell_14 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

528. 0.043 0.334 ↑ 5.1 351 1

Merge Append (cost=5.63..454.87 rows=1,788 width=203) (actual time=0.136..0.334 rows=351 loops=1)

  • Sort Key: road_network_partitioned2_cell_1401.lon, road_network_partitioned2_cell_1401.lat, road_network_partitioned2_cell_1401.link_id
529. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1401_pkey on road_network_partitioned2_cell_1401 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

530. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1359_pkey on road_network_partitioned2_cell_1359 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

531. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1317_pkey on road_network_partitioned2_cell_1317 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

532. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1275_pkey on road_network_partitioned2_cell_1275 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

533. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1233_pkey on road_network_partitioned2_cell_1233 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

534. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1191_pkey on road_network_partitioned2_cell_1191 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

535. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1149_pkey on road_network_partitioned2_cell_1149 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

536. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1107_pkey on road_network_partitioned2_cell_1107 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

537. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1065_pkey on road_network_partitioned2_cell_1065 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

538. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1023_pkey on road_network_partitioned2_cell_1023 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

539. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_981_pkey on road_network_partitioned2_cell_981 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

540. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_939_pkey on road_network_partitioned2_cell_939 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

541. 0.038 0.038 ↑ 1.0 60 1

Index Scan using road_network_partitioned2_cell_897_pkey on road_network_partitioned2_cell_897 (cost=0.14..7.04 rows=60 width=23) (actual time=0.008..0.038 rows=60 loops=1)

542. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_855_pkey on road_network_partitioned2_cell_855 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

543. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_813_pkey on road_network_partitioned2_cell_813 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

544. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_771_pkey on road_network_partitioned2_cell_771 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

545. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_729_pkey on road_network_partitioned2_cell_729 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

546. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_687_pkey on road_network_partitioned2_cell_687 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

547. 0.022 0.022 ↑ 1.2 41 1

Index Scan using road_network_partitioned2_cell_645_pkey on road_network_partitioned2_cell_645 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.022 rows=41 loops=1)

548. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_603_pkey on road_network_partitioned2_cell_603 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

549. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_561_pkey on road_network_partitioned2_cell_561 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

550. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_519_pkey on road_network_partitioned2_cell_519 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

551. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_477_pkey on road_network_partitioned2_cell_477 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

552. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_435_pkey on road_network_partitioned2_cell_435 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

553. 0.018 0.018 ↑ 1.7 30 1

Index Scan using road_network_partitioned2_cell_393_pkey on road_network_partitioned2_cell_393 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.018 rows=30 loops=1)

554. 0.063 0.063 ↑ 1.0 122 1

Index Scan using road_network_partitioned2_cell_351_pkey on road_network_partitioned2_cell_351 (cost=0.14..10.97 rows=122 width=27) (actual time=0.008..0.063 rows=122 loops=1)

555. 0.035 0.035 ↑ 1.0 56 1

Index Scan using road_network_partitioned2_cell_309_pkey on road_network_partitioned2_cell_309 (cost=0.14..8.98 rows=56 width=33) (actual time=0.008..0.035 rows=56 loops=1)

556. 0.006 0.006 ↑ 50.0 1 1

Index Scan using road_network_partitioned2_cell_267_pkey on road_network_partitioned2_cell_267 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.006 rows=1 loops=1)

557. 0.030 0.030 ↑ 1.2 41 1

Index Scan using road_network_partitioned2_cell_225_pkey on road_network_partitioned2_cell_225 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.030 rows=41 loops=1)

558. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_183_pkey on road_network_partitioned2_cell_183 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

559. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_141_pkey on road_network_partitioned2_cell_141 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

560. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_99_pkey on road_network_partitioned2_cell_99 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

561. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_57_pkey on road_network_partitioned2_cell_57 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

562. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_15_pkey on road_network_partitioned2_cell_15 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

563. 0.079 0.614 ↑ 2.7 842 1

Merge Append (cost=5.76..487.04 rows=2,251 width=162) (actual time=0.151..0.614 rows=842 loops=1)

  • Sort Key: road_network_partitioned2_cell_1402.lon, road_network_partitioned2_cell_1402.lat, road_network_partitioned2_cell_1402.link_id
564. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1402_pkey on road_network_partitioned2_cell_1402 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

565. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1360_pkey on road_network_partitioned2_cell_1360 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

566. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1318_pkey on road_network_partitioned2_cell_1318 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

567. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1276_pkey on road_network_partitioned2_cell_1276 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

568. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1234_pkey on road_network_partitioned2_cell_1234 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

569. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1192_pkey on road_network_partitioned2_cell_1192 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

570. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1150_pkey on road_network_partitioned2_cell_1150 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

571. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1108_pkey on road_network_partitioned2_cell_1108 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

572. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1066_pkey on road_network_partitioned2_cell_1066 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

573. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1024_pkey on road_network_partitioned2_cell_1024 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

574. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_982_pkey on road_network_partitioned2_cell_982 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

575. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_940_pkey on road_network_partitioned2_cell_940 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

576. 0.046 0.046 ↑ 1.0 76 1

Index Scan using road_network_partitioned2_cell_898_pkey on road_network_partitioned2_cell_898 (cost=0.14..8.28 rows=76 width=22) (actual time=0.009..0.046 rows=76 loops=1)

577. 0.007 0.007 ↑ 50.0 1 1

Index Scan using road_network_partitioned2_cell_856_pkey on road_network_partitioned2_cell_856 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.007 rows=1 loops=1)

578. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_814_pkey on road_network_partitioned2_cell_814 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

579. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_772_pkey on road_network_partitioned2_cell_772 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

580. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_730_pkey on road_network_partitioned2_cell_730 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

581. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_688_pkey on road_network_partitioned2_cell_688 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

582. 0.017 0.017 ↑ 1.4 35 1

Index Scan using road_network_partitioned2_cell_646_pkey on road_network_partitioned2_cell_646 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.017 rows=35 loops=1)

583. 0.010 0.010 ↑ 3.6 14 1

Index Scan using road_network_partitioned2_cell_604_pkey on road_network_partitioned2_cell_604 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.010 rows=14 loops=1)

584. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_562_pkey on road_network_partitioned2_cell_562 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

585. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_520_pkey on road_network_partitioned2_cell_520 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

586. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_478_pkey on road_network_partitioned2_cell_478 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

587. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_436_pkey on road_network_partitioned2_cell_436 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

588. 0.009 0.009 ↑ 3.8 13 1

Index Scan using road_network_partitioned2_cell_394_pkey on road_network_partitioned2_cell_394 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.009 rows=13 loops=1)

589. 0.016 0.016 ↑ 1.8 28 1

Index Scan using road_network_partitioned2_cell_352_pkey on road_network_partitioned2_cell_352 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.016 rows=28 loops=1)

590. 0.054 0.054 ↑ 1.0 105 1

Index Scan using road_network_partitioned2_cell_310_pkey on road_network_partitioned2_cell_310 (cost=0.14..8.72 rows=105 width=29) (actual time=0.007..0.054 rows=105 loops=1)

591. 0.061 0.061 ↑ 1.0 112 1

Index Scan using road_network_partitioned2_cell_268_pkey on road_network_partitioned2_cell_268 (cost=0.14..9.82 rows=112 width=30) (actual time=0.007..0.061 rows=112 loops=1)

592. 0.243 0.243 ↑ 1.0 458 1

Index Scan using road_network_partitioned2_cell_226_pkey on road_network_partitioned2_cell_226 (cost=0.27..29.14 rows=458 width=26) (actual time=0.017..0.243 rows=458 loops=1)

593. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_184_pkey on road_network_partitioned2_cell_184 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

594. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_142_pkey on road_network_partitioned2_cell_142 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

595. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_100_pkey on road_network_partitioned2_cell_100 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

596. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_58_pkey on road_network_partitioned2_cell_58 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

597. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_16_pkey on road_network_partitioned2_cell_16 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

598. 0.042 0.314 ↑ 4.8 366 1

Merge Append (cost=5.63..453.73 rows=1,741 width=213) (actual time=0.137..0.314 rows=366 loops=1)

  • Sort Key: road_network_partitioned2_cell_1403.lon, road_network_partitioned2_cell_1403.lat, road_network_partitioned2_cell_1403.link_id
599. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1403_pkey on road_network_partitioned2_cell_1403 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

600. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1361_pkey on road_network_partitioned2_cell_1361 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

601. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1319_pkey on road_network_partitioned2_cell_1319 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

602. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1277_pkey on road_network_partitioned2_cell_1277 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

603. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1235_pkey on road_network_partitioned2_cell_1235 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

604. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1193_pkey on road_network_partitioned2_cell_1193 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

605. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1151_pkey on road_network_partitioned2_cell_1151 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

606. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1109_pkey on road_network_partitioned2_cell_1109 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

607. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1067_pkey on road_network_partitioned2_cell_1067 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

608. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1025_pkey on road_network_partitioned2_cell_1025 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

609. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_983_pkey on road_network_partitioned2_cell_983 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

610. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_941_pkey on road_network_partitioned2_cell_941 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

611. 0.031 0.031 ↑ 1.0 58 1

Index Scan using road_network_partitioned2_cell_899_pkey on road_network_partitioned2_cell_899 (cost=0.14..5.01 rows=58 width=21) (actual time=0.009..0.031 rows=58 loops=1)

612. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_857_pkey on road_network_partitioned2_cell_857 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

613. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_815_pkey on road_network_partitioned2_cell_815 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

614. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_773_pkey on road_network_partitioned2_cell_773 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

615. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_731_pkey on road_network_partitioned2_cell_731 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

616. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_689_pkey on road_network_partitioned2_cell_689 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

617. 0.010 0.010 ↑ 3.3 15 1

Index Scan using road_network_partitioned2_cell_647_pkey on road_network_partitioned2_cell_647 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.010 rows=15 loops=1)

618. 0.014 0.014 ↑ 1.6 31 1

Index Scan using road_network_partitioned2_cell_605_pkey on road_network_partitioned2_cell_605 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.014 rows=31 loops=1)

619. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_563_pkey on road_network_partitioned2_cell_563 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

620. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_521_pkey on road_network_partitioned2_cell_521 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

621. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_479_pkey on road_network_partitioned2_cell_479 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

622. 0.010 0.010 ↑ 4.2 12 1

Index Scan using road_network_partitioned2_cell_437_pkey on road_network_partitioned2_cell_437 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.010 rows=12 loops=1)

623. 0.019 0.019 ↑ 1.6 32 1

Index Scan using road_network_partitioned2_cell_395_pkey on road_network_partitioned2_cell_395 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.019 rows=32 loops=1)

624. 0.007 0.007 ↑ 7.1 7 1

Index Scan using road_network_partitioned2_cell_353_pkey on road_network_partitioned2_cell_353 (cost=0.14..12.89 rows=50 width=230) (actual time=0.005..0.007 rows=7 loops=1)

625. 0.026 0.026 ↑ 1.0 48 1

Index Scan using road_network_partitioned2_cell_311_pkey on road_network_partitioned2_cell_311 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.026 rows=48 loops=1)

626. 0.044 0.044 ↓ 1.6 80 1

Index Scan using road_network_partitioned2_cell_269_pkey on road_network_partitioned2_cell_269 (cost=0.14..12.89 rows=50 width=230) (actual time=0.008..0.044 rows=80 loops=1)

627. 0.043 0.043 ↑ 1.0 83 1

Index Scan using road_network_partitioned2_cell_227_pkey on road_network_partitioned2_cell_227 (cost=0.14..7.39 rows=83 width=24) (actual time=0.007..0.043 rows=83 loops=1)

628. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_185_pkey on road_network_partitioned2_cell_185 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

629. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_143_pkey on road_network_partitioned2_cell_143 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

630. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_101_pkey on road_network_partitioned2_cell_101 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

631. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_59_pkey on road_network_partitioned2_cell_59 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

632. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_17_pkey on road_network_partitioned2_cell_17 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

633. 0.162 1.219 ↑ 1.7 1,900 1

Merge Append (cost=5.77..552.58 rows=3,231 width=116) (actual time=0.146..1.219 rows=1,900 loops=1)

  • Sort Key: road_network_partitioned2_cell_1404.lon, road_network_partitioned2_cell_1404.lat, road_network_partitioned2_cell_1404.link_id
634. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1404_pkey on road_network_partitioned2_cell_1404 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

635. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1362_pkey on road_network_partitioned2_cell_1362 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

636. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1320_pkey on road_network_partitioned2_cell_1320 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

637. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1278_pkey on road_network_partitioned2_cell_1278 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

638. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1236_pkey on road_network_partitioned2_cell_1236 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

639. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1194_pkey on road_network_partitioned2_cell_1194 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

640. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1152_pkey on road_network_partitioned2_cell_1152 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

641. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1110_pkey on road_network_partitioned2_cell_1110 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

642. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1068_pkey on road_network_partitioned2_cell_1068 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

643. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1026_pkey on road_network_partitioned2_cell_1026 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

644. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_984_pkey on road_network_partitioned2_cell_984 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

645. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_942_pkey on road_network_partitioned2_cell_942 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

646. 0.027 0.027 ↑ 1.1 46 1

Index Scan using road_network_partitioned2_cell_900_pkey on road_network_partitioned2_cell_900 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.027 rows=46 loops=1)

647. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_858_pkey on road_network_partitioned2_cell_858 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

648. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_816_pkey on road_network_partitioned2_cell_816 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

649. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_774_pkey on road_network_partitioned2_cell_774 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

650. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_732_pkey on road_network_partitioned2_cell_732 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

651. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_690_pkey on road_network_partitioned2_cell_690 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

652. 0.058 0.058 ↑ 1.0 110 1

Index Scan using road_network_partitioned2_cell_648_pkey on road_network_partitioned2_cell_648 (cost=0.14..8.79 rows=110 width=23) (actual time=0.008..0.058 rows=110 loops=1)

653. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_606_pkey on road_network_partitioned2_cell_606 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

654. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_564_pkey on road_network_partitioned2_cell_564 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

655. 0.007 0.007 ↑ 25.0 2 1

Index Scan using road_network_partitioned2_cell_522_pkey on road_network_partitioned2_cell_522 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.007 rows=2 loops=1)

656. 0.009 0.009 ↑ 4.5 11 1

Index Scan using road_network_partitioned2_cell_480_pkey on road_network_partitioned2_cell_480 (cost=0.14..12.89 rows=50 width=230) (actual time=0.005..0.009 rows=11 loops=1)

657. 0.011 0.011 ↑ 2.8 18 1

Index Scan using road_network_partitioned2_cell_438_pkey on road_network_partitioned2_cell_438 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.011 rows=18 loops=1)

658. 0.006 0.006 ↑ 50.0 1 1

Index Scan using road_network_partitioned2_cell_396_pkey on road_network_partitioned2_cell_396 (cost=0.14..12.89 rows=50 width=230) (actual time=0.005..0.006 rows=1 loops=1)

659. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_354_pkey on road_network_partitioned2_cell_354 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

660. 0.032 0.032 ↑ 1.0 64 1

Index Scan using road_network_partitioned2_cell_312_pkey on road_network_partitioned2_cell_312 (cost=0.14..6.10 rows=64 width=24) (actual time=0.006..0.032 rows=64 loops=1)

661. 0.025 0.025 ↑ 1.2 41 1

Index Scan using road_network_partitioned2_cell_270_pkey on road_network_partitioned2_cell_270 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.025 rows=41 loops=1)

662. 0.083 0.083 ↑ 1.0 152 1

Index Scan using road_network_partitioned2_cell_228_pkey on road_network_partitioned2_cell_228 (cost=0.14..11.42 rows=152 width=24) (actual time=0.009..0.083 rows=152 loops=1)

663. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_186_pkey on road_network_partitioned2_cell_186 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

664. 0.044 0.044 ↑ 1.0 81 1

Index Scan using road_network_partitioned2_cell_144_pkey on road_network_partitioned2_cell_144 (cost=0.14..9.36 rows=81 width=27) (actual time=0.007..0.044 rows=81 loops=1)

665. 0.692 0.692 ↑ 1.0 1,374 1

Index Scan using road_network_partitioned2_cell_102_pkey on road_network_partitioned2_cell_102 (cost=0.28..66.89 rows=1,374 width=24) (actual time=0.009..0.692 rows=1,374 loops=1)

666. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_60_pkey on road_network_partitioned2_cell_60 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

667. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_18_pkey on road_network_partitioned2_cell_18 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

668. 0.249 1.895 ↑ 1.4 2,729 1

Merge Append (cost=5.92..607.35 rows=3,949 width=94) (actual time=0.166..1.895 rows=2,729 loops=1)

  • Sort Key: road_network_partitioned2_cell_1405.lon, road_network_partitioned2_cell_1405.lat, road_network_partitioned2_cell_1405.link_id
669. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1405_pkey on road_network_partitioned2_cell_1405 (cost=0.14..11.89 rows=50 width=230) (actual time=0.005..0.005 rows=0 loops=1)

670. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1363_pkey on road_network_partitioned2_cell_1363 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

671. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1321_pkey on road_network_partitioned2_cell_1321 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

672. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1279_pkey on road_network_partitioned2_cell_1279 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

673. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1237_pkey on road_network_partitioned2_cell_1237 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

674. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1195_pkey on road_network_partitioned2_cell_1195 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.003 rows=0 loops=1)

675. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1153_pkey on road_network_partitioned2_cell_1153 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

676. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1111_pkey on road_network_partitioned2_cell_1111 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

677. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1069_pkey on road_network_partitioned2_cell_1069 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

678. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1027_pkey on road_network_partitioned2_cell_1027 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

679. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_985_pkey on road_network_partitioned2_cell_985 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

680. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_943_pkey on road_network_partitioned2_cell_943 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

681. 0.059 0.059 ↑ 1.0 75 1

Index Scan using road_network_partitioned2_cell_901_pkey on road_network_partitioned2_cell_901 (cost=0.14..6.27 rows=75 width=21) (actual time=0.010..0.059 rows=75 loops=1)

682. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_859_pkey on road_network_partitioned2_cell_859 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

683. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_817_pkey on road_network_partitioned2_cell_817 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

684. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_775_pkey on road_network_partitioned2_cell_775 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

685. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_733_pkey on road_network_partitioned2_cell_733 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

686. 0.011 0.011 ↑ 4.2 12 1

Index Scan using road_network_partitioned2_cell_691_pkey on road_network_partitioned2_cell_691 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.011 rows=12 loops=1)

687. 0.089 0.089 ↑ 1.0 152 1

Index Scan using road_network_partitioned2_cell_649_pkey on road_network_partitioned2_cell_649 (cost=0.14..10.42 rows=152 width=25) (actual time=0.009..0.089 rows=152 loops=1)

688. 0.017 0.017 ↑ 1.7 30 1

Index Scan using road_network_partitioned2_cell_607_pkey on road_network_partitioned2_cell_607 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.017 rows=30 loops=1)

689. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_565_pkey on road_network_partitioned2_cell_565 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

690. 0.022 0.022 ↑ 1.2 42 1

Index Scan using road_network_partitioned2_cell_523_pkey on road_network_partitioned2_cell_523 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.022 rows=42 loops=1)

691. 0.009 0.009 ↑ 4.5 11 1

Index Scan using road_network_partitioned2_cell_481_pkey on road_network_partitioned2_cell_481 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.009 rows=11 loops=1)

692. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_439_pkey on road_network_partitioned2_cell_439 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

693. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_397_pkey on road_network_partitioned2_cell_397 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

694. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_355_pkey on road_network_partitioned2_cell_355 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

695. 0.019 0.019 ↑ 1.4 35 1

Index Scan using road_network_partitioned2_cell_313_pkey on road_network_partitioned2_cell_313 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.019 rows=35 loops=1)

696. 0.043 0.043 ↑ 1.0 84 1

Index Scan using road_network_partitioned2_cell_271_pkey on road_network_partitioned2_cell_271 (cost=0.14..7.40 rows=84 width=24) (actual time=0.007..0.043 rows=84 loops=1)

697. 0.112 0.112 ↑ 1.0 221 1

Index Scan using road_network_partitioned2_cell_229_pkey on road_network_partitioned2_cell_229 (cost=0.14..14.46 rows=221 width=25) (actual time=0.008..0.112 rows=221 loops=1)

698. 0.080 0.080 ↑ 1.0 150 1

Index Scan using road_network_partitioned2_cell_187_pkey on road_network_partitioned2_cell_187 (cost=0.14..14.39 rows=150 width=26) (actual time=0.008..0.080 rows=150 loops=1)

699. 0.391 0.391 ↑ 1.0 614 1

Index Scan using road_network_partitioned2_cell_145_pkey on road_network_partitioned2_cell_145 (cost=0.28..41.48 rows=614 width=23) (actual time=0.010..0.391 rows=614 loops=1)

700. 0.728 0.728 ↑ 1.0 1,303 1

Index Scan using road_network_partitioned2_cell_103_pkey on road_network_partitioned2_cell_103 (cost=0.28..65.82 rows=1,303 width=23) (actual time=0.010..0.728 rows=1,303 loops=1)

701. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_61_pkey on road_network_partitioned2_cell_61 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

702. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_19_pkey on road_network_partitioned2_cell_19 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

703. 0.203 1.327 ↑ 1.6 1,957 1

Merge Append (cost=5.79..544.37 rows=3,160 width=108) (actual time=0.192..1.327 rows=1,957 loops=1)

  • Sort Key: road_network_partitioned2_cell_1406.lon, road_network_partitioned2_cell_1406.lat, road_network_partitioned2_cell_1406.link_id
704. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1406_pkey on road_network_partitioned2_cell_1406 (cost=0.14..11.89 rows=50 width=230) (actual time=0.005..0.005 rows=0 loops=1)

705. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1364_pkey on road_network_partitioned2_cell_1364 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

706. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1322_pkey on road_network_partitioned2_cell_1322 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

707. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1280_pkey on road_network_partitioned2_cell_1280 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

708. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1238_pkey on road_network_partitioned2_cell_1238 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

709. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1196_pkey on road_network_partitioned2_cell_1196 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

710. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1154_pkey on road_network_partitioned2_cell_1154 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

711. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1112_pkey on road_network_partitioned2_cell_1112 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

712. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1070_pkey on road_network_partitioned2_cell_1070 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

713. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1028_pkey on road_network_partitioned2_cell_1028 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

714. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_986_pkey on road_network_partitioned2_cell_986 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

715. 0.015 0.015 ↑ 4.2 12 1

Index Scan using road_network_partitioned2_cell_944_pkey on road_network_partitioned2_cell_944 (cost=0.14..12.89 rows=50 width=230) (actual time=0.010..0.015 rows=12 loops=1)

716. 0.125 0.125 ↑ 1.0 223 1

Index Scan using road_network_partitioned2_cell_902_pkey on road_network_partitioned2_cell_902 (cost=0.14..16.49 rows=223 width=23) (actual time=0.018..0.125 rows=223 loops=1)

717. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_860_pkey on road_network_partitioned2_cell_860 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

718. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_818_pkey on road_network_partitioned2_cell_818 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

719. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_776_pkey on road_network_partitioned2_cell_776 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

720. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_734_pkey on road_network_partitioned2_cell_734 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

721. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_692_pkey on road_network_partitioned2_cell_692 (cost=0.14..11.89 rows=50 width=230) (actual time=0.002..0.002 rows=0 loops=1)

722. 0.074 0.074 ↑ 1.0 151 1

Index Scan using road_network_partitioned2_cell_650_pkey on road_network_partitioned2_cell_650 (cost=0.14..10.41 rows=151 width=24) (actual time=0.008..0.074 rows=151 loops=1)

723. 0.025 0.025 ↑ 1.2 42 1

Index Scan using road_network_partitioned2_cell_608_pkey on road_network_partitioned2_cell_608 (cost=0.14..12.89 rows=50 width=230) (actual time=0.006..0.025 rows=42 loops=1)

724. 0.068 0.068 ↑ 1.0 114 1

Index Scan using road_network_partitioned2_cell_566_pkey on road_network_partitioned2_cell_566 (cost=0.14..10.85 rows=114 width=25) (actual time=0.014..0.068 rows=114 loops=1)

725. 0.044 0.044 ↑ 1.0 77 1

Index Scan using road_network_partitioned2_cell_524_pkey on road_network_partitioned2_cell_524 (cost=0.14..8.30 rows=77 width=25) (actual time=0.008..0.044 rows=77 loops=1)

726. 0.012 0.012 ↑ 2.3 22 1

Index Scan using road_network_partitioned2_cell_482_pkey on road_network_partitioned2_cell_482 (cost=0.14..12.89 rows=50 width=230) (actual time=0.007..0.012 rows=22 loops=1)

727. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_440_pkey on road_network_partitioned2_cell_440 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

728. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_398_pkey on road_network_partitioned2_cell_398 (cost=0.14..11.89 rows=50 width=230) (a