explain.depesz.com

PostgreSQL's explain analyze made readable

Result: duFd

Settings
# exclusive inclusive rows x rows loops node
1. 0.402 46.857 ↑ 552,834.0 1 1

Append (cost=54.50..729,171.02 rows=552,834 width=24) (actual time=20.015..46.857 rows=1 loops=1)

  • Functions: 2856
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 1018.051 ms, Inlining 0.000 ms, Optimization 0.000 ms, Emission 0.000 ms, Total 1018.051 ms"Execution Time: 1611.604 ms
2. 0.002 0.018 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_0 (cost=54.50..3,011.88 rows=2,333 width=24) (actual time=0.018..0.018 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
3. 0.016 0.016 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_0_trip_id_idx (cost=0.00..53.92 rows=2,333 width=0) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
4. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_1 (cost=54.36..2,987.56 rows=2,314 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
5. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_1_trip_id_idx (cost=0.00..53.78 rows=2,314 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
6. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_2 (cost=4.44..12.30 rows=2 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
7. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_2_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
8. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_3 (cost=4.44..12.28 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
9. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_3_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
10. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_4 (cost=4.45..16.19 rows=3 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
11. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_4_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
12. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_5 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
13. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_5_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
14. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_6 (cost=48.49..2,676.28 rows=2,073 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
15. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_6_trip_id_idx (cost=0.00..47.97 rows=2,073 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
16. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_7 (cost=4.44..12.31 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
17. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_7_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
18. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_8 (cost=47.78..2,560.40 rows=1,982 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
19. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_8_trip_id_idx (cost=0.00..47.29 rows=1,982 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
20. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_9 (cost=4.45..16.20 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
21. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_9_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
22. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_10 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
23. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_10_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
24. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_11 (cost=4.44..12.29 rows=2 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
25. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_11_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
26. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_12 (cost=4.45..16.21 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
27. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_12_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
28. 0.015 0.015 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_13_trip_id_idx on road_segments_grid_partitioned_13 (cost=0.42..12.41 rows=2 width=24) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
29. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_14 (cost=37.15..2,119.01 rows=1,642 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
30. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_14_trip_id_idx (cost=0.00..36.74 rows=1,642 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
31. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_15 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
32. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_15_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
33. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_16 (cost=42.99..2,426.44 rows=1,880 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
34. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_16_trip_id_idx (cost=0.00..42.52 rows=1,880 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
35. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_17 (cost=4.45..16.17 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
36. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_17_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
37. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_18 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
38. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_18_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
39. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_19 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
40. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_19_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
41. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_20 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
42. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_20_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
43. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_21 (cost=4.45..16.17 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
44. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_21_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
45. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_22 (cost=4.45..16.17 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
46. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_22_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
47. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_23 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
48. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_23_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
49. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_24 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
50. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_24_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
51. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_25 (cost=4.45..16.20 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
52. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_25_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
53. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_26 (cost=47.78..2,558.49 rows=1,981 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
54. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_26_trip_id_idx (cost=0.00..47.28 rows=1,981 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
55. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_27 (cost=4.44..12.28 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
56. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_27_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
57. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_28 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
58. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_28_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
59. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_29 (cost=43.55..2,518.00 rows=1,952 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
60. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_29_trip_id_idx (cost=0.00..43.06 rows=1,952 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
61. 0.016 0.016 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_30_trip_id_idx on road_segments_grid_partitioned_30 (cost=0.42..16.36 rows=3 width=24) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
62. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_31 (cost=4.44..12.28 rows=2 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
63. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_31_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
64. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_32 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
65. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_32_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
66. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_33 (cost=41.94..2,252.97 rows=1,744 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
67. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_33_trip_id_idx (cost=0.00..41.50 rows=1,744 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
68. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_34 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
69. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_34_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
70. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_35 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
71. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_35_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
72. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_36 (cost=4.45..16.20 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
73. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_36_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
74. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_37 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
75. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_37_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
76. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_38 (cost=55.34..3,148.88 rows=2,441 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
77. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_38_trip_id_idx (cost=0.00..54.73 rows=2,441 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
78. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_39 (cost=47.98..2,593.68 rows=2,008 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
79. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_39_trip_id_idx (cost=0.00..47.48 rows=2,008 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
80. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_40 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
81. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_40_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
82. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_41 (cost=42.11..2,281.13 rows=1,766 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
83. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_41_trip_id_idx (cost=0.00..41.67 rows=1,766 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
84. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_42 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
85. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_42_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
86. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_43 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
87. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_43_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
88. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_44 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
89. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_44_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
90. 0.015 0.015 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_45_trip_id_idx on road_segments_grid_partitioned_45 (cost=0.42..12.41 rows=2 width=24) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
91. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_46 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
92. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_46_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
93. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_47 (cost=4.45..16.20 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
94. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_47_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
95. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_48 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
96. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_48_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
97. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_49 (cost=4.44..12.28 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
98. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_49_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
99. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_50 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
100. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_50_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
101. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_51 (cost=4.45..16.20 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
102. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_51_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
103. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_52 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
104. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_52_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
105. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_53 (cost=4.44..12.28 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
106. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_53_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
107. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_54 (cost=54.71..3,046.45 rows=2,360 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
108. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_54_trip_id_idx (cost=0.00..54.12 rows=2,360 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
109. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_55 (cost=48.98..2,756.30 rows=2,136 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
110. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_55_trip_id_idx (cost=0.00..48.44 rows=2,136 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
111. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_56 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
112. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_56_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
113. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_57 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
114. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_57_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
115. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_58 (cost=4.45..16.17 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
116. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_58_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
117. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_59 (cost=60.55..3,351.97 rows=2,597 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
118. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_59_trip_id_idx (cost=0.00..59.90 rows=2,597 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
119. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_60 (cost=37.25..2,135.02 rows=1,655 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
120. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_60_trip_id_idx (cost=0.00..36.84 rows=1,655 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
121. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_61 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
122. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_61_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
123. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_62 (cost=42.50..2,345.14 rows=1,816 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
124. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_62_trip_id_idx (cost=0.00..42.04 rows=1,816 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
125. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_63 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
126. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_63_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
127. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_64 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
128. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_64_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
129. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_65 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
130. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_65_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
131. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_66 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
132. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_66_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
133. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_67 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
134. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_67_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
135. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_68 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
136. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_68_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
137. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_69 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
138. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_69_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
139. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_70 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
140. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_70_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
141. 0.013 0.013 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_71_trip_id_idx on road_segments_grid_partitioned_71 (cost=0.42..12.36 rows=2 width=24) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
142. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_72 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
143. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_72_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
144. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_73 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
145. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_73_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
146. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_74 (cost=4.44..12.28 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
147. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_74_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
148. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_75 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
149. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_75_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
150. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_76 (cost=48.05..2,605.21 rows=2,017 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
151. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_76_trip_id_idx (cost=0.00..47.55 rows=2,017 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
152. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_77 (cost=4.45..16.20 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
153. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_77_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
154. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_78 (cost=4.45..16.22 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
155. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_78_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
156. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_79 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
157. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_79_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
158. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_80 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
159. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_80_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
160. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_81 (cost=54.00..2,928.66 rows=2,268 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
161. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_81_trip_id_idx (cost=0.00..53.43 rows=2,268 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
162. 0.012 0.012 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_82_trip_id_idx on road_segments_grid_partitioned_82 (cost=0.42..16.34 rows=3 width=24) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
163. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_83 (cost=54.66..3,037.49 rows=2,353 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
164. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_83_trip_id_idx (cost=0.00..54.07 rows=2,353 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
165. 0.010 0.010 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_84_trip_id_idx on road_segments_grid_partitioned_84 (cost=0.42..12.37 rows=2 width=24) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
166. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_85 (cost=42.78..2,389.97 rows=1,852 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
167. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_85_trip_id_idx (cost=0.00..42.31 rows=1,852 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
168. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_86 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
169. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_86_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
170. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_87 (cost=49.59..2,857.44 rows=2,215 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
171. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_87_trip_id_idx (cost=0.00..49.03 rows=2,215 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
172. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_88 (cost=48.26..2,637.86 rows=2,043 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
173. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_88_trip_id_idx (cost=0.00..47.74 rows=2,043 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
174. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_89 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
175. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_89_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
176. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_90 (cost=4.44..12.28 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
177. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_90_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
178. 0.011 0.011 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_91_trip_id_idx on road_segments_grid_partitioned_91 (cost=0.42..12.41 rows=2 width=24) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
179. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_92 (cost=4.45..16.20 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
180. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_92_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
181. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_93 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
182. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_93_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
183. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_94 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
184. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_94_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
185. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_95 (cost=4.45..16.21 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
186. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_95_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
187. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_96 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
188. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_96_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
189. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_97 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
190. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_97_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
191. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_98 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
192. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_98_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
193. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_99 (cost=4.45..16.17 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
194. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_99_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
195. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_100 (cost=4.45..16.17 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
196. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_100_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
197. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_101 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
198. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_101_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
199. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_102 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
200. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_102_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
201. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_103 (cost=4.44..12.27 rows=2 width=24) (actual time=0.005..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
202. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_103_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
203. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_104 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
204. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_104_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
205. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_105 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
206. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_105_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
207. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_106 (cost=4.45..16.17 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
208. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_106_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
209. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_107 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
210. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_107_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
211. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_108 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
212. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_108_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
213. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_109 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
214. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_109_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
215. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_110 (cost=4.44..12.31 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
216. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_110_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
217. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_111 (cost=4.45..16.17 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
218. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_111_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
219. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_112 (cost=4.45..16.20 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
220. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_112_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
221. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_113 (cost=48.37..2,657.08 rows=2,058 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
222. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_113_trip_id_idx (cost=0.00..47.86 rows=2,058 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
223. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_114 (cost=54.38..2,990.76 rows=2,317 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
224. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_114_trip_id_idx (cost=0.00..53.80 rows=2,317 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
225. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_115 (cost=42.08..2,275.37 rows=1,762 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
226. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_115_trip_id_idx (cost=0.00..41.64 rows=1,762 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
227. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_116 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
228. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_116_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
229. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_117 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
230. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_117_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
231. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_118 (cost=48.11..2,613.54 rows=2,024 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
232. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_118_trip_id_idx (cost=0.00..47.60 rows=2,024 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
233. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_119 (cost=4.45..16.20 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
234. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_119_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
235. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_120 (cost=55.00..3,093.81 rows=2,397 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
236. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_120_trip_id_idx (cost=0.00..54.40 rows=2,397 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
237. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_121 (cost=49.16..2,787.65 rows=2,160 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
238. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_121_trip_id_idx (cost=0.00..48.62 rows=2,160 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
239. 0.013 0.013 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_122_trip_id_idx on road_segments_grid_partitioned_122 (cost=0.42..12.41 rows=2 width=24) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
240. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_123 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
241. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_123_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
242. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_124 (cost=48.62..2,697.41 rows=2,090 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
243. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_124_trip_id_idx (cost=0.00..48.10 rows=2,090 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
244. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_125 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
245. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_125_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
246. 0.011 0.011 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_126_trip_id_idx on road_segments_grid_partitioned_126 (cost=0.42..12.37 rows=2 width=24) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
247. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_127 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
248. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_127_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
249. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_128 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
250. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_128_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
251. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_129 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
252. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_129_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
253. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_130 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
254. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_130_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
255. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_131 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
256. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_131_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
257. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_132 (cost=54.50..3,011.88 rows=2,333 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
258. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_132_trip_id_idx (cost=0.00..53.92 rows=2,333 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
259. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_133 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
260. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_133_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
261. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_134 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
262. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_134_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
263. 0.012 0.012 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_135_trip_id_idx on road_segments_grid_partitioned_135 (cost=0.42..12.40 rows=2 width=24) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
264. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_136 (cost=4.45..16.17 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
265. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_136_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
266. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_137 (cost=4.44..12.27 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
267. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_137_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
268. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_138 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
269. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_138_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
270. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_139 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
271. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_139_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
272. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_140 (cost=4.44..12.31 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
273. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_140_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
274. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_141 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
275. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_141_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
276. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_142 (cost=54.57..3,023.40 rows=2,342 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
277. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_142_trip_id_idx (cost=0.00..53.99 rows=2,342 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
278. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_143 (cost=42.58..2,359.22 rows=1,827 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
279. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_143_trip_id_idx (cost=0.00..42.12 rows=1,827 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
280. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_144 (cost=42.74..2,385.48 rows=1,848 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
281. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_144_trip_id_idx (cost=0.00..42.28 rows=1,848 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
282. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_145 (cost=4.44..12.31 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
283. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_145_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
284. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_146 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
285. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_146_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
286. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_147 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
287. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_147_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
288. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_148 (cost=49.26..2,802.39 rows=2,172 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
289. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_148_trip_id_idx (cost=0.00..48.71 rows=2,172 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
290. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_149 (cost=37.03..2,099.17 rows=1,627 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
291. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_149_trip_id_idx (cost=0.00..36.62 rows=1,627 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
292. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_150 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
293. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_150_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
294. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_151 (cost=4.44..12.28 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
295. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_151_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
296. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_152 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
297. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_152_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
298. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_153 (cost=49.45..2,834.40 rows=2,197 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
299. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_153_trip_id_idx (cost=0.00..48.90 rows=2,197 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
300. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_154 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
301. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_154_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
302. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_155 (cost=4.45..16.15 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
303. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_155_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
304. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_156 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
305. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_156_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
306. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_157 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
307. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_157_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
308. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_158 (cost=49.02..2,763.33 rows=2,141 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
309. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_158_trip_id_idx (cost=0.00..48.48 rows=2,141 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
310. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_159 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
311. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_159_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
312. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_160 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
313. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_160_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
314. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_161 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
315. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_161_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
316. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_162 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
317. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_162_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
318. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_163 (cost=4.45..16.22 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
319. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_163_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
320. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_164 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
321. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_164_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
322. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_165 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
323. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_165_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
324. 0.013 0.013 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_166_trip_id_idx on road_segments_grid_partitioned_166 (cost=0.42..12.42 rows=2 width=24) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
325. 0.011 0.011 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_167_trip_id_idx on road_segments_grid_partitioned_167 (cost=0.42..16.17 rows=3 width=24) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
326. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_168 (cost=4.44..12.28 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
327. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_168_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
328. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_169 (cost=42.70..2,377.80 rows=1,842 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
329. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_169_trip_id_idx (cost=0.00..42.24 rows=1,842 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
330. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_170 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
331. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_170_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
332. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_171 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
333. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_171_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
334. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_172 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
335. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_172_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
336. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_173 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
337. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_173_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
338. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_174 (cost=47.88..2,576.41 rows=1,995 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
339. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_174_trip_id_idx (cost=0.00..47.38 rows=1,995 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
340. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_175 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
341. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_175_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
342. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_176 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
343. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_176_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
344. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_177 (cost=4.44..12.31 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
345. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_177_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
346. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_178 (cost=4.45..16.21 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
347. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_178_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
348. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_179 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
349. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_179_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
350. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_180 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
351. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_180_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
352. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_181 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
353. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_181_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
354. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_182 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
355. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_182_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
356. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_183 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
357. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_183_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
358. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_184 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
359. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_184_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
360. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_185 (cost=49.62..2,862.56 rows=2,219 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
361. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_185_trip_id_idx (cost=0.00..49.06 rows=2,219 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
362. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_186 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
363. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_186_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
364. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_187 (cost=49.49..2,840.79 rows=2,202 width=24) (actual time=0.005..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
365. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_187_trip_id_idx (cost=0.00..48.94 rows=2,202 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
366. 0.012 0.012 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_188_trip_id_idx on road_segments_grid_partitioned_188 (cost=0.42..12.40 rows=2 width=24) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
367. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_189 (cost=53.99..2,928.01 rows=2,267 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
368. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_189_trip_id_idx (cost=0.00..53.42 rows=2,267 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
369. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_190 (cost=37.45..2,168.30 rows=1,681 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
370. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_190_trip_id_idx (cost=0.00..37.03 rows=1,681 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
371. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_191 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
372. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_191_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
373. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_192 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
374. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_192_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
375. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_193 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
376. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_193_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
377. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_194 (cost=49.60..2,858.72 rows=2,216 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
378. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_194_trip_id_idx (cost=0.00..49.04 rows=2,216 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
379. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_195 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
380. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_195_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
381. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_196 (cost=4.45..16.17 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
382. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_196_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
383. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_197 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
384. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_197_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
385. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_198 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
386. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_198_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
387. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_199 (cost=4.45..16.21 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
388. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_199_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
389. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_200 (cost=37.15..2,119.01 rows=1,642 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
390. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_200_trip_id_idx (cost=0.00..36.74 rows=1,642 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
391. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_201 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
392. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_201_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
393. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_202 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
394. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_202_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
395. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_203 (cost=4.45..16.20 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
396. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_203_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
397. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_204 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
398. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_204_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
399. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_205 (cost=42.81..2,396.37 rows=1,857 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
400. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_205_trip_id_idx (cost=0.00..42.35 rows=1,857 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
401. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_206 (cost=4.45..16.22 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
402. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_206_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
403. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_207 (cost=42.78..2,391.89 rows=1,853 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
404. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_207_trip_id_idx (cost=0.00..42.32 rows=1,853 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
405. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_208 (cost=4.45..16.17 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
406. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_208_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
407. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_209 (cost=42.92..2,414.93 rows=1,871 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
408. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_209_trip_id_idx (cost=0.00..42.45 rows=1,871 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
409. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_210 (cost=49.57..2,854.87 rows=2,213 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
410. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_210_trip_id_idx (cost=0.00..49.02 rows=2,213 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
411. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_211 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
412. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_211_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
413. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_212 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
414. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_212_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
415. 0.012 0.012 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_213_trip_id_idx on road_segments_grid_partitioned_213 (cost=0.42..12.36 rows=2 width=24) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
416. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_214 (cost=48.66..2,704.44 rows=2,095 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
417. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_214_trip_id_idx (cost=0.00..48.13 rows=2,095 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
418. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_215 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
419. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_215_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
420. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_216 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
421. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_216_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
422. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_217 (cost=4.45..16.20 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
423. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_217_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
424. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_218 (cost=4.45..16.17 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
425. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_218_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
426. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_219 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
427. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_219_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
428. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_220 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
429. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_220_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
430. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_221 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
431. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_221_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
432. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_222 (cost=60.25..3,302.04 rows=2,558 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
433. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_222_trip_id_idx (cost=0.00..59.61 rows=2,558 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
434. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_223 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
435. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_223_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
436. 0.011 0.011 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_224_trip_id_idx on road_segments_grid_partitioned_224 (cost=0.42..12.41 rows=2 width=24) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
437. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_225 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
438. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_225_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
439. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_226 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
440. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_226_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
441. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_227 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
442. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_227_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
443. 0.012 0.012 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_228_trip_id_idx on road_segments_grid_partitioned_228 (cost=0.42..12.40 rows=2 width=24) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
444. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_229 (cost=4.45..16.16 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
445. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_229_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
446. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_230 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
447. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_230_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
448. 0.015 0.015 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_231_trip_id_idx on road_segments_grid_partitioned_231 (cost=0.42..12.37 rows=2 width=24) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
449. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_232 (cost=4.45..16.17 rows=3 width=24) (actual time=0.006..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
450. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_232_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
451. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_233 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
452. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_233_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
453. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_234 (cost=47.47..2,509.19 rows=1,942 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
454. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_234_trip_id_idx (cost=0.00..46.99 rows=1,942 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
455. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_235 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
456. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_235_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
457. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_236 (cost=4.44..12.28 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
458. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_236_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
459. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_237 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
460. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_237_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
461. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_238 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
462. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_238_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
463. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_239 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
464. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_239_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
465. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_240 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
466. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_240_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
467. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_241 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
468. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_241_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
469. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_242 (cost=4.45..16.20 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
470. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_242_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
471. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_243 (cost=37.45..2,168.94 rows=1,681 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
472. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_243_trip_id_idx (cost=0.00..37.03 rows=1,681 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
473. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_244 (cost=49.53..2,848.48 rows=2,208 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
474. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_244_trip_id_idx (cost=0.00..48.98 rows=2,208 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
475. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_245 (cost=4.44..12.27 rows=2 width=24) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
476. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_245_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
477. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_246 (cost=4.44..12.29 rows=2 width=24) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
478. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_246_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
479. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_247 (cost=4.44..12.30 rows=2 width=24) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
480. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_247_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
481. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_248 (cost=4.45..16.21 rows=3 width=24) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
482. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_248_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
483. 0.001 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_249 (cost=4.45..16.19 rows=3 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
484. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_249_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
485. 0.001 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_250 (cost=4.45..16.19 rows=3 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
486. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_250_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
487. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_251 (cost=4.45..16.20 rows=3 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
488. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_251_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
489. 0.002 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_252 (cost=43.35..2,484.70 rows=1,926 width=24) (actual time=0.006..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
490. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_252_trip_id_idx (cost=0.00..42.87 rows=1,926 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
491. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_253 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
492. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_253_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
493. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_254 (cost=43.09..2,441.18 rows=1,892 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
494. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_254_trip_id_idx (cost=0.00..42.61 rows=1,892 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
495. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_255 (cost=4.45..16.16 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
496. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_255_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
497. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_256 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
498. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_256_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
499. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_257 (cost=4.45..16.17 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
500. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_257_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
501. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_258 (cost=42.78..2,391.25 rows=1,853 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
502. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_258_trip_id_idx (cost=0.00..42.32 rows=1,853 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
503. 0.001 0.010 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_259 (cost=4.44..12.29 rows=2 width=24) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
504. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_259_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
505. 0.002 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_260 (cost=4.44..12.31 rows=2 width=24) (actual time=0.008..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
506. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_260_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
507. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_261 (cost=4.44..12.30 rows=2 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
508. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_261_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
509. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_262 (cost=4.44..12.29 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
510. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_262_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
511. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_263 (cost=54.46..3,004.19 rows=2,327 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
512. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_263_trip_id_idx (cost=0.00..53.88 rows=2,327 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
513. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_264 (cost=49.46..2,836.95 rows=2,199 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
514. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_264_trip_id_idx (cost=0.00..48.91 rows=2,199 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
515. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_265 (cost=48.70..2,710.84 rows=2,100 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
516. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_265_trip_id_idx (cost=0.00..48.17 rows=2,100 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
517. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_266 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
518. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_266_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
519. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_267 (cost=4.45..16.20 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
520. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_267_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
521. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_268 (cost=4.45..16.20 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
522. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_268_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
523. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_269 (cost=55.52..3,178.96 rows=2,464 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
524. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_269_trip_id_idx (cost=0.00..54.90 rows=2,464 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
525. 0.013 0.013 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_270_trip_id_idx on road_segments_grid_partitioned_270 (cost=0.42..16.29 rows=3 width=24) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
526. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_271 (cost=48.27..2,640.43 rows=2,045 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
527. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_271_trip_id_idx (cost=0.00..47.76 rows=2,045 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
528. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_272 (cost=4.45..16.20 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
529. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_272_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
530. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_273 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
531. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_273_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
532. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_274 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
533. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_274_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
534. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_275 (cost=4.45..16.17 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
535. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_275_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
536. 0.011 0.011 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_276_trip_id_idx on road_segments_grid_partitioned_276 (cost=0.42..12.39 rows=2 width=24) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
537. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_277 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
538. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_277_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
539. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_278 (cost=42.79..2,393.16 rows=1,854 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
540. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_278_trip_id_idx (cost=0.00..42.33 rows=1,854 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
541. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_279 (cost=4.45..16.20 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
542. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_279_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
543. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_280 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
544. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_280_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
545. 0.012 0.012 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_281_trip_id_idx on road_segments_grid_partitioned_281 (cost=0.42..16.31 rows=3 width=24) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
546. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_282 (cost=4.45..16.17 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
547. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_282_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
548. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_283 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
549. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_283_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
550. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_284 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
551. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_284_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
552. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_285 (cost=49.31..2,811.35 rows=2,179 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
553. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_285_trip_id_idx (cost=0.00..48.77 rows=2,179 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
554. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_286 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
555. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_286_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
556. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_287 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
557. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_287_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
558. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_288 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
559. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_288_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
560. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_289 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
561. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_289_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
562. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_290 (cost=4.45..16.20 rows=3 width=24) (actual time=0.005..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
563. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_290_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
564. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_291 (cost=4.44..12.27 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
565. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_291_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
566. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_292 (cost=49.29..2,808.79 rows=2,177 width=24) (actual time=0.004..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
567. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_292_trip_id_idx (cost=0.00..48.75 rows=2,177 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
568. 0.014 0.014 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_293_trip_id_idx on road_segments_grid_partitioned_293 (cost=0.42..12.40 rows=2 width=24) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
569. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_294 (cost=4.45..16.17 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
570. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_294_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
571. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_295 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
572. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_295_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
573. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_296 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
574. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_296_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
575. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_297 (cost=59.85..3,237.37 rows=2,507 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
576. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_297_trip_id_idx (cost=0.00..59.22 rows=2,507 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
577. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_298 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
578. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_298_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
579. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_299 (cost=4.45..16.20 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
580. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_299_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
581. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_300 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
582. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_300_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
583. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_301 (cost=4.44..12.28 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
584. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_301_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
585. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_302 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
586. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_302_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
587. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_303 (cost=4.45..16.20 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
588. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_303_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
589. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_304 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
590. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_304_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
591. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_305 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
592. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_305_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
593. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_306 (cost=48.16..2,622.50 rows=2,031 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
594. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_306_trip_id_idx (cost=0.00..47.66 rows=2,031 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
595. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_307 (cost=42.98..2,423.26 rows=1,878 width=24) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
596. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_307_trip_id_idx (cost=0.00..42.51 rows=1,878 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
597. 0.001 0.010 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_308 (cost=4.44..12.28 rows=2 width=24) (actual time=0.009..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
598. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_308_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
599. 0.016 0.016 ↓ 0.0 0 1

Index Scan using road_segments_grid_partitioned_309_trip_id_idx on road_segments_grid_partitioned_309 (cost=0.42..12.43 rows=2 width=24) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
600. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_310 (cost=4.45..16.20 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
601. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_310_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
602. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_311 (cost=54.46..3,004.19 rows=2,327 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
603. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_311_trip_id_idx (cost=0.00..53.88 rows=2,327 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
604. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_312 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
605. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_312_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
606. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_313 (cost=54.63..3,033.64 rows=2,350 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
607. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_313_trip_id_idx (cost=0.00..54.05 rows=2,350 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
608. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_314 (cost=4.45..16.20 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
609. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_314_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
610. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_315 (cost=48.36..2,655.79 rows=2,057 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
611. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_315_trip_id_idx (cost=0.00..47.85 rows=2,057 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
612. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_316 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
613. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_316_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
614. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_317 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
615. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_317_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
616. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_318 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
617. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_318_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
618. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_319 (cost=54.89..3,075.89 rows=2,383 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
619. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_319_trip_id_idx (cost=0.00..54.30 rows=2,383 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
620. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_320 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
621. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_320_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
622. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_321 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
623. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_321_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
624. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_322 (cost=4.45..16.21 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
625. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_322_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
626. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_323 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
627. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_323_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
628. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_324 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
629. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_324_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
630. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_325 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
631. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_325_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
632. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_326 (cost=4.45..16.19 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
633. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_326_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
634. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_327 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
635. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_327_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
636. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_328 (cost=4.45..16.20 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
637. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_328_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
638. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_329 (cost=4.45..16.18 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
639. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_329_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
640. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_330 (cost=4.44..12.28 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
641. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_330_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
642. 0.002 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_331 (cost=49.32..2,812.63 rows=2,180 width=24) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
643. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_331_trip_id_idx (cost=0.00..48.77 rows=2,180 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
644. 0.002 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_332 (cost=4.45..16.17 rows=3 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
645. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_332_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
646. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_333 (cost=4.44..12.30 rows=2 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
647. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_333_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
648. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_334 (cost=4.44..12.31 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
649. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_334_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
650. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_335 (cost=48.09..2,611.61 rows=2,022 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
651. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_335_trip_id_idx (cost=0.00..47.59 rows=2,022 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
652. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_336 (cost=55.26..3,136.71 rows=2,431 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
653. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_336_trip_id_idx (cost=0.00..54.66 rows=2,431 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
654. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_337 (cost=4.44..12.29 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
655. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_337_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
656. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_338 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
657. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_338_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
658. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_339 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
659. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_339_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
660. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_340 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
661. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_340_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
662. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_341 (cost=4.45..16.19 rows=3 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
663. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_341_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
664. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_342 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
665. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_342_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
666. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_343 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
667. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_343_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
668. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_344 (cost=42.65..2,370.12 rows=1,836 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
669. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_344_trip_id_idx (cost=0.00..42.19 rows=1,836 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
670. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_345 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
671. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_345_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
672. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_346 (cost=4.44..12.30 rows=2 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
673. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_346_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
674. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_347 (cost=4.44..12.30 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
675. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_347_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
676. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_348 (cost=4.44..12.28 rows=2 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
677. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_348_trip_id_idx (cost=0.00..4.44 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
678. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_349 (cost=4.45..16.18 rows=3 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
679. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_349_trip_id_idx (cost=0.00..4.45 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
680. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on road_segments_grid_partitioned_350 (cost=55.39..3,159.10 rows=2,448 width=24) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 1)
681. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on road_segments_grid_partitioned_350_trip_id_idx (cost=0.00..54.78 rows=2,448 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 1)
682. 0.000 0.005 ↓ 0.0 0 1