explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mokQ : asd

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2,353.864 ↓ 0.0 0 1

Subquery Scan on d (cost=2.35..48,505.61 rows=1 width=1,145) (actual time=2,353.864..2,353.864 rows=0 loops=1)

  • Filter: ((d.row_id >= 0) AND (d.row_id < 10000))
2. 0.001 2,353.863 ↓ 0.0 0 1

WindowAgg (cost=2.35..48,505.59 rows=1 width=1,145) (actual time=2,353.863..2,353.863 rows=0 loops=1)

3. 0.001 2,353.862 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.35..48,505.53 rows=1 width=824) (actual time=2,353.861..2,353.862 rows=0 loops=1)

  • Join Filter: (((dl.company_code)::text = (a.company_code)::text) AND ((dl.prod_type)::text = (a.prod_type)::text) AND (dl.cur_code = a.cur_code))
4. 0.000 2,353.861 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.35..48,504.42 rows=1 width=775) (actual time=2,353.861..2,353.861 rows=0 loops=1)

  • Join Filter: (((pl.company_code)::text = (a.company_code)::text) AND ((pl.prod_code)::text = (a.prod_code)::text) AND (pl.cur_code = a.cur_code))
5. 0.000 2,353.861 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.35..48,487.67 rows=1 width=766) (actual time=2,353.861..2,353.861 rows=0 loops=1)

  • Join Filter: (((pci.prod_code)::text = (a.prod_code)::text) AND ((pci.int_type_code)::text = (ai.int_type_code)::text) AND (pci.cur_code = a.cur_code))
6. 0.000 2,353.861 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.35..48,484.94 rows=1 width=750) (actual time=2,353.861..2,353.861 rows=0 loops=1)

  • Filter: ((aa.last_accrual_date IS NULL) OR (aa.last_accrual_date < to_date('2019-09-09'::text, 'yyyy-mm-dd'::text)))
7. 0.001 2,353.861 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.93..48,483.64 rows=1 width=742) (actual time=2,353.861..2,353.861 rows=0 loops=1)

  • Join Filter: (((i.dest_cont_bal_type)::text = (bt_cont.bal_type_code)::text) AND ((i.prod_type)::text = (bt_cont.prod_type)::text))
8. 0.000 2,353.860 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.93..48,470.84 rows=1 width=793) (actual time=2,353.860..2,353.860 rows=0 loops=1)

  • Join Filter: (((i.dest_bal_type)::text = (bt.bal_type_code)::text) AND ((i.prod_type)::text = (bt.prod_type)::text))
9. 0.000 2,353.860 ↓ 0.0 0 1

Nested Loop (cost=1.93..48,458.04 rows=1 width=786) (actual time=2,353.860..2,353.860 rows=0 loops=1)

  • Join Filter: ((a.prod_code)::text = (p.prod_code)::text)
10. 0.000 2,353.860 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.93..48,422.52 rows=1 width=768) (actual time=2,353.860..2,353.860 rows=0 loops=1)

  • Join Filter: (((pi.prod_code)::text = (a.prod_code)::text) AND ((pi.int_type_code)::text = (ai.int_type_code)::text))
  • Filter: (fnc_pk_bcom_checkfreqday_new(to_date('2019-09-09'::text, 'yyyy-mm-dd'::text), (CASE ai.int_lvl WHEN 'P'::text THEN pi.accr_freq ELSE ai.accr_freq END)::text, (CASE ai.int_lvl WHEN 'P'::text THEN pi.accr_unit ELSE ai.accr_unit END)::integer, (CASE ai.int_lvl WHEN 'P'::text THEN pi.accr_day ELSE ai.accr_day END)::integer, a.start_date, a.end_date, a.next_schd_date) = 1)
11. 0.000 2,353.860 ↓ 0.0 0 1

Nested Loop (cost=1.93..48,131.01 rows=2 width=649) (actual time=2,353.860..2,353.860 rows=0 loops=1)

12. 0.002 2,353.860 ↓ 0.0 0 1

Hash Join (cost=1.51..47,736.05 rows=417 width=560) (actual time=2,353.860..2,353.860 rows=0 loops=1)

  • Hash Cond: (((ai.int_type_code)::text = (i.int_type_code)::text) AND ((ai.prod_type)::text = (i.prod_type)::text))
13. 2,353.858 2,353.858 ↓ 0.0 0 1

Seq Scan on bcom_acnt_int ai (cost=0.00..46,151.19 rows=301,104 width=332) (actual time=2,353.858..2,353.858 rows=0 loops=1)

  • Filter: ((int_stopped = '0'::numeric) AND (CASE WHEN (expire_date IS NULL) THEN (to_date('2019-09-09'::text, 'yyyy-mm-dd'::text) + ('1 days'::cstring)::interval) ELSE (expire_date)::timestamp without time zone END > to_date('2019-09-17'::text, 'yyyy-mm-dd'::text)))
  • Rows Removed by Filter: 903373
14. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.48..1.48 rows=2 width=290) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Seq Scan on bcom_int i (cost=0.00..1.48 rows=2 width=290) (never executed)

  • Filter: ((type)::text = ANY ('{SIMPLE,SIMPLE_H}'::text[]))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_bcom_acnt_link on bcom_acnt a (cost=0.42..0.95 rows=1 width=102) (never executed)

  • Index Cond: ((acnt_code)::text = (ai.acnt_code)::text)
  • Filter: (((company_code)::text = '30'::text) AND ((status)::text <> ALL ('{N,C,D}'::text[])) AND (((prod_type)::text <> 'TD'::text) OR (end_date > to_date('2019-09-17'::text, 'yyyy-mm-dd'::text))) AND (fnc_pk_bcom_check_acnt_code_digit(10, 0, (last_digit)::integer) = 1))
17. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..16.28 rows=485 width=152) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Seq Scan on bcom_prod_int pi (cost=0.00..13.85 rows=485 width=152) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on bcom_prod p (cost=0.00..26.34 rows=734 width=26) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Seq Scan on bcom_bal_types bt (cost=0.00..8.72 rows=272 width=26) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Seq Scan on bcom_bal_types bt_cont (cost=0.00..8.72 rows=272 width=26) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_bcom_acnt_accrual on bcom_acnt_accrual aa (cost=0.42..1.29 rows=1 width=30) (never executed)

  • Index Cond: (((acnt_code)::text = (ai.acnt_code)::text) AND ((int_type_code)::text = (ai.int_type_code)::text) AND (item_no = '0'::numeric))
23. 0.000 0.000 ↓ 0.0 0

Seq Scan on bcom_prod_ccy_int pci (cost=0.00..1.63 rows=63 width=39) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Seq Scan on bcom_prod_limit pl (cost=0.00..10.25 rows=371 width=24) (never executed)

  • Filter: ((company_code)::text = '30'::text)
25. 0.000 0.000 ↓ 0.0 0

Seq Scan on bcom_default_limit dl (cost=0.00..1.10 rows=1 width=148) (never executed)

  • Filter: ((company_code)::text = '30'::text)