explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tXUf

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

Limit (cost=0.85..316.80 rows=100 width=137) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.85..2,370.43 rows=750 width=137) (actual rows= loops=)

  • Join Filter: false
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.85..2,362.93 rows=750 width=132) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.58..2,135.81 rows=750 width=128) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..1,980.36 rows=750 width=96) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..1,857.26 rows=750 width=89) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on warehouse_products wp (cost=0.00..284.10 rows=1,053 width=8) (actual rows= loops=)

  • Filter: ((minimum >= amount) AND (maximum <= amount))
8. 0.000 0.000 ↓ 0.0

Index Scan using products_pk on products p (cost=0.29..1.49 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (id = wp.fk_product_id)
  • Filter: (fk_product_type_id = 1)
9. 0.000 0.000 ↓ 0.0

Index Scan using product_groups_pk on product_groups pg (cost=0.14..0.16 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (id = p.fk_product_group_id)
10. 0.000 0.000 ↓ 0.0

Index Only Scan using product_serialnumbers_fk_product_id_serialnumber_uindex on product_serialnumbers psn (cost=0.15..0.19 rows=2 width=36) (actual rows= loops=)

  • Index Cond: (fk_product_id = p.id)
11. 0.000 0.000 ↓ 0.0

Index Scan using companies_fk_account_id_uindex on companies supp (cost=0.28..0.30 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (fk_account_id = p.fk_supplier_account_id)
12. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=5) (actual rows= loops=)

  • One-Time Filter: false