explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RhuP : Optimization for: plan #L4P6

Settings

Optimization(s) for this plan:

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

Nested Loop (cost=30.62..56.50 rows=1 width=1,394) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=30.48..55.55 rows=1 width=1,316) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=30.32..55.33 rows=1 width=1,284) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=30.18..55.12 rows=1 width=1,206) (actual rows= loops=)

  • Join Filter: ((oi.product_id = prd.product_id) AND (oi.product_published_id = prd.product_published_id))
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=30.04..53.84 rows=1 width=1,176) (actual rows= loops=)

  • Hash Cond: (prcc.pricing_table_id = prct.pricing_table_id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on tbl_pricing_campaign_code prcc (cost=0.00..20.00 rows=1,000 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=30.03..30.03 rows=1 width=1,176) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.30..30.03 rows=1 width=1,176) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.15..29.81 rows=1 width=1,176) (actual rows= loops=)

  • Join Filter: ((oi.product_id = prct.product_id) AND (oi.product_published_id = prct.product_published_id))
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.15..18.81 rows=1 width=612) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on tbl_order_item oi (cost=0.00..10.63 rows=1 width=596) (actual rows= loops=)

  • Filter: ((order_combo_bundle_id IS NOT NULL) AND ((dtype)::text = 'OrderLeafItem'::text))
12. 0.000 0.000 ↓ 0.0

Index Scan using tbl_order_combo_bundle_pkey on tbl_order_combo_bundle ocb (cost=0.15..8.17 rows=1 width=48) (actual rows= loops=)

  • Index Cond: (order_combo_bundle_id = oi.order_combo_bundle_id)
13. 0.000 0.000 ↓ 0.0

Seq Scan on tbl_pricing_table prct (cost=0.00..10.40 rows=40 width=564) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using tbl_combo_bundle_pkey on tbl_combo_bundle cb (cost=0.15..0.22 rows=1 width=64) (actual rows= loops=)

  • Index Cond: ((combo_bundle_id = ocb.combo_bundle_id) AND (combo_bundle_published_id = ocb.combo_bundle_published_id))
15. 0.000 0.000 ↓ 0.0

Index Scan using tbl_product_pkey on tbl_product prd (cost=0.14..1.26 rows=1 width=126) (actual rows= loops=)

  • Index Cond: ((product_id = prct.product_id) AND (product_published_id = prct.product_published_id))
16. 0.000 0.000 ↓ 0.0

Index Scan using tbl_product_campaign_pkey on tbl_product_campaign prdc (cost=0.14..0.21 rows=1 width=110) (actual rows= loops=)

  • Index Cond: (product_campaign_id = prcc.product_campaign_id)
17. 0.000 0.000 ↓ 0.0

Index Only Scan using tbl_combo_pkey on tbl_combo c (cost=0.15..0.23 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((product_unit_id = cb.combo_id) AND (product_unit_published_id = cb.combo_published_id))
18. 0.000 0.000 ↓ 0.0

Index Scan using tbl_product_unit_pkey on tbl_product_unit cpu (cost=0.14..0.19 rows=1 width=126) (actual rows= loops=)