explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oA3F : delivery_analytics2

Settings
# exclusive inclusive rows x rows loops node
1. 0.327 16.687 ↑ 1.0 1,000 1

Limit (cost=0.00..118.61 rows=1,000 width=368) (actual time=0.091..16.687 rows=1,000 loops=1)

  • Buffers: shared hit=145
2. 1.905 16.360 ↑ 7,715.6 1,000 1

Result (cost=0.00..915,160.95 rows=7,715,600 width=368) (actual time=0.089..16.360 rows=1,000 loops=1)

  • Buffers: shared hit=145
3. 13.603 14.455 ↑ 7,715.6 1,000 1

ProjectSet (cost=0.00..124,311.95 rows=7,715,600 width=304) (actual time=0.079..14.455 rows=1,000 loops=1)

  • Buffers: shared hit=145
4. 0.236 0.852 ↑ 109.0 708 1

Append (cost=0.00..80,718.81 rows=77,156 width=80) (actual time=0.046..0.852 rows=708 loops=1)

  • Buffers: shared hit=145
5. 0.017 0.017 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
6. 0.599 0.599 ↑ 68.4 708 1

Index Scan using route_delivery_1549144800_endtime_idx on delivery_1549144800 d_1 (cost=0.43..49,938.80 rows=48,428 width=80) (actual time=0.028..0.599 rows=708 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=145
7. 0.000 0.000 ↓ 0.0 0

Index Scan using route_delivery_1549231200_endtime_idx on delivery_1549231200 d_2 (cost=0.43..29,622.67 rows=28,727 width=80) (never executed)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))