explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bzw : Optimization for: plan #Shon

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.227 0.537 ↓ 12.0 12 1

HashAggregate (cost=58.63..58.78 rows=1 width=190) (actual time=0.514..0.537 rows=12 loops=1)

2. 0.107 0.310 ↓ 36.0 36 1

Nested Loop Left Join (cost=1.55..58.51 rows=1 width=190) (actual time=0.060..0.310 rows=36 loops=1)

3. 0.010 0.131 ↓ 12.0 12 1

Nested Loop (cost=1.12..49.67 rows=1 width=157) (actual time=0.040..0.131 rows=12 loops=1)

4. 0.011 0.085 ↓ 4.0 12 1

Nested Loop (cost=0.85..48.74 rows=3 width=191) (actual time=0.030..0.085 rows=12 loops=1)

5. 0.038 0.038 ↓ 4.0 12 1

Index Scan using ix_fnd_order_journal_order_id on fnd_order_journal f (cost=0.43..23.39 rows=3 width=157) (actual time=0.018..0.038 rows=12 loops=1)

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

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

  • Index Cond: ((fund_id)::bpchar = (f.fund_id)::bpchar)
7. 0.036 0.036 ↑ 1.0 1 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.003..0.003 rows=1 loops=12)

  • Index Cond: ((budget_id)::bpchar = (d.budget_id)::bpchar)
  • Filter: (((budget_type)::text = 'ACCOUNTS'::text) AND ((d.master_account_id)::bpchar = (master_account_id)::bpchar))
8. 0.072 0.072 ↑ 1.0 3 12

Index Scan using ix_fnd_order_journal_details_fund_journal_id on fnd_order_journal_details d_1 (cost=0.43..8.75 rows=3 width=50) (actual time=0.003..0.006 rows=3 loops=12)

  • Index Cond: ((f.fund_journal_id)::bpchar = (fund_journal_id)::bpchar)