explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TnaP : Optimization for: del_interval3; plan #S945

Settings

Optimization path:

# 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)

  • Buffers: shared hit=143 read=7
  • I/O Timings: read=40.565
2. 0.428 358.413 ↑ 1.0 1,000 1

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

  • Buffers: shared hit=143 read=7
  • I/O Timings: read=40.565
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
  • Buffers: shared hit=143 read=7
  • I/O Timings: read=40.565
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)
  • Buffers: shared hit=143 read=7
  • I/O Timings: read=40.565
5. 0.587 22.708 ↑ 3,022.8 334 3

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

  • Buffers: shared hit=143 read=7
  • I/O Timings: read=40.565
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)

  • Buffers: shared hit=143 read=7
  • I/O Timings: read=40.565
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)

  • Buffers: shared hit=143 read=7
  • I/O Timings: read=40.565
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))
  • Buffers: shared hit=139 read=7
  • I/O Timings: read=40.565
11. 0.001 0.001 ↓ 0.0 0 1

Parallel Seq Scan on delivery d (cost=0.00..0.00 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=1)

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