explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EADc : sss

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

Hash Left Join (cost=21.04..576.55 rows=60 width=2,650) (actual rows= loops=)

  • Hash Cond: (products_product.attribute_set_id = products_attributeset.id)
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=18.49..573.83 rows=60 width=2,613) (actual rows= loops=)

  • Filter: (((catalogs_productstock.stock_list_id = 1) AND (catalogs_productprice.price_list_id = 1)) OR ((products_product.product_type)::text = '3'::text)
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=18.20..551.36 rows=60 width=2,617) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.92..530.53 rows=60 width=2,613) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.64..481.33 rows=154 width=2,617) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=17.35..114.14 rows=155 width=4) (actual rows= loops=)

  • Hash Cond: (catalogs_catalogitem.id = promotions_productcollectionitem.catalog_item_id)
7. 0.000 0.000 ↓ 0.0

Seq Scan on catalogs_catalogitem (cost=0.00..84.14 rows=4,814 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=15.41..15.41 rows=155 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on promotions_productcollectionitem (cost=5.48..15.41 rows=155 width=4) (actual rows= loops=)

  • Recheck Cond: (collection_id = 2)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on promotions_productcollectionitem_0a1a4dd8 (cost=0.00..5.44 rows=155 width=0) (actual rows= loops=)

  • Index Cond: (collection_id = 2)
11. 0.000 0.000 ↓ 0.0

Index Scan using products_product_pkey on products_product (cost=0.29..2.37 rows=1 width=2,613) (actual rows= loops=)

  • Index Cond: (id = catalogs_catalogitem.product_id)
  • Filter: ((product_type)::text <> '-1'::text)
12. 0.000 0.000 ↓ 0.0

Index Scan using catalogs_catalogitem_9bea82de on catalogs_catalogitem t5 (cost=0.28..0.32 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (product_id = products_product.id)
  • Filter: (catalog_id = 1)
13. 0.000 0.000 ↓ 0.0

Index Scan using catalogs_productstock_9bea82de on catalogs_productstock (cost=0.29..0.34 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (products_product.id = product_id)
14. 0.000 0.000 ↓ 0.0

Index Scan using catalogs_productprice_9bea82de on catalogs_productprice (cost=0.29..0.36 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (products_product.id = product_id)
15. 0.000 0.000 ↓ 0.0

Hash (cost=1.69..1.69 rows=69 width=37) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on products_attributeset (cost=0.00..1.69 rows=69 width=37) (actual rows= loops=)