# Result: S945 : del_interval3

Settings

### Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.364 358.777 ↑ 1.0 1 1

Aggregate (cost=5,628.20..5,628.21 rows=1 width=16) (actual time=358.777..358.777 rows=1 loops=1)

2. 0.428 358.413 ↑ 1.0 1,000 1

(cost=1,000.42..5,613.20 rows=1,000 width=8) (actual time=17.303..358.413 rows=1,000 loops=1)

3. 335.102 357.985 ↑ 24.2 1,000 1

Gather (cost=1,000.42..112,763.28 rows=24,229 width=8) (actual time=17.302..357.985 rows=1,000 loops=1)

• Workers Planned: 2
• Workers Launched: 2
4. 0.175 22.883 ↑ 72.5 334 3

Subquery Scan on bml_vbase_delivery_analytics (cost=0.42..109,340.38 rows=24,229 width=8) (actual time=11.265..22.883 rows=334 loops=3)

• Filter: (bml_vbase_delivery_analytics.esme ~~ '%'::text)
5. 0.587 22.708 ↑ 3,022.8 334 3

(cost=0.42..109,037.50 rows=1,009,600 width=368) (actual time=11.262..22.708 rows=334 loops=3)

6. 5.021 22.121 ↑ 3,022.8 334 3

ProjectSet (cost=0.42..10,601.50 rows=1,009,600 width=264) (actual time=11.245..22.121 rows=334 loops=3)

7. 0.000 17.100 ↑ 43.3 233 3

Parallel Append (cost=0.42..4,897.26 rows=10,096 width=1,254) (actual time=11.168..17.100 rows=233 loops=3)

8. 0.199 0.229 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on delivery_1549324800 d_2 (cost=1.29..5.50 rows=2 width=40) (actual time=0.229..0.229 rows=0 loops=1)

• Recheck Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
• Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
• Buffers: shared hit=4
9. 0.030 0.030 ↓ 0.0 0 1

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

• Index Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
• Buffers: shared hit=4
10. 16.927 16.927 ↑ 61.2 233 3

Parallel Index Scan using route_delivery_1549317600_endtime_idx on delivery_1549317600 d_1 (cost=0.42..4,740.32 rows=14,251 width=1,254) (actual time=11.086..16.927 rows=233 loops=3)

• Index Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
• Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))