explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EZhq : base_delivery

Settings
# exclusive inclusive rows x rows loops node
1. 1.766 17.730 ↑ 1.0 1,000 1

Limit (cost=1,000.43..7,320.05 rows=1,000 width=368) (actual time=1.881..17.730 rows=1,000 loops=1)

  • Buffers: shared hit=154
2. 1.815 15.964 ↑ 76.8 1,000 1

Subquery Scan on v (cost=1,000.43..486,612.23 rows=76,842 width=368) (actual time=1.879..15.964 rows=1,000 loops=1)

  • Buffers: shared hit=47
3. 4.724 14.149 ↑ 76.8 1,000 1

Gather (cost=1,000.43..482,385.92 rows=76,842 width=336) (actual time=1.869..14.149 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=154
4. 1.301 9.425 ↑ 9,586.2 334 3

Result (cost=0.43..473,701.72 rows=3,201,800 width=336) (actual time=0.132..9.425 rows=334 loops=3)

  • Buffers: shared hit=154
5. 7.463 8.124 ↑ 9,586.2 334 3

ProjectSet (cost=0.43..97,490.22 rows=3,201,800 width=304) (actual time=0.118..8.124 rows=334 loops=3)

  • Buffers: shared hit=154
6. 0.000 0.661 ↑ 134.5 238 3

Parallel Append (cost=0.43..79,400.05 rows=32,018 width=80) (actual time=0.058..0.661 rows=238 loops=3)

  • Buffers: shared hit=154
7. 0.694 0.694 ↑ 93.4 305 1

Parallel Index Scan using route_delivery_1549144800_endtime_idx on delivery_1549144800 (cost=0.43..49,738.29 rows=28,487 width=80) (actual time=0.056..0.694 rows=305 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=70
8. 0.455 0.455 ↑ 81.9 204 2

Parallel Index Scan using route_delivery_1549231200_endtime_idx on delivery_1549231200 (cost=0.43..29,181.50 rows=16,714 width=80) (actual time=0.056..0.455 rows=204 loops=2)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=84
9. 0.001 0.001 ↓ 0.0 0 1

Parallel Seq Scan on delivery (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))