explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aAxQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.111 ↓ 0.0 0 1

Nested Loop Left Join (cost=51.84..60.93 rows=1 width=283) (actual time=0.111..0.111 rows=0 loops=1)

2.          

CTE cte_cart_item_funds

3. 0.000 0.108 ↓ 0.0 0 1

HashAggregate (cost=49.68..49.69 rows=1 width=68) (actual time=0.108..0.108 rows=0 loops=1)

4. 0.004 0.108 ↓ 0.0 0 1

Nested Loop (cost=1.12..49.67 rows=1 width=68) (actual time=0.108..0.108 rows=0 loops=1)

5. 0.011 0.080 ↓ 4.0 12 1

Nested Loop (cost=0.85..48.74 rows=3 width=102) (actual time=0.039..0.080 rows=12 loops=1)

6. 0.045 0.045 ↓ 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.031..0.045 rows=12 loops=1)

  • Index Cond: ((order_id)::bpchar = 'OR18110003408171'::bpchar)
  • Filter: ((type_entry)::text = 'APPLY'::text)
  • Rows Removed by Filter: 12
7. 0.024 0.024 ↑ 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.002..0.002 rows=1 loops=12)

  • Index Cond: ((fund_id)::bpchar = (o.fund_id)::bpchar)
8. 0.024 0.024 ↓ 0.0 0 12

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

  • Index Cond: ((budget_id)::bpchar = (d_4.budget_id)::bpchar)
  • Filter: (((budget_type)::text = 'ASSETS'::text) AND ((d_4.master_account_id)::bpchar = (master_account_id)::bpchar))
  • Rows Removed by Filter: 1
9. 0.000 0.110 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.72..10.45 rows=1 width=259) (actual time=0.110..0.110 rows=0 loops=1)

10. 0.000 0.110 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.29..9.79 rows=1 width=235) (actual time=0.110..0.110 rows=0 loops=1)

11. 0.001 0.110 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.86..9.14 rows=1 width=211) (actual time=0.110..0.110 rows=0 loops=1)

12. 0.000 0.109 ↓ 0.0 0 1

Nested Loop (cost=0.43..8.48 rows=1 width=187) (actual time=0.109..0.109 rows=0 loops=1)

13. 0.109 0.109 ↓ 0.0 0 1

CTE Scan on cte_cart_item_funds c (cost=0.00..0.02 rows=1 width=96) (actual time=0.109..0.109 rows=0 loops=1)

14. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_fnd_order_journal on fnd_order_journal f (cost=0.43..8.45 rows=1 width=123) (never executed)

  • Index Cond: ((fund_journal_id)::bpchar = c.fund_journal_id)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_fnd_order_journal_details_fund_journal_id on fnd_order_journal_details d (cost=0.43..0.64 rows=2 width=41) (never executed)

  • Index Cond: ((f.fund_journal_id)::bpchar = (fund_journal_id)::bpchar)
  • Filter: ((price_group)::text = 'BASE PRICE'::text)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_fnd_order_journal_details_fund_journal_id on fnd_order_journal_details d_1 (cost=0.43..0.64 rows=1 width=41) (never executed)

  • Index Cond: ((f.fund_journal_id)::bpchar = (fund_journal_id)::bpchar)
  • Filter: ((price_group)::text = 'POSTAGE'::text)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_fnd_order_journal_details_fund_journal_id on fnd_order_journal_details d_2 (cost=0.43..0.64 rows=1 width=41) (never executed)

  • Index Cond: ((f.fund_journal_id)::bpchar = (fund_journal_id)::bpchar)
  • Filter: ((price_group)::text = 'SHIPPING'::text)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_fnd_order_journal_details_fund_journal_id on fnd_order_journal_details d_3 (cost=0.43..0.64 rows=1 width=41) (never executed)

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