# | 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)
|
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)
|
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)
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Nested Loop Left Join (cost=51.84..60.93 rows=1 width=283) (actual time=0.111..0.111 rows=0 loops=1) CTE cte_cart_item_funds -> HashAggregate (cost=49.68..49.69 rows=1 width=68) (actual time=0.108..0.108 rows=0 loops=1) -> Nested Loop (cost=1.12..49.67 rows=1 width=68) (actual time=0.108..0.108 rows=0 loops=1) -> Nested Loop (cost=0.85..48.74 rows=3 width=102) (actual time=0.039..0.080 rows=12 loops=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 -> 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) -> 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 -> Nested Loop Left Join (cost=1.72..10.45 rows=1 width=259) (actual time=0.110..0.110 rows=0 loops=1) -> Nested Loop Left Join (cost=1.29..9.79 rows=1 width=235) (actual time=0.110..0.110 rows=0 loops=1) -> Nested Loop Left Join (cost=0.86..9.14 rows=1 width=211) (actual time=0.110..0.110 rows=0 loops=1) -> Nested Loop (cost=0.43..8.48 rows=1 width=187) (actual time=0.109..0.109 rows=0 loops=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) -> 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) -> 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) -> 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) -> 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) -> 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) Total runtime: 0.292 ms 35 rows selected.
node type | count | sum of times | % of query |
---|---|---|---|
CTE Scan | 1 | 0.109 ms | 98.2 % |
HashAggregate | 1 | 0.000 ms | 0.0 % |
Index Scan | 8 | 0.093 ms | 83.8 % |
Nested Loop | 3 | 0.015 ms | 13.5 % |
Nested Loop Left Join | 4 | 0.002 ms | 1.8 % |
Table name | Scan count | Total time | % of query |
---|---|---|---|
scan type | count | sum of times | % of table |
fnd_budgets | 1 | 0.024 ms | 21.6 % |
Index Scan | 1 | 0.024 ms | 100.0 % |
fnd_funds | 1 | 0.024 ms | 21.6 % |
Index Scan | 1 | 0.024 ms | 100.0 % |
fnd_order_journal | 2 | 0.045 ms | 40.5 % |
Index Scan | 2 | 0.045 ms | 100.0 % |
fnd_order_journal_details | 4 | 0.000 ms | 0.0 % |
Index Scan | 4 | 0.000 ms | 0.0 % |