explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y9pU

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.86..427.27 rows=3,981 width=271) (actual rows= loops=)

  • -> Index Scan using index_purchase_order_list_histories_on_purchase_order_list_id on purchase_order_list_histories (cost=0.29..4.60 rows
2. 0.000 0.000 ↓ 0.0

Merge Join (cost=1.58..13.86 rows=78 width=8) (actual rows= loops=)

  • Merge Cond: (purchase_order_lists.purchase_order_id = purchase_orders.id)
  • Index Cond: (purchase_order_list_id = purchase_order_lists.id)
3. 0.000 0.000 ↓ 0.0

Index Scan using index_purchase_order_lists_on_purchase_order_id on purchase_order_lists (cost=0.28..72.62 rows=547 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=1.30..1.33 rows=11 width=8) (actual rows= loops=)

  • Sort Key: purchase_orders.id
5. 0.000 0.000 ↓ 0.0

Seq Scan on purchase_orders (cost=0.00..1.11 rows=11 width=8) (actual rows= loops=)