explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ekqg : Optimization for: plan #BNVr

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.011 0.013 ↓ 0.0 0 1

Sort (cost=11.55..11.56 rows=1 width=20) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: ((SubPlan 1)) DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.002 0.002 ↓ 0.0 0 1

Index Scan using delivery_order_items_item_id_index on delivery_order_items (cost=0.27..11.54 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((item_id IS NOT NULL) AND (item_id = 264))
3.          

SubPlan (forIndex Scan)

4. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..3.25 rows=1 width=8) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Seq Scan on delivery_orders (cost=0.00..3.25 rows=1 width=8) (never executed)

  • Filter: (delivery_order_items.delivery_order_id = id)