explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AQ0w : plain_delivery

Settings
# exclusive inclusive rows x rows loops node
1. 0.302 1.101 ↑ 1.0 1,000 1

Limit (cost=0.00..1,036.16 rows=1,000 width=80) (actual time=0.044..1.101 rows=1,000 loops=1)

  • Buffers: shared hit=205
2. 0.282 0.799 ↑ 76.8 1,000 1

Append (cost=0.00..79,562.90 rows=76,786 width=80) (actual time=0.043..0.799 rows=1,000 loops=1)

  • Buffers: shared hit=205
3. 0.020 0.020 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
4. 0.497 0.497 ↑ 48.4 1,000 1

Index Scan using route_delivery_1549144800_endtime_idx on delivery_1549144800 (cost=0.43..49,937.69 rows=48,428 width=80) (actual time=0.022..0.497 rows=1,000 loops=1)

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

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

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