explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gv3F

Settings
# exclusive inclusive rows x rows loops node
1. 1.242 6.985 ↓ 13.3 3,391 1

Merge Join (cost=1,315.64..1,366.16 rows=255 width=26) (actual time=5.340..6.985 rows=3,391 loops=1)

  • Merge Cond: ((road_network_partitioned2_cell_84.link_id = road_network_partitioned3_cell_84.link_id) AND (road_network_partitioned2_cell_84.lon = road_network_partitioned3_cell_84.lon))
2. 1.438 2.937 ↓ 1.0 3,391 1

Sort (cost=659.27..667.65 rows=3,352 width=26) (actual time=2.738..2.937 rows=3,391 loops=1)

  • Sort Key: road_network_partitioned2_cell_84.link_id, road_network_partitioned2_cell_84.lon
  • Sort Method: quicksort Memory: 355kB
3. 0.247 1.499 ↓ 1.0 3,391 1

Append (cost=0.14..463.00 rows=3,352 width=26) (actual time=0.166..1.499 rows=3,391 loops=1)

4. 0.011 0.011 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
5. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
6. 0.007 0.007 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
7. 0.010 0.010 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
8. 0.007 0.007 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
9. 0.007 0.007 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
10. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
11. 0.011 0.011 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
12. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
13. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
14. 0.009 0.009 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
15. 0.007 0.007 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
16. 0.013 0.013 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
17. 0.007 0.007 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
18. 0.007 0.007 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
19. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
20. 0.007 0.007 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
21. 0.010 0.010 ↓ 0.0 0 1

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

  • Index Cond: (lat = '-12'::integer)
22. 0.390 0.390 ↑ 1.0 1,374 1

Seq Scan on road_network_partitioned2_cell_102 (cost=0.00..52.17 rows=1,374 width=24) (actual time=0.012..0.390 rows=1,374 loops=1)

  • Filter: (lat = '-12'::integer)
23. 0.381 0.381 ↑ 1.0 1,303 1

Seq Scan on road_network_partitioned2_cell_103 (cost=0.00..53.29 rows=1,303 width=23) (actual time=0.015..0.381 rows=1,303 loops=1)

  • Filter: (lat = '-12'::integer)
24. 0.082 0.082 ↑ 1.0 264 1

Seq Scan on road_network_partitioned2_cell_104 (cost=0.00..13.30 rows=264 width=23) (actual time=0.010..0.082 rows=264 loops=1)

  • Filter: (lat = '-12'::integer)
25. 0.013 0.013 ↓ 19.0 19 1

Seq Scan on road_network_partitioned2_cell_105 (cost=0.00..10.62 rows=1 width=230) (actual time=0.007..0.013 rows=19 loops=1)

  • Filter: (lat = '-12'::integer)
26. 0.039 0.039 ↑ 1.0 115 1

Seq Scan on road_network_partitioned2_cell_106 (cost=0.00..6.44 rows=115 width=31) (actual time=0.009..0.039 rows=115 loops=1)

  • Filter: (lat = '-12'::integer)
27. 0.033 0.033 ↑ 1.0 95 1

Seq Scan on road_network_partitioned2_cell_107 (cost=0.00..6.19 rows=95 width=27) (actual time=0.006..0.033 rows=95 loops=1)

  • Filter: (lat = '-12'::integer)
28. 0.021 0.021 ↑ 1.0 65 1

Seq Scan on road_network_partitioned2_cell_108 (cost=0.00..3.81 rows=65 width=30) (actual time=0.007..0.021 rows=65 loops=1)

  • Filter: (lat = '-12'::integer)
29. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on road_network_partitioned2_cell_109 (cost=0.00..10.62 rows=1 width=230) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (lat = '-12'::integer)
30. 0.012 0.012 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_110_pkey on road_network_partitioned2_cell_110 (cost=0.14..8.53 rows=1 width=230) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
31. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_111_pkey on road_network_partitioned2_cell_111 (cost=0.14..8.53 rows=1 width=230) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
32. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_112_pkey on road_network_partitioned2_cell_112 (cost=0.14..8.53 rows=1 width=230) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
33. 0.035 0.035 ↑ 1.0 101 1

Seq Scan on road_network_partitioned2_cell_113 (cost=0.00..4.26 rows=101 width=26) (actual time=0.007..0.035 rows=101 loops=1)

  • Filter: (lat = '-12'::integer)
34. 0.020 0.020 ↓ 55.0 55 1

Seq Scan on road_network_partitioned2_cell_114 (cost=0.00..10.62 rows=1 width=230) (actual time=0.006..0.020 rows=55 loops=1)

  • Filter: (lat = '-12'::integer)
35. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on road_network_partitioned2_cell_115 (cost=0.00..10.62 rows=1 width=230) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (lat = '-12'::integer)
36. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_116_pkey on road_network_partitioned2_cell_116 (cost=0.14..8.53 rows=1 width=230) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
37. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_117_pkey on road_network_partitioned2_cell_117 (cost=0.14..8.53 rows=1 width=230) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
38. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_118_pkey on road_network_partitioned2_cell_118 (cost=0.14..8.53 rows=1 width=230) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
39. 0.002 0.002 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_119_pkey on road_network_partitioned2_cell_119 (cost=0.14..8.53 rows=1 width=230) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
40. 0.010 0.010 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_120_pkey on road_network_partitioned2_cell_120 (cost=0.14..8.53 rows=1 width=230) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
41. 0.008 0.008 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_121_pkey on road_network_partitioned2_cell_121 (cost=0.14..8.53 rows=1 width=230) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
42. 0.007 0.007 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_122_pkey on road_network_partitioned2_cell_122 (cost=0.14..8.53 rows=1 width=230) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
43. 0.009 0.009 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_123_pkey on road_network_partitioned2_cell_123 (cost=0.14..8.53 rows=1 width=230) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
44. 0.007 0.007 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_124_pkey on road_network_partitioned2_cell_124 (cost=0.14..8.53 rows=1 width=230) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
45. 0.007 0.007 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_125_pkey on road_network_partitioned2_cell_125 (cost=0.14..8.53 rows=1 width=230) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
46. 1.290 2.806 ↓ 1.1 3,391 1

Sort (cost=656.37..663.98 rows=3,044 width=12) (actual time=2.598..2.806 rows=3,391 loops=1)

  • Sort Key: road_network_partitioned3_cell_84.link_id, road_network_partitioned3_cell_84.lon
  • Sort Method: quicksort Memory: 255kB
47. 0.236 1.516 ↓ 1.1 3,391 1

Append (cost=0.14..480.24 rows=3,044 width=12) (actual time=0.223..1.516 rows=3,391 loops=1)

48. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_84_pkey on road_network_partitioned3_cell_84 (cost=0.14..8.53 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
49. 0.012 0.012 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_85_pkey on road_network_partitioned3_cell_85 (cost=0.14..8.53 rows=1 width=12) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
50. 0.020 0.020 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_86_pkey on road_network_partitioned3_cell_86 (cost=0.14..8.53 rows=1 width=12) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
51. 0.013 0.013 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_87_pkey on road_network_partitioned3_cell_87 (cost=0.14..8.53 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
52. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_88_pkey on road_network_partitioned3_cell_88 (cost=0.14..8.53 rows=1 width=12) (actual time=0.009..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
53. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_89_pkey on road_network_partitioned3_cell_89 (cost=0.14..8.53 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
54. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_90_pkey on road_network_partitioned3_cell_90 (cost=0.14..8.53 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
55. 0.013 0.013 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_91_pkey on road_network_partitioned3_cell_91 (cost=0.14..8.53 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
56. 0.013 0.013 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_92_pkey on road_network_partitioned3_cell_92 (cost=0.14..8.53 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
57. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_93_pkey on road_network_partitioned3_cell_93 (cost=0.14..8.53 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
58. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_94_pkey on road_network_partitioned3_cell_94 (cost=0.14..8.53 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
59. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_95_pkey on road_network_partitioned3_cell_95 (cost=0.14..8.53 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
60. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_96_pkey on road_network_partitioned3_cell_96 (cost=0.14..8.53 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
61. 0.015 0.015 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_97_pkey on road_network_partitioned3_cell_97 (cost=0.14..8.53 rows=1 width=12) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
62. 0.012 0.012 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_98_pkey on road_network_partitioned3_cell_98 (cost=0.14..8.53 rows=1 width=12) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
63. 0.014 0.014 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_99_pkey on road_network_partitioned3_cell_99 (cost=0.14..8.53 rows=1 width=12) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
64. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_100_pkey on road_network_partitioned3_cell_100 (cost=0.14..8.53 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
65. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_101_pkey on road_network_partitioned3_cell_101 (cost=0.14..8.53 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
66. 0.331 0.331 ↑ 1.0 1,374 1

Seq Scan on road_network_partitioned3_cell_102 (cost=0.00..52.17 rows=1,374 width=12) (actual time=0.008..0.331 rows=1,374 loops=1)

  • Filter: (lat = '-12'::integer)
67. 0.334 0.334 ↑ 1.0 1,303 1

Seq Scan on road_network_partitioned3_cell_103 (cost=0.00..52.29 rows=1,303 width=12) (actual time=0.008..0.334 rows=1,303 loops=1)

  • Filter: (lat = '-12'::integer)
68. 0.083 0.083 ↑ 1.0 264 1

Seq Scan on road_network_partitioned3_cell_104 (cost=0.00..22.30 rows=264 width=12) (actual time=0.015..0.083 rows=264 loops=1)

  • Filter: (lat = '-12'::integer)
69. 0.017 0.017 ↓ 19.0 19 1

Seq Scan on road_network_partitioned3_cell_105 (cost=0.00..10.62 rows=1 width=12) (actual time=0.012..0.017 rows=19 loops=1)

  • Filter: (lat = '-12'::integer)
70. 0.042 0.042 ↓ 115.0 115 1

Seq Scan on road_network_partitioned3_cell_106 (cost=0.00..10.62 rows=1 width=12) (actual time=0.010..0.042 rows=115 loops=1)

  • Filter: (lat = '-12'::integer)
71. 0.028 0.028 ↓ 95.0 95 1

Seq Scan on road_network_partitioned3_cell_107 (cost=0.00..10.62 rows=1 width=12) (actual time=0.005..0.028 rows=95 loops=1)

  • Filter: (lat = '-12'::integer)
72. 0.021 0.021 ↑ 1.0 65 1

Seq Scan on road_network_partitioned3_cell_108 (cost=0.00..3.81 rows=65 width=12) (actual time=0.006..0.021 rows=65 loops=1)

  • Filter: (lat = '-12'::integer)
73. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_109_pkey on road_network_partitioned3_cell_109 (cost=0.14..8.53 rows=1 width=12) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
74. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_110_pkey on road_network_partitioned3_cell_110 (cost=0.14..8.53 rows=1 width=12) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
75. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_111_pkey on road_network_partitioned3_cell_111 (cost=0.14..8.53 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
76. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_112_pkey on road_network_partitioned3_cell_112 (cost=0.14..8.53 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
77. 0.030 0.030 ↓ 101.0 101 1

Seq Scan on road_network_partitioned3_cell_113 (cost=0.00..10.62 rows=1 width=12) (actual time=0.007..0.030 rows=101 loops=1)

  • Filter: (lat = '-12'::integer)
78. 0.024 0.024 ↓ 55.0 55 1

Seq Scan on road_network_partitioned3_cell_114 (cost=0.00..10.62 rows=1 width=12) (actual time=0.010..0.024 rows=55 loops=1)

  • Filter: (lat = '-12'::integer)
79. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_115_pkey on road_network_partitioned3_cell_115 (cost=0.14..8.53 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
80. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_116_pkey on road_network_partitioned3_cell_116 (cost=0.14..8.53 rows=1 width=12) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
81. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_117_pkey on road_network_partitioned3_cell_117 (cost=0.14..8.53 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
82. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_118_pkey on road_network_partitioned3_cell_118 (cost=0.14..8.53 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
83. 0.013 0.013 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_119_pkey on road_network_partitioned3_cell_119 (cost=0.14..8.53 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
84. 0.012 0.012 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_120_pkey on road_network_partitioned3_cell_120 (cost=0.14..8.53 rows=1 width=12) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
85. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_121_pkey on road_network_partitioned3_cell_121 (cost=0.14..8.53 rows=1 width=12) (actual time=0.010..0.011 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
86. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_122_pkey on road_network_partitioned3_cell_122 (cost=0.14..8.53 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
87. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_123_pkey on road_network_partitioned3_cell_123 (cost=0.14..8.53 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
88. 0.013 0.013 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_124_pkey on road_network_partitioned3_cell_124 (cost=0.14..8.53 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
89. 0.014 0.014 ↓ 0.0 0 1

Index Only Scan using road_network_partitioned3_cell_125_pkey on road_network_partitioned3_cell_125 (cost=0.14..8.53 rows=1 width=12) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (lat = '-12'::integer)
  • Heap Fetches: 0
Planning time : 27.413 ms