explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nPZu

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=)

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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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=)

  • 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 tjs110 a (cost=156,890.03..8,687,463.50 rows=3,369,462 width=185) (actual rows= loops=)

  • Recheck Cond: ((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: ((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=)

31. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on tjs400 e1 (cost=138,620.14..5,028,462.28 rows=2,564,661 width=46) (actual rows= loops=)

  • Recheck Cond: (((clsn_yymm)::text = '201701'::text) AND ((resf_sc_cd)::text = 'B'::tex (...)
32. 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: (((clsn_yymm)::text = '201701'::text) AND ((resf_sc_cd)::text = 'B': (...)
33. 0.000 0.000 ↓ 0.0

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

34. 0.000 0.000 ↓ 0.0

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

  • Filter: ((info_item_cd)::text = '12'::text)
35. 0.000 0.000 ↓ 0.0

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

36. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: ((to_char(((('1900-01-01'::date + level.level) - 1))::timestamp with time zone, 'YYYYMM (...)
37. 0.000 0.000 ↓ 0.0

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

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

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

39. 0.000 0.000 ↓ 0.0

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

40. 0.000 0.000 ↓ 0.0

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

  • Filter: (chld_seq = '1'::numeric)
41. 0.000 0.000 ↓ 0.0

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

  • Sort Key: d.cov_cd, d.pol_no, d.pao_grp_kd_cd, d.pao_grp_seq
42. 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=)

43. 0.000 0.000 ↓ 0.0

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

  • Group Key: d1.clsn_yymm, d1.pol_no, d1.pao_grp_kd_cd, d1.pao_grp_seq, d1.cov_cd
44. 0.000 0.000 ↓ 0.0

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

  • Sort Key: d1.pol_no, d1.pao_grp_kd_cd, d1.pao_grp_seq, d1.cov_cd
45. 0.000 0.000 ↓ 0.0

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

  • One-Time Filter: false
46. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((clsn_yymm)::text = '201709'::text)
  • Filter: (((prem_dasm_kd_cd)::text ~~ 'P%'::text) AND ((prem_dasm_kd_cd)::text <> 'PC01 (...)
47. 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: ((clsn_yymm)::text = '201709'::text)
48. 0.000 0.000 ↓ 0.0

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

49. 0.000 0.000 ↓ 0.0

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

50. 0.000 0.000 ↓ 0.0

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

  • Group Key: tjs170.clsn_yymm, tjs170.pol_no
51. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjs170.pol_no
52. 0.000 0.000 ↓ 0.0

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

  • One-Time Filter: false
53. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((clsn_yymm)::text = '$$1'::text)
54. 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: ((clsn_yymm)::text = '$$1'::text)
55. 0.000 0.000 ↓ 0.0

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

56. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((clsn_yymm)::text = '201701'::text)
57. 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: ((clsn_yymm)::text = '201701'::text)
58. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060.cov_cd
59. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '001'::text)
60. 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: ((calc_kd_cd)::text = '1'::text)
61. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_1.cov_cd
62. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '002'::text)
63. 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: ((calc_kd_cd)::text = '1'::text)
64. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_2.cov_cd
65. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '012'::text)
66. 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: ((calc_kd_cd)::text = '1'::text)
67. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_3.cov_cd
68. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '079'::text)
69. 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: ((calc_kd_cd)::text = '1'::text)
70. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_4.cov_cd
71. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '080'::text)
72. 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: ((calc_kd_cd)::text = '1'::text)
73. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_5.cov_cd
74. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '081'::text)
75. 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: ((calc_kd_cd)::text = '1'::text)
76. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_6.cov_cd
77. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '083'::text)
78. 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: ((calc_kd_cd)::text = '1'::text)
79. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_7.cov_cd
80. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '085'::text)
81. 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: ((calc_kd_cd)::text = '1'::text)
82. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_8.cov_cd
83. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '086'::text)
84. 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: ((calc_kd_cd)::text = '1'::text)
85. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_9.cov_cd
86. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '087'::text)
87. 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: ((calc_kd_cd)::text = '1'::text)
88. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_10.cov_cd
89. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '088'::text)
90. 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: ((calc_kd_cd)::text = '1'::text)
91. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_11.cov_cd
92. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '089'::text)
93. 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: ((calc_kd_cd)::text = '1'::text)
94. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_12.cov_cd
95. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '091'::text)
96. 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: ((calc_kd_cd)::text = '1'::text)
97. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_13.cov_cd
98. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '092'::text)
99. 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: ((calc_kd_cd)::text = '1'::text)
100. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_14.cov_cd
101. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '093'::text)
102. 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: ((calc_kd_cd)::text = '1'::text)
103. 0.000 0.000 ↓ 0.0

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

104. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_15.cov_cd
105. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '094'::text)
106. 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: ((calc_kd_cd)::text = '1'::text)
107. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_16.cov_cd
108. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '095'::text)
109. 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: ((calc_kd_cd)::text = '1'::text)
110. 0.000 0.000 ↓ 0.0

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

111. 0.000 0.000 ↓ 0.0

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

  • Sort Key: tjp060_17.cov_cd
112. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((calc_kd_cd)::text = '1'::text)
  • Filter: ((calc_base_item_cd)::text = '096'::text)
113. 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: ((calc_kd_cd)::text = '1'::text)