explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CWKm : delivery analytics_with_arguments

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.327 38,950.410 ↑ 1.0 1 1

Aggregate (cost=3,088.39..3,088.40 rows=1 width=16) (actual time=38,950.408..38,950.410 rows=1 loops=1)

  • Buffers: shared hit=605 read=156236
  • I/O Timings: read=155055.860
2. 0.453 38,950.083 ↑ 1.0 1,000 1

Limit (cost=1,007.88..3,073.39 rows=1,000 width=8) (actual time=178.709..38,950.083 rows=1,000 loops=1)

  • Buffers: shared hit=605 read=156236
  • I/O Timings: read=155055.860
3.          

Initplan (forLimit)

4. 0.009 0.009 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=1)

5. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1)

6. 12,623.783 38,949.619 ↑ 1,332.0 1,000 1

Gather (cost=1,007.84..2,752,290.76 rows=1,332,007 width=8) (actual time=178.707..38,949.619 rows=1,000 loops=1)

  • Workers Planned: 6
  • Params Evaluated: $0, $1
  • Workers Launched: 6
  • Buffers: shared hit=605 read=156236
  • I/O Timings: read=155055.860
7. 0.067 26,325.836 ↑ 9,250.0 144 7

Subquery Scan on bml_vbase_delivery_analytics (cost=7.84..2,618,090.06 rows=1,332,007 width=8) (actual time=26,323.382..26,325.836 rows=144 loops=7)

  • Filter: (bml_vbase_delivery_analytics.esme ~~ '%'::text)
  • Buffers: shared hit=605 read=156236
  • I/O Timings: read=155055.860
8. 0.232 26,325.769 ↑ 154,259.7 144 7

Result (cost=7.84..2,601,438.31 rows=22,213,400 width=368) (actual time=26,323.379..26,325.769 rows=144 loops=7)

  • Buffers: shared hit=605 read=156236
  • I/O Timings: read=155055.860
9. 1.905 26,325.537 ↑ 154,259.7 144 7

ProjectSet (cost=7.84..435,631.81 rows=22,213,400 width=264) (actual time=26,323.367..26,325.537 rows=144 loops=7)

  • Buffers: shared hit=605 read=156236
  • I/O Timings: read=155055.860
10. 0.000 26,323.632 ↑ 2,199.3 101 7

Parallel Append (cost=7.84..310,126.10 rows=222,134 width=1,245) (actual time=26,323.283..26,323.632 rows=101 loops=7)

  • Buffers: shared hit=605 read=156236
  • I/O Timings: read=155055.860
11. 0.014 32.906 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1548021600 d_593 (cost=9.09..5,709.14 rows=1,930 width=1,241) (actual time=32.906..32.906 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=43 read=7
  • I/O Timings: read=32.313
12. 32.892 32.892 ↓ 0.0 0 1

Bitmap Index Scan on brin_delivery_1548021600_endtime_idx (cost=0.00..7.93 rows=5,296 width=0) (actual time=32.892..32.892 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=43 read=7
  • I/O Timings: read=32.313
13. 0.018 25.741 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546984800 d_581 (cost=9.02..4,890.09 rows=1,880 width=1,247) (actual time=25.741..25.741 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=44 read=6
  • I/O Timings: read=25.079
14. 25.723 25.723 ↓ 0.0 0 1

Bitmap Index Scan on brin_delivery_1546984800_endtime_idx (cost=0.00..7.90 rows=4,520 width=0) (actual time=25.723..25.723 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=44 read=6
  • I/O Timings: read=25.079
15. 0.023 19.398 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546812000 d_579 (cost=9.02..4,892.19 rows=1,878 width=1,244) (actual time=19.398..19.398 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=44 read=6
  • I/O Timings: read=18.806
16. 19.375 19.375 ↓ 0.0 0 1

Bitmap Index Scan on brin_delivery_1546812000_endtime_idx (cost=0.00..7.90 rows=4,522 width=0) (actual time=19.375..19.375 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=44 read=6
  • I/O Timings: read=18.806
17. 0.015 27.516 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546898400 d_580 (cost=9.02..4,883.48 rows=1,874 width=1,247) (actual time=27.516..27.516 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=44 read=6
  • I/O Timings: read=26.897
18. 27.501 27.501 ↓ 0.0 0 1

Bitmap Index Scan on brin_delivery_1546898400_endtime_idx (cost=0.00..7.90 rows=4,514 width=0) (actual time=27.501..27.501 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=44 read=6
  • I/O Timings: read=26.897
19. 0.019 22.717 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1547071200 d_582 (cost=7.89..4,902.86 rows=1,822 width=1,241) (actual time=22.717..22.717 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=44 read=5
  • I/O Timings: read=22.195
20. 22.698 22.698 ↓ 0.0 0 1

Bitmap Index Scan on brin_delivery_1547071200_endtime_idx (cost=0.00..6.80 rows=4,537 width=0) (actual time=22.698..22.698 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=44 read=5
  • I/O Timings: read=22.195
21. 0.016 34.879 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546639200 d_577 (cost=7.84..4,877.08 rows=1,730 width=1,247) (actual time=34.879..34.879 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=44 read=5
  • I/O Timings: read=34.307
22. 34.863 34.863 ↓ 0.0 0 1

Bitmap Index Scan on brin_delivery_1546639200_endtime_idx (cost=0.00..6.80 rows=4,518 width=0) (actual time=34.863..34.863 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=44 read=5
  • I/O Timings: read=34.307
23. 0.009 74.148 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546725600 d_578 (cost=7.77..4,870.21 rows=1,625 width=1,245) (actual time=74.148..74.148 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared read=5
  • I/O Timings: read=73.885
24. 74.139 74.139 ↓ 0.0 0 1

Bitmap Index Scan on brin_delivery_1546725600_endtime_idx (cost=0.00..6.80 rows=4,518 width=0) (actual time=74.139..74.139 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared read=5
  • I/O Timings: read=73.885
25. 29,818.986 29,825.516 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1548972000 d_642 (cost=4.67..5,671.62 rows=1,898 width=1,249) (actual time=29,825.516..29,825.516 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Rows Removed by Index Recheck: 910247
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared read=154769
  • I/O Timings: read=1043.801
26. 6.530 6.530 ↓ 294.1 1,548,800 1

Bitmap Index Scan on brin_delivery_1548972000_endtime_idx (cost=0.00..3.53 rows=5,266 width=0) (actual time=6.530..6.530 rows=1,548,800 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared read=2
  • I/O Timings: read=0.027
27. 0.003 0.018 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1520287200 d_12 (cost=1.30..5.51 rows=2 width=40) (actual time=0.018..0.018 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
28. 0.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1520287200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
29. 0.004 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1522022400 d_153 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
30. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1522022400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
31. 0.001 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1522108800 d_154 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
32. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1522108800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
33. 0.004 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1522195200 d_155 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
34. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1522195200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
35. 0.001 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1522281600 d_156 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
36. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1522281600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
37. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1522368000 d_157 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
38. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1522368000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
39. 0.005 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1522454400 d_158 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
40. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1522454400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
41. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1522540800 d_159 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
42. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1522540800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
43. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1522627200 d_160 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
44. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1522627200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
45. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1522713600 d_161 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
46. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1522713600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
47. 0.003 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1522800000 d_162 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
48. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1522800000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
49. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1522886400 d_163 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
50. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1522886400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
51. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1522972800 d_164 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
52. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1522972800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
53. 0.004 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1523059200 d_165 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
54. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1523059200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
55. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1523145600 d_166 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
56. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1523145600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
57. 0.004 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1523232000 d_167 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
58. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1523232000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
59. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1523318400 d_168 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
60. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1523318400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
61. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1523404800 d_169 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
62. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1523404800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
63. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1523491200 d_170 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
64. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1523491200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
65. 0.002 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1523577600 d_171 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
66. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1523577600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
67. 0.004 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1523664000 d_172 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
68. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1523664000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
69. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1523750400 d_173 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
70. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1523750400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
71. 0.005 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1523836800 d_174 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
72. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1523836800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
73. 0.001 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1523923200 d_175 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
74. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1523923200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
75. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1524009600 d_176 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
76. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1524009600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
77. 0.009 0.017 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1524096000 d_177 (cost=1.30..5.51 rows=2 width=40) (actual time=0.017..0.017 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
78. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1524096000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
79. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1524182400 d_178 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
80. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1524182400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
81. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1524268800 d_179 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
82. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1524268800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
83. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1524355200 d_180 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
84. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1524355200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
85. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1524441600 d_181 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
86. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1524441600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
87. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1524528000 d_182 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
88. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1524528000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
89. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1524614400 d_183 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
90. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1524614400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
91. 0.003 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1524700800 d_184 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
92. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1524700800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
93. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1524787200 d_185 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
94. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1524787200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
95. 0.003 0.018 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1524873600 d_186 (cost=1.30..5.51 rows=2 width=40) (actual time=0.018..0.018 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
96. 0.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1524873600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
97. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1524960000 d_187 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
98. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1524960000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
99. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1525046400 d_188 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
100. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1525046400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
101. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1525132800 d_189 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
102. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1525132800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
103. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1525219200 d_190 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
104. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1525219200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
105. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1525305600 d_191 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
106. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1525305600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
107. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1525392000 d_192 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
108. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1525392000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
109. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1525478400 d_193 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
110. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1525478400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
111. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1525564800 d_194 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
112. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1525564800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
113. 0.003 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1525651200 d_195 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
114. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1525651200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
115. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1525737600 d_196 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
116. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1525737600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
117. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1525824000 d_197 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
118. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1525824000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
119. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1525910400 d_198 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
120. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1525910400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
121. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1525996800 d_199 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
122. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1525996800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
123. 0.006 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1526083200 d_200 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
124. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1526083200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
125. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1526169600 d_201 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
126. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1526169600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
127. 0.003 0.016 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1526256000 d_202 (cost=1.30..5.51 rows=2 width=40) (actual time=0.016..0.016 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
128. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1526256000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
129. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1526342400 d_203 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
130. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1526342400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
131. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1526428800 d_204 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
132. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1526428800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
133. 0.004 0.029 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1526515200 d_205 (cost=1.30..5.51 rows=2 width=40) (actual time=0.029..0.029 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
134. 0.025 0.025 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1526515200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
135. 0.002 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1526601600 d_206 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
136. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1526601600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
137. 0.004 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1526688000 d_207 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
138. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1526688000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
139. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1526774400 d_208 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
140. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1526774400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
141. 0.003 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1526860800 d_209 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
142. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1526860800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
143. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1526947200 d_210 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
144. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1526947200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
145. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1527033600 d_211 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
146. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1527033600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
147. 0.003 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1527120000 d_212 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
148. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1527120000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
149. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1527206400 d_213 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
150. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1527206400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
151. 0.004 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1527292800 d_214 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
152. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1527292800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
153. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1527379200 d_215 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
154. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1527379200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
155. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1527465600 d_216 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
156. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1527465600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
157. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1527552000 d_217 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
158. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1527552000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
159. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1527638400 d_218 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
160. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1527638400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
161. 0.003 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1527724800 d_219 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
162. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1527724800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
163. 0.001 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1527811200 d_220 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
164. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1527811200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
165. 0.004 0.016 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1527897600 d_221 (cost=1.30..5.51 rows=2 width=40) (actual time=0.016..0.016 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
166. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1527897600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
167. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1527984000 d_222 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
168. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1527984000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
169. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1528070400 d_223 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
170. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1528070400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
171. 0.004 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1528156800 d_224 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
172. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1528156800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
173. 0.004 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1528243200 d_225 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
174. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1528243200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
175. 0.010 0.019 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1528329600 d_226 (cost=1.30..5.51 rows=2 width=40) (actual time=0.019..0.019 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
176. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1528329600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
177. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1528416000 d_227 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
178. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1528416000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
179. 0.004 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1528502400 d_228 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
180. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1528502400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
181. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1528588800 d_229 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
182. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1528588800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
183. 0.001 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1528675200 d_230 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
184. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1528675200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
185. 0.004 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1528761600 d_231 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
186. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1528761600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
187. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1528848000 d_232 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
188. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1528848000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
189. 0.004 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1528934400 d_233 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
190. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1528934400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
191. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1529020800 d_234 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
192. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1529020800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
193. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1529107200 d_235 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
194. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1529107200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
195. 0.001 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1529193600 d_236 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
196. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1529193600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
197. 0.001 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1529280000 d_237 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
198. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1529280000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
199. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1529366400 d_238 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
200. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1529366400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
201. 0.003 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1529452800 d_239 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
202. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1529452800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
203. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1529539200 d_240 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
204. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1529539200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
205. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1529625600 d_241 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
206. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1529625600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
207. 0.004 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1529712000 d_242 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
208. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1529712000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
209. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1529798400 d_243 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
210. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1529798400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
211. 0.001 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1529884800 d_244 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
212. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1529884800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
213. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1529971200 d_245 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
214. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1529971200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
215. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1530057600 d_246 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
216. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1530057600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
217. 0.004 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1530144000 d_247 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
218. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1530144000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
219. 0.001 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1530230400 d_248 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
220. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1530230400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
221. 0.004 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1530316800 d_249 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
222. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1530316800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
223. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1530403200 d_250 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
224. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1530403200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
225. 0.003 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1530489600 d_251 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
226. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1530489600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
227. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1530576000 d_252 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
228. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1530576000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
229. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1530662400 d_253 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
230. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1530662400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
231. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1530748800 d_254 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
232. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1530748800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
233. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1530835200 d_255 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
234. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1530835200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
235. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1530921600 d_256 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
236. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1530921600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
237. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1531008000 d_257 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
238. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1531008000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
239. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1531094400 d_258 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
240. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1531094400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
241. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1531180800 d_259 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
242. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1531180800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
243. 0.001 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1531267200 d_260 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
244. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1531267200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
245. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1531353600 d_261 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
246. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1531353600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
247. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1531440000 d_262 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
248. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1531440000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
249. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1531526400 d_263 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
250. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1531526400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
251. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1531612800 d_264 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
252. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1531612800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
253. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1531699200 d_265 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
254. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1531699200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
255. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1531785600 d_266 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
256. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1531785600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
257. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1531872000 d_267 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
258. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1531872000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
259. 0.004 0.018 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1531958400 d_268 (cost=1.30..5.51 rows=2 width=40) (actual time=0.018..0.018 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
260. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1531958400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
261. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1532044800 d_269 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
262. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1532044800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
263. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1532131200 d_270 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
264. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1532131200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
265. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1532217600 d_271 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
266. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1532217600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
267. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1532304000 d_272 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
268. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1532304000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
269. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1532390400 d_273 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
270. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1532390400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
271. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1532476800 d_274 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
272. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1532476800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
273. 0.003 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1532563200 d_275 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
274. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1532563200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
275. 0.001 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1532649600 d_276 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
276. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1532649600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
277. 0.003 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1532736000 d_277 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
278. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1532736000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
279. 0.009 0.017 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1532822400 d_278 (cost=1.30..5.51 rows=2 width=40) (actual time=0.017..0.017 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
280. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1532822400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
281. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1532908800 d_279 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
282. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1532908800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
283. 0.003 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1532995200 d_280 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
284. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1532995200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
285. 0.001 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1533081600 d_281 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
286. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1533081600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
287. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1533168000 d_282 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
288. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1533168000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
289. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1533254400 d_283 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
290. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1533254400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
291. 0.003 0.036 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1533340800 d_284 (cost=1.30..5.51 rows=2 width=40) (actual time=0.036..0.036 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
292. 0.033 0.033 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1533340800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.033..0.033 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
293. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1533427200 d_285 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
294. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1533427200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
295. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1533513600 d_286 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
296. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1533513600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
297. 0.004 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1533600000 d_287 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
298. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1533600000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
299. 0.001 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1533686400 d_290 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
300. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1533686400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
301. 0.004 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1533772800 d_291 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
302. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1533772800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
303. 0.001 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1533859200 d_300 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
304. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1533859200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
305. 0.001 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1533945600 d_301 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
306. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1533945600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
307. 0.003 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1534032000 d_302 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
308. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1534032000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
309. 0.002 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1534118400 d_303 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
310. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1534118400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
311. 0.003 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1534204800 d_304 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
312. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1534204800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
313. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1534291200 d_305 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
314. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1534291200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
315. 0.005 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1534377600 d_306 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
316. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1534377600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
317. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1534464000 d_307 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
318. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1534464000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
319. 0.002 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1534550400 d_313 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
320. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1534550400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
321. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1534636800 d_314 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
322. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1534636800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
323. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1534723200 d_315 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
324. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1534723200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
325. 0.004 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1534809600 d_316 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
326. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1534809600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
327. 0.003 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1534896000 d_317 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
328. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1534896000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
329. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1534982400 d_320 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
330. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1534982400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
331. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1535068800 d_321 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
332. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1535068800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
333. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1535155200 d_326 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
334. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1535155200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
335. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1535241600 d_327 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
336. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1535241600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
337. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1535328000 d_328 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
338. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1535328000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
339. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1535414400 d_329 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
340. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1535414400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
341. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1535500800 d_331 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
342. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1535500800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
343. 0.003 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1535587200 d_343 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
344. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1535587200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
345. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1535673600 d_344 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
346. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1535673600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
347. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1535760000 d_345 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
348. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1535760000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
349. 0.004 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1535846400 d_346 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
350. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1535846400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
351. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1535932800 d_347 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
352. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1535932800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
353. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1536019200 d_348 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
354. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1536019200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
355. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1536105600 d_349 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
356. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1536105600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
357. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1536192000 d_350 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
358. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1536192000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
359. 0.004 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1536278400 d_351 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
360. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1536278400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
361. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1536364800 d_352 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
362. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1536364800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
363. 0.005 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1536451200 d_353 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
364. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1536451200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
365. 0.002 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1536537600 d_354 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
366. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1536537600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
367. 0.003 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1536624000 d_357 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
368. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1536624000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
369. 0.001 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1536710400 d_360 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
370. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1536710400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
371. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1536796800 d_361 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
372. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1536796800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
373. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1536883200 d_366 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
374. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1536883200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
375. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1536969600 d_367 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
376. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1536969600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
377. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1537056000 d_368 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
378. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1537056000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
379. 0.004 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1537142400 d_369 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
380. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1537142400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
381. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1537228800 d_377 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
382. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1537228800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
383. 0.002 0.018 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1537315200 d_378 (cost=1.30..5.51 rows=2 width=40) (actual time=0.018..0.018 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
384. 0.016 0.016 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1537315200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
385. 0.002 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1537401600 d_379 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
386. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1537401600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
387. 0.003 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1537488000 d_380 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
388. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1537488000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
389. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1537574400 d_381 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
390. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1537574400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
391. 0.003 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1537660800 d_382 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
392. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1537660800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
393. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1537747200 d_383 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
394. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1537747200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
395. 0.003 0.016 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1537833600 d_386 (cost=1.30..5.51 rows=2 width=40) (actual time=0.016..0.016 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
396. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1537833600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
397. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1537920000 d_387 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
398. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1537920000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
399. 0.001 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1538006400 d_389 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
400. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1538006400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
401. 0.004 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1538092800 d_395 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
402. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1538092800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
403. 0.002 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1538179200 d_396 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
404. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1538179200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
405. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1538265600 d_397 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
406. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1538265600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
407. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1538352000 d_398 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
408. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1538352000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
409. 0.005 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1538438400 d_399 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
410. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1538438400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
411. 0.001 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1538524800 d_401 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
412. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1538524800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
413. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1538611200 d_403 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
414. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1538611200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
415. 0.004 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1538697600 d_412 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
416. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1538697600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
417. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1538784000 d_413 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
418. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1538784000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
419. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1538870400 d_414 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
420. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1538870400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
421. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1538956800 d_415 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
422. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1538956800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
423. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1539043200 d_416 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
424. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1539043200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
425. 0.001 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1539129600 d_417 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
426. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1539129600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
427. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1539216000 d_418 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
428. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1539216000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
429. 0.006 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1539302400 d_419 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
430. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1539302400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
431. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1539388800 d_423 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
432. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1539388800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
433. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1539475200 d_424 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
434. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1539475200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
435. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1539561600 d_425 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
436. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1539561600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
437. 0.004 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1539648000 d_430 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
438. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1539648000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
439. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1539734400 d_431 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
440. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1539734400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
441. 0.001 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1539820800 d_432 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
442. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1539820800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
443. 0.004 0.031 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1539907200 d_433 (cost=1.30..5.51 rows=2 width=40) (actual time=0.031..0.031 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
444. 0.027 0.027 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1539907200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
445. 0.002 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1539993600 d_438 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
446. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1539993600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
447. 0.004 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1540080000 d_439 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
448. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1540080000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
449. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1540166400 d_440 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
450. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1540166400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
451. 0.003 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1540252800 d_441 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
452. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1540252800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
453. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1540339200 d_444 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
454. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1540339200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
455. 0.002 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1540425600 d_445 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
456. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1540425600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
457. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1540512000 d_450 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
458. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1540512000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
459. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1540598400 d_451 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
460. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1540598400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
461. 0.004 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1540684800 d_452 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
462. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1540684800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
463. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1540771200 d_453 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
464. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1540771200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
465. 0.001 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1540857600 d_455 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
466. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1540857600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
467. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1540944000 d_457 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
468. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1540944000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
469. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1541030400 d_459 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
470. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1541030400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
471. 0.002 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1541116800 d_461 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
472. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1541116800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
473. 0.004 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1541203200 d_467 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
474. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1541203200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
475. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1541289600 d_468 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
476. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1541289600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
477. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1541376000 d_469 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
478. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1541376000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
479. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1541462400 d_470 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
480. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1541462400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
481. 0.005 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1541548800 d_471 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
482. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1541548800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
483. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1541635200 d_478 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
484. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1541635200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
485. 0.001 0.006 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1541721600 d_479 (cost=1.30..5.51 rows=2 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
486. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1541721600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
487. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1541808000 d_480 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
488. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1541808000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
489. 0.001 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1541894400 d_481 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
490. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1541894400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
491. 0.002 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1541980800 d_482 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
492. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1541980800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
493. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1542067200 d_483 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
494. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1542067200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
495. 0.001 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1542153600 d_484 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
496. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1542153600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
497. 0.004 0.016 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1542240000 d_491 (cost=1.30..5.51 rows=2 width=40) (actual time=0.016..0.016 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
498. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1542240000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
499. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1542326400 d_492 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
500. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1542326400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
501. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1542412800 d_493 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
502. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1542412800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
503. 0.002 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1542499200 d_494 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
504. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1542499200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
505. 0.002 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1542585600 d_495 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
506. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1542585600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
507. 0.008 0.019 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1542672000 d_531 (cost=1.30..5.51 rows=2 width=40) (actual time=0.019..0.019 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
508. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1542672000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
509. 0.003 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1542758400 d_532 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
510. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1542758400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
511. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1542844800 d_533 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
512. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1542844800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
513. 0.001 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1542931200 d_534 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
514. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1542931200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
515. 0.003 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1543017600 d_535 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
516. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1543017600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
517. 0.003 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1543104000 d_536 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
518. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1543104000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
519. 0.001 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1543190400 d_537 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
520. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1543190400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
521. 0.002 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1543276800 d_538 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
522. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1543276800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
523. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1543363200 d_539 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
524. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1543363200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
525. 0.001 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1543449600 d_540 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
526. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1543449600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
527. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1543536000 d_541 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
528. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1543536000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
529. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1543622400 d_542 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
530. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1543622400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
531. 0.005 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1543708800 d_543 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
532. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1543708800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
533. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1543795200 d_544 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
534. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1543795200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
535. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1543881600 d_545 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
536. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1543881600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
537. 0.001 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1543968000 d_546 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
538. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1543968000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
539. 0.003 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1544054400 d_547 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
540. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1544054400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
541. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1544140800 d_548 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
542. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1544140800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
543. 0.001 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1544227200 d_549 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
544. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1544227200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
545. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1544313600 d_550 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
546. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1544313600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
547. 0.003 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1544400000 d_551 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
548. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1544400000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
549. 0.006 0.017 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1544486400 d_552 (cost=1.30..5.51 rows=2 width=40) (actual time=0.017..0.017 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
550. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1544486400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
551. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1544572800 d_553 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
552. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1544572800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
553. 0.001 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1544659200 d_554 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
554. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1544659200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
555. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1544745600 d_555 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
556. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1544745600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
557. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1544832000 d_556 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
558. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1544832000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
559. 0.002 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1544918400 d_557 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
560. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1544918400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
561. 0.001 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1545004800 d_558 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
562. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1545004800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
563. 0.003 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1545091200 d_559 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
564. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1545091200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
565. 0.002 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1545177600 d_560 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
566. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1545177600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
567. 0.002 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1545264000 d_561 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
568. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1545264000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
569. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1545350400 d_562 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
570. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1545350400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
571. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1545436800 d_563 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
572. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1545436800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
573. 0.004 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1545523200 d_564 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
574. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1545523200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
575. 0.001 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1545609600 d_565 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
576. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1545609600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
577. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1545696000 d_594 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
578. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1545696000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
579. 0.001 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1545782400 d_595 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
580. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1545782400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
581. 0.006 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1545868800 d_596 (cost=1.30..5.51 rows=2 width=40) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
582. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1545868800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
583. 0.006 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1545955200 d_597 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
584. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1545955200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
585. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546041600 d_598 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
586. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1546041600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
587. 0.001 0.007 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546128000 d_599 (cost=1.30..5.51 rows=2 width=40) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
588. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1546128000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
589. 0.002 0.022 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546214400 d_600 (cost=1.30..5.51 rows=2 width=40) (actual time=0.022..0.022 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
590. 0.020 0.020 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1546214400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
591. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546300800 d_601 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
592. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1546300800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
593. 0.004 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546387200 d_602 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
594. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1546387200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
595. 0.002 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546473600 d_603 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
596. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1546473600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
597. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546560000 d_604 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
598. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1546560000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
599. 0.003 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546646400 d_605 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
600. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1546646400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
601. 0.004 0.015 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546732800 d_606 (cost=1.30..5.51 rows=2 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
602. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1546732800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
603. 0.001 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546819200 d_607 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
604. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1546819200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
605. 0.001 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546905600 d_608 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
606. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1546905600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
607. 0.002 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1546992000 d_609 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
608. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1546992000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
609. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1547078400 d_610 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
610. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1547078400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
611. 0.003 0.018 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1547164800 d_611 (cost=1.30..5.51 rows=2 width=40) (actual time=0.018..0.018 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
612. 0.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1547164800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
613. 0.001 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1547251200 d_612 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
614. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1547251200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
615. 0.003 0.011 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1547337600 d_613 (cost=1.30..5.51 rows=2 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
616. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1547337600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
617. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1547424000 d_614 (cost=1.30..5.51 rows=2 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
618. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1547424000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
619. 0.001 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1547510400 d_615 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
620. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1547510400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
621. 0.002 0.009 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1547596800 d_616 (cost=1.30..5.51 rows=2 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
622. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1547596800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
623. 0.001 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1547683200 d_617 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
624. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1547683200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
625. 0.001 0.008 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1547769600 d_618 (cost=1.30..5.51 rows=2 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
626. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1547769600_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
627. 0.004 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1547856000 d_619 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
628. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1547856000_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
629. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1547942400 d_620 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
630. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1547942400_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
631. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1548028800 d_621 (cost=1.30..5.51 rows=2 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
632. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1548028800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
633. 0.003 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1548115200 d_626 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
634. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1548115200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Buffers: shared hit=1
635. 0.002 0.010 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1548201600 d_627 (cost=1.30..5.51 rows=2 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((endtime >= ($0)::bigint) AND (endtime <= ($1)::bigint))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=1
636. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on route_delivery_1548201600_endtime_idx (cost=0.00..1.29 rows=4 width=0)