explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VGPC

Settings
# exclusive inclusive rows x rows loops node
1. 4.535 313.234 ↑ 1.5 67,458 1

Append (cost=43,039.61..111,569.73 rows=101,254 width=21) (actual time=187.253..313.234 rows=67,458 loops=1)

  • Functions: 158
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 13.355 ms, Inlining 0.000 ms, Optimization 3.143 ms, Emission 77.763 ms, Total 94.261 ms"Execution Time: 330.078 ms
2. 13.658 203.321 ↑ 1.8 29,263 1

Merge Join (cost=43,039.61..54,519.55 rows=53,557 width=21) (actual time=187.252..203.321 rows=29,263 loops=1)

  • Merge Cond: ((a.link_id = b.link_id) AND (a.lon = b.lon))
3. 9.839 112.486 ↑ 1.0 29,263 1

Sort (cost=12,221.41..12,294.57 rows=29,263 width=24) (actual time=110.830..112.486 rows=29,263 loops=1)

  • Sort Key: a.link_id, a.lon
  • Sort Method: quicksort Memory: 2999kB
4. 2.781 102.647 ↑ 1.0 29,263 1

Append (cost=0.28..10,050.56 rows=29,263 width=24) (actual time=82.015..102.647 rows=29,263 loops=1)

5. 86.137 86.137 ↑ 1.0 6,677 1

Index Scan using road_network_partitioned2_cell_796_pkey on road_network_partitioned2_cell_796 a (cost=0.28..1,688.79 rows=6,677 width=25) (actual time=82.014..86.137 rows=6,677 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
6. 13.729 13.729 ↑ 1.0 22,586 1

Index Scan using road_network_partitioned2_cell_754_pkey on road_network_partitioned2_cell_754 a_1 (cost=0.29..5,435.48 rows=22,586 width=24) (actual time=0.038..13.729 rows=22,586 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
7. 25.054 77.177 ↑ 1.4 53,410 1

Sort (cost=30,818.20..31,001.22 rows=73,208 width=10) (actual time=73.985..77.177 rows=53,410 loops=1)

  • Sort Key: b.link_id, b.lon
  • Sort Method: quicksort Memory: 6446kB
8. 6.895 52.123 ↑ 1.0 71,958 1

Append (cost=0.14..24,903.10 rows=73,208 width=10) (actual time=0.087..52.123 rows=71,958 loops=1)

9. 0.006 0.006 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1426 on road_network_partitioned2_cell_1426 b (cost=0.14..21.14 rows=50 width=10) (actual time=0.006..0.006 rows=0 loops=1)

10. 0.008 0.008 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1384 on road_network_partitioned2_cell_1384 b_1 (cost=0.14..21.14 rows=50 width=10) (actual time=0.008..0.008 rows=0 loops=1)

11. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1342 on road_network_partitioned2_cell_1342 b_2 (cost=0.14..21.14 rows=50 width=10) (actual time=0.004..0.004 rows=0 loops=1)

12. 0.015 0.015 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1300 on road_network_partitioned2_cell_1300 b_3 (cost=0.14..21.14 rows=50 width=10) (actual time=0.015..0.015 rows=0 loops=1)

13. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1258 on road_network_partitioned2_cell_1258 b_4 (cost=0.14..21.14 rows=50 width=10) (actual time=0.004..0.004 rows=0 loops=1)

14. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1216 on road_network_partitioned2_cell_1216 b_5 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.004 rows=0 loops=1)

15. 0.006 0.006 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1174 on road_network_partitioned2_cell_1174 b_6 (cost=0.14..21.14 rows=50 width=10) (actual time=0.006..0.006 rows=0 loops=1)

16. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1132 on road_network_partitioned2_cell_1132 b_7 (cost=0.14..21.14 rows=50 width=10) (actual time=0.004..0.004 rows=0 loops=1)

17. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1090 on road_network_partitioned2_cell_1090 b_8 (cost=0.14..21.14 rows=50 width=10) (actual time=0.004..0.004 rows=0 loops=1)

18. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1048 on road_network_partitioned2_cell_1048 b_9 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

19. 0.007 0.007 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1006 on road_network_partitioned2_cell_1006 b_10 (cost=0.14..21.14 rows=50 width=10) (actual time=0.007..0.007 rows=0 loops=1)

20. 1.712 1.712 ↑ 1.0 2,908 1

Index Only Scan using road_network_partitioned2_cell_964_pkey on road_network_partitioned2_cell_964 b_11 (cost=0.28..697.03 rows=2,908 width=10) (actual time=0.018..1.712 rows=2,908 loops=1)

  • Heap Fetches: 2908
21. 4.885 4.885 ↑ 1.0 7,979 1

Index Only Scan using road_network_partitioned2_cell_922_pkey on road_network_partitioned2_cell_922 b_12 (cost=0.28..1,919.48 rows=7,979 width=10) (actual time=0.017..4.885 rows=7,979 loops=1)

  • Heap Fetches: 7979
22. 3.243 3.243 ↑ 1.0 5,312 1

Index Only Scan using road_network_partitioned2_cell_880_pkey on road_network_partitioned2_cell_880 b_13 (cost=0.28..1,336.95 rows=5,312 width=10) (actual time=0.036..3.243 rows=5,312 loops=1)

  • Heap Fetches: 5312
23. 2.414 2.414 ↑ 1.0 3,983 1

Index Only Scan using road_network_partitioned2_cell_838_pkey on road_network_partitioned2_cell_838 b_14 (cost=0.28..983.08 rows=3,983 width=10) (actual time=0.024..2.414 rows=3,983 loops=1)

  • Heap Fetches: 3983
24. 4.024 4.024 ↑ 1.0 6,677 1

Index Only Scan using road_network_partitioned2_cell_796_pkey on road_network_partitioned2_cell_796 b_15 (cost=0.28..1,622.02 rows=6,677 width=10) (actual time=0.021..4.024 rows=6,677 loops=1)

  • Heap Fetches: 6677
25. 14.323 14.323 ↑ 1.0 22,586 1

Index Only Scan using road_network_partitioned2_cell_754_pkey on road_network_partitioned2_cell_754 b_16 (cost=0.29..5,209.62 rows=22,586 width=10) (actual time=0.023..14.323 rows=22,586 loops=1)

  • Heap Fetches: 22586
26. 9.431 9.431 ↑ 1.0 14,149 1

Index Only Scan using road_network_partitioned2_cell_712_pkey on road_network_partitioned2_cell_712 b_17 (cost=0.29..3,334.79 rows=14,149 width=10) (actual time=0.027..9.431 rows=14,149 loops=1)

  • Heap Fetches: 14149
27. 3.666 3.666 ↑ 1.0 5,927 1

Index Only Scan using road_network_partitioned2_cell_670_pkey on road_network_partitioned2_cell_670 b_18 (cost=0.28..1,389.98 rows=5,927 width=10) (actual time=0.022..3.666 rows=5,927 loops=1)

  • Heap Fetches: 5927
28. 1.417 1.417 ↑ 1.0 2,437 1

Index Only Scan using road_network_partitioned2_cell_628_pkey on road_network_partitioned2_cell_628 b_19 (cost=0.28..560.80 rows=2,437 width=10) (actual time=0.026..1.417 rows=2,437 loops=1)

  • Heap Fetches: 2437
29. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx586 on road_network_partitioned2_cell_586 b_20 (cost=0.14..21.14 rows=50 width=10) (actual time=0.005..0.005 rows=0 loops=1)

30. 0.007 0.007 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx544 on road_network_partitioned2_cell_544 b_21 (cost=0.14..21.14 rows=50 width=10) (actual time=0.007..0.007 rows=0 loops=1)

31. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx502 on road_network_partitioned2_cell_502 b_22 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

32. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx460 on road_network_partitioned2_cell_460 b_23 (cost=0.14..21.14 rows=50 width=10) (actual time=0.002..0.002 rows=0 loops=1)

33. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx418 on road_network_partitioned2_cell_418 b_24 (cost=0.14..21.14 rows=50 width=10) (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_ce_link_id_street_name_road_km_idx376 on road_network_partitioned2_cell_376 b_25 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

35. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx334 on road_network_partitioned2_cell_334 b_26 (cost=0.14..21.14 rows=50 width=10) (actual time=0.002..0.002 rows=0 loops=1)

36. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx292 on road_network_partitioned2_cell_292 b_27 (cost=0.14..21.14 rows=50 width=10) (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_ce_link_id_street_name_road_km_idx250 on road_network_partitioned2_cell_250 b_28 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

38. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx208 on road_network_partitioned2_cell_208 b_29 (cost=0.14..21.14 rows=50 width=10) (actual time=0.005..0.005 rows=0 loops=1)

39. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx166 on road_network_partitioned2_cell_166 b_30 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

40. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx124 on road_network_partitioned2_cell_124 b_31 (cost=0.14..21.14 rows=50 width=10) (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_ce_link_id_street_name_road_km__idx82 on road_network_partitioned2_cell_82 b_32 (cost=0.14..21.14 rows=50 width=10) (actual time=0.002..0.003 rows=0 loops=1)

42. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km__idx40 on road_network_partitioned2_cell_40 b_33 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

43. 15.807 105.378 ↑ 1.2 38,195 1

Merge Join (cost=36,724.29..46,924.78 rows=47,697 width=21) (actual time=84.782..105.378 rows=38,195 loops=1)

  • Merge Cond: ((a_2.link_id = b_34.link_id) AND (a_2.lon = b_34.lon))
44. 13.714 40.713 ↑ 1.0 38,195 1

Sort (cost=15,956.78..16,052.27 rows=38,195 width=23) (actual time=38.467..40.713 rows=38,195 loops=1)

  • Sort Key: a_2.link_id, a_2.lon
  • Sort Method: quicksort Memory: 4403kB
45. 3.589 26.999 ↑ 1.0 38,195 1

Append (cost=0.29..13,049.93 rows=38,195 width=23) (actual time=0.039..26.999 rows=38,195 loops=1)

46. 8.146 8.146 ↑ 1.0 13,205 1

Index Scan using road_network_partitioned2_cell_797_pkey on road_network_partitioned2_cell_797 a_2 (cost=0.29..3,267.00 rows=13,205 width=23) (actual time=0.039..8.146 rows=13,205 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
47. 15.264 15.264 ↑ 1.0 24,990 1

Index Scan using road_network_partitioned2_cell_755_pkey on road_network_partitioned2_cell_755 a_3 (cost=0.29..5,963.44 rows=24,990 width=23) (actual time=0.032..15.264 rows=24,990 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
48. 17.174 48.858 ↑ 1.1 44,335 1

Sort (cost=20,767.51..20,892.39 rows=49,951 width=10) (actual time=46.077..48.858 rows=44,335 loops=1)

  • Sort Key: b_34.link_id, b_34.lon
  • Sort Method: quicksort Memory: 3812kB
49. 4.562 31.684 ↑ 1.0 48,551 1

Append (cost=0.14..16,869.28 rows=49,951 width=10) (actual time=0.092..31.684 rows=48,551 loops=1)

50. 0.009 0.009 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1427 on road_network_partitioned2_cell_1427 b_34 (cost=0.14..21.14 rows=50 width=10) (actual time=0.009..0.009 rows=0 loops=1)

51. 0.016 0.016 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1385 on road_network_partitioned2_cell_1385 b_35 (cost=0.14..21.14 rows=50 width=10) (actual time=0.016..0.016 rows=0 loops=1)

52. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1343 on road_network_partitioned2_cell_1343 b_36 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

53. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1301 on road_network_partitioned2_cell_1301 b_37 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

54. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1259 on road_network_partitioned2_cell_1259 b_38 (cost=0.14..21.14 rows=50 width=10) (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_c_link_id_street_name_road_km_idx1217 on road_network_partitioned2_cell_1217 b_39 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

56. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1175 on road_network_partitioned2_cell_1175 b_40 (cost=0.14..21.14 rows=50 width=10) (actual time=0.005..0.005 rows=0 loops=1)

57. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1133 on road_network_partitioned2_cell_1133 b_41 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

58. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1091 on road_network_partitioned2_cell_1091 b_42 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

59. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1049 on road_network_partitioned2_cell_1049 b_43 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

60. 0.008 0.008 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1007 on road_network_partitioned2_cell_1007 b_44 (cost=0.14..21.14 rows=50 width=10) (actual time=0.008..0.008 rows=0 loops=1)

61. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx965 on road_network_partitioned2_cell_965 b_45 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

62. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx923 on road_network_partitioned2_cell_923 b_46 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

63. 1.605 1.605 ↑ 1.0 3,107 1

Index Only Scan using road_network_partitioned2_cell_881_pkey on road_network_partitioned2_cell_881 b_47 (cost=0.28..740.84 rows=3,107 width=10) (actual time=0.023..1.605 rows=3,107 loops=1)

  • Heap Fetches: 3107
64. 1.425 1.425 ↑ 1.0 2,796 1

Index Only Scan using road_network_partitioned2_cell_839_pkey on road_network_partitioned2_cell_839 b_48 (cost=0.28..666.62 rows=2,796 width=10) (actual time=0.019..1.425 rows=2,796 loops=1)

  • Heap Fetches: 2796
65. 7.275 7.275 ↑ 1.0 13,205 1

Index Only Scan using road_network_partitioned2_cell_797_pkey on road_network_partitioned2_cell_797 b_49 (cost=0.29..3,134.95 rows=13,205 width=10) (actual time=0.018..7.275 rows=13,205 loops=1)

  • Heap Fetches: 13205
66. 14.369 14.369 ↑ 1.0 24,990 1

Index Only Scan using road_network_partitioned2_cell_755_pkey on road_network_partitioned2_cell_755 b_50 (cost=0.29..5,713.54 rows=24,990 width=10) (actual time=0.025..14.369 rows=24,990 loops=1)

  • Heap Fetches: 24990
67. 2.294 2.294 ↑ 1.0 4,367 1

Index Only Scan using road_network_partitioned2_cell_713_pkey on road_network_partitioned2_cell_713 b_51 (cost=0.28..1,003.90 rows=4,367 width=10) (actual time=0.029..2.294 rows=4,367 loops=1)

  • Heap Fetches: 4367
68. 0.043 0.043 ↑ 1.0 86 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx671 on road_network_partitioned2_cell_671 b_52 (cost=0.14..22.35 rows=86 width=10) (actual time=0.013..0.043 rows=86 loops=1)

69. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx629 on road_network_partitioned2_cell_629 b_53 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

70. 0.006 0.006 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx587 on road_network_partitioned2_cell_587 b_54 (cost=0.14..21.14 rows=50 width=10) (actual time=0.006..0.006 rows=0 loops=1)

71. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx545 on road_network_partitioned2_cell_545 b_55 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

72. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx503 on road_network_partitioned2_cell_503 b_56 (cost=0.14..21.14 rows=50 width=10) (actual time=0.002..0.002 rows=0 loops=1)

73. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx461 on road_network_partitioned2_cell_461 b_57 (cost=0.14..21.14 rows=50 width=10) (actual time=0.002..0.002 rows=0 loops=1)

74. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx419 on road_network_partitioned2_cell_419 b_58 (cost=0.14..21.14 rows=50 width=10) (actual time=0.002..0.003 rows=0 loops=1)

75. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx377 on road_network_partitioned2_cell_377 b_59 (cost=0.14..21.14 rows=50 width=10) (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_ce_link_id_street_name_road_km_idx335 on road_network_partitioned2_cell_335 b_60 (cost=0.14..21.14 rows=50 width=10) (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_ce_link_id_street_name_road_km_idx293 on road_network_partitioned2_cell_293 b_61 (cost=0.14..21.14 rows=50 width=10) (actual time=0.004..0.004 rows=0 loops=1)

78. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx251 on road_network_partitioned2_cell_251 b_62 (cost=0.14..21.14 rows=50 width=10) (actual time=0.002..0.002 rows=0 loops=1)

79. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx209 on road_network_partitioned2_cell_209 b_63 (cost=0.14..21.14 rows=50 width=10) (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_ce_link_id_street_name_road_km_idx167 on road_network_partitioned2_cell_167 b_64 (cost=0.14..21.14 rows=50 width=10) (actual time=0.002..0.003 rows=0 loops=1)

81. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx125 on road_network_partitioned2_cell_125 b_65 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)

82. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km__idx83 on road_network_partitioned2_cell_83 b_66 (cost=0.14..21.14 rows=50 width=10) (actual time=0.002..0.002 rows=0 loops=1)

83. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km__idx41 on road_network_partitioned2_cell_41 b_67 (cost=0.14..21.14 rows=50 width=10) (actual time=0.003..0.003 rows=0 loops=1)