explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H9sn : del_interval_FEB

Settings
# exclusive inclusive rows x rows loops node
1. 0.320 79.109 ↑ 1.0 1 1

Aggregate (cost=5,629.38..5,629.39 rows=1 width=16) (actual time=79.109..79.109 rows=1 loops=1)

  • Buffers: shared hit=26 read=128
  • I/O Timings: read=0.611
2. 0.381 78.789 ↑ 1.0 1,000 1

Limit (cost=1,000.00..5,614.38 rows=1,000 width=8) (actual time=1.732..78.789 rows=1,000 loops=1)

  • Buffers: shared hit=26 read=128
  • I/O Timings: read=0.611
3. 72.393 78.408 ↑ 23.7 1,000 1

Gather (cost=1,000.00..110,522.31 rows=23,735 width=8) (actual time=1.731..78.408 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=26 read=128
  • I/O Timings: read=0.611
4. 0.166 6.015 ↑ 71.1 334 3

Subquery Scan on bml_vbase_delivery_analytics (cost=0.00..107,148.81 rows=23,735 width=8) (actual time=0.116..6.015 rows=334 loops=3)

  • Filter: (bml_vbase_delivery_analytics.esme ~~ '%'::text)
  • Buffers: shared hit=26 read=128
  • I/O Timings: read=0.611
5. 0.556 5.849 ↑ 2,961.4 334 3

Result (cost=0.00..106,852.09 rows=989,100 width=368) (actual time=0.114..5.849 rows=334 loops=3)

  • Buffers: shared hit=26 read=128
  • I/O Timings: read=0.611
6. 4.532 5.293 ↑ 2,961.4 334 3

ProjectSet (cost=0.00..10,414.84 rows=989,100 width=264) (actual time=0.107..5.293 rows=334 loops=3)

  • Buffers: shared hit=26 read=128
  • I/O Timings: read=0.611
7. 0.085 0.761 ↑ 42.3 234 3

Parallel Append (cost=0.00..4,826.43 rows=9,891 width=1,259) (actual time=0.061..0.761 rows=234 loops=3)

  • Buffers: shared hit=26 read=128
  • I/O Timings: read=0.611
8. 0.675 0.675 ↑ 59.7 234 3

Parallel Index Scan using route_delivery_1549404000_endtime_idx on delivery_1549404000 d_1 (cost=0.42..4,678.06 rows=13,962 width=1,259) (actual time=0.060..0.675 rows=234 loops=3)

  • Index Cond: ((endtime >= 1549436885) AND (endtime <= 1549438685))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=26 read=128
  • I/O Timings: read=0.611
9. 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.000..0.001 rows=0 loops=1)

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