explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Shon

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.081 0.856 ↓ 12.0 12 1

Nested Loop Left Join (cost=103.15..190.65 rows=1 width=253) (actual time=0.418..0.856 rows=12 loops=1)

2.          

CTE cte_cart_item_funds

3. 0.025 0.311 ↓ 12.0 12 1

HashAggregate (cost=100.18..100.19 rows=1 width=68) (actual time=0.306..0.311 rows=12 loops=1)

4. 0.005 0.286 ↓ 12.0 12 1

Nested Loop (cost=1.56..100.17 rows=1 width=68) (actual time=0.113..0.286 rows=12 loops=1)

5. 0.006 0.209 ↓ 12.0 12 1

Nested Loop (cost=1.28..98.01 rows=1 width=102) (actual time=0.100..0.209 rows=12 loops=1)

6. 0.032 0.155 ↓ 12.0 12 1

Nested Loop (cost=0.86..89.56 rows=1 width=68) (actual time=0.085..0.155 rows=12 loops=1)

  • Join Filter: (((i_1.cart_id)::bpchar = (o.cart_id)::bpchar) AND ((i_1.cart_item_id)::bpchar = (o.cart_item_id)::bpchar))
  • Rows Removed by Join Filter: 132
7. 0.051 0.051 ↑ 1.5 12 1

Index Scan using ix_ord_items_order_id on ord_items i_1 (cost=0.43..65.22 rows=18 width=34) (actual time=0.029..0.051 rows=12 loops=1)

  • Index Cond: ((order_id)::bpchar = 'OR18110003408171'::bpchar)
8. 0.017 0.072 ↓ 4.0 12 12

Materialize (cost=0.43..23.40 rows=3 width=68) (actual time=0.002..0.006 rows=12 loops=12)

9. 0.055 0.055 ↓ 4.0 12 1

Index Scan using ix_fnd_order_journal_order_id on fnd_order_journal o (cost=0.43..23.39 rows=3 width=68) (actual time=0.022..0.055 rows=12 loops=1)

  • Index Cond: ((order_id)::bpchar = 'OR18110003408171'::bpchar)
  • Filter: ((type_entry)::text = 'APPLY'::text)
  • Rows Removed by Filter: 12
10. 0.048 0.048 ↑ 1.0 1 12

Index Scan using pk_fnd_funds on fnd_funds d_4 (cost=0.42..8.44 rows=1 width=51) (actual time=0.003..0.004 rows=1 loops=12)

  • Index Cond: ((fund_id)::bpchar = (o.fund_id)::bpchar)
11. 0.072 0.072 ↑ 1.0 1 12

Index Scan using ix_fnd_budgets_budget_id on fnd_budgets b (cost=0.28..2.15 rows=1 width=34) (actual time=0.006..0.006 rows=1 loops=12)

  • Index Cond: ((budget_id)::bpchar = (d_4.budget_id)::bpchar)
  • Filter: (((budget_type)::text = 'ACCOUNTS'::text) AND ((d_4.master_account_id)::bpchar = (master_account_id)::bpchar))
12. 0.008 0.739 ↓ 12.0 12 1

Nested Loop Left Join (cost=2.40..86.24 rows=1 width=229) (actual time=0.394..0.739 rows=12 loops=1)

13. 0.014 0.671 ↓ 12.0 12 1

Nested Loop Left Join (cost=1.85..82.16 rows=1 width=205) (actual time=0.384..0.671 rows=12 loops=1)

14. 0.007 0.609 ↓ 12.0 12 1

Nested Loop Left Join (cost=1.29..78.08 rows=1 width=181) (actual time=0.361..0.609 rows=12 loops=1)

15. 0.026 0.542 ↓ 12.0 12 1

Nested Loop (cost=0.86..73.97 rows=1 width=157) (actual time=0.346..0.542 rows=12 loops=1)

16. 0.046 0.480 ↓ 12.0 12 1

Nested Loop (cost=0.43..65.51 rows=1 width=66) (actual time=0.324..0.480 rows=12 loops=1)

  • Join Filter: (((i.cart_id)::bpchar = (c.cart_id)::bpchar) AND ((i.cart_item_id)::bpchar = (c.cart_item_id)::bpchar))
  • Rows Removed by Join Filter: 132
17. 0.314 0.314 ↓ 12.0 12 1

CTE Scan on cte_cart_item_funds c (cost=0.00..0.02 rows=1 width=96) (actual time=0.307..0.314 rows=12 loops=1)

18. 0.120 0.120 ↑ 1.5 12 12

Index Scan using ix_ord_items_order_id on ord_items i (cost=0.43..65.22 rows=18 width=34) (actual time=0.004..0.010 rows=12 loops=12)

  • Index Cond: ((order_id)::bpchar = 'OR18110003408171'::bpchar)
19. 0.036 0.036 ↑ 1.0 1 12

Index Scan using pk_fnd_order_journal on fnd_order_journal f (cost=0.43..8.45 rows=1 width=123) (actual time=0.003..0.003 rows=1 loops=12)

  • Index Cond: ((fund_journal_id)::bpchar = c.fund_journal_id)
20. 0.060 0.060 ↑ 2.0 1 12

Index Scan using ix_fnd_order_journal_details_fund_journal_id on fnd_order_journal_details d (cost=0.43..4.09 rows=2 width=41) (actual time=0.004..0.005 rows=1 loops=12)

  • Index Cond: ((f.fund_journal_id)::bpchar = (fund_journal_id)::bpchar)
  • Filter: ((price_group)::text = 'BASE PRICE'::text)
  • Rows Removed by Filter: 2
21. 0.048 0.048 ↓ 0.0 0 12

Index Scan using pk_fnd_order_journal_details on fnd_order_journal_details d_1 (cost=0.56..4.07 rows=1 width=41) (actual time=0.004..0.004 rows=0 loops=12)

  • Index Cond: (((f.fund_journal_id)::bpchar = (fund_journal_id)::bpchar) AND ((price_group)::text = 'POSTAGE'::text))
22. 0.060 0.060 ↑ 1.0 1 12

Index Scan using pk_fnd_order_journal_details on fnd_order_journal_details d_2 (cost=0.56..4.07 rows=1 width=41) (actual time=0.004..0.005 rows=1 loops=12)

  • Index Cond: (((f.fund_journal_id)::bpchar = (fund_journal_id)::bpchar) AND ((price_group)::text = 'SHIPPING'::text))
23. 0.036 0.036 ↑ 1.0 1 12

Index Scan using pk_fnd_order_journal_details on fnd_order_journal_details d_3 (cost=0.56..4.07 rows=1 width=41) (actual time=0.003..0.003 rows=1 loops=12)

  • Index Cond: (((f.fund_journal_id)::bpchar = (fund_journal_id)::bpchar) AND ((price_group)::text = 'TAX'::text))