explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ce8k : delivery_analytics2a

Settings
# exclusive inclusive rows x rows loops node
1. 0.324 30.040 ↑ 1.0 1,000 1

Limit (cost=1,000.43..6,649.97 rows=1,000 width=368) (actual time=1.688..30.040 rows=1,000 loops=1)

  • Buffers: shared hit=258 read=2
  • I/O Timings: read=21.340
2. 9.400 29.716 ↑ 77.5 1,000 1

Gather (cost=1,000.43..438,273.33 rows=77,537 width=368) (actual time=1.686..29.716 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=258 read=2
  • I/O Timings: read=21.340
3. 1.502 20.316 ↑ 5,708.0 566 3

Result (cost=0.43..429,519.63 rows=3,230,700 width=368) (actual time=0.139..20.316 rows=566 loops=3)

  • Buffers: shared hit=258 read=2
  • I/O Timings: read=21.340
4. 10.713 18.814 ↑ 5,708.0 566 3

ProjectSet (cost=0.43..98,372.88 rows=3,230,700 width=304) (actual time=0.127..18.814 rows=566 loops=3)

  • Buffers: shared hit=258 read=2
  • I/O Timings: read=21.340
5. 0.000 8.101 ↑ 79.4 407 3

Parallel Append (cost=0.43..80,119.43 rows=32,307 width=80) (actual time=0.051..8.101 rows=407 loops=3)

  • Buffers: shared hit=258 read=2
  • I/O Timings: read=21.340
6. 1.125 1.125 ↑ 59.2 481 1

Parallel Index Scan using route_delivery_1549144800_endtime_idx on delivery_1549144800 d_1 (cost=0.43..49,739.39 rows=28,487 width=80) (actual time=0.075..1.125 rows=481 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=106
7. 11.305 11.305 ↑ 46.3 370 2

Parallel Index Scan using route_delivery_1549231200_endtime_idx on delivery_1549231200 d_2 (cost=0.43..29,895.44 rows=17,122 width=80) (actual time=0.032..11.305 rows=370 loops=2)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=152 read=2
  • I/O Timings: read=21.340
8. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))