explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IlBh : del_interval2

Settings
# exclusive inclusive rows x rows loops node
1. 0.303 4.185 ↑ 1.0 1,000 1

Limit (cost=0.00..38.09 rows=1,000 width=104) (actual time=0.067..4.185 rows=1,000 loops=1)

  • Buffers: shared hit=145
2. 0.800 3.882 ↑ 6,649.9 1,000 1

Result (cost=0.00..253,269.30 rows=6,649,900 width=104) (actual time=0.066..3.882 rows=1,000 loops=1)

  • Buffers: shared hit=145
3. 2.308 3.082 ↑ 6,649.9 1,000 1

ProjectSet (cost=0.00..103,646.55 rows=6,649,900 width=72) (actual time=0.060..3.082 rows=1,000 loops=1)

  • Buffers: shared hit=145
4. 0.227 0.774 ↑ 93.9 708 1

Append (cost=0.00..69,565.81 rows=66,499 width=72) (actual time=0.047..0.774 rows=708 loops=1)

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

Seq Scan on delivery (cost=0.00..0.00 rows=1 width=72) (actual time=0.023..0.024 rows=0 loops=1)

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

Index Scan using route_delivery_1549144800_endtime_idx on delivery_1549144800 (cost=0.43..49,935.50 rows=48,428 width=72) (actual time=0.022..0.523 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 (cost=0.43..18,632.83 rows=18,070 width=72) (never executed)

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