explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZtA : del_interval

Settings
# exclusive inclusive rows x rows loops node
1. 0.314 4.482 ↑ 1.0 1,000 1

Limit (cost=0.01..35.37 rows=1,000 width=104) (actual time=0.062..4.482 rows=1,000 loops=1)

  • Buffers: shared hit=145
2. 1.297 4.168 ↑ 6,639.4 1,000 1

Nested Loop (cost=0.01..234,777.60 rows=6,639,400 width=104) (actual time=0.061..4.168 rows=1,000 loops=1)

  • Buffers: shared hit=145
3. 0.212 0.747 ↑ 93.8 708 1

Append (cost=0.00..68,792.60 rows=66,394 width=72) (actual time=0.042..0.747 rows=708 loops=1)

  • Buffers: shared hit=145
4. 0.013 0.013 ↓ 0.0 0 1

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

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

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

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

Index Scan using route_delivery_1549231200_endtime_idx on delivery_1549231200 d_2 (cost=0.43..18,525.13 rows=17,965 width=72) (never executed)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
7. 2.124 2.124 ↑ 100.0 1 708

Function Scan on jsonb_each esme (cost=0.01..1.01 rows=100 width=32) (actual time=0.003..0.003 rows=1 loops=708)