explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MryN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

WindowAgg (cost=3,212,901,270,643.35..3,613,671,837,667.33 rows=1,121,036,551,116 width=1,411) (actual rows= loops=)

  • Output: to_char((last_day(to_date(((a.clsn_yymm)::text || '01'::text), 'YYYYMMDD'::text)))::timestamp with time zone, 'YYYYMMDD'::text), a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, CASE WHEN ((a.mkzr_deal_yn)::text = 'Y'::text) THEN '1'::t (...)
2. 0.000 0.000 ↓ 0.0

Sort (cost=3,212,901,270,643.35..3,215,703,862,021.15 rows=1,121,036,551,116 width=650) (actual rows= loops=)

  • Output: a.pol_no, a.pao_grp_seq, a.cov_cd, a.bas_opt_kd_cd, a.clsn_yymm, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, b.subs_d, a.insr_srt_d, a.insr_fin_d, a.renw_tod, b.sttl_chnl_kd_cd, tjc350.info_item_char_val, a.pao_grp_kd_cd, a.inst_expr_yy_c, a.au (...)
  • Sort Key: a.pol_no, a.pao_grp_seq, a.bas_opt_kd_cd, a.cov_cd
3. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,089,284.88..383,003,009,353.01 rows=1,121,036,551,116 width=650) (actual rows= loops=)

  • Output: a.pol_no, a.pao_grp_seq, a.cov_cd, a.bas_opt_kd_cd, a.clsn_yymm, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, b.subs_d, a.insr_srt_d, a.insr_fin_d, a.renw_tod, b.sttl_chnl_kd_cd, tjc350.info_item_char_val, a.pao_grp_kd_cd, a.inst_expr_yy_c (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_17.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_17.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_17.renw_tod)::text))
4. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,089,022.98..380,063,865,679.54 rows=1,121,036,551,116 width=645) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr_yy_c, a.auto_renw_kd_cd, a.expr_yy_c, a.pay_yy_c, a.inst_age, a.inst_se (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_16.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_16.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_16.renw_tod)::text))
5. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,088,761.08..376,988,169,972.29 rows=1,121,036,551,116 width=640) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr_yy_c, a.auto_renw_kd_cd, a.expr_yy_c, a.pay_yy_c, a.inst_age, a.i (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_15.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_15.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_15.renw_tod)::text))
6. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,088,499.18..374,049,026,298.82 rows=1,121,036,551,116 width=635) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr_yy_c, a.auto_renw_kd_cd, a.expr_yy_c, a.pay_yy_c, a.inst_ag (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_14.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_14.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_14.renw_tod)::text))
7. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,088,237.29..370,973,330,591.57 rows=1,121,036,551,116 width=630) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr_yy_c, a.auto_renw_kd_cd, a.expr_yy_c, a.pay_yy_c, a.i (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_13.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_13.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_13.renw_tod)::text))
8. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,087,975.30..367,214,874,715.31 rows=1,121,036,551,116 width=625) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr_yy_c, a.auto_renw_kd_cd, a.expr_yy_c, a.pay_yy_ (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_12.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_12.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_12.renw_tod)::text))
9. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,087,713.31..363,456,418,839.05 rows=1,121,036,551,116 width=620) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr_yy_c, a.auto_renw_kd_cd, a.expr_yy_c, a.p (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_11.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_11.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_11.renw_tod)::text))
10. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,087,449.78..353,006,913,305.82 rows=1,121,036,551,116 width=615) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr_yy_c, a.auto_renw_kd_cd, a.expr_yy_ (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_10.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_10.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_10.renw_tod)::text))
11. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,087,186.15..342,147,751,671.13 rows=1,121,036,551,116 width=610) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr_yy_c, a.auto_renw_kd_cd, a.ex (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_9.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_9.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_9.renw_tod)::text))
12. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,086,923.55..335,385,151,051.00 rows=1,121,036,551,116 width=605) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr_yy_c, a.auto_renw_kd_cd (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_8.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_8.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_8.renw_tod)::text))
13. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,086,657.99..317,869,077,767.39 rows=1,121,036,551,116 width=600) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr_yy_c, a.auto_renw (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_7.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_7.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_7.renw_tod)::text))
14. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,086,395.77..312,881,653,586.85 rows=1,121,036,551,116 width=595) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr_yy_c, a.aut (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_6.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_6.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_6.renw_tod)::text))
15. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,086,133.69..308,576,989,575.36 rows=1,121,036,551,116 width=590) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr_yy_c, (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_5.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_5.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_5.renw_tod)::text))
16. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,085,871.76..305,228,189,800.50 rows=1,121,036,551,116 width=585) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.inst_expr (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_4.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_4.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_4.renw_tod)::text))
17. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,085,609.84..301,879,390,025.64 rows=1,121,036,551,116 width=580) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, a.ins (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_3.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_3.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_3.renw_tod)::text))
18. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,085,347.91..298,530,590,250.79 rows=1,121,036,551,116 width=575) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_kd_cd, (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_2.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_2.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_2.renw_tod)::text))
19. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,085,079.95..273,367,603,072.88 rows=1,121,036,551,116 width=570) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pao_grp_ (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060_1.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060_1.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060_1.renw_tod)::text))
20. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,084,787.58..182,113,431,519.02 rows=1,121,036,551,116 width=565) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod, a.pa (...)
  • Merge Cond: ((a.cov_cd)::text = (tjp060.cov_cd)::text)
  • Join Filter: (((a.prod_cd)::text = (tjp060.prod_cd)::text) AND ((a.renw_tod)::text = (tjp060.renw_tod)::text))
21. 0.000 0.000 ↓ 0.0

Nested Loop (cost=21,084,472.63..35,931,204,352.86 rows=1,121,036,551,116 width=560) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.renw_tod (...)
22. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=21,073,932.89..21,181,672.44 rows=3,591,316 width=438) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d, a.re (...)
  • Inner Unique: true
  • Join Filter: (((a.clsn_yymm)::text = (f.clsn_yymm)::text) AND ((a.pol_no)::text = (f.pol_no)::text))
23. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,073,756.09..21,118,647.57 rows=3,591,316 width=374) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr_fin_d (...)
  • Inner Unique: true
  • Merge Cond: (((a.cov_cd)::text = (d.cov_cd)::text) AND ((a.pol_no)::text = (d.pol_no)::text) AND ((a.pao_grp_kd_cd)::text (...)
  • Join Filter: ((a.clsn_yymm)::text = (d.clsn_yymm)::text)
24. 0.000 0.000 ↓ 0.0

Sort (cost=16,383,396.47..16,392,374.76 rows=3,591,316 width=246) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, a.insr (...)
  • Sort Key: a.cov_cd, a.pol_no, a.pao_grp_kd_cd, a.pao_grp_seq
25. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5,293,890.18..14,740,321.02 rows=3,591,316 width=246) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_srt_d, (...)
  • Hash Cond: (((a.pol_no)::text = (a1.pol_no)::text) AND (a.pao_grp_seq = a1.inst_seq))
26. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5,292,811.07..14,606,957.97 rows=3,591,316 width=203) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a.insr_s (...)
  • Hash Cond: ((a.pol_no)::text = (tjc350.pol_no)::text)
27. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5,265,598.18..14,040,624.86 rows=3,369,462 width=198) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_yn, a. (...)
  • Inner Unique: true
  • Hash Cond: (((a.clsn_yymm)::text = (e1.clsn_yymm)::text) AND ((a.pol_no)::text = (e1.pol_no)::text (...)
28. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjs110 a (cost=156,890.03..8,687,463.50 rows=3,369,462 width=185) (actual rows= loops=)

  • Output: a.clsn_yymm, a.pol_no, a.pao_grp_seq, a.cov_cd, a.prod_cd, a.clf_kd_cd, a.mkzr_deal_ (...)
  • Recheck Cond: ((a.clsn_yymm)::text = '201701'::text)
29. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjs110_pk (cost=0.00..156,047.66 rows=3,369,462 width=0) (actual rows= loops=)

  • Index Cond: ((a.clsn_yymm)::text = '201701'::text)
30. 0.000 0.000 ↓ 0.0

Hash (cost=5,028,462.28..5,028,462.28 rows=2,564,661 width=46) (actual rows= loops=)

  • Output: e1.base_entr_amt, e1.nprm_md_accu_amt, e1.tmn_md_accu_amt, e1.prpd_prem, e1.clsn_yym (...)
  • -> Bitmap Heap Scan on ltcontract.tjs400 e1 (cost=138620.14..5028462.28 rows=2564661 width (...)
  • Output: e1.base_entr_amt, e1.nprm_md_accu_amt, e1.tmn_md_accu_amt, e1.prpd_prem, e1.cl (...)
  • Recheck Cond: (((e1.clsn_yymm)::text = '201701'::text) AND ((e1.resf_sc_cd)::text = 'B (...)
31. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjs400_pk (cost=0.00..137,978.98 rows=2,564,661 width=0) (actual rows= loops=)

  • Index Cond: (((e1.clsn_yymm)::text = '201701'::text) AND ((e1.resf_sc_cd)::text (...)
32. 0.000 0.000 ↓ 0.0

Hash (cost=17,650.69..17,650.69 rows=520,816 width=18) (actual rows= loops=)

  • Output: tjc350.info_item_char_val, tjc350.pol_no
33. 0.000 0.000 ↓ 0.0

Seq Scan on ltcontract.tjc350 (cost=0.00..17,650.69 rows=520,816 width=18) (actual rows= loops=)

  • Output: tjc350.info_item_char_val, tjc350.pol_no
  • Filter: ((tjc350.info_item_cd)::text = '12'::text)
34. 0.000 0.000 ↓ 0.0

Hash (cost=848.57..848.57 rows=15,370 width=61) (actual rows= loops=)

  • Output: a1.chld_bith_d, a1.chld_sex_cd, a1.pol_no, a1.inst_seq, (to_char(((('1900-01-01'::date + level.l (...)
35. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=768.45..848.57 rows=15,370 width=61) (actual rows= loops=)

  • Output: a1.chld_bith_d, a1.chld_sex_cd, a1.pol_no, a1.inst_seq, (to_char(((('1900-01-01'::date + l (...)
  • Hash Cond: ((to_char(((('1900-01-01'::date + level.level) - 1))::timestamp with time zone, 'YYYYMM (...)
36. 0.000 0.000 ↓ 0.0

Sort (cost=69.85..72.35 rows=1,000 width=32) (actual rows= loops=)

  • Output: (to_char(((('1900-01-01'::date + level.level) - 1))::timestamp with time zone, 'YYYY (...)
  • Sort Key: (to_char(((('1900-01-01'::date + level.level) - 1))::timestamp with time zone, 'YY (...)
37. 0.000 0.000 ↓ 0.0

Function Scan on pg_catalog.generate_series level (cost=0.02..20.02 rows=1,000 width=32) (actual rows= loops=)

  • Output: to_char(((('1900-01-01'::date + level.level) - 1))::timestamp with time zone, (...)
  • Function Call: generate_series(1, ((date_part('YEAR'::text, age(now(), ('1900-01-01':: (...)
38. 0.000 0.000 ↓ 0.0

Hash (cost=506.48..506.48 rows=15,370 width=29) (actual rows= loops=)

  • Output: a1.chld_bith_d, a1.chld_sex_cd, a1.pol_no, a1.inst_seq
39. 0.000 0.000 ↓ 0.0

Seq Scan on ltcontract.tjr810 a1 (cost=0.00..506.48 rows=15,370 width=29) (actual rows= loops=)

  • Output: a1.chld_bith_d, a1.chld_sex_cd, a1.pol_no, a1.inst_seq
  • Filter: (a1.chld_seq = '1'::numeric)
40. 0.000 0.000 ↓ 0.0

Sort (cost=4,690,359.62..4,690,359.63 rows=1 width=161) (actual rows= loops=)

  • Output: d.dc_prem1, d.dc_prem2, d.dc_prem3, d.risk_prem, d.clsn_yymm, d.pol_no, d.pao_grp_kd_cd, d.pao_grp_seq, d.co (...)
  • Sort Key: d.cov_cd, d.pol_no, d.pao_grp_kd_cd, d.pao_grp_seq
41. 0.000 0.000 ↓ 0.0

Subquery Scan on d (cost=4,690,359.56..4,690,359.61 rows=1 width=161) (actual rows= loops=)

  • Output: d.dc_prem1, d.dc_prem2, d.dc_prem3, d.risk_prem, d.clsn_yymm, d.pol_no, d.pao_grp_kd_cd, d.pao_grp_seq (...)
42. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4,690,359.56..4,690,359.60 rows=1 width=161) (actual rows= loops=)

  • Output: d1.clsn_yymm, d1.pol_no, d1.pao_grp_kd_cd, d1.pao_grp_seq, d1.cov_cd, sum(d1.risk_prem), sum(d1. (...)
  • Group Key: d1.clsn_yymm, d1.pol_no, d1.pao_grp_kd_cd, d1.pao_grp_seq, d1.cov_cd
43. 0.000 0.000 ↓ 0.0

Sort (cost=4,690,359.56..4,690,359.56 rows=1 width=46) (actual rows= loops=)

  • Output: d1.clsn_yymm, d1.pol_no, d1.pao_grp_kd_cd, d1.pao_grp_seq, d1.cov_cd, d1.risk_prem, d1.dc_ (...)
  • Sort Key: d1.pol_no, d1.pao_grp_kd_cd, d1.pao_grp_seq, d1.cov_cd
44. 0.000 0.000 ↓ 0.0

Result (cost=144,812.32..4,690,359.55 rows=1 width=46) (actual rows= loops=)

  • Output: d1.clsn_yymm, d1.pol_no, d1.pao_grp_kd_cd, d1.pao_grp_seq, d1.cov_cd, d1.risk_prem, (...)
  • One-Time Filter: false
45. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjs290 d1 (cost=144,812.32..4,690,359.55 rows=1 width=46) (actual rows= loops=)

  • Output: d1.clsn_yymm, d1.pol_no, d1.tr_seq, d1.seq, d1.pao_grp_kd_cd, d1.pao_grp_seq, (...)
  • Recheck Cond: ((d1.clsn_yymm)::text = '201709'::text)
  • Filter: (((d1.prem_dasm_kd_cd)::text ~~ 'P%'::text) AND ((d1.prem_dasm_kd_cd)::text <> (...)
46. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pk_tjs290 (cost=0.00..144,812.32 rows=2,468,750 width=0) (actual rows= loops=)

  • Index Cond: ((d1.clsn_yymm)::text = '201709'::text)
47. 0.000 0.000 ↓ 0.0

Materialize (cost=176.79..176.84 rows=1 width=84) (actual rows= loops=)

  • Output: f.loan_bal, f.uclt_int_amt, f.clsn_yymm, f.pol_no
48. 0.000 0.000 ↓ 0.0

Subquery Scan on f (cost=176.79..176.83 rows=1 width=84) (actual rows= loops=)

  • Output: f.loan_bal, f.uclt_int_amt, f.clsn_yymm, f.pol_no
49. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=176.79..176.82 rows=1 width=84) (actual rows= loops=)

  • Output: tjs170.clsn_yymm, tjs170.pol_no, sum(tjs170.loan_bal), sum(tjs170.uclt_int_amt)
  • Group Key: tjs170.clsn_yymm, tjs170.pol_no
50. 0.000 0.000 ↓ 0.0

Sort (cost=176.79..176.80 rows=1 width=31) (actual rows= loops=)

  • Output: tjs170.clsn_yymm, tjs170.pol_no, tjs170.loan_bal, tjs170.uclt_int_amt
  • Sort Key: tjs170.pol_no
51. 0.000 0.000 ↓ 0.0

Result (cost=4.80..176.78 rows=1 width=31) (actual rows= loops=)

  • Output: tjs170.clsn_yymm, tjs170.pol_no, tjs170.loan_bal, tjs170.uclt_int_amt
  • One-Time Filter: false
52. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjs170 (cost=4.80..176.78 rows=1 width=31) (actual rows= loops=)

  • Output: tjs170.clsn_yymm, tjs170.pol_no, tjs170.loan_seq, tjs170.prod_cd, tjs170.last_loan_d (...)
  • Recheck Cond: ((tjs170.clsn_yymm)::text = '$$1'::text)
53. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjs170_pk (cost=0.00..4.80 rows=69 width=0) (actual rows= loops=)

  • Index Cond: ((tjs170.clsn_yymm)::text = '$$1'::text)
54. 0.000 0.000 ↓ 0.0

Materialize (cost=10,539.74..820,005.40 rows=312,152 width=129) (actual rows= loops=)

  • Output: b.subs_d, b.sttl_chnl_kd_cd, b.pay_cycl_cd, b.pay_exm_d, b.fpay_d, b.last_pay_tod, b.cot_stat_cd, b.ann_begn_agecd, b.an (...)
55. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjs100 b (cost=10,539.74..812,347.64 rows=312,152 width=129) (actual rows= loops=)

  • Output: b.subs_d, b.sttl_chnl_kd_cd, b.pay_cycl_cd, b.pay_exm_d, b.fpay_d, b.last_pay_tod, b.cot_stat_cd, b.ann_begn_agecd (...)
  • Recheck Cond: ((b.clsn_yymm)::text = '201701'::text)
56. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjs100_pk (cost=0.00..10,461.70 rows=312,152 width=0) (actual rows= loops=)

  • Index Cond: ((b.clsn_yymm)::text = '201701'::text)
57. 0.000 0.000 ↓ 0.0

Sort (cost=314.96..317.59 rows=1,052 width=21) (actual rows= loops=)

  • Output: tjp060.seq, tjp060.prod_cd, tjp060.cov_cd, tjp060.renw_tod
  • Sort Key: tjp060.cov_cd
58. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 (cost=85.42..262.15 rows=1,052 width=21) (actual rows= loops=)

  • Output: tjp060.seq, tjp060.prod_cd, tjp060.cov_cd, tjp060.renw_tod
  • Recheck Cond: ((tjp060.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060.calc_base_item_cd)::text = '001'::text)
59. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060.calc_kd_cd)::text = '1'::text)
60. 0.000 0.000 ↓ 0.0

Sort (cost=292.36..293.99 rows=649 width=21) (actual rows= loops=)

  • Output: tjp060_1.seq, tjp060_1.prod_cd, tjp060_1.cov_cd, tjp060_1.renw_tod
  • Sort Key: tjp060_1.cov_cd
61. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_1 (cost=85.31..262.05 rows=649 width=21) (actual rows= loops=)

  • Output: tjp060_1.seq, tjp060_1.prod_cd, tjp060_1.cov_cd, tjp060_1.renw_tod
  • Recheck Cond: ((tjp060_1.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_1.calc_base_item_cd)::text = '002'::text)
62. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_1.calc_kd_cd)::text = '1'::text)
63. 0.000 0.000 ↓ 0.0

Sort (cost=267.96..268.37 rows=164 width=21) (actual rows= loops=)

  • Output: tjp060_2.seq, tjp060_2.prod_cd, tjp060_2.cov_cd, tjp060_2.renw_tod
  • Sort Key: tjp060_2.cov_cd
64. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_2 (cost=85.19..261.93 rows=164 width=21) (actual rows= loops=)

  • Output: tjp060_2.seq, tjp060_2.prod_cd, tjp060_2.cov_cd, tjp060_2.renw_tod
  • Recheck Cond: ((tjp060_2.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_2.calc_base_item_cd)::text = '012'::text)
65. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_2.calc_kd_cd)::text = '1'::text)
66. 0.000 0.000 ↓ 0.0

Sort (cost=261.93..261.94 rows=4 width=21) (actual rows= loops=)

  • Output: tjp060_3.seq, tjp060_3.prod_cd, tjp060_3.cov_cd, tjp060_3.renw_tod
  • Sort Key: tjp060_3.cov_cd
67. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_3 (cost=85.15..261.89 rows=4 width=21) (actual rows= loops=)

  • Output: tjp060_3.seq, tjp060_3.prod_cd, tjp060_3.cov_cd, tjp060_3.renw_tod
  • Recheck Cond: ((tjp060_3.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_3.calc_base_item_cd)::text = '079'::text)
68. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_3.calc_kd_cd)::text = '1'::text)
69. 0.000 0.000 ↓ 0.0

Sort (cost=261.93..261.94 rows=4 width=21) (actual rows= loops=)

  • Output: tjp060_4.seq, tjp060_4.prod_cd, tjp060_4.cov_cd, tjp060_4.renw_tod
  • Sort Key: tjp060_4.cov_cd
70. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_4 (cost=85.15..261.89 rows=4 width=21) (actual rows= loops=)

  • Output: tjp060_4.seq, tjp060_4.prod_cd, tjp060_4.cov_cd, tjp060_4.renw_tod
  • Recheck Cond: ((tjp060_4.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_4.calc_base_item_cd)::text = '080'::text)
71. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_4.calc_kd_cd)::text = '1'::text)
72. 0.000 0.000 ↓ 0.0

Sort (cost=261.93..261.94 rows=4 width=21) (actual rows= loops=)

  • Output: tjp060_5.seq, tjp060_5.prod_cd, tjp060_5.cov_cd, tjp060_5.renw_tod
  • Sort Key: tjp060_5.cov_cd
73. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_5 (cost=85.15..261.89 rows=4 width=21) (actual rows= loops=)

  • Output: tjp060_5.seq, tjp060_5.prod_cd, tjp060_5.cov_cd, tjp060_5.renw_tod
  • Recheck Cond: ((tjp060_5.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_5.calc_base_item_cd)::text = '081'::text)
74. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_5.calc_kd_cd)::text = '1'::text)
75. 0.000 0.000 ↓ 0.0

Sort (cost=262.08..262.11 rows=11 width=21) (actual rows= loops=)

  • Output: tjp060_6.seq, tjp060_6.prod_cd, tjp060_6.cov_cd, tjp060_6.renw_tod
  • Sort Key: tjp060_6.cov_cd
76. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_6 (cost=85.16..261.89 rows=11 width=21) (actual rows= loops=)

  • Output: tjp060_6.seq, tjp060_6.prod_cd, tjp060_6.cov_cd, tjp060_6.renw_tod
  • Recheck Cond: ((tjp060_6.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_6.calc_base_item_cd)::text = '083'::text)
77. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_6.calc_kd_cd)::text = '1'::text)
78. 0.000 0.000 ↓ 0.0

Sort (cost=262.21..262.25 rows=16 width=21) (actual rows= loops=)

  • Output: tjp060_7.seq, tjp060_7.prod_cd, tjp060_7.cov_cd, tjp060_7.renw_tod
  • Sort Key: tjp060_7.cov_cd
79. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_7 (cost=85.16..261.89 rows=16 width=21) (actual rows= loops=)

  • Output: tjp060_7.seq, tjp060_7.prod_cd, tjp060_7.cov_cd, tjp060_7.renw_tod
  • Recheck Cond: ((tjp060_7.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_7.calc_base_item_cd)::text = '085'::text)
80. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_7.calc_kd_cd)::text = '1'::text)
81. 0.000 0.000 ↓ 0.0

Sort (cost=265.56..265.83 rows=108 width=21) (actual rows= loops=)

  • Output: tjp060_8.seq, tjp060_8.prod_cd, tjp060_8.cov_cd, tjp060_8.renw_tod
  • Sort Key: tjp060_8.cov_cd
82. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_8 (cost=85.18..261.91 rows=108 width=21) (actual rows= loops=)

  • Output: tjp060_8.seq, tjp060_8.prod_cd, tjp060_8.cov_cd, tjp060_8.renw_tod
  • Recheck Cond: ((tjp060_8.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_8.calc_base_item_cd)::text = '086'::text)
83. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_8.calc_kd_cd)::text = '1'::text)
84. 0.000 0.000 ↓ 0.0

Sort (cost=262.60..262.67 rows=29 width=21) (actual rows= loops=)

  • Output: tjp060_9.seq, tjp060_9.prod_cd, tjp060_9.cov_cd, tjp060_9.renw_tod
  • Sort Key: tjp060_9.cov_cd
85. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_9 (cost=85.16..261.89 rows=29 width=21) (actual rows= loops=)

  • Output: tjp060_9.seq, tjp060_9.prod_cd, tjp060_9.cov_cd, tjp060_9.renw_tod
  • Recheck Cond: ((tjp060_9.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_9.calc_base_item_cd)::text = '087'::text)
86. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_9.calc_kd_cd)::text = '1'::text)
87. 0.000 0.000 ↓ 0.0

Sort (cost=263.64..263.79 rows=59 width=21) (actual rows= loops=)

  • Output: tjp060_10.seq, tjp060_10.prod_cd, tjp060_10.cov_cd, tjp060_10.renw_tod
  • Sort Key: tjp060_10.cov_cd
88. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_10 (cost=85.17..261.90 rows=59 width=21) (actual rows= loops=)

  • Output: tjp060_10.seq, tjp060_10.prod_cd, tjp060_10.cov_cd, tjp060_10.renw_tod
  • Recheck Cond: ((tjp060_10.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_10.calc_base_item_cd)::text = '088'::text)
89. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_10.calc_kd_cd)::text = '1'::text)
90. 0.000 0.000 ↓ 0.0

Sort (cost=263.53..263.67 rows=56 width=21) (actual rows= loops=)

  • Output: tjp060_11.seq, tjp060_11.prod_cd, tjp060_11.cov_cd, tjp060_11.renw_tod
  • Sort Key: tjp060_11.cov_cd
91. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_11 (cost=85.17..261.90 rows=56 width=21) (actual rows= loops=)

  • Output: tjp060_11.seq, tjp060_11.prod_cd, tjp060_11.cov_cd, tjp060_11.renw_tod
  • Recheck Cond: ((tjp060_11.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_11.calc_base_item_cd)::text = '089'::text)
92. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_11.calc_kd_cd)::text = '1'::text)
93. 0.000 0.000 ↓ 0.0

Sort (cost=261.99..262.01 rows=7 width=21) (actual rows= loops=)

  • Output: tjp060_12.seq, tjp060_12.prod_cd, tjp060_12.cov_cd, tjp060_12.renw_tod
  • Sort Key: tjp060_12.cov_cd
94. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_12 (cost=85.15..261.89 rows=7 width=21) (actual rows= loops=)

  • Output: tjp060_12.seq, tjp060_12.prod_cd, tjp060_12.cov_cd, tjp060_12.renw_tod
  • Recheck Cond: ((tjp060_12.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_12.calc_base_item_cd)::text = '091'::text)
95. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_12.calc_kd_cd)::text = '1'::text)
96. 0.000 0.000 ↓ 0.0

Sort (cost=261.99..262.01 rows=7 width=21) (actual rows= loops=)

  • Output: tjp060_13.seq, tjp060_13.prod_cd, tjp060_13.cov_cd, tjp060_13.renw_tod
  • Sort Key: tjp060_13.cov_cd
97. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_13 (cost=85.15..261.89 rows=7 width=21) (actual rows= loops=)

  • Output: tjp060_13.seq, tjp060_13.prod_cd, tjp060_13.cov_cd, tjp060_13.renw_tod
  • Recheck Cond: ((tjp060_13.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_13.calc_base_item_cd)::text = '092'::text)
98. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_13.calc_kd_cd)::text = '1'::text)
99. 0.000 0.000 ↓ 0.0

Sort (cost=261.90..261.90 rows=2 width=21) (actual rows= loops=)

  • Output: tjp060_14.seq, tjp060_14.prod_cd, tjp060_14.cov_cd, tjp060_14.renw_tod
  • Sort Key: tjp060_14.cov_cd
100. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_14 (cost=85.15..261.89 rows=2 width=21) (actual rows= loops=)

  • Output: tjp060_14.seq, tjp060_14.prod_cd, tjp060_14.cov_cd, tjp060_14.renw_tod
  • Recheck Cond: ((tjp060_14.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_14.calc_base_item_cd)::text = '093'::text)
101. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_14.calc_kd_cd)::text = '1'::text)
102. 0.000 0.000 ↓ 0.0

Materialize (cost=261.90..261.91 rows=1 width=21) (actual rows= loops=)

  • Output: tjp060_15.seq, tjp060_15.prod_cd, tjp060_15.cov_cd, tjp060_15.renw_tod
103. 0.000 0.000 ↓ 0.0

Sort (cost=261.90..261.90 rows=1 width=21) (actual rows= loops=)

  • Output: tjp060_15.seq, tjp060_15.prod_cd, tjp060_15.cov_cd, tjp060_15.renw_tod
  • Sort Key: tjp060_15.cov_cd
104. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_15 (cost=85.15..261.89 rows=1 width=21) (actual rows= loops=)

  • Output: tjp060_15.seq, tjp060_15.prod_cd, tjp060_15.cov_cd, tjp060_15.renw_tod
  • Recheck Cond: ((tjp060_15.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_15.calc_base_item_cd)::text = '094'::text)
105. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_15.calc_kd_cd)::text = '1'::text)
106. 0.000 0.000 ↓ 0.0

Sort (cost=261.90..261.90 rows=2 width=21) (actual rows= loops=)

  • Output: tjp060_16.seq, tjp060_16.prod_cd, tjp060_16.cov_cd, tjp060_16.renw_tod
  • Sort Key: tjp060_16.cov_cd
107. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_16 (cost=85.15..261.89 rows=2 width=21) (actual rows= loops=)

  • Output: tjp060_16.seq, tjp060_16.prod_cd, tjp060_16.cov_cd, tjp060_16.renw_tod
  • Recheck Cond: ((tjp060_16.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_16.calc_base_item_cd)::text = '095'::text)
108. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_16.calc_kd_cd)::text = '1'::text)
109. 0.000 0.000 ↓ 0.0

Materialize (cost=261.90..261.91 rows=1 width=21) (actual rows= loops=)

  • Output: tjp060_17.seq, tjp060_17.prod_cd, tjp060_17.cov_cd, tjp060_17.renw_tod
110. 0.000 0.000 ↓ 0.0

Sort (cost=261.90..261.90 rows=1 width=21) (actual rows= loops=)

  • Output: tjp060_17.seq, tjp060_17.prod_cd, tjp060_17.cov_cd, tjp060_17.renw_tod
  • Sort Key: tjp060_17.cov_cd
111. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ltcontract.tjp060 tjp060_17 (cost=85.15..261.89 rows=1 width=21) (actual rows= loops=)

  • Output: tjp060_17.seq, tjp060_17.prod_cd, tjp060_17.cov_cd, tjp060_17.renw_tod
  • Recheck Cond: ((tjp060_17.calc_kd_cd)::text = '1'::text)
  • Filter: ((tjp060_17.calc_base_item_cd)::text = '096'::text)
112. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tjp060_pk (cost=0.00..85.15 rows=2,249 width=0) (actual rows= loops=)

  • Index Cond: ((tjp060_17.calc_kd_cd)::text = '1'::text)