explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P72S : del_interval_JAN

Settings
# exclusive inclusive rows x rows loops node
1. 0.381 4,021.379 ↑ 1.0 1 1

Aggregate (cost=38,152.38..38,152.39 rows=1 width=16) (actual time=4,021.378..4,021.379 rows=1 loops=1)

  • Buffers: shared hit=4 read=67695
  • I/O Timings: read=23564.544
2. 6.865 4,020.998 ↑ 1.0 1,000 1

Limit (cost=1,000.00..38,137.38 rows=1,000 width=8) (actual time=3,855.139..4,020.998 rows=1,000 loops=1)

  • Buffers: shared hit=4 read=67695
  • I/O Timings: read=23564.544
3. 0.000 4,014.133 ↑ 4.2 1,000 1

Subquery Scan on bml_vbase_delivery_analytics (cost=1,000.00..155,380.08 rows=4,157 width=8) (actual time=3,855.137..4,014.133 rows=1,000 loops=1)

  • Filter: (bml_vbase_delivery_analytics.esme ~~ '%'::text)
  • Buffers: shared read=17160
  • I/O Timings: read=3954.178
4. 35.378 4,019.894 ↑ 4.2 1,000 1

Gather (cost=1,000.00..155,328.12 rows=4,157 width=368) (actual time=3,855.135..4,019.894 rows=1,000 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=4 read=67695
  • I/O Timings: read=23564.544
5. 0.371 3,984.516 ↑ 491.7 169 6

Result (cost=0.00..153,912.42 rows=83,100 width=368) (actual time=3,850.982..3,984.516 rows=169 loops=6)

  • Buffers: shared hit=4 read=67695
  • I/O Timings: read=23564.544
6. 3.377 3,984.145 ↑ 491.7 169 6

ProjectSet (cost=0.00..145,810.17 rows=83,100 width=264) (actual time=3,850.971..3,984.145 rows=169 loops=6)

  • Buffers: shared hit=4 read=67695
  • I/O Timings: read=23564.544
7. 0.000 3,980.768 ↑ 7.6 110 6

Parallel Append (cost=0.00..145,340.66 rows=831 width=40) (actual time=3,850.860..3,980.768 rows=110 loops=6)

  • Buffers: shared hit=4 read=67695
  • I/O Timings: read=23564.544
8. 0.170 0.194 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on delivery_1546646400 d_2 (cost=1.29..5.50 rows=2 width=40) (actual time=0.194..0.194 rows=0 loops=3)

  • Recheck Cond: ((endtime >= 1546683937) AND (endtime <= 1546685737))
  • Filter: ((split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Buffers: shared hit=4
9. 0.024 0.024 ↓ 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.024..0.024 rows=0 loops=1)

  • Index Cond: ((endtime >= 1546683937) AND (endtime <= 1546685737))
  • Buffers: shared hit=4
10. 3,980.604 3,980.604 ↑ 7.5 110 6

Parallel Seq Scan on delivery_1546639200 d_1 (cost=0.00..145,322.70 rows=830 width=40) (actual time=3,850.759..3,980.604 rows=110 loops=6)

  • Filter: ((endtime >= 1546683937) AND (endtime <= 1546685737) AND (split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))
  • Rows Removed by Filter: 66093
  • Buffers: shared read=67695
  • I/O Timings: read=23564.544
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 >= 1546683937) AND (endtime <= 1546685737) AND (split_part(route, '@'::text, 1) ~~ '%'::text) AND (split_part(route, '@'::text, 2) ~~ '%'::text))