explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Ze3

Settings
# exclusive inclusive rows x rows loops node
1. 0.399 12.432 ↑ 138,208.5 4 1

Append (cost=54.50..729,171.02 rows=552,834 width=24) (actual time=11.011..12.432 rows=4 loops=1)

  • Functions: 2856
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 315.116 ms, Inlining 0.000 ms, Optimization 0.000 ms, Emission 0.000 ms, Total 315.116 ms"Execution Time: 535.515 ms
2. 0.002 0.024 ↓ 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.024..0.024 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
3. 0.022 0.022 ↓ 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.022..0.022 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
4. 0.000 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
5. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
6. 0.000 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
7. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
8. 0.000 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
9. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
10. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
11. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
12. 0.000 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
13. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
14. 0.000 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
15. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
16. 0.001 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
17. 0.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
18. 0.001 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
19. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
20. 0.001 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
21. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
22. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
23. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
24. 0.001 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
25. 0.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
26. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
27. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
28. 0.019 0.019 ↓ 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.019..0.019 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
29. 0.001 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
30. 0.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
31. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
32. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
33. 0.000 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
34. 0.008 0.008 ↓ 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.007..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
35. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
36. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
37. 0.000 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
38. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
39. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
40. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
41. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
42. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
43. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
44. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
45. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
46. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
47. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
48. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
49. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
50. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
51. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
52. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
53. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
54. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
55. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
56. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
57. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
58. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
59. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
60. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
61. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
62. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
63. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
64. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
65. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
66. 0.000 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
67. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
68. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
69. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
70. 0.004 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
71. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
72. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
73. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
74. 0.003 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
75. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
76. 0.000 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
77. 0.009 0.009 ↓ 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.008..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
78. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
79. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
80. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
81. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
82. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
83. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
84. 0.001 0.008 ↓ 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.007..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
85. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
86. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
87. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
88. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
89. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
90. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
91. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
92. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
93. 0.001 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
94. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
95. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
96. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
97. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
98. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
99. 0.000 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
100. 0.008 0.008 ↓ 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.007..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
101. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
102. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
103. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
104. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
105. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
106. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
107. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
108. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
109. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
110. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
111. 0.000 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
112. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
113. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
114. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
115. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
116. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
117. 0.000 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
118. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
119. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
120. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
121. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
122. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
123. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
124. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
125. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
126. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
127. 0.001 0.007 ↓ 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.006..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
128. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
129. 0.000 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
130. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
131. 0.000 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
132. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
133. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
134. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
135. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
136. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
137. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
138. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
139. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
140. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
141. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
142. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
143. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
144. 0.000 0.017 ↓ 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.017..0.017 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
145. 0.017 0.017 ↓ 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.017..0.017 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
146. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
147. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
148. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
149. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
150. 0.001 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
151. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
152. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
153. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
154. 0.001 0.008 ↓ 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.007..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
155. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
156. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
157. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
158. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
159. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
160. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
161. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
162. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
163. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
164. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
165. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
166. 0.000 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
167. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
168. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
169. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
170. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
171. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
172. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
173. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
174. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
175. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
176. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
177. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
178. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
179. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
180. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
181. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
182. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
183. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
184. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
185. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
186. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
187. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
188. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
189. 0.000 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
190. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
191. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
192. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
193. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
194. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
195. 0.000 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
196. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
197. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
198. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
199. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
200. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
201. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
202. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
203. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
204. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
205. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
206. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
207. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
208. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
209. 0.000 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
210. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
211. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
212. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
213. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
214. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
215. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
216. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
217. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
218. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
219. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
220. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
221. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
222. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
223. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
224. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
225. 0.001 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
226. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
227. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
228. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
229. 0.001 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
230. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
231. 0.001 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
232. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
233. 0.001 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
234. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
235. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
236. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
237. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
238. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
239. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
240. 0.001 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
241. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
242. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
243. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
244. 0.000 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
245. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
246. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
247. 0.000 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
248. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
249. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
250. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
251. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
252. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
253. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
254. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
255. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
256. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
257. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
258. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
259. 0.001 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
260. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
261. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
262. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
263. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
264. 0.001 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
265. 0.015 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
266. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
267. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
268. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
269. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
270. 0.000 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
271. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
272. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
273. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
274. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
275. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
276. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
277. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
278. 0.000 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
279. 0.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
280. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
281. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
282. 0.000 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
283. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
284. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
285. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
286. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
287. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
288. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
289. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
290. 0.001 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
291. 0.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
292. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
293. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
294. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
295. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
296. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
297. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
298. 0.000 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
299. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
300. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
301. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
302. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
303. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
304. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
305. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
306. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
307. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
308. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
309. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
310. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
311. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
312. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
313. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
314. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
315. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
316. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
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.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
318. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
319. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
320. 0.000 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 = 200)
321. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
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 = 200)
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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
324. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
325. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
326. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
327. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
328. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
329. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
330. 0.000 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
331. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
332. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
333. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
334. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
335. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
336. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
337. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
338. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
339. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
340. 0.000 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
341. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
342. 0.001 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
343. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
344. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
345. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
346. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
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 = 200)
348. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
349. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
350. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
351. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
352. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
353. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
354. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
355. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
356. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
357. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
358. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
359. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
360. 0.000 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 = 200)
361. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
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 = 200)
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 = 200)
364. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
365. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
366. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
367. 0.000 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 = 200)
368. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
369. 0.001 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
370. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
371. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
372. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
373. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
374. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
375. 0.000 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
376. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
377. 0.001 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
378. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
379. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
380. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
381. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
382. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
383. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
384. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
385. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
386. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
387. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
388. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
389. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
390. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
391. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
392. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
393. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
394. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
395. 0.000 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 = 200)
396. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
397. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
398. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
399. 0.001 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
400. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
401. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
402. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
403. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
404. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
405. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
406. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
407. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
408. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
409. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
410. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
411. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
412. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
413. 0.001 0.007 ↓ 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.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
414. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
415. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
416. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
417. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
418. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
419. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
420. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
421. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
422. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
423. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
424. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
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 = 200)
426. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
427. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
428. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
429. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
430. 0.000 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
431. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
432. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
433. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
434. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
435. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
436. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
437. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
438. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
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 = 200)
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 = 200)
441. 0.001 0.037 ↓ 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.037..0.037 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
442. 0.036 0.036 ↓ 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.036..0.036 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
443. 0.009 0.009 ↓ 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.008..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
444. 0.001 0.018 ↓ 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.018..0.018 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
445. 0.017 0.017 ↓ 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.017..0.017 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
446. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
447. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
448. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
449. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
450. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
451. 0.000 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
452. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
453. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
454. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
455. 0.001 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
456. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
457. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
458. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
459. 0.000 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 = 200)
460. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
461. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
462. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
463. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
464. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
465. 0.001 0.008 ↓ 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.007..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
466. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
467. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
468. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
469. 0.001 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
470. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
471. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
472. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
473. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
474. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
475. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
476. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
477. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
478. 0.006 0.006 ↓ 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.005..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
479. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
480. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
481. 0.001 0.007 ↓ 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.006..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
482. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
483. 0.001 0.007 ↓ 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.006..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
484. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
485. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
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 = 200)
487. 0.000 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
488. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
489. 0.001 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
490. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
491. 0.001 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 = 200)
492. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
493. 0.000 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
494. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
495. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
496. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
497. 0.001 0.007 ↓ 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.006..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
498. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
499. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
500. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
501. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
502. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
503. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
504. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
505. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
506. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
507. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
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 = 200)
509. 0.000 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
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 = 200)
511. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
512. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
513. 0.001 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
514. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
515. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
516. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
517. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
518. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
519. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
520. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
521. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
522. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
523. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
524. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
525. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
526. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
527. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
528. 0.000 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
529. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
530. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
531. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
532. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
533. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
534. 0.001 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
535. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
536. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
537. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
538. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
539. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
540. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
541. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
542. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
543. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
544. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
545. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
546. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
547. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
548. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
549. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
550. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
551. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
552. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
553. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
554. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
555. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
556. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
557. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
558. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
559. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
560. 0.001 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
561. 0.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
562. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
563. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
564. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
565. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
566. 0.001 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
567. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
568. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
569. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
570. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
571. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
572. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
573. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
574. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
575. 0.001 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
576. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
577. 0.000 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
578. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
579. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
580. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
581. 0.004 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
582. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
583. 0.001 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
584. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
585. 0.003 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
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 = 200)
587. 0.001 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
588. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
589. 0.001 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
590. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
591. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
592. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
593. 0.001 0.009 ↓ 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.008..0.009 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
594. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
595. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
596. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
597. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
598. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
599. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
600. 0.000 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
601. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
602. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
603. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
604. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
605. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
606. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
607. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
608. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
609. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
610. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
611. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
612. 0.000 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
613. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
614. 0.001 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
615. 0.015 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
616. 0.004 0.015 ↓ 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.014..0.015 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
617. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
618. 0.001 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
619. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
620. 0.003 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
621. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
622. 0.001 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
623. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
624. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
625. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
626. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
627. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
628. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
629. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
630. 0.002 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
631. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
632. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
633. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
634. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
635. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
636. 0.000 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
637. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
638. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
639. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
640. 0.000 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 = 200)
641. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
642. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
643. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
644. 0.001 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 = 200)
645. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
646. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
647. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
648. 0.001 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
649. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
650. 0.000 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
651. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
652. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
653. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
654. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
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 = 200)
656. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
657. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
658. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
659. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
660. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
661. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
662. 0.001 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
663. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
664. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
665. 0.007 0.007 ↓ 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.006..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
666. 0.000 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
667. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
668. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
669. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
670. 0.001 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
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 = 200)
672. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
673. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
674. 0.001 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
675. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
676. 0.001 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
677. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
678. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Recheck Cond: (trip_id = 200)
679. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (trip_id = 200)
680. 0.000 0.007 ↓ 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.007..0.007 rows=0 loops=1)

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