explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8R6a

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

Sort (cost=180,190,957,200.73..180,190,957,200.75 rows=10 width=2,629) (actual rows= loops=)

  • Sort Key: crs.plnplnscd, crs.plnsmsino, (max(ck.rltv_dysu)), (max((ck.kteiordr_crskteino)::text)), kc.szicd
2.          

CTE csh

3. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=180,190,318,913.04..180,190,575,625.55 rows=1 width=986) (actual rows= loops=)

  • Hash Cond: ((b.crs_sttng_trm_id = "*SELECT* 1".crs_sttng_trm_id) AND (b.sh_sstcd = "*SELECT* 1".sh_sstcd) AND (b.roomtypcd = "*SELECT* 1".roomtypcd) AND (b.stfkbn = "*SELECT* 1".crs_stfkbn) AND (b.offr_aply_ninzu = "*SELECT* 1".offr_aply_ninzu) AND (b.use_ymd = "*SELECT* 1".use_ymd))
4. 0.000 0.000 ↓ 0.0

Seq Scan on crs_cntrl_amt b (cost=0.00..155,407.36 rows=4,502,436 width=52) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=180,190,318,913.02..180,190,318,913.02 rows=1 width=970) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=180,190,318,850.76..180,190,318,913.02 rows=1 width=970) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".gdskbn = (e.hnyovluecd)::bpchar)
  • Join Filter: ((((e.hnyo_3_kbnvluecd)::text <> ALL ('{02,06}'::text[])) AND ((max("*SELECT* 1".sh_exclddy_flg)) = '0'::bpchar) AND ((max((1))) = 1)) OR ((e.hnyo_3_kbnvluecd)::text = ANY ('{02,06}'::text[])))
7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=180,190,318,810.68..180,190,318,872.61 rows=3 width=1,022) (actual rows= loops=)

  • Join Filter: ((d.aply_bgn_ymd <= "*SELECT* 1".use_ymd) AND (d.aply_end_ymd >= "*SELECT* 1".use_ymd))
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=170,190,318,810.68..170,190,318,869.53 rows=3 width=1,017) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".hksu = c_1.hksu)
9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=170,190,318,808.38..170,190,318,864.80 rows=640 width=1,024) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

HashAggregate (cost=160,190,318,808.10..160,190,318,848.10 rows=640 width=1,016) (actual rows= loops=)

  • Group Key: "*SELECT* 1".plnplnscd, "*SELECT* 1".plnsmsino, "*SELECT* 1".crs_clndr_id, "*SELECT* 1".sh_sstcd, "*SELECT* 1".roomtypcd, "*SELECT* 1".use_ymd, "*SELECT* 1".offr_aply_ninzu, "*SELECT* 1".crs_stfkbn, "*SELECT* 1".lnd_slsamtrltno, "*SELECT* 1".mrm_amt, "*SELECT* 1".mrm_keta, "*SELECT* 1".stndrd_roomtypcd, "*SELECT* 1".crs_sttng_trm_id, "*SELECT* 1".crs_sh_sst_id, "*SELECT* 1".plncd, "*SELECT* 1".hksu, "*SELECT* 1".gdskbn
11. 0.000 0.000 ↓ 0.0

Append (cost=20,025,355,798.71..160,190,318,104.54 rows=6,396 width=134) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=20,025,355,798.71..20,025,770,627.98 rows=945 width=202) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash Join (cost=20,025,355,798.71..20,025,770,618.53 rows=945 width=202) (actual rows= loops=)

  • Hash Cond: ((jj.roomtypebts_chrg_grp_sttng_id = t.id) AND (jj.use_ymd = e_1.dprt_ymd))
14. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt_clndr jj (cost=0.00..322,871.57 rows=12,186,057 width=19) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=20,025,355,787.41..20,025,355,787.41 rows=753 width=208) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
16. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,024,457,370.74..20,025,355,787.41 rows=753 width=208) (actual rows= loops=)

  • Hash Cond: ((f.szicd = ii.szicd) AND ((f.mealcndtnkbn)::text = (ii.mealcndtnkbn)::text) AND (ff.sttngtrmno = ii.sttngtrmno) AND (b_2.szi_slsamtrltno = ii.sh_slsamtrltno) AND (ff.offr_aply_ninzu = ii.offr_aply_ninzu) AND (ff.stfkbn = ii.stfkbn) AND (CASE WHEN (((f.rltv_dysu = 1) AND ((q.srssty_dscnt_aply_dy_cndtn_kbn)::text <> '01'::text)) OR (hh.szicd IS NOT NULL) OR (d_1.hksu < '2'::numeric) OR (gg.szicd IS NULL)) THEN '0'::numeric ELSE d_1.hksu END = ii.srssty_dysu) AND (f.hayatoku_rltv_dysu = ii.hayatoku_rltv_dysu))
17. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,023,771,490.46..20,024,235,067.31 rows=753 width=231) (actual rows= loops=)

  • Hash Cond: ((f.szicd = hh.szicd) AND (d_1.hksu = (hh.srssty_dysu)::numeric) AND (ff.sttngtrmno = hh.sttngtrmno) AND (ff.stfkbn = hh.stfkbn) AND (b_2.szi_slsamtrltno = hh.sh_slsamtrltno))
18. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,023,765,060.61..20,024,211,753.83 rows=753 width=223) (actual rows= loops=)

  • Hash Cond: ((f.szicd = gg.szicd) AND (d_1.hksu = (gg.srssty_dysu)::numeric) AND (ff.sttngtrmno = gg.sttngtrmno) AND (ff.stfkbn = gg.stfkbn))
19. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,023,761,614.38..20,024,207,616.89 rows=753 width=205) (actual rows= loops=)

  • Hash Cond: ((f.szicd = ff.szicd) AND ((f.mealcndtnkbn)::text = (ff.mealcndtnkbn)::text) AND (b_2.szi_slsamtrltno = ff.sh_slsamtrltno) AND (u.offr_aply_ninzu = ff.offr_aply_ninzu) AND (n.sh_stfkbn = ff.stfkbn))
  • Filter: ((f.szicd = 'Z999999'::bpchar) OR ((f.szicd <> 'Z999999'::bpchar) AND (ff.szicd IS NOT NULL)))
20. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=20,023,744,163.59..20,024,183,889.84 rows=753 width=176) (actual rows= loops=)

  • Hash Cond: ((ee.roomtypebts_chrg_grp_sttng_id = t.id) AND (ee.kariszi_sh_tax_amt_slsamtrltno = b_2.sh_tax_amt_slsamtrltno) AND ((ee.chrgrankkbn)::text = (aa.chrgrankkbn)::text) AND (ee.stfkbn = aa.stfkbn) AND ((ee.dvlpfrmealcndtnkbn)::text = (bb.dvlpfrmealcndtnkbn)::text) AND (ee.offr_aply_ninzu = aa.offr_aply_ninzu) AND (ee.hayatoku_rltv_dysu = f.hayatoku_rltv_dysu) AND (ee.rltv_dysu = f.rltv_dysu))
  • Join Filter: ((f.kteikbn)::text = '03'::text)
21. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_sh_tax_amt ee (cost=0.00..200,639.56 rows=7,969,556 width=34) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash (cost=20,023,744,141.00..20,023,744,141.00 rows=753 width=193) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
23. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=20,023,645,070.36..20,023,744,141.00 rows=753 width=193) (actual rows= loops=)

  • Join Filter: (((k.aply_bgn_ymd)::text <= to_char((((to_date((e_1.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)) AND ((k.aply_end_ymd)::text >= to_char((((to_date((e_1.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)))
24. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,023,645,070.36..10,023,744,096.69 rows=753 width=188) (actual rows= loops=)

  • Hash Cond: ((cc.roomtypebts_chrg_grp_sttng_id = t.id) AND (cc.kariszi_hayatoku_dscnt_slsamtrltno = b_2.hayatoku_dscntamt_slsamtrltno) AND (cc.stfkbn = aa.stfkbn) AND (cc.rltv_dysu = f.rltv_dysu) AND (cc.hayatoku_rltv_dysu = f.hayatoku_rltv_dysu))
  • Join Filter: ((f.kteikbn)::text = '03'::text)
25. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_hayatoku_dscntamt cc (cost=0.00..55,108.38 rows=2,342,238 width=25) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,645,053.42..10,023,645,053.42 rows=753 width=185) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
27. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,023,618,972.94..10,023,645,053.42 rows=753 width=185) (actual rows= loops=)

  • Hash Cond: ((bb.roomtypebts_chrg_grp_sttng_id = t.id) AND (bb.stfkbn = aa.stfkbn) AND ((bb.dvlpfrmealcndtnkbn)::text = (f.mealcndtnkbn)::text))
  • Join Filter: (f.szicd = 'Z999999'::bpchar)
28. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_mealcndtnkbn_slsamt bb (cost=0.00..17,428.57 rows=769,057 width=20) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,618,959.76..10,023,618,959.76 rows=753 width=176) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
30. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,023,617,997.13..10,023,618,959.76 rows=753 width=176) (actual rows= loops=)

  • Hash Cond: ((dd.roomtypebts_chrg_grp_sttng_id = t.id) AND (dd.kariszi_srssty_dscnt_slsamtrltno = b_2.srssty_dscntamt_slsamtrltno) AND (dd.stfkbn = aa.stfkbn) AND (dd.rltv_dysu = f.rltv_dysu))
  • Join Filter: ((f.kteikbn)::text = '03'::text)
31. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_srssty_dscntamt dd (cost=0.00..608.85 rows=23,585 width=24) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,617,982.07..10,023,617,982.07 rows=753 width=173) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
33. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,023,493,145.31..10,023,617,982.07 rows=753 width=173) (actual rows= loops=)

  • Hash Cond: ((aa.roomtypebts_chrg_grp_sttng_id = t.id) AND (aa.kariszi_slsamtrltno = b_2.szi_slsamtrltno) AND (aa.stfkbn = n.sh_stfkbn) AND (aa.offr_aply_ninzu = u.offr_aply_ninzu) AND (aa.rltv_dysu = f.rltv_dysu))
  • Join Filter: (f.szicd = 'Z999999'::bpchar)
34. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt aa (cost=0.00..71,040.85 rows=2,868,985 width=34) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,493,128.37..10,023,493,128.37 rows=753 width=154) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
36. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,023,400,095.14..10,023,493,128.37 rows=753 width=154) (actual rows= loops=)

  • Hash Cond: ((e_1.crssttngtrmno = c_2.crssttngtrmno) AND (e_1.crs_id = c_2.crs_id) AND (e_1.lnd_slsamtrltno = b_2.lnd_slsamtrltno))
37. 0.000 0.000 ↓ 0.0

Seq Scan on crs_clndr e_1 (cost=0.00..81,896.80 rows=989,235 width=35) (actual rows= loops=)

  • Filter: (exclddy_flg = '0'::bpchar)
38. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,400,073.11..10,023,400,073.11 rows=1,259 width=176) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
39. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,023,156,557.93..10,023,400,073.11 rows=1,259 width=176) (actual rows= loops=)

  • Hash Cond: (b_2.id = y.crs_szi_rank_id)
40. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank b_2 (cost=0.00..221,791.43 rows=5,789,643 width=26) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,156,542.19..10,023,156,542.19 rows=1,259 width=166) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
42. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,022,972,853.89..10,023,156,542.19 rows=1,259 width=166) (actual rows= loops=)

  • Hash Cond: (y.ktei_cmps_msi_id = a.ktei_cmps_msi_id)
43. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank_cmps y (cost=0.00..163,364.97 rows=5,416,197 width=16) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Hash (cost=10,022,972,853.82..10,022,972,853.82 rows=6 width=174) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
45. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,611,000.24..10,022,972,853.82 rows=6 width=174) (actual rows= loops=)

  • Hash Cond: ((d_1.plncd = v.plncd) AND (to_char(c_2.crssttngtrmno, 'FM00'::text) = (v.sttngtrmno)::text) AND (f.sh_sstcd = v.sstcd))
46. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,610,987.95..10,022,972,841.43 rows=6 width=171) (actual rows= loops=)

  • Hash Cond: ((u.roomtypebts_chrg_grp_sttng_id = t.id) AND (u.stfkbn = n.sh_stfkbn))
47. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=290,463.10..22,642,753.24 rows=1,275,105 width=16) (actual rows= loops=)

  • Hash Cond: ((u.roomtypebts_chrg_grp_sttng_id = u1.roomtypebts_chrg_grp_sttng_id) AND (u.stfkbn = u1.stfkbn) AND (u.offr_aply_ninzu = u1.offr_aply_ninzu) AND (u.kariszi_slsamtrltno = u1.kariszi_slsamtrltno))
  • Join Filter: (u.rltv_dysu > u1.rltv_dysu)
48. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=145,231.55..6,292,528.15 rows=1,912,657 width=23) (actual rows= loops=)

  • Hash Cond: ((u.roomtypebts_chrg_grp_sttng_id = u2.roomtypebts_chrg_grp_sttng_id) AND (u.stfkbn = u2.stfkbn) AND (u.offr_aply_ninzu = u2.offr_aply_ninzu) AND (u.rltv_dysu = u2.rltv_dysu))
  • Join Filter: (u.kariszi_slsamtrltno > u2.kariszi_slsamtrltno)
49. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u2 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u1 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,320,524.83..10,000,320,524.83 rows=1 width=166) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
55. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,319,276.87..10,000,320,524.83 rows=1 width=166) (actual rows= loops=)

  • Hash Cond: ((t.plnplnscd = c_2.plnplnscd) AND (t.plnsmsino = c_2.plnsmsino) AND (t.crssttngtrmno = c_2.crssttngtrmno) AND (t.sh_sstcd = f.sh_sstcd) AND (t.roomtypcd = f.roomtypcd))
56. 0.000 0.000 ↓ 0.0

Seq Scan on roomtypebts_chrg_grp_sttng t (cost=0.00..937.55 rows=16,555 width=39) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,319,276.84..10,000,319,276.84 rows=1 width=191) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
58. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,319,233.23..10,000,319,276.84 rows=1 width=191) (actual rows= loops=)

  • Hash Cond: ((x.crs_sttng_trm_id = f.crs_sttng_trm_id) AND (x.pln_ptn_no = a.pln_ptn_no))
59. 0.000 0.000 ↓ 0.0

Seq Scan on crs_stndrd_ktei_ptn x (cost=0.00..33.06 rows=1,406 width=13) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,319,233.21..10,000,319,233.21 rows=1 width=204) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
61. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,314,030.10..10,000,319,233.21 rows=1 width=204) (actual rows= loops=)

  • Hash Cond: ((z.sh_buyin_irai_gstroom_msi_id = p.id) AND (z.stfkbn = n.sh_stfkbn))
  • Filter: ((z.agree_psbl_flg = '1'::bpchar) OR (f.sh_sstcd = 'ZZZZZZZ'::bpchar))
62. 0.000 0.000 ↓ 0.0

Seq Scan on sh_buyin_irai_gstroom_agree_stf_kbn z (cost=0.00..4,546.05 rows=87,605 width=13) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,314,030.07..10,000,314,030.07 rows=2 width=212) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
64. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,308,343.51..10,000,314,030.07 rows=2 width=212) (actual rows= loops=)

  • Hash Cond: ((d_1.plncd = p.plncd) AND (to_char(c_2.crssttngtrmno, 'FM00'::text) = (p.sttngtrmno)::text) AND (f.sh_sstcd = p.sstcd) AND (f.roomtypcd = p.gstroom_roomtypcd))
65. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,308,331.11..10,000,314,017.62 rows=2 width=204) (actual rows= loops=)

  • Hash Cond: ((d_1.plncd = q.plncd) AND (to_char(c_2.crssttngtrmno, 'FM00'::text) = (q.sttngtrmno)::text) AND (f.sh_sstcd = q.sstcd))
66. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,308,324.66..10,000,314,011.14 rows=2 width=201) (actual rows= loops=)

  • Hash Cond: (m.stfkbn = n.crs_stfkbn)
67. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,308,323.46..10,000,314,009.91 rows=2 width=198) (actual rows= loops=)

  • Hash Cond: (m.crs_id = c_2.crs_id)
68. 0.000 0.000 ↓ 0.0

Seq Scan on crs_agree_stf_kbn m (cost=0.00..5,646.12 rows=10,747 width=11) (actual rows= loops=)

  • Filter: (agree_psbl_flg = '1'::bpchar)
69. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,308,323.45..10,000,308,323.45 rows=1 width=187) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
70. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,307,411.51..10,000,308,323.45 rows=1 width=187) (actual rows= loops=)

  • Hash Cond: ((i.sstcd = h.sstcd) AND (i.aply_bgn_ymd = h.aply_bgn_ymd))
71. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=546.01..1,389.49 rows=9,127 width=23) (actual rows= loops=)

  • Hash Cond: ((i.sstcd = j.sstcd) AND (i.aply_bgn_ymd = j.aply_bgn_ymd))
  • Join Filter: (i.chrg_rvsn_ymd < j.chrg_rvsn_ymd)
72. 0.000 0.000 ↓ 0.0

Seq Scan on sh_sst_bsc_tsry_mst i (cost=0.00..498.91 rows=13,691 width=32) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Hash (cost=340.65..340.65 rows=13,691 width=26) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Index Only Scan using sh_sst_bsc_tsry_mst_pkey_1 on sh_sst_bsc_tsry_mst j (cost=0.29..340.65 rows=13,691 width=26) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,306,865.48..10,000,306,865.48 rows=1 width=198) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
76. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,304,652.02..10,000,306,865.48 rows=1 width=198) (actual rows= loops=)

  • Hash Cond: (h.sstcd = f.sh_sstcd)
  • Join Filter: ((h.aply_bgn_ymd <= d_1.trvl_cndtn_stndrd_ymd) AND (d_1.trvl_cndtn_stndrd_ymd <= h.aply_end_ymd))
77. 0.000 0.000 ↓ 0.0

Seq Scan on sh_sst_bsc_mst h (cost=0.00..2,162.20 rows=13,663 width=32) (actual rows= loops=)

  • Filter: ((langkbn)::text = 'ja'::text)
78. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,304,652.00..10,000,304,652.00 rows=1 width=184) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
79. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,303,909.07..10,000,304,652.00 rows=1 width=184) (actual rows= loops=)

  • Hash Cond: (a.ktei_cmps_msi_id = f.id)
80. 0.000 0.000 ↓ 0.0

Seq Scan on crs_ktei_ptn a (cost=0.00..646.13 rows=25,813 width=13) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,303,909.05..10,000,303,909.05 rows=1 width=171) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
82. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,303,186.62..10,000,303,909.05 rows=1 width=171) (actual rows= loops=)

  • Hash Cond: ((s.plnplnscd = c_2.plnplnscd) AND (s.plnsmsino = c_2.plnsmsino) AND (s.crssttngtrmno = c_2.crssttngtrmno) AND (s.sh_sstcd = f.sh_sstcd))
83. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sh_sst s (cost=0.00..600.37 rows=8,137 width=39) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,303,186.22..10,000,303,186.22 rows=20 width=132) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
85. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,000,000,645.20..10,000,303,186.22 rows=20 width=132) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Hash Join (cost=644.92..303,183.67 rows=20 width=129) (actual rows= loops=)

  • Hash Cond: (f.crs_sttng_trm_id = c_2.id)
87. 0.000 0.000 ↓ 0.0

Seq Scan on ktei_cmps_msi f (cost=0.00..302,352.14 rows=49,710 width=43) (actual rows= loops=)

  • Filter: ((kteikbn)::text = '03'::text)
88. 0.000 0.000 ↓ 0.0

Hash (cost=644.90..644.90 rows=2 width=86) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
89. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.28..644.90 rows=2 width=86) (actual rows= loops=)

  • Hash Cond: (c_2.crs_id = d_1.id)
90. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sttng_trm c_2 (cost=0.00..622.62 rows=5,062 width=36) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash (cost=3.25..3.25 rows=2 width=50) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
92. 0.000 0.000 ↓ 0.0

Index Scan using crs_01_index on crs d_1 (cost=0.28..3.25 rows=2 width=50) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
93. 0.000 0.000 ↓ 0.0

Materialize (cost=0.28..2.30 rows=1 width=10) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Index Scan using pln_unq_idx on pln g (cost=0.28..2.29 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
95. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=6) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
96. 0.000 0.000 ↓ 0.0

Seq Scan on stfkbn_trns_mst n (cost=0.00..1.09 rows=9 width=6) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Hash (cost=6.36..6.36 rows=5 width=21) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_unq_idx on sh_buyin_irai q (cost=0.41..6.36 rows=5 width=21) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
99. 0.000 0.000 ↓ 0.0

Hash (cost=12.18..12.18 rows=11 width=29) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi p (cost=0.41..12.18 rows=11 width=29) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
101. 0.000 0.000 ↓ 0.0

Hash (cost=12.21..12.21 rows=5 width=21) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi v (cost=0.41..12.21 rows=5 width=21) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
  • Filter: (stndrd_room_typ_flg = '1'::bpchar)
103. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Seq Scan on cnsmtax_mst k (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Hash (cost=8,585.55..8,585.55 rows=292,455 width=37) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Seq Scan on shszi_szi_slsamt ff (cost=0.00..8,585.55 rows=292,455 width=37) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Hash (cost=1,751.41..1,751.41 rows=63,141 width=26) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Seq Scan on srssty_dscntamt gg (cost=0.00..1,751.41 rows=63,141 width=26) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Hash (cost=3,129.19..3,129.19 rows=116,385 width=21) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Index Only Scan using srssty_dscnt_excld_unq_idx on srssty_dscnt_excld hh (cost=0.42..3,129.19 rows=116,385 width=21) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

Hash (cost=297,453.32..297,453.32 rows=10,272,432 width=36) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Seq Scan on shszi_szi_sh_tax ii (cost=0.00..297,453.32 rows=10,272,432 width=36) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=20,023,519,000.62..20,023,540,515.07 rows=753 width=135) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=20,023,519,000.62..20,023,540,507.54 rows=753 width=135) (actual rows= loops=)

  • Join Filter: (((k_1.aply_bgn_ymd)::text <= to_char((((to_date((e_2.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_1.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)) AND ((k_1.aply_end_ymd)::text >= to_char((((to_date((e_2.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_1.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)))
115. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,023,519,000.62..10,023,540,306.04 rows=753 width=132) (actual rows= loops=)

  • Hash Cond: ((aa_1.szicd = f_1.szicd) AND (aa_1.aprchgnno = f_1.aprchgnno) AND ((aa_1.equipkbn)::text = (f_1.equipkbn)::text) AND (aa_1.aprch_slsamtrltno = b_3.szi_slsamtrltno) AND (aa_1.stfkbn = CASE WHEN ((l.aprchkbn)::text = '3'::text) THEN (o.hnyo_1_kbnvluecd)::bpchar ELSE n_1.aprch_stfkbn END))
  • Join Filter: ((l.aprchkbn)::text = ANY ('{1,2,3}'::text[]))
116. 0.000 0.000 ↓ 0.0

Seq Scan on dvlp_aprch_szi_slsamt aa_1 (cost=0.00..11,463.04 rows=357,904 width=37) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,518,983.68..10,023,518,983.68 rows=753 width=141) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
118. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,023,425,950.46..10,023,518,983.68 rows=753 width=141) (actual rows= loops=)

  • Hash Cond: ((e_2.crssttngtrmno = c_3.crssttngtrmno) AND (e_2.crs_id = c_3.crs_id) AND (e_2.lnd_slsamtrltno = b_3.lnd_slsamtrltno))
119. 0.000 0.000 ↓ 0.0

Seq Scan on crs_clndr e_2 (cost=0.00..81,896.80 rows=989,235 width=35) (actual rows= loops=)

  • Filter: (exclddy_flg = '0'::bpchar)
120. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,425,928.42..10,023,425,928.42 rows=1,259 width=158) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 18kB
121. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,023,182,413.24..10,023,425,928.42 rows=1,259 width=158) (actual rows= loops=)

  • Hash Cond: (b_3.id = y_1.crs_szi_rank_id)
122. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank b_3 (cost=0.00..221,791.43 rows=5,789,643 width=17) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,182,397.51..10,023,182,397.51 rows=1,259 width=157) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 18kB
124. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,022,998,709.21..10,023,182,397.51 rows=1,259 width=157) (actual rows= loops=)

  • Hash Cond: (y_1.ktei_cmps_msi_id = a_1.ktei_cmps_msi_id)
125. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank_cmps y_1 (cost=0.00..163,364.97 rows=5,416,197 width=16) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Hash (cost=10,022,998,709.13..10,022,998,709.13 rows=6 width=165) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
127. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,022,998,665.47..10,022,998,709.13 rows=6 width=165) (actual rows= loops=)

  • Hash Cond: ((x_1.crs_sttng_trm_id = f_1.crs_sttng_trm_id) AND (x_1.pln_ptn_no = a_1.pln_ptn_no))
128. 0.000 0.000 ↓ 0.0

Seq Scan on crs_stndrd_ktei_ptn x_1 (cost=0.00..33.06 rows=1,406 width=13) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Hash (cost=10,022,998,665.38..10,022,998,665.38 rows=6 width=178) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
130. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,636,811.16..10,022,998,665.38 rows=6 width=178) (actual rows= loops=)

  • Hash Cond: ((d_2.plncd = v_1.plncd) AND (to_char(c_3.crssttngtrmno, 'FM00'::text) = (v_1.sttngtrmno)::text) AND (f_1.sh_sstcd = v_1.sstcd))
131. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,636,798.87..10,022,998,652.99 rows=6 width=175) (actual rows= loops=)

  • Hash Cond: (d_2.gdskbn = (q_1.hnyovluecd)::bpchar)
132. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,636,758.79..10,022,998,612.28 rows=6 width=172) (actual rows= loops=)

  • Hash Cond: ((u_1.roomtypebts_chrg_grp_sttng_id = t_1.id) AND (u_1.stfkbn = n_1.sh_stfkbn))
133. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=290,463.10..22,642,753.24 rows=1,275,105 width=16) (actual rows= loops=)

  • Hash Cond: ((u_1.roomtypebts_chrg_grp_sttng_id = u1_1.roomtypebts_chrg_grp_sttng_id) AND (u_1.stfkbn = u1_1.stfkbn) AND (u_1.offr_aply_ninzu = u1_1.offr_aply_ninzu) AND (u_1.kariszi_slsamtrltno = u1_1.kariszi_slsamtrltno))
  • Join Filter: (u_1.rltv_dysu > u1_1.rltv_dysu)
134. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=145,231.55..6,292,528.15 rows=1,912,657 width=23) (actual rows= loops=)

  • Hash Cond: ((u_1.roomtypebts_chrg_grp_sttng_id = u2_1.roomtypebts_chrg_grp_sttng_id) AND (u_1.stfkbn = u2_1.stfkbn) AND (u_1.offr_aply_ninzu = u2_1.offr_aply_ninzu) AND (u_1.rltv_dysu = u2_1.rltv_dysu))
  • Join Filter: (u_1.kariszi_slsamtrltno > u2_1.kariszi_slsamtrltno)
135. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u_1 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

  • Buckets: 65536 Batches: 64 Memory Usage: 2937kB
137. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u2_1 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

  • Buckets: 65536 Batches: 64 Memory Usage: 2942kB
139. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u1_1 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

140. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,346,295.68..10,000,346,295.68 rows=1 width=178) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
141. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,345,047.71..10,000,346,295.68 rows=1 width=178) (actual rows= loops=)

  • Hash Cond: ((t_1.plnplnscd = s_1.plnplnscd) AND (t_1.plnsmsino = s_1.plnsmsino) AND (t_1.crssttngtrmno = s_1.crssttngtrmno) AND (t_1.sh_sstcd = s_1.sh_sstcd) AND (t_1.roomtypcd = f_1.roomtypcd))
142. 0.000 0.000 ↓ 0.0

Seq Scan on roomtypebts_chrg_grp_sttng t_1 (cost=0.00..937.55 rows=16,555 width=39) (actual rows= loops=)

143. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,345,047.69..10,000,345,047.69 rows=1 width=193) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
144. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,339,844.59..10,000,345,047.69 rows=1 width=193) (actual rows= loops=)

  • Hash Cond: ((z_1.sh_buyin_irai_gstroom_msi_id = p_1.id) AND (z_1.stfkbn = n_1.sh_stfkbn))
  • Filter: ((z_1.agree_psbl_flg = '1'::bpchar) OR (f_1.sh_sstcd = 'ZZZZZZZ'::bpchar))
145. 0.000 0.000 ↓ 0.0

Seq Scan on sh_buyin_irai_gstroom_agree_stf_kbn z_1 (cost=0.00..4,546.05 rows=87,605 width=13) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,339,844.57..10,000,339,844.57 rows=1 width=201) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
147. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,334,158.05..10,000,339,844.57 rows=1 width=201) (actual rows= loops=)

  • Hash Cond: ((d_2.plncd = p_1.plncd) AND (to_char(c_3.crssttngtrmno, 'FM00'::text) = (p_1.sttngtrmno)::text) AND (f_1.sh_sstcd = p_1.sstcd) AND (f_1.roomtypcd = p_1.gstroom_roomtypcd))
148. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,334,145.65..10,000,339,832.14 rows=1 width=185) (actual rows= loops=)

  • Hash Cond: (m_1.stfkbn = (o.hnyo_2_kbnvluecd)::bpchar)
149. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,334,141.19..10,000,339,827.66 rows=2 width=186) (actual rows= loops=)

  • Hash Cond: (m_1.stfkbn = n_1.crs_stfkbn)
150. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,334,139.98..10,000,339,826.43 rows=2 width=177) (actual rows= loops=)

  • Hash Cond: (m_1.crs_id = c_3.crs_id)
151. 0.000 0.000 ↓ 0.0

Seq Scan on crs_agree_stf_kbn m_1 (cost=0.00..5,646.12 rows=10,747 width=11) (actual rows= loops=)

  • Filter: (agree_psbl_flg = '1'::bpchar)
152. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,334,139.97..10,000,334,139.97 rows=1 width=166) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
153. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,333,386.58..10,000,334,139.97 rows=1 width=166) (actual rows= loops=)

  • Hash Cond: ((i_1.sstcd = h_1.sstcd) AND (i_1.aply_bgn_ymd = h_1.aply_bgn_ymd))
154. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=546.30..1,231.23 rows=9,127 width=17) (actual rows= loops=)

  • Hash Cond: ((i_1.sstcd = j_1.sstcd) AND (i_1.aply_bgn_ymd = j_1.aply_bgn_ymd))
  • Join Filter: (i_1.chrg_rvsn_ymd < j_1.chrg_rvsn_ymd)
155. 0.000 0.000 ↓ 0.0

Index Only Scan using sh_sst_bsc_tsry_mst_pkey_1 on sh_sst_bsc_tsry_mst i_1 (cost=0.29..340.65 rows=13,691 width=26) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Hash (cost=340.65..340.65 rows=13,691 width=26) (actual rows= loops=)

  • Buckets: 16384 Batches: 1 Memory Usage: 911kB
157. 0.000 0.000 ↓ 0.0

Index Only Scan using sh_sst_bsc_tsry_mst_pkey_1 on sh_sst_bsc_tsry_mst j_1 (cost=0.29..340.65 rows=13,691 width=26) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,332,840.26..10,000,332,840.26 rows=1 width=183) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
159. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,332,804.97..10,000,332,840.26 rows=1 width=183) (actual rows= loops=)

  • Hash Cond: (l.aprchchrglstcd = d_2.aprchchrglstcd)
160. 0.000 0.000 ↓ 0.0

Seq Scan on aprch_chrglst l (cost=0.00..32.75 rows=675 width=9) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,332,804.96..10,000,332,804.96 rows=1 width=188) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
162. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,330,591.49..10,000,332,804.96 rows=1 width=188) (actual rows= loops=)

  • Hash Cond: (h_1.sstcd = f_1.sh_sstcd)
  • Join Filter: ((h_1.aply_bgn_ymd <= d_2.trvl_cndtn_stndrd_ymd) AND (d_2.trvl_cndtn_stndrd_ymd <= h_1.aply_end_ymd))
163. 0.000 0.000 ↓ 0.0

Seq Scan on sh_sst_bsc_mst h_1 (cost=0.00..2,162.20 rows=13,663 width=26) (actual rows= loops=)

  • Filter: ((langkbn)::text = 'ja'::text)
164. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,330,591.48..10,000,330,591.48 rows=1 width=180) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
165. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,329,869.05..10,000,330,591.48 rows=1 width=180) (actual rows= loops=)

  • Hash Cond: ((s_1.plnplnscd = c_3.plnplnscd) AND (s_1.plnsmsino = c_3.plnsmsino) AND (s_1.crssttngtrmno = c_3.crssttngtrmno) AND (s_1.sh_sstcd = f_1.sh_sstcd))
166. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sh_sst s_1 (cost=0.00..600.37 rows=8,137 width=39) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,329,868.85..10,000,329,868.85 rows=10 width=156) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
168. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,329,125.82..10,000,329,868.85 rows=10 width=156) (actual rows= loops=)

  • Hash Cond: (a_1.ktei_cmps_msi_id = f_1.id)
169. 0.000 0.000 ↓ 0.0

Seq Scan on crs_ktei_ptn a_1 (cost=0.00..646.13 rows=25,813 width=13) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,329,091.49..10,000,329,091.49 rows=2,746 width=143) (actual rows= loops=)

  • Buckets: 4096 Batches: 1 Memory Usage: 36kB
171. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,000,647.24..10,000,329,091.49 rows=2,746 width=143) (actual rows= loops=)

  • Hash Cond: (f_1.crs_sttng_trm_id = c_3.id)
172. 0.000 0.000 ↓ 0.0

Seq Scan on ktei_cmps_msi f_1 (cost=0.00..302,352.14 rows=6,950,574 width=45) (actual rows= loops=)

  • Filter: ((kteikbn)::text = ANY ('{01,02}'::text[]))
173. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,000,647.22..10,000,000,647.22 rows=2 width=98) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
174. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,000,000,003.55..10,000,000,647.22 rows=2 width=98) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.28..644.90 rows=2 width=98) (actual rows= loops=)

  • Hash Cond: (c_3.crs_id = d_2.id)
176. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sttng_trm c_3 (cost=0.00..622.62 rows=5,062 width=36) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

Hash (cost=3.25..3.25 rows=2 width=62) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
178. 0.000 0.000 ↓ 0.0

Index Scan using crs_01_index on crs d_2 (cost=0.28..3.25 rows=2 width=62) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
179. 0.000 0.000 ↓ 0.0

Materialize (cost=0.28..2.30 rows=1 width=7) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

Index Only Scan using pln_unq_idx on pln g_1 (cost=0.28..2.29 rows=1 width=7) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
181. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=9) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
182. 0.000 0.000 ↓ 0.0

Seq Scan on stfkbn_trns_mst n_1 (cost=0.00..1.09 rows=9 width=9) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Hash (cost=4.41..4.41 rows=4 width=4) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
184. 0.000 0.000 ↓ 0.0

Index Scan using hnyo_mst_pkey_1 on hnyo_mst o (cost=0.28..4.41 rows=4 width=4) (actual rows= loops=)

  • Index Cond: ((hnyokeycd)::text = '264'::text)
185. 0.000 0.000 ↓ 0.0

Hash (cost=12.18..12.18 rows=11 width=37) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
186. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi p_1 (cost=0.41..12.18 rows=11 width=37) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
187. 0.000 0.000 ↓ 0.0

Hash (cost=39.05..39.05 rows=82 width=6) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
188. 0.000 0.000 ↓ 0.0

Index Scan using hnyo_mst_pkey_1 on hnyo_mst q_1 (cost=0.28..39.05 rows=82 width=6) (actual rows= loops=)

  • Index Cond: ((hnyokeycd)::text = '080'::text)
189. 0.000 0.000 ↓ 0.0

Hash (cost=12.21..12.21 rows=5 width=21) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
190. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi v_1 (cost=0.41..12.21 rows=5 width=21) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
  • Filter: (stndrd_room_typ_flg = '1'::bpchar)
191. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Seq Scan on cnsmtax_mst k_1 (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

193. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 3 (cost=20,001,153,742.82..20,023,515,928.37 rows=753 width=135) (actual rows= loops=)

194. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,001,153,742.82..20,023,515,920.84 rows=753 width=135) (actual rows= loops=)

  • Hash Cond: ((f_2.szicd = aa_2.szicd) AND (f_2.aprchgnno = aa_2.aprchgnno) AND ((f_2.equipkbn)::text = (aa_2.equipkbn)::text) AND (b_4.szi_slsamtrltno = aa_2.aprch_slsamtrltno) AND (n_2.aprch_stfkbn = aa_2.stfkbn))
  • Join Filter: ((l_1.aprchkbn)::text = '4'::text)
195. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=20,001,153,568.50..20,023,515,429.30 rows=753 width=142) (actual rows= loops=)

  • Hash Cond: ((u_2.roomtypebts_chrg_grp_sttng_id = t_2.id) AND (u_2.stfkbn = n_2.sh_stfkbn))
196. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=290,463.10..22,642,753.24 rows=1,275,105 width=16) (actual rows= loops=)

  • Hash Cond: ((u_2.roomtypebts_chrg_grp_sttng_id = u1_2.roomtypebts_chrg_grp_sttng_id) AND (u_2.stfkbn = u1_2.stfkbn) AND (u_2.offr_aply_ninzu = u1_2.offr_aply_ninzu) AND (u_2.kariszi_slsamtrltno = u1_2.kariszi_slsamtrltno))
  • Join Filter: (u_2.rltv_dysu > u1_2.rltv_dysu)
197. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=145,231.55..6,292,528.15 rows=1,912,657 width=23) (actual rows= loops=)

  • Hash Cond: ((u_2.roomtypebts_chrg_grp_sttng_id = u2_2.roomtypebts_chrg_grp_sttng_id) AND (u_2.stfkbn = u2_2.stfkbn) AND (u_2.offr_aply_ninzu = u2_2.offr_aply_ninzu) AND (u_2.rltv_dysu = u2_2.rltv_dysu))
  • Join Filter: (u_2.kariszi_slsamtrltno > u2_2.kariszi_slsamtrltno)
198. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u_2 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

199. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

  • Buckets: 65536 Batches: 64 Memory Usage: 2937kB
200. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u2_2 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

  • Buckets: 65536 Batches: 64 Memory Usage: 2942kB
202. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u1_2 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

203. 0.000 0.000 ↓ 0.0

Hash (cost=20,000,863,103.51..20,000,863,103.51 rows=126 width=148) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
204. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=20,000,770,068.30..20,000,863,103.51 rows=126 width=148) (actual rows= loops=)

  • Join Filter: (((k_2.aply_bgn_ymd)::text <= to_char((((to_date((e_3.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_2.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)) AND ((k_2.aply_end_ymd)::text >= to_char((((to_date((e_3.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_2.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)))
205. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,770,068.30..10,000,863,095.25 rows=126 width=145) (actual rows= loops=)

  • Hash Cond: ((e_3.crssttngtrmno = c_4.crssttngtrmno) AND (e_3.crs_id = c_4.crs_id) AND (e_3.lnd_slsamtrltno = b_4.lnd_slsamtrltno))
206. 0.000 0.000 ↓ 0.0

Seq Scan on crs_clndr e_3 (cost=0.00..81,896.80 rows=989,235 width=35) (actual rows= loops=)

  • Filter: (exclddy_flg = '0'::bpchar)
207. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,770,064.62..10,000,770,064.62 rows=210 width=162) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
208. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,526,559.93..10,000,770,064.62 rows=210 width=162) (actual rows= loops=)

  • Hash Cond: (b_4.id = y_2.crs_szi_rank_id)
209. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank b_4 (cost=0.00..221,791.43 rows=5,789,643 width=17) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,526,557.31..10,000,526,557.31 rows=210 width=161) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
211. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,342,879.50..10,000,526,557.31 rows=210 width=161) (actual rows= loops=)

  • Hash Cond: (y_2.ktei_cmps_msi_id = a_2.ktei_cmps_msi_id)
212. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank_cmps y_2 (cost=0.00..163,364.97 rows=5,416,197 width=16) (actual rows= loops=)

213. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,342,879.49..10,000,342,879.49 rows=1 width=169) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
214. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,342,835.87..10,000,342,879.49 rows=1 width=169) (actual rows= loops=)

  • Hash Cond: ((x_2.crs_sttng_trm_id = f_2.crs_sttng_trm_id) AND (x_2.pln_ptn_no = a_2.pln_ptn_no))
215. 0.000 0.000 ↓ 0.0

Seq Scan on crs_stndrd_ktei_ptn x_2 (cost=0.00..33.06 rows=1,406 width=13) (actual rows= loops=)

216. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,342,835.86..10,000,342,835.86 rows=1 width=182) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
217. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,337,632.61..10,000,342,835.86 rows=1 width=182) (actual rows= loops=)

  • Hash Cond: ((d_3.plncd = v_2.plncd) AND (to_char(c_4.crssttngtrmno, 'FM00'::text) = (v_2.sttngtrmno)::text) AND (f_2.sh_sstcd = v_2.sstcd))
218. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,337,620.32..10,000,342,823.54 rows=1 width=179) (actual rows= loops=)

  • Hash Cond: (d_3.gdskbn = (q_2.hnyovluecd)::bpchar)
219. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,337,580.25..10,000,342,783.35 rows=1 width=176) (actual rows= loops=)

  • Hash Cond: ((z_2.sh_buyin_irai_gstroom_msi_id = p_2.id) AND (z_2.stfkbn = n_2.sh_stfkbn))
  • Filter: ((z_2.agree_psbl_flg = '1'::bpchar) OR (f_2.sh_sstcd = 'ZZZZZZZ'::bpchar))
220. 0.000 0.000 ↓ 0.0

Seq Scan on sh_buyin_irai_gstroom_agree_stf_kbn z_2 (cost=0.00..4,546.05 rows=87,605 width=13) (actual rows= loops=)

221. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,337,580.23..10,000,337,580.23 rows=1 width=184) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
222. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,336,332.26..10,000,337,580.23 rows=1 width=184) (actual rows= loops=)

  • Hash Cond: ((t_2.plnplnscd = s_2.plnplnscd) AND (t_2.plnsmsino = s_2.plnsmsino) AND (t_2.crssttngtrmno = s_2.crssttngtrmno) AND (t_2.sh_sstcd = s_2.sh_sstcd) AND (t_2.roomtypcd = f_2.roomtypcd))
223. 0.000 0.000 ↓ 0.0

Seq Scan on roomtypebts_chrg_grp_sttng t_2 (cost=0.00..937.55 rows=16,555 width=39) (actual rows= loops=)

224. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,336,332.24..10,000,336,332.24 rows=1 width=199) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
225. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,330,645.72..10,000,336,332.24 rows=1 width=199) (actual rows= loops=)

  • Hash Cond: ((d_3.plncd = p_2.plncd) AND (to_char(c_4.crssttngtrmno, 'FM00'::text) = (p_2.sttngtrmno)::text) AND (f_2.sh_sstcd = p_2.sstcd) AND (f_2.roomtypcd = p_2.gstroom_roomtypcd))
226. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,330,633.32..10,000,336,319.82 rows=1 width=183) (actual rows= loops=)

  • Hash Cond: (m_2.stfkbn = (o_1.hnyo_2_kbnvluecd)::bpchar)
227. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,330,628.86..10,000,336,315.33 rows=2 width=186) (actual rows= loops=)

  • Hash Cond: (m_2.stfkbn = n_2.crs_stfkbn)
228. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,330,627.65..10,000,336,314.10 rows=2 width=177) (actual rows= loops=)

  • Hash Cond: (m_2.crs_id = c_4.crs_id)
229. 0.000 0.000 ↓ 0.0

Seq Scan on crs_agree_stf_kbn m_2 (cost=0.00..5,646.12 rows=10,747 width=11) (actual rows= loops=)

  • Filter: (agree_psbl_flg = '1'::bpchar)
230. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,330,627.64..10,000,330,627.64 rows=1 width=166) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
231. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,329,905.21..10,000,330,627.64 rows=1 width=166) (actual rows= loops=)

  • Hash Cond: ((s_2.plnplnscd = c_4.plnplnscd) AND (s_2.plnsmsino = c_4.plnsmsino) AND (s_2.crssttngtrmno = c_4.crssttngtrmno) AND (s_2.sh_sstcd = f_2.sh_sstcd))
232. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sh_sst s_2 (cost=0.00..600.37 rows=8,137 width=39) (actual rows= loops=)

233. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,329,905.01..10,000,329,905.01 rows=10 width=142) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
234. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,329,161.98..10,000,329,905.01 rows=10 width=142) (actual rows= loops=)

  • Hash Cond: (a_2.ktei_cmps_msi_id = f_2.id)
235. 0.000 0.000 ↓ 0.0

Seq Scan on crs_ktei_ptn a_2 (cost=0.00..646.13 rows=25,813 width=13) (actual rows= loops=)

236. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,329,127.65..10,000,329,127.65 rows=2,746 width=129) (actual rows= loops=)

  • Buckets: 4096 Batches: 1 Memory Usage: 35kB
237. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,000,683.40..10,000,329,127.65 rows=2,746 width=129) (actual rows= loops=)

  • Hash Cond: (f_2.crs_sttng_trm_id = c_4.id)
238. 0.000 0.000 ↓ 0.0

Seq Scan on ktei_cmps_msi f_2 (cost=0.00..302,352.14 rows=6,950,574 width=45) (actual rows= loops=)

  • Filter: ((kteikbn)::text = ANY ('{01,02}'::text[]))
239. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,000,683.38..10,000,000,683.38 rows=2 width=84) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
240. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,000,000,039.71..10,000,000,683.38 rows=2 width=84) (actual rows= loops=)

241. 0.000 0.000 ↓ 0.0

Hash Join (cost=39.44..681.06 rows=2 width=84) (actual rows= loops=)

  • Hash Cond: (c_4.crs_id = d_3.id)
242. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sttng_trm c_4 (cost=0.00..622.62 rows=5,062 width=36) (actual rows= loops=)

243. 0.000 0.000 ↓ 0.0

Hash (cost=39.41..39.41 rows=2 width=48) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
244. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=3.28..39.41 rows=2 width=48) (actual rows= loops=)

  • Hash Cond: (l_1.aprchchrglstcd = d_3.aprchchrglstcd)
245. 0.000 0.000 ↓ 0.0

Seq Scan on aprch_chrglst l_1 (cost=0.00..32.75 rows=675 width=9) (actual rows= loops=)

246. 0.000 0.000 ↓ 0.0

Hash (cost=3.25..3.25 rows=2 width=53) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
247. 0.000 0.000 ↓ 0.0

Index Scan using crs_01_index on crs d_3 (cost=0.28..3.25 rows=2 width=53) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
248. 0.000 0.000 ↓ 0.0

Materialize (cost=0.28..2.30 rows=1 width=7) (actual rows= loops=)

249. 0.000 0.000 ↓ 0.0

Index Only Scan using pln_unq_idx on pln g_2 (cost=0.28..2.29 rows=1 width=7) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
250. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=9) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
251. 0.000 0.000 ↓ 0.0

Seq Scan on stfkbn_trns_mst n_2 (cost=0.00..1.09 rows=9 width=9) (actual rows= loops=)

252. 0.000 0.000 ↓ 0.0

Hash (cost=4.41..4.41 rows=4 width=2) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
253. 0.000 0.000 ↓ 0.0

Index Scan using hnyo_mst_pkey_1 on hnyo_mst o_1 (cost=0.28..4.41 rows=4 width=2) (actual rows= loops=)

  • Index Cond: ((hnyokeycd)::text = '264'::text)
254. 0.000 0.000 ↓ 0.0

Hash (cost=12.18..12.18 rows=11 width=37) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
255. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi p_2 (cost=0.41..12.18 rows=11 width=37) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
256. 0.000 0.000 ↓ 0.0

Hash (cost=39.05..39.05 rows=82 width=6) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
257. 0.000 0.000 ↓ 0.0

Index Scan using hnyo_mst_pkey_1 on hnyo_mst q_2 (cost=0.28..39.05 rows=82 width=6) (actual rows= loops=)

  • Index Cond: ((hnyokeycd)::text = '080'::text)
258. 0.000 0.000 ↓ 0.0

Hash (cost=12.21..12.21 rows=5 width=21) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
259. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi v_2 (cost=0.41..12.21 rows=5 width=21) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
  • Filter: (stndrd_room_typ_flg = '1'::bpchar)
260. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

261. 0.000 0.000 ↓ 0.0

Seq Scan on cnsmtax_mst k_2 (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

262. 0.000 0.000 ↓ 0.0

Hash (cost=96.56..96.56 rows=3,456 width=37) (actual rows= loops=)

  • Buckets: 4096 Batches: 1 Memory Usage: 270kB
263. 0.000 0.000 ↓ 0.0

Seq Scan on dvlp_std_aprch_szi_slsamt aa_2 (cost=0.00..96.56 rows=3,456 width=37) (actual rows= loops=)

264. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 4 (cost=20,023,517,844.71..20,023,529,628.14 rows=335 width=135) (actual rows= loops=)

265. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=20,023,517,844.71..20,023,529,624.79 rows=335 width=135) (actual rows= loops=)

  • Hash Cond: ((aa_3.jysha_ekicd = bb_1.jysha_ekicd) AND (aa_3.kosha_ekicd = bb_1.kosha_ekicd) AND ((aa_3.equipkbn)::text = (bb_1.equipkbn)::text) AND (aa_3.stfkbn = bb_1.stfkbn) AND (aa_3.trainno = bb_1.trainno) AND ((aa_3.eplatgdskbn)::text = (bb_1.eplatgdskbn)::text) AND (aa_3.eplat_slsamtrltno = bb_1.eplat_slsamtrltno) AND (aa_3.aply_bgn_ymd = bb_1.aply_bgn_ymd))
  • Join Filter: (aa_3.jrtraincd > bb_1.jrtraincd)
266. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=20,023,516,646.42..20,023,527,700.73 rows=502 width=177) (actual rows= loops=)

  • Hash Cond: ((aa_3.jysha_ekicd = cc_1.jysha_ekicd) AND (aa_3.kosha_ekicd = cc_1.kosha_ekicd) AND ((aa_3.equipkbn)::text = (cc_1.equipkbn)::text) AND (aa_3.stfkbn = cc_1.stfkbn) AND (aa_3.jrtraincd = cc_1.jrtraincd) AND ((aa_3.eplatgdskbn)::text = (cc_1.eplatgdskbn)::text) AND (aa_3.eplat_slsamtrltno = cc_1.eplat_slsamtrltno) AND (aa_3.aply_bgn_ymd = cc_1.aply_bgn_ymd))
  • Join Filter: (aa_3.trainno > cc_1.trainno)
267. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=20,023,515,448.13..20,023,525,551.90 rows=753 width=177) (actual rows= loops=)

  • Hash Cond: ((aa_3.jysha_ekicd = f_3.dprt_ekicd) AND (aa_3.kosha_ekicd = f_3.arrv_ekicd) AND ((aa_3.equipkbn)::text = (f_3.equipkbn)::text) AND (aa_3.stfkbn = n_3.aprch_stfkbn) AND (aa_3.eplat_slsamtrltno = b_5.szi_slsamtrltno) AND ((aa_3.eplatgdskbn)::text = CASE WHEN ((l_2.aprchkbn)::text = '5'::text) THEN '1'::text WHEN ((l_2.aprchkbn)::text = '6'::text) THEN '2'::text ELSE NULL::text END))
  • Join Filter: ((f_3.szicd = 'X999999'::bpchar) AND (aa_3.aply_bgn_ymd <= c_5.sttng_trm_bgn_ymd) AND (c_5.sttng_trm_end_ymd <= aa_3.aply_end_ymd))
268. 0.000 0.000 ↓ 0.0

Seq Scan on dvlp_eplat_slsamt aa_3 (cost=0.00..1,021.64 rows=15,264 width=66) (actual rows= loops=)

269. 0.000 0.000 ↓ 0.0

Hash (cost=20,023,515,429.30..20,023,515,429.30 rows=753 width=167) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
270. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=20,001,153,568.50..20,023,515,429.30 rows=753 width=167) (actual rows= loops=)

  • Hash Cond: ((u_3.roomtypebts_chrg_grp_sttng_id = t_3.id) AND (u_3.stfkbn = n_3.sh_stfkbn))
271. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=290,463.10..22,642,753.24 rows=1,275,105 width=16) (actual rows= loops=)

  • Hash Cond: ((u_3.roomtypebts_chrg_grp_sttng_id = u1_3.roomtypebts_chrg_grp_sttng_id) AND (u_3.stfkbn = u1_3.stfkbn) AND (u_3.offr_aply_ninzu = u1_3.offr_aply_ninzu) AND (u_3.kariszi_slsamtrltno = u1_3.kariszi_slsamtrltno))
  • Join Filter: (u_3.rltv_dysu > u1_3.rltv_dysu)
272. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=145,231.55..6,292,528.15 rows=1,912,657 width=23) (actual rows= loops=)

  • Hash Cond: ((u_3.roomtypebts_chrg_grp_sttng_id = u2_3.roomtypebts_chrg_grp_sttng_id) AND (u_3.stfkbn = u2_3.stfkbn) AND (u_3.offr_aply_ninzu = u2_3.offr_aply_ninzu) AND (u_3.rltv_dysu = u2_3.rltv_dysu))
  • Join Filter: (u_3.kariszi_slsamtrltno > u2_3.kariszi_slsamtrltno)
273. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u_3 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

274. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

  • Buckets: 65536 Batches: 64 Memory Usage: 2937kB
275. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u2_3 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

276. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

  • Buckets: 65536 Batches: 64 Memory Usage: 2942kB
277. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u1_3 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

278. 0.000 0.000 ↓ 0.0

Hash (cost=20,000,863,103.51..20,000,863,103.51 rows=126 width=173) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
279. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=20,000,770,068.30..20,000,863,103.51 rows=126 width=173) (actual rows= loops=)

  • Join Filter: (((k_3.aply_bgn_ymd)::text <= to_char((((to_date((e_4.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_3.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)) AND ((k_3.aply_end_ymd)::text >= to_char((((to_date((e_4.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_3.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)))
280. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,770,068.30..10,000,863,095.25 rows=126 width=170) (actual rows= loops=)

  • Hash Cond: ((e_4.crssttngtrmno = c_5.crssttngtrmno) AND (e_4.crs_id = c_5.crs_id) AND (e_4.lnd_slsamtrltno = b_5.lnd_slsamtrltno))
281. 0.000 0.000 ↓ 0.0

Seq Scan on crs_clndr e_4 (cost=0.00..81,896.80 rows=989,235 width=35) (actual rows= loops=)

  • Filter: (exclddy_flg = '0'::bpchar)
282. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,770,064.62..10,000,770,064.62 rows=210 width=187) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
283. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,526,559.93..10,000,770,064.62 rows=210 width=187) (actual rows= loops=)

  • Hash Cond: (b_5.id = y_3.crs_szi_rank_id)
284. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank b_5 (cost=0.00..221,791.43 rows=5,789,643 width=17) (actual rows= loops=)

285. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,526,557.31..10,000,526,557.31 rows=210 width=186) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
286. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,342,879.50..10,000,526,557.31 rows=210 width=186) (actual rows= loops=)

  • Hash Cond: (y_3.ktei_cmps_msi_id = a_3.ktei_cmps_msi_id)
287. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank_cmps y_3 (cost=0.00..163,364.97 rows=5,416,197 width=16) (actual rows= loops=)

288. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,342,879.49..10,000,342,879.49 rows=1 width=194) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
289. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,342,835.87..10,000,342,879.49 rows=1 width=194) (actual rows= loops=)

  • Hash Cond: ((x_3.crs_sttng_trm_id = f_3.crs_sttng_trm_id) AND (x_3.pln_ptn_no = a_3.pln_ptn_no))
290. 0.000 0.000 ↓ 0.0

Seq Scan on crs_stndrd_ktei_ptn x_3 (cost=0.00..33.06 rows=1,406 width=13) (actual rows= loops=)

291. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,342,835.86..10,000,342,835.86 rows=1 width=207) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
292. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,337,632.61..10,000,342,835.86 rows=1 width=207) (actual rows= loops=)

  • Hash Cond: ((d_4.plncd = v_3.plncd) AND (to_char(c_5.crssttngtrmno, 'FM00'::text) = (v_3.sttngtrmno)::text) AND (f_3.sh_sstcd = v_3.sstcd))
293. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,337,620.32..10,000,342,823.54 rows=1 width=204) (actual rows= loops=)

  • Hash Cond: (d_4.gdskbn = (q_3.hnyovluecd)::bpchar)
294. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,337,580.25..10,000,342,783.35 rows=1 width=201) (actual rows= loops=)

  • Hash Cond: ((z_3.sh_buyin_irai_gstroom_msi_id = p_3.id) AND (z_3.stfkbn = n_3.sh_stfkbn))
  • Filter: ((z_3.agree_psbl_flg = '1'::bpchar) OR (f_3.sh_sstcd = 'ZZZZZZZ'::bpchar))
295. 0.000 0.000 ↓ 0.0

Seq Scan on sh_buyin_irai_gstroom_agree_stf_kbn z_3 (cost=0.00..4,546.05 rows=87,605 width=13) (actual rows= loops=)

296. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,337,580.23..10,000,337,580.23 rows=1 width=209) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
297. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,336,332.26..10,000,337,580.23 rows=1 width=209) (actual rows= loops=)

  • Hash Cond: ((t_3.plnplnscd = s_3.plnplnscd) AND (t_3.plnsmsino = s_3.plnsmsino) AND (t_3.crssttngtrmno = s_3.crssttngtrmno) AND (t_3.sh_sstcd = s_3.sh_sstcd) AND (t_3.roomtypcd = f_3.roomtypcd))
298. 0.000 0.000 ↓ 0.0

Seq Scan on roomtypebts_chrg_grp_sttng t_3 (cost=0.00..937.55 rows=16,555 width=39) (actual rows= loops=)

299. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,336,332.24..10,000,336,332.24 rows=1 width=224) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
300. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,330,645.72..10,000,336,332.24 rows=1 width=224) (actual rows= loops=)

  • Hash Cond: ((d_4.plncd = p_3.plncd) AND (to_char(c_5.crssttngtrmno, 'FM00'::text) = (p_3.sttngtrmno)::text) AND (f_3.sh_sstcd = p_3.sstcd) AND (f_3.roomtypcd = p_3.gstroom_roomtypcd))
301. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,330,633.32..10,000,336,319.82 rows=1 width=208) (actual rows= loops=)

  • Hash Cond: (m_3.stfkbn = (o_2.hnyo_2_kbnvluecd)::bpchar)
302. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,330,628.86..10,000,336,315.33 rows=2 width=211) (actual rows= loops=)

  • Hash Cond: (m_3.stfkbn = n_3.crs_stfkbn)
303. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,330,627.65..10,000,336,314.10 rows=2 width=202) (actual rows= loops=)

  • Hash Cond: (m_3.crs_id = c_5.crs_id)
304. 0.000 0.000 ↓ 0.0

Seq Scan on crs_agree_stf_kbn m_3 (cost=0.00..5,646.12 rows=10,747 width=11) (actual rows= loops=)

  • Filter: (agree_psbl_flg = '1'::bpchar)
305. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,330,627.64..10,000,330,627.64 rows=1 width=191) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
306. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,329,905.21..10,000,330,627.64 rows=1 width=191) (actual rows= loops=)

  • Hash Cond: ((s_3.plnplnscd = c_5.plnplnscd) AND (s_3.plnsmsino = c_5.plnsmsino) AND (s_3.crssttngtrmno = c_5.crssttngtrmno) AND (s_3.sh_sstcd = f_3.sh_sstcd))
307. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sh_sst s_3 (cost=0.00..600.37 rows=8,137 width=39) (actual rows= loops=)

308. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,329,905.01..10,000,329,905.01 rows=10 width=167) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
309. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,329,161.98..10,000,329,905.01 rows=10 width=167) (actual rows= loops=)

  • Hash Cond: (a_3.ktei_cmps_msi_id = f_3.id)
310. 0.000 0.000 ↓ 0.0

Seq Scan on crs_ktei_ptn a_3 (cost=0.00..646.13 rows=25,813 width=13) (actual rows= loops=)

311. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,329,127.65..10,000,329,127.65 rows=2,746 width=154) (actual rows= loops=)

  • Buckets: 4096 Batches: 1 Memory Usage: 36kB
312. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,000,683.40..10,000,329,127.65 rows=2,746 width=154) (actual rows= loops=)

  • Hash Cond: (f_3.crs_sttng_trm_id = c_5.id)
313. 0.000 0.000 ↓ 0.0

Seq Scan on ktei_cmps_msi f_3 (cost=0.00..302,352.14 rows=6,950,574 width=52) (actual rows= loops=)

  • Filter: ((kteikbn)::text = ANY ('{01,02}'::text[]))
314. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,000,683.38..10,000,000,683.38 rows=2 width=102) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
315. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,000,000,039.71..10,000,000,683.38 rows=2 width=102) (actual rows= loops=)

316. 0.000 0.000 ↓ 0.0

Hash Join (cost=39.44..681.06 rows=2 width=102) (actual rows= loops=)

  • Hash Cond: (c_5.crs_id = d_4.id)
317. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sttng_trm c_5 (cost=0.00..622.62 rows=5,062 width=54) (actual rows= loops=)

318. 0.000 0.000 ↓ 0.0

Hash (cost=39.41..39.41 rows=2 width=48) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
319. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=3.28..39.41 rows=2 width=48) (actual rows= loops=)

  • Hash Cond: (l_2.aprchchrglstcd = d_4.aprchchrglstcd)
320. 0.000 0.000 ↓ 0.0

Seq Scan on aprch_chrglst l_2 (cost=0.00..32.75 rows=675 width=9) (actual rows= loops=)

321. 0.000 0.000 ↓ 0.0

Hash (cost=3.25..3.25 rows=2 width=53) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
322. 0.000 0.000 ↓ 0.0

Index Scan using crs_01_index on crs d_4 (cost=0.28..3.25 rows=2 width=53) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
323. 0.000 0.000 ↓ 0.0

Materialize (cost=0.28..2.30 rows=1 width=7) (actual rows= loops=)

324. 0.000 0.000 ↓ 0.0

Index Only Scan using pln_unq_idx on pln g_3 (cost=0.28..2.29 rows=1 width=7) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
325. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=9) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
326. 0.000 0.000 ↓ 0.0

Seq Scan on stfkbn_trns_mst n_3 (cost=0.00..1.09 rows=9 width=9) (actual rows= loops=)

327. 0.000 0.000 ↓ 0.0

Hash (cost=4.41..4.41 rows=4 width=2) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
328. 0.000 0.000 ↓ 0.0

Index Scan using hnyo_mst_pkey_1 on hnyo_mst o_2 (cost=0.28..4.41 rows=4 width=2) (actual rows= loops=)

  • Index Cond: ((hnyokeycd)::text = '264'::text)
329. 0.000 0.000 ↓ 0.0

Hash (cost=12.18..12.18 rows=11 width=37) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
330. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi p_3 (cost=0.41..12.18 rows=11 width=37) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
331. 0.000 0.000 ↓ 0.0

Hash (cost=39.05..39.05 rows=82 width=6) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
332. 0.000 0.000 ↓ 0.0

Index Scan using hnyo_mst_pkey_1 on hnyo_mst q_3 (cost=0.28..39.05 rows=82 width=6) (actual rows= loops=)

  • Index Cond: ((hnyokeycd)::text = '080'::text)
333. 0.000 0.000 ↓ 0.0

Hash (cost=12.21..12.21 rows=5 width=21) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
334. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi v_3 (cost=0.41..12.21 rows=5 width=21) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
  • Filter: (stndrd_room_typ_flg = '1'::bpchar)
335. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

336. 0.000 0.000 ↓ 0.0

Seq Scan on cnsmtax_mst k_3 (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

337. 0.000 0.000 ↓ 0.0

Hash (cost=740.37..740.37 rows=15,264 width=42) (actual rows= loops=)

  • Buckets: 16384 Batches: 1 Memory Usage: 1232kB
338. 0.000 0.000 ↓ 0.0

Index Only Scan using dvlp_eplat_slsamt_pkey_1 on dvlp_eplat_slsamt cc_1 (cost=0.41..740.37 rows=15,264 width=42) (actual rows= loops=)

339. 0.000 0.000 ↓ 0.0

Hash (cost=740.37..740.37 rows=15,264 width=42) (actual rows= loops=)

  • Buckets: 16384 Batches: 1 Memory Usage: 1232kB
340. 0.000 0.000 ↓ 0.0

Index Only Scan using dvlp_eplat_slsamt_pkey_1 on dvlp_eplat_slsamt bb_1 (cost=0.41..740.37 rows=15,264 width=42) (actual rows= loops=)

341. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 5 (cost=20,023,396,302.01..20,023,489,575.36 rows=892 width=119) (actual rows= loops=)

342. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,023,396,302.01..20,023,489,566.44 rows=892 width=119) (actual rows= loops=)

  • Hash Cond: (f_4.szicd = bb_2.szicd)
343. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,023,396,239.26..20,023,489,360.10 rows=753 width=116) (actual rows= loops=)

  • Hash Cond: ((f_4.szicd = aa_4.szicd) AND (b_6.szi_slsamtrltno = aa_4.snsha_slsamtrltno) AND (n_4.snsha_stfkbn = CASE WHEN (aa_4.stfkbn = '99'::bpchar) THEN '01'::bpchar ELSE aa_4.stfkbn END))
344. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=20,023,396,215.48..20,023,489,293.01 rows=753 width=113) (actual rows= loops=)

  • Join Filter: (((k_4.aply_bgn_ymd)::text <= to_char((((to_date((e_5.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_4.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)) AND ((k_4.aply_end_ymd)::text >= to_char((((to_date((e_5.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_4.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)))
345. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,023,396,215.48..10,023,489,248.70 rows=753 width=110) (actual rows= loops=)

  • Hash Cond: ((e_5.crssttngtrmno = c_6.crssttngtrmno) AND (e_5.crs_id = c_6.crs_id) AND (e_5.lnd_slsamtrltno = b_6.lnd_slsamtrltno))
346. 0.000 0.000 ↓ 0.0

Seq Scan on crs_clndr e_5 (cost=0.00..81,896.80 rows=989,235 width=35) (actual rows= loops=)

  • Filter: (exclddy_flg = '0'::bpchar)
347. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,396,193.45..10,023,396,193.45 rows=1,259 width=127) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
348. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,023,152,678.26..10,023,396,193.45 rows=1,259 width=127) (actual rows= loops=)

  • Hash Cond: (b_6.id = y_4.crs_szi_rank_id)
349. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank b_6 (cost=0.00..221,791.43 rows=5,789,643 width=17) (actual rows= loops=)

350. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,152,662.53..10,023,152,662.53 rows=1,259 width=126) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
351. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,022,968,974.23..10,023,152,662.53 rows=1,259 width=126) (actual rows= loops=)

  • Hash Cond: (y_4.ktei_cmps_msi_id = a_4.ktei_cmps_msi_id)
352. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank_cmps y_4 (cost=0.00..163,364.97 rows=5,416,197 width=16) (actual rows= loops=)

353. 0.000 0.000 ↓ 0.0

Hash (cost=10,022,968,974.15..10,022,968,974.15 rows=6 width=134) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
354. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,607,120.47..10,022,968,974.15 rows=6 width=134) (actual rows= loops=)

  • Hash Cond: ((f_4.crs_sttng_trm_id = x_4.crs_sttng_trm_id) AND (a_4.pln_ptn_no = x_4.pln_ptn_no))
355. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,607,066.32..10,022,968,919.90 rows=6 width=147) (actual rows= loops=)

  • Hash Cond: ((d_5.plncd = v_4.plncd) AND (to_char(c_6.crssttngtrmno, 'FM00'::text) = (v_4.sttngtrmno)::text) AND (f_4.sh_sstcd = v_4.sstcd))
356. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,607,054.03..10,022,968,907.51 rows=6 width=144) (actual rows= loops=)

  • Hash Cond: ((u_4.roomtypebts_chrg_grp_sttng_id = t_4.id) AND (u_4.stfkbn = n_4.sh_stfkbn))
357. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=290,463.10..22,642,753.24 rows=1,275,105 width=16) (actual rows= loops=)

  • Hash Cond: ((u_4.roomtypebts_chrg_grp_sttng_id = u1_4.roomtypebts_chrg_grp_sttng_id) AND (u_4.stfkbn = u1_4.stfkbn) AND (u_4.offr_aply_ninzu = u1_4.offr_aply_ninzu) AND (u_4.kariszi_slsamtrltno = u1_4.kariszi_slsamtrltno))
  • Join Filter: (u_4.rltv_dysu > u1_4.rltv_dysu)
358. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=145,231.55..6,292,528.15 rows=1,912,657 width=23) (actual rows= loops=)

  • Hash Cond: ((u_4.roomtypebts_chrg_grp_sttng_id = u2_4.roomtypebts_chrg_grp_sttng_id) AND (u_4.stfkbn = u2_4.stfkbn) AND (u_4.offr_aply_ninzu = u2_4.offr_aply_ninzu) AND (u_4.rltv_dysu = u2_4.rltv_dysu))
  • Join Filter: (u_4.kariszi_slsamtrltno > u2_4.kariszi_slsamtrltno)
359. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u_4 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

360. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

  • Buckets: 65536 Batches: 64 Memory Usage: 2937kB
361. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u2_4 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

362. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

  • Buckets: 65536 Batches: 64 Memory Usage: 2942kB
363. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u1_4 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

364. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,316,590.91..10,000,316,590.91 rows=1 width=150) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
365. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,311,387.79..10,000,316,590.91 rows=1 width=150) (actual rows= loops=)

  • Hash Cond: ((z_4.sh_buyin_irai_gstroom_msi_id = p_4.id) AND (z_4.stfkbn = n_4.sh_stfkbn))
  • Filter: ((z_4.agree_psbl_flg = '1'::bpchar) OR (f_4.sh_sstcd = 'ZZZZZZZ'::bpchar))
366. 0.000 0.000 ↓ 0.0

Seq Scan on sh_buyin_irai_gstroom_agree_stf_kbn z_4 (cost=0.00..4,546.05 rows=87,605 width=13) (actual rows= loops=)

367. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,311,387.76..10,000,311,387.76 rows=2 width=158) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
368. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,310,139.80..10,000,311,387.76 rows=2 width=158) (actual rows= loops=)

  • Hash Cond: ((t_4.plnplnscd = s_4.plnplnscd) AND (t_4.plnsmsino = s_4.plnsmsino) AND (t_4.crssttngtrmno = s_4.crssttngtrmno) AND (t_4.sh_sstcd = s_4.sh_sstcd) AND (t_4.roomtypcd = f_4.roomtypcd))
369. 0.000 0.000 ↓ 0.0

Seq Scan on roomtypebts_chrg_grp_sttng t_4 (cost=0.00..937.55 rows=16,555 width=39) (actual rows= loops=)

370. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,310,139.75..10,000,310,139.75 rows=2 width=173) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
371. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,304,453.23..10,000,310,139.75 rows=2 width=173) (actual rows= loops=)

  • Hash Cond: ((d_5.plncd = p_4.plncd) AND (to_char(c_6.crssttngtrmno, 'FM00'::text) = (p_4.sttngtrmno)::text) AND (f_4.sh_sstcd = p_4.sstcd) AND (f_4.roomtypcd = p_4.gstroom_roomtypcd))
372. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,304,440.84..10,000,310,127.31 rows=2 width=165) (actual rows= loops=)

  • Hash Cond: (m_4.stfkbn = n_4.crs_stfkbn)
373. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,304,439.63..10,000,310,126.08 rows=2 width=159) (actual rows= loops=)

  • Hash Cond: (m_4.crs_id = c_6.crs_id)
374. 0.000 0.000 ↓ 0.0

Seq Scan on crs_agree_stf_kbn m_4 (cost=0.00..5,646.12 rows=10,747 width=11) (actual rows= loops=)

  • Filter: (agree_psbl_flg = '1'::bpchar)
375. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,304,439.62..10,000,304,439.62 rows=1 width=148) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
376. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,303,696.68..10,000,304,439.62 rows=1 width=148) (actual rows= loops=)

  • Hash Cond: (a_4.ktei_cmps_msi_id = f_4.id)
377. 0.000 0.000 ↓ 0.0

Seq Scan on crs_ktei_ptn a_4 (cost=0.00..646.13 rows=25,813 width=13) (actual rows= loops=)

378. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,303,696.67..10,000,303,696.67 rows=1 width=135) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
379. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,000,001,337.24..10,000,303,696.67 rows=1 width=135) (actual rows= loops=)

380. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,336.97..303,694.37 rows=1 width=135) (actual rows= loops=)

  • Hash Cond: ((f_4.crs_sttng_trm_id = c_6.id) AND (f_4.sh_sstcd = s_4.sh_sstcd))
381. 0.000 0.000 ↓ 0.0

Seq Scan on ktei_cmps_msi f_4 (cost=0.00..302,352.14 rows=700 width=37) (actual rows= loops=)

  • Filter: ((kteikbn)::text = '04'::text)
382. 0.000 0.000 ↓ 0.0

Hash (cost=1,336.89..1,336.89 rows=5 width=98) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
383. 0.000 0.000 ↓ 0.0

Hash Join (cost=644.93..1,336.89 rows=5 width=98) (actual rows= loops=)

  • Hash Cond: ((s_4.plnplnscd = c_6.plnplnscd) AND (s_4.plnsmsino = c_6.plnsmsino) AND (s_4.crssttngtrmno = c_6.crssttngtrmno))
384. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sh_sst s_4 (cost=0.00..600.37 rows=8,137 width=39) (actual rows= loops=)

385. 0.000 0.000 ↓ 0.0

Hash (cost=644.90..644.90 rows=2 width=74) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
386. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.28..644.90 rows=2 width=74) (actual rows= loops=)

  • Hash Cond: (c_6.crs_id = d_5.id)
387. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sttng_trm c_6 (cost=0.00..622.62 rows=5,062 width=36) (actual rows= loops=)

388. 0.000 0.000 ↓ 0.0

Hash (cost=3.25..3.25 rows=2 width=38) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
389. 0.000 0.000 ↓ 0.0

Index Scan using crs_01_index on crs d_5 (cost=0.28..3.25 rows=2 width=38) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
390. 0.000 0.000 ↓ 0.0

Index Only Scan using pln_unq_idx on pln g_4 (cost=0.28..2.29 rows=1 width=7) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
391. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=9) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
392. 0.000 0.000 ↓ 0.0

Seq Scan on stfkbn_trns_mst n_4 (cost=0.00..1.09 rows=9 width=9) (actual rows= loops=)

393. 0.000 0.000 ↓ 0.0

Hash (cost=12.18..12.18 rows=11 width=29) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
394. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi p_4 (cost=0.41..12.18 rows=11 width=29) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
395. 0.000 0.000 ↓ 0.0

Hash (cost=12.21..12.21 rows=5 width=21) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
396. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi v_4 (cost=0.41..12.21 rows=5 width=21) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
  • Filter: (stndrd_room_typ_flg = '1'::bpchar)
397. 0.000 0.000 ↓ 0.0

Hash (cost=33.06..33.06 rows=1,406 width=13) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 78kB
398. 0.000 0.000 ↓ 0.0

Seq Scan on crs_stndrd_ktei_ptn x_4 (cost=0.00..33.06 rows=1,406 width=13) (actual rows= loops=)

399. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

400. 0.000 0.000 ↓ 0.0

Seq Scan on cnsmtax_mst k_4 (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

401. 0.000 0.000 ↓ 0.0

Hash (cost=16.92..16.92 rows=392 width=26) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
402. 0.000 0.000 ↓ 0.0

Seq Scan on snshaszi_slsamt aa_4 (cost=0.00..16.92 rows=392 width=26) (actual rows= loops=)

403. 0.000 0.000 ↓ 0.0

Hash (cost=59.30..59.30 rows=276 width=19) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
404. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=11.82..59.30 rows=276 width=19) (actual rows= loops=)

  • Hash Cond: ((bb_2.sstcd = cc_2.sstcd) AND (bb_2.zikoformno = cc_2.zikoformno))
405. 0.000 0.000 ↓ 0.0

Seq Scan on snshaszi bb_2 (cost=0.00..24.33 rows=233 width=25) (actual rows= loops=)

406. 0.000 0.000 ↓ 0.0

Hash (cost=8.33..8.33 rows=233 width=16) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
407. 0.000 0.000 ↓ 0.0

Seq Scan on snsha_ziko cc_2 (cost=0.00..8.33 rows=233 width=16) (actual rows= loops=)

408. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 6 (cost=20,001,130,877.51..20,023,493,036.47 rows=1,212 width=117) (actual rows= loops=)

409. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,001,130,877.51..20,023,493,024.35 rows=1,212 width=117) (actual rows= loops=)

  • Hash Cond: (f_5.szicd = bb_3.szicd)
410. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,001,130,853.05..20,023,492,723.27 rows=753 width=114) (actual rows= loops=)

  • Hash Cond: ((f_5.szicd = aa_5.szicd) AND (b_7.szi_slsamtrltno = aa_5.trsm_slsamtrltno) AND (n_5.trsm_stfkbn = CASE WHEN (aa_5.stfkbn = '99'::bpchar) THEN '01'::bpchar ELSE aa_5.stfkbn END))
411. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=20,001,130,843.79..20,023,492,704.60 rows=753 width=113) (actual rows= loops=)

  • Hash Cond: ((u_5.roomtypebts_chrg_grp_sttng_id = t_5.id) AND (u_5.stfkbn = n_5.sh_stfkbn))
412. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=290,463.10..22,642,753.24 rows=1,275,105 width=16) (actual rows= loops=)

  • Hash Cond: ((u_5.roomtypebts_chrg_grp_sttng_id = u1_5.roomtypebts_chrg_grp_sttng_id) AND (u_5.stfkbn = u1_5.stfkbn) AND (u_5.offr_aply_ninzu = u1_5.offr_aply_ninzu) AND (u_5.kariszi_slsamtrltno = u1_5.kariszi_slsamtrltno))
  • Join Filter: (u_5.rltv_dysu > u1_5.rltv_dysu)
413. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=145,231.55..6,292,528.15 rows=1,912,657 width=23) (actual rows= loops=)

  • Hash Cond: ((u_5.roomtypebts_chrg_grp_sttng_id = u2_5.roomtypebts_chrg_grp_sttng_id) AND (u_5.stfkbn = u2_5.stfkbn) AND (u_5.offr_aply_ninzu = u2_5.offr_aply_ninzu) AND (u_5.rltv_dysu = u2_5.rltv_dysu))
  • Join Filter: (u_5.kariszi_slsamtrltno > u2_5.kariszi_slsamtrltno)
414. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u_5 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

415. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

416. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u2_5 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

417. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

418. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u1_5 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

419. 0.000 0.000 ↓ 0.0

Hash (cost=20,000,840,378.80..20,000,840,378.80 rows=126 width=119) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
420. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=20,000,747,343.59..20,000,840,378.80 rows=126 width=119) (actual rows= loops=)

  • Join Filter: (((k_5.aply_bgn_ymd)::text <= to_char((((to_date((e_6.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_5.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)) AND ((k_5.aply_end_ymd)::text >= to_char((((to_date((e_6.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_5.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)))
421. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,747,343.59..10,000,840,370.55 rows=126 width=116) (actual rows= loops=)

  • Hash Cond: ((e_6.crssttngtrmno = c_7.crssttngtrmno) AND (e_6.crs_id = c_7.crs_id) AND (e_6.lnd_slsamtrltno = b_7.lnd_slsamtrltno))
422. 0.000 0.000 ↓ 0.0

Seq Scan on crs_clndr e_6 (cost=0.00..81,896.80 rows=989,235 width=35) (actual rows= loops=)

  • Filter: (exclddy_flg = '0'::bpchar)
423. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,747,339.92..10,000,747,339.92 rows=210 width=133) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
424. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,503,835.23..10,000,747,339.92 rows=210 width=133) (actual rows= loops=)

  • Hash Cond: (b_7.id = y_5.crs_szi_rank_id)
425. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank b_7 (cost=0.00..221,791.43 rows=5,789,643 width=17) (actual rows= loops=)

426. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,503,832.60..10,000,503,832.60 rows=210 width=132) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
427. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,320,154.79..10,000,503,832.60 rows=210 width=132) (actual rows= loops=)

  • Hash Cond: (y_5.ktei_cmps_msi_id = a_5.ktei_cmps_msi_id)
428. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank_cmps y_5 (cost=0.00..163,364.97 rows=5,416,197 width=16) (actual rows= loops=)

429. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,320,154.78..10,000,320,154.78 rows=1 width=140) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
430. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,320,111.17..10,000,320,154.78 rows=1 width=140) (actual rows= loops=)

  • Hash Cond: ((x_5.crs_sttng_trm_id = f_5.crs_sttng_trm_id) AND (x_5.pln_ptn_no = a_5.pln_ptn_no))
431. 0.000 0.000 ↓ 0.0

Seq Scan on crs_stndrd_ktei_ptn x_5 (cost=0.00..33.06 rows=1,406 width=13) (actual rows= loops=)

432. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,320,111.15..10,000,320,111.15 rows=1 width=153) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
433. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,314,908.01..10,000,320,111.15 rows=1 width=153) (actual rows= loops=)

  • Hash Cond: ((d_6.plncd = v_5.plncd) AND (to_char(c_7.crssttngtrmno, 'FM00'::text) = (v_5.sttngtrmno)::text) AND (f_5.sh_sstcd = v_5.sstcd))
434. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,314,895.72..10,000,320,098.83 rows=1 width=150) (actual rows= loops=)

  • Hash Cond: ((z_5.sh_buyin_irai_gstroom_msi_id = p_5.id) AND (z_5.stfkbn = n_5.sh_stfkbn))
  • Filter: ((z_5.agree_psbl_flg = '1'::bpchar) OR (f_5.sh_sstcd = 'ZZZZZZZ'::bpchar))
435. 0.000 0.000 ↓ 0.0

Seq Scan on sh_buyin_irai_gstroom_agree_stf_kbn z_5 (cost=0.00..4,546.05 rows=87,605 width=13) (actual rows= loops=)

436. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,314,895.69..10,000,314,895.69 rows=2 width=158) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
437. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,309,209.17..10,000,314,895.69 rows=2 width=158) (actual rows= loops=)

  • Hash Cond: ((d_6.plncd = p_5.plncd) AND (to_char(c_7.crssttngtrmno, 'FM00'::text) = (p_5.sttngtrmno)::text) AND (f_5.sh_sstcd = p_5.sstcd) AND (f_5.roomtypcd = p_5.gstroom_roomtypcd))
438. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,309,196.77..10,000,314,883.24 rows=2 width=150) (actual rows= loops=)

  • Hash Cond: (m_5.stfkbn = n_5.crs_stfkbn)
439. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,309,195.56..10,000,314,882.01 rows=2 width=144) (actual rows= loops=)

  • Hash Cond: (m_5.crs_id = c_7.crs_id)
440. 0.000 0.000 ↓ 0.0

Seq Scan on crs_agree_stf_kbn m_5 (cost=0.00..5,646.12 rows=10,747 width=11) (actual rows= loops=)

  • Filter: (agree_psbl_flg = '1'::bpchar)
441. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,309,195.55..10,000,309,195.55 rows=1 width=133) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
442. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,307,947.59..10,000,309,195.55 rows=1 width=133) (actual rows= loops=)

  • Hash Cond: ((t_5.plnplnscd = s_5.plnplnscd) AND (t_5.plnsmsino = s_5.plnsmsino) AND (t_5.crssttngtrmno = s_5.crssttngtrmno) AND (t_5.sh_sstcd = s_5.sh_sstcd) AND (t_5.roomtypcd = f_5.roomtypcd))
443. 0.000 0.000 ↓ 0.0

Seq Scan on roomtypebts_chrg_grp_sttng t_5 (cost=0.00..937.55 rows=16,555 width=39) (actual rows= loops=)

444. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,307,947.56..10,000,307,947.56 rows=1 width=148) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
445. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,307,194.17..10,000,307,947.56 rows=1 width=148) (actual rows= loops=)

  • Hash Cond: ((i_2.sstcd = h_2.sstcd) AND (i_2.aply_bgn_ymd = h_2.aply_bgn_ymd))
446. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=546.30..1,231.23 rows=9,127 width=17) (actual rows= loops=)

  • Hash Cond: ((i_2.sstcd = j_2.sstcd) AND (i_2.aply_bgn_ymd = j_2.aply_bgn_ymd))
  • Join Filter: (i_2.chrg_rvsn_ymd < j_2.chrg_rvsn_ymd)
447. 0.000 0.000 ↓ 0.0

Index Only Scan using sh_sst_bsc_tsry_mst_pkey_1 on sh_sst_bsc_tsry_mst i_2 (cost=0.29..340.65 rows=13,691 width=26) (actual rows= loops=)

448. 0.000 0.000 ↓ 0.0

Hash (cost=340.65..340.65 rows=13,691 width=26) (actual rows= loops=)

449. 0.000 0.000 ↓ 0.0

Index Only Scan using sh_sst_bsc_tsry_mst_pkey_1 on sh_sst_bsc_tsry_mst j_2 (cost=0.29..340.65 rows=13,691 width=26) (actual rows= loops=)

450. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,306,647.86..10,000,306,647.86 rows=1 width=165) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
451. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,304,434.39..10,000,306,647.86 rows=1 width=165) (actual rows= loops=)

  • Hash Cond: (h_2.sstcd = f_5.sh_sstcd)
  • Join Filter: ((h_2.aply_bgn_ymd <= d_6.trvl_cndtn_stndrd_ymd) AND (d_6.trvl_cndtn_stndrd_ymd <= h_2.aply_end_ymd))
452. 0.000 0.000 ↓ 0.0

Seq Scan on sh_sst_bsc_mst h_2 (cost=0.00..2,162.20 rows=13,663 width=26) (actual rows= loops=)

  • Filter: ((langkbn)::text = 'ja'::text)
453. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,304,434.38..10,000,304,434.38 rows=1 width=157) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
454. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,303,691.44..10,000,304,434.38 rows=1 width=157) (actual rows= loops=)

  • Hash Cond: (a_5.ktei_cmps_msi_id = f_5.id)
455. 0.000 0.000 ↓ 0.0

Seq Scan on crs_ktei_ptn a_5 (cost=0.00..646.13 rows=25,813 width=13) (actual rows= loops=)

456. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,303,691.43..10,000,303,691.43 rows=1 width=144) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
457. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,000,001,337.24..10,000,303,691.43 rows=1 width=144) (actual rows= loops=)

458. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,336.97..303,689.12 rows=1 width=144) (actual rows= loops=)

  • Hash Cond: ((f_5.crs_sttng_trm_id = c_7.id) AND (f_5.sh_sstcd = s_5.sh_sstcd))
459. 0.000 0.000 ↓ 0.0

Seq Scan on ktei_cmps_msi f_5 (cost=0.00..302,352.14 rows=1 width=37) (actual rows= loops=)

  • Filter: ((kteikbn)::text = '05'::text)
460. 0.000 0.000 ↓ 0.0

Hash (cost=1,336.89..1,336.89 rows=5 width=107) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
461. 0.000 0.000 ↓ 0.0

Hash Join (cost=644.93..1,336.89 rows=5 width=107) (actual rows= loops=)

  • Hash Cond: ((s_5.plnplnscd = c_7.plnplnscd) AND (s_5.plnsmsino = c_7.plnsmsino) AND (s_5.crssttngtrmno = c_7.crssttngtrmno))
462. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sh_sst s_5 (cost=0.00..600.37 rows=8,137 width=39) (actual rows= loops=)

463. 0.000 0.000 ↓ 0.0

Hash (cost=644.90..644.90 rows=2 width=83) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
464. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.28..644.90 rows=2 width=83) (actual rows= loops=)

  • Hash Cond: (c_7.crs_id = d_6.id)
465. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sttng_trm c_7 (cost=0.00..622.62 rows=5,062 width=36) (actual rows= loops=)

466. 0.000 0.000 ↓ 0.0

Hash (cost=3.25..3.25 rows=2 width=47) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
467. 0.000 0.000 ↓ 0.0

Index Scan using crs_01_index on crs d_6 (cost=0.28..3.25 rows=2 width=47) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
468. 0.000 0.000 ↓ 0.0

Index Only Scan using pln_unq_idx on pln g_5 (cost=0.28..2.29 rows=1 width=7) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
469. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=9) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
470. 0.000 0.000 ↓ 0.0

Seq Scan on stfkbn_trns_mst n_5 (cost=0.00..1.09 rows=9 width=9) (actual rows= loops=)

471. 0.000 0.000 ↓ 0.0

Hash (cost=12.18..12.18 rows=11 width=29) (actual rows= loops=)

472. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi p_5 (cost=0.41..12.18 rows=11 width=29) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
473. 0.000 0.000 ↓ 0.0

Hash (cost=12.21..12.21 rows=5 width=21) (actual rows= loops=)

474. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi v_5 (cost=0.41..12.21 rows=5 width=21) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
  • Filter: (stndrd_room_typ_flg = '1'::bpchar)
475. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

476. 0.000 0.000 ↓ 0.0

Seq Scan on cnsmtax_mst k_5 (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

477. 0.000 0.000 ↓ 0.0

Hash (cost=5.91..5.91 rows=191 width=24) (actual rows= loops=)

478. 0.000 0.000 ↓ 0.0

Seq Scan on trsmszi_slsamt aa_5 (cost=0.00..5.91 rows=191 width=24) (actual rows= loops=)

479. 0.000 0.000 ↓ 0.0

Hash (cost=22.59..22.59 rows=150 width=19) (actual rows= loops=)

480. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5.28..22.59 rows=150 width=19) (actual rows= loops=)

  • Hash Cond: ((bb_3.sstcd = cc_3.sstcd) AND (bb_3.zikoformno = cc_3.zikoformno))
481. 0.000 0.000 ↓ 0.0

Seq Scan on trsmszi bb_3 (cost=0.00..10.93 rows=93 width=25) (actual rows= loops=)

482. 0.000 0.000 ↓ 0.0

Hash (cost=3.91..3.91 rows=91 width=16) (actual rows= loops=)

483. 0.000 0.000 ↓ 0.0

Seq Scan on trsm_ziko cc_3 (cost=0.00..3.91 rows=91 width=16) (actual rows= loops=)

484. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 7 (cost=20,023,396,224.60..20,023,489,398.25 rows=753 width=114) (actual rows= loops=)

485. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,023,396,224.60..20,023,489,390.72 rows=753 width=114) (actual rows= loops=)

  • Hash Cond: (f_6.szicd = cc_4.szicd)
486. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,023,396,220.72..20,023,489,310.56 rows=753 width=120) (actual rows= loops=)

  • Hash Cond: (f_6.szicd = bb_4.szicd)
  • Join Filter: ((bb_4.aply_bgn_ymd <= c_8.sttng_trm_bgn_ymd) AND (c_8.sttng_trm_end_ymd <= bb_4.aply_end_ymd))
487. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,023,396,218.87..20,023,489,305.82 rows=753 width=134) (actual rows= loops=)

  • Hash Cond: ((f_6.szicd = aa_6.szicd) AND (b_8.szi_slsamtrltno = aa_6.frcpn_slsamtrltno) AND (n_6.frcpn_stfkbn = CASE WHEN (aa_6.stfkbn = '99'::bpchar) THEN '01'::bpchar ELSE aa_6.stfkbn END))
488. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=20,023,396,213.73..20,023,489,291.26 rows=753 width=131) (actual rows= loops=)

  • Join Filter: (((k_6.aply_bgn_ymd)::text <= to_char((((to_date((e_7.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_6.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)) AND ((k_6.aply_end_ymd)::text >= to_char((((to_date((e_7.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_6.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)))
489. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,023,396,213.73..10,023,489,246.95 rows=753 width=128) (actual rows= loops=)

  • Hash Cond: ((e_7.crssttngtrmno = c_8.crssttngtrmno) AND (e_7.crs_id = c_8.crs_id) AND (e_7.lnd_slsamtrltno = b_8.lnd_slsamtrltno))
490. 0.000 0.000 ↓ 0.0

Seq Scan on crs_clndr e_7 (cost=0.00..81,896.80 rows=989,235 width=35) (actual rows= loops=)

  • Filter: (exclddy_flg = '0'::bpchar)
491. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,396,191.70..10,023,396,191.70 rows=1,259 width=145) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
492. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,023,152,676.52..10,023,396,191.70 rows=1,259 width=145) (actual rows= loops=)

  • Hash Cond: (b_8.id = y_6.crs_szi_rank_id)
493. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank b_8 (cost=0.00..221,791.43 rows=5,789,643 width=17) (actual rows= loops=)

494. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,152,660.78..10,023,152,660.78 rows=1,259 width=144) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
495. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,022,968,972.48..10,023,152,660.78 rows=1,259 width=144) (actual rows= loops=)

  • Hash Cond: (y_6.ktei_cmps_msi_id = a_6.ktei_cmps_msi_id)
496. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank_cmps y_6 (cost=0.00..163,364.97 rows=5,416,197 width=16) (actual rows= loops=)

497. 0.000 0.000 ↓ 0.0

Hash (cost=10,022,968,972.41..10,022,968,972.41 rows=6 width=152) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
498. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,607,118.72..10,022,968,972.41 rows=6 width=152) (actual rows= loops=)

  • Hash Cond: ((f_6.crs_sttng_trm_id = x_6.crs_sttng_trm_id) AND (a_6.pln_ptn_no = x_6.pln_ptn_no))
499. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,607,064.57..10,022,968,918.15 rows=6 width=165) (actual rows= loops=)

  • Hash Cond: ((d_7.plncd = v_6.plncd) AND (to_char(c_8.crssttngtrmno, 'FM00'::text) = (v_6.sttngtrmno)::text) AND (f_6.sh_sstcd = v_6.sstcd))
500. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,607,052.28..10,022,968,905.76 rows=6 width=162) (actual rows= loops=)

  • Hash Cond: ((u_6.roomtypebts_chrg_grp_sttng_id = t_6.id) AND (u_6.stfkbn = n_6.sh_stfkbn))
501. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=290,463.10..22,642,753.24 rows=1,275,105 width=16) (actual rows= loops=)

  • Hash Cond: ((u_6.roomtypebts_chrg_grp_sttng_id = u1_6.roomtypebts_chrg_grp_sttng_id) AND (u_6.stfkbn = u1_6.stfkbn) AND (u_6.offr_aply_ninzu = u1_6.offr_aply_ninzu) AND (u_6.kariszi_slsamtrltno = u1_6.kariszi_slsamtrltno))
  • Join Filter: (u_6.rltv_dysu > u1_6.rltv_dysu)
502. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=145,231.55..6,292,528.15 rows=1,912,657 width=23) (actual rows= loops=)

  • Hash Cond: ((u_6.roomtypebts_chrg_grp_sttng_id = u2_6.roomtypebts_chrg_grp_sttng_id) AND (u_6.stfkbn = u2_6.stfkbn) AND (u_6.offr_aply_ninzu = u2_6.offr_aply_ninzu) AND (u_6.rltv_dysu = u2_6.rltv_dysu))
  • Join Filter: (u_6.kariszi_slsamtrltno > u2_6.kariszi_slsamtrltno)
503. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u_6 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

504. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

505. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u2_6 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

506. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

507. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u1_6 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

508. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,316,589.16..10,000,316,589.16 rows=1 width=168) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
509. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,311,386.05..10,000,316,589.16 rows=1 width=168) (actual rows= loops=)

  • Hash Cond: ((z_6.sh_buyin_irai_gstroom_msi_id = p_6.id) AND (z_6.stfkbn = n_6.sh_stfkbn))
  • Filter: ((z_6.agree_psbl_flg = '1'::bpchar) OR (f_6.sh_sstcd = 'ZZZZZZZ'::bpchar))
510. 0.000 0.000 ↓ 0.0

Seq Scan on sh_buyin_irai_gstroom_agree_stf_kbn z_6 (cost=0.00..4,546.05 rows=87,605 width=13) (actual rows= loops=)

511. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,311,386.02..10,000,311,386.02 rows=2 width=176) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
512. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,310,138.05..10,000,311,386.02 rows=2 width=176) (actual rows= loops=)

  • Hash Cond: ((t_6.plnplnscd = s_6.plnplnscd) AND (t_6.plnsmsino = s_6.plnsmsino) AND (t_6.crssttngtrmno = s_6.crssttngtrmno) AND (t_6.sh_sstcd = s_6.sh_sstcd) AND (t_6.roomtypcd = f_6.roomtypcd))
513. 0.000 0.000 ↓ 0.0

Seq Scan on roomtypebts_chrg_grp_sttng t_6 (cost=0.00..937.55 rows=16,555 width=39) (actual rows= loops=)

514. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,310,138.01..10,000,310,138.01 rows=2 width=191) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
515. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,304,451.49..10,000,310,138.01 rows=2 width=191) (actual rows= loops=)

  • Hash Cond: ((d_7.plncd = p_6.plncd) AND (to_char(c_8.crssttngtrmno, 'FM00'::text) = (p_6.sttngtrmno)::text) AND (f_6.sh_sstcd = p_6.sstcd) AND (f_6.roomtypcd = p_6.gstroom_roomtypcd))
516. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,304,439.09..10,000,310,125.56 rows=2 width=183) (actual rows= loops=)

  • Hash Cond: (m_6.stfkbn = n_6.crs_stfkbn)
517. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,304,437.89..10,000,310,124.33 rows=2 width=177) (actual rows= loops=)

  • Hash Cond: (m_6.crs_id = c_8.crs_id)
518. 0.000 0.000 ↓ 0.0

Seq Scan on crs_agree_stf_kbn m_6 (cost=0.00..5,646.12 rows=10,747 width=11) (actual rows= loops=)

  • Filter: (agree_psbl_flg = '1'::bpchar)
519. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,304,437.87..10,000,304,437.87 rows=1 width=166) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
520. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,303,694.93..10,000,304,437.87 rows=1 width=166) (actual rows= loops=)

  • Hash Cond: (a_6.ktei_cmps_msi_id = f_6.id)
521. 0.000 0.000 ↓ 0.0

Seq Scan on crs_ktei_ptn a_6 (cost=0.00..646.13 rows=25,813 width=13) (actual rows= loops=)

522. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,303,694.92..10,000,303,694.92 rows=1 width=153) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
523. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,000,001,337.24..10,000,303,694.92 rows=1 width=153) (actual rows= loops=)

524. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,336.97..303,692.62 rows=1 width=153) (actual rows= loops=)

  • Hash Cond: ((f_6.crs_sttng_trm_id = c_8.id) AND (f_6.sh_sstcd = s_6.sh_sstcd))
525. 0.000 0.000 ↓ 0.0

Seq Scan on ktei_cmps_msi f_6 (cost=0.00..302,352.14 rows=467 width=37) (actual rows= loops=)

  • Filter: ((kteikbn)::text = '06'::text)
526. 0.000 0.000 ↓ 0.0

Hash (cost=1,336.89..1,336.89 rows=5 width=116) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
527. 0.000 0.000 ↓ 0.0

Hash Join (cost=644.93..1,336.89 rows=5 width=116) (actual rows= loops=)

  • Hash Cond: ((s_6.plnplnscd = c_8.plnplnscd) AND (s_6.plnsmsino = c_8.plnsmsino) AND (s_6.crssttngtrmno = c_8.crssttngtrmno))
528. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sh_sst s_6 (cost=0.00..600.37 rows=8,137 width=39) (actual rows= loops=)

529. 0.000 0.000 ↓ 0.0

Hash (cost=644.90..644.90 rows=2 width=92) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
530. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.28..644.90 rows=2 width=92) (actual rows= loops=)

  • Hash Cond: (c_8.crs_id = d_7.id)
531. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sttng_trm c_8 (cost=0.00..622.62 rows=5,062 width=54) (actual rows= loops=)

532. 0.000 0.000 ↓ 0.0

Hash (cost=3.25..3.25 rows=2 width=38) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
533. 0.000 0.000 ↓ 0.0

Index Scan using crs_01_index on crs d_7 (cost=0.28..3.25 rows=2 width=38) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
534. 0.000 0.000 ↓ 0.0

Index Only Scan using pln_unq_idx on pln g_6 (cost=0.28..2.29 rows=1 width=7) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
535. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=9) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
536. 0.000 0.000 ↓ 0.0

Seq Scan on stfkbn_trns_mst n_6 (cost=0.00..1.09 rows=9 width=9) (actual rows= loops=)

537. 0.000 0.000 ↓ 0.0

Hash (cost=12.18..12.18 rows=11 width=29) (actual rows= loops=)

538. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi p_6 (cost=0.41..12.18 rows=11 width=29) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
539. 0.000 0.000 ↓ 0.0

Hash (cost=12.21..12.21 rows=5 width=21) (actual rows= loops=)

540. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi v_6 (cost=0.41..12.21 rows=5 width=21) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
  • Filter: (stndrd_room_typ_flg = '1'::bpchar)
541. 0.000 0.000 ↓ 0.0

Hash (cost=33.06..33.06 rows=1,406 width=13) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 78kB
542. 0.000 0.000 ↓ 0.0

Seq Scan on crs_stndrd_ktei_ptn x_6 (cost=0.00..33.06 rows=1,406 width=13) (actual rows= loops=)

543. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

544. 0.000 0.000 ↓ 0.0

Seq Scan on cnsmtax_mst k_6 (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

545. 0.000 0.000 ↓ 0.0

Hash (cost=3.14..3.14 rows=114 width=26) (actual rows= loops=)

546. 0.000 0.000 ↓ 0.0

Seq Scan on frcpn_slsamt aa_6 (cost=0.00..3.14 rows=114 width=26) (actual rows= loops=)

547. 0.000 0.000 ↓ 0.0

Hash (cost=1.38..1.38 rows=38 width=30) (actual rows= loops=)

548. 0.000 0.000 ↓ 0.0

Seq Scan on frcpn_szi_trm_no bb_4 (cost=0.00..1.38 rows=38 width=30) (actual rows= loops=)

549. 0.000 0.000 ↓ 0.0

Hash (cost=3.39..3.39 rows=39 width=10) (actual rows= loops=)

550. 0.000 0.000 ↓ 0.0

Seq Scan on frcpn_szi cc_4 (cost=0.00..3.39 rows=39 width=10) (actual rows= loops=)

551. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 8 (cost=20,023,396,221.31..20,023,489,394.91 rows=753 width=112) (actual rows= loops=)

552. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,023,396,221.31..20,023,489,387.38 rows=753 width=112) (actual rows= loops=)

  • Hash Cond: (f_7.szicd = cc_5.szicd)
553. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,023,396,216.75..20,023,489,306.56 rows=753 width=118) (actual rows= loops=)

  • Hash Cond: (f_7.szicd = bb_5.szicd)
  • Join Filter: ((bb_5.aply_bgn_ymd <= c_9.sttng_trm_bgn_ymd) AND (c_9.sttng_trm_end_ymd <= bb_5.aply_end_ymd))
554. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,023,396,215.19..20,023,489,302.14 rows=753 width=133) (actual rows= loops=)

  • Hash Cond: ((f_7.szicd = aa_7.szicd) AND (b_9.szi_slsamtrltno = aa_7.cstclcfr_slsamtrltno) AND (n_7.cstclcfr_stfkbn = CASE WHEN (aa_7.stfkbn = '99'::bpchar) THEN '01'::bpchar ELSE aa_7.stfkbn END))
555. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=20,023,396,210.24..20,023,489,287.77 rows=753 width=131) (actual rows= loops=)

  • Join Filter: (((k_7.aply_bgn_ymd)::text <= to_char((((to_date((e_8.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_7.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)) AND ((k_7.aply_end_ymd)::text >= to_char((((to_date((e_8.dprt_ymd)::text, 'YYYYMMDD'::text) - 1) + (f_7.rltv_dysu)::integer))::timestamp with time zone, 'YYYYMMDD'::text)))
556. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,023,396,210.24..10,023,489,243.46 rows=753 width=128) (actual rows= loops=)

  • Hash Cond: ((e_8.crssttngtrmno = c_9.crssttngtrmno) AND (e_8.crs_id = c_9.crs_id) AND (e_8.lnd_slsamtrltno = b_9.lnd_slsamtrltno))
557. 0.000 0.000 ↓ 0.0

Seq Scan on crs_clndr e_8 (cost=0.00..81,896.80 rows=989,235 width=35) (actual rows= loops=)

  • Filter: (exclddy_flg = '0'::bpchar)
558. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,396,188.20..10,023,396,188.20 rows=1,259 width=145) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
559. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,023,152,673.02..10,023,396,188.20 rows=1,259 width=145) (actual rows= loops=)

  • Hash Cond: (b_9.id = y_7.crs_szi_rank_id)
560. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank b_9 (cost=0.00..221,791.43 rows=5,789,643 width=17) (actual rows= loops=)

561. 0.000 0.000 ↓ 0.0

Hash (cost=10,023,152,657.28..10,023,152,657.28 rows=1,259 width=144) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
562. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,022,968,968.99..10,023,152,657.28 rows=1,259 width=144) (actual rows= loops=)

  • Hash Cond: (y_7.ktei_cmps_msi_id = a_7.ktei_cmps_msi_id)
563. 0.000 0.000 ↓ 0.0

Seq Scan on crs_szi_rank_cmps y_7 (cost=0.00..163,364.97 rows=5,416,197 width=16) (actual rows= loops=)

564. 0.000 0.000 ↓ 0.0

Hash (cost=10,022,968,968.91..10,022,968,968.91 rows=6 width=152) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
565. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,607,115.23..10,022,968,968.91 rows=6 width=152) (actual rows= loops=)

  • Hash Cond: ((f_7.crs_sttng_trm_id = x_7.crs_sttng_trm_id) AND (a_7.pln_ptn_no = x_7.pln_ptn_no))
566. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,607,061.08..10,022,968,914.66 rows=6 width=165) (actual rows= loops=)

  • Hash Cond: ((d_8.plncd = v_7.plncd) AND (to_char(c_9.crssttngtrmno, 'FM00'::text) = (v_7.sttngtrmno)::text) AND (f_7.sh_sstcd = v_7.sstcd))
567. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,607,048.78..10,022,968,902.27 rows=6 width=162) (actual rows= loops=)

  • Hash Cond: ((u_7.roomtypebts_chrg_grp_sttng_id = t_7.id) AND (u_7.stfkbn = n_7.sh_stfkbn))
568. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=290,463.10..22,642,753.24 rows=1,275,105 width=16) (actual rows= loops=)

  • Hash Cond: ((u_7.roomtypebts_chrg_grp_sttng_id = u1_7.roomtypebts_chrg_grp_sttng_id) AND (u_7.stfkbn = u1_7.stfkbn) AND (u_7.offr_aply_ninzu = u1_7.offr_aply_ninzu) AND (u_7.kariszi_slsamtrltno = u1_7.kariszi_slsamtrltno))
  • Join Filter: (u_7.rltv_dysu > u1_7.rltv_dysu)
569. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=145,231.55..6,292,528.15 rows=1,912,657 width=23) (actual rows= loops=)

  • Hash Cond: ((u_7.roomtypebts_chrg_grp_sttng_id = u2_7.roomtypebts_chrg_grp_sttng_id) AND (u_7.stfkbn = u2_7.stfkbn) AND (u_7.offr_aply_ninzu = u2_7.offr_aply_ninzu) AND (u_7.rltv_dysu = u2_7.rltv_dysu))
  • Join Filter: (u_7.kariszi_slsamtrltno > u2_7.kariszi_slsamtrltno)
570. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u_7 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

571. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

572. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u2_7 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

573. 0.000 0.000 ↓ 0.0

Hash (cost=71,040.85..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

574. 0.000 0.000 ↓ 0.0

Seq Scan on kariszi_slsamt u1_7 (cost=0.00..71,040.85 rows=2,868,985 width=23) (actual rows= loops=)

575. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,316,585.67..10,000,316,585.67 rows=1 width=168) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
576. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,311,382.55..10,000,316,585.67 rows=1 width=168) (actual rows= loops=)

  • Hash Cond: ((z_7.sh_buyin_irai_gstroom_msi_id = p_7.id) AND (z_7.stfkbn = n_7.sh_stfkbn))
  • Filter: ((z_7.agree_psbl_flg = '1'::bpchar) OR (f_7.sh_sstcd = 'ZZZZZZZ'::bpchar))
577. 0.000 0.000 ↓ 0.0

Seq Scan on sh_buyin_irai_gstroom_agree_stf_kbn z_7 (cost=0.00..4,546.05 rows=87,605 width=13) (actual rows= loops=)

578. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,311,382.52..10,000,311,382.52 rows=2 width=176) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
579. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=10,000,310,134.56..10,000,311,382.52 rows=2 width=176) (actual rows= loops=)

  • Hash Cond: ((t_7.plnplnscd = s_7.plnplnscd) AND (t_7.plnsmsino = s_7.plnsmsino) AND (t_7.crssttngtrmno = s_7.crssttngtrmno) AND (t_7.sh_sstcd = s_7.sh_sstcd) AND (t_7.roomtypcd = f_7.roomtypcd))
580. 0.000 0.000 ↓ 0.0

Seq Scan on roomtypebts_chrg_grp_sttng t_7 (cost=0.00..937.55 rows=16,555 width=39) (actual rows= loops=)

581. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,310,134.51..10,000,310,134.51 rows=2 width=191) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
582. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,000,304,447.99..10,000,310,134.51 rows=2 width=191) (actual rows= loops=)

  • Hash Cond: ((d_8.plncd = p_7.plncd) AND (to_char(c_9.crssttngtrmno, 'FM00'::text) = (p_7.sttngtrmno)::text) AND (f_7.sh_sstcd = p_7.sstcd) AND (f_7.roomtypcd = p_7.gstroom_roomtypcd))
583. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,304,435.59..10,000,310,122.07 rows=2 width=183) (actual rows= loops=)

  • Hash Cond: (m_7.stfkbn = n_7.crs_stfkbn)
584. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,304,434.39..10,000,310,120.84 rows=2 width=177) (actual rows= loops=)

  • Hash Cond: (m_7.crs_id = c_9.crs_id)
585. 0.000 0.000 ↓ 0.0

Seq Scan on crs_agree_stf_kbn m_7 (cost=0.00..5,646.12 rows=10,747 width=11) (actual rows= loops=)

  • Filter: (agree_psbl_flg = '1'::bpchar)
586. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,304,434.38..10,000,304,434.38 rows=1 width=166) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
587. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,000,303,691.44..10,000,304,434.38 rows=1 width=166) (actual rows= loops=)

  • Hash Cond: (a_7.ktei_cmps_msi_id = f_7.id)
588. 0.000 0.000 ↓ 0.0

Seq Scan on crs_ktei_ptn a_7 (cost=0.00..646.13 rows=25,813 width=13) (actual rows= loops=)

589. 0.000 0.000 ↓ 0.0

Hash (cost=10,000,303,691.43..10,000,303,691.43 rows=1 width=153) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
590. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,000,001,337.24..10,000,303,691.43 rows=1 width=153) (actual rows= loops=)

591. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,336.97..303,689.12 rows=1 width=153) (actual rows= loops=)

  • Hash Cond: ((f_7.crs_sttng_trm_id = c_9.id) AND (f_7.sh_sstcd = s_7.sh_sstcd))
592. 0.000 0.000 ↓ 0.0

Seq Scan on ktei_cmps_msi f_7 (cost=0.00..302,352.14 rows=1 width=37) (actual rows= loops=)

  • Filter: ((kteikbn)::text = '08'::text)
593. 0.000 0.000 ↓ 0.0

Hash (cost=1,336.89..1,336.89 rows=5 width=116) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
594. 0.000 0.000 ↓ 0.0

Hash Join (cost=644.93..1,336.89 rows=5 width=116) (actual rows= loops=)

  • Hash Cond: ((s_7.plnplnscd = c_9.plnplnscd) AND (s_7.plnsmsino = c_9.plnsmsino) AND (s_7.crssttngtrmno = c_9.crssttngtrmno))
595. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sh_sst s_7 (cost=0.00..600.37 rows=8,137 width=39) (actual rows= loops=)

596. 0.000 0.000 ↓ 0.0

Hash (cost=644.90..644.90 rows=2 width=92) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
597. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.28..644.90 rows=2 width=92) (actual rows= loops=)

  • Hash Cond: (c_9.crs_id = d_8.id)
598. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sttng_trm c_9 (cost=0.00..622.62 rows=5,062 width=54) (actual rows= loops=)

599. 0.000 0.000 ↓ 0.0

Hash (cost=3.25..3.25 rows=2 width=38) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
600. 0.000 0.000 ↓ 0.0

Index Scan using crs_01_index on crs d_8 (cost=0.28..3.25 rows=2 width=38) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
601. 0.000 0.000 ↓ 0.0

Index Only Scan using pln_unq_idx on pln g_7 (cost=0.28..2.29 rows=1 width=7) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
602. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=9) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
603. 0.000 0.000 ↓ 0.0

Seq Scan on stfkbn_trns_mst n_7 (cost=0.00..1.09 rows=9 width=9) (actual rows= loops=)

604. 0.000 0.000 ↓ 0.0

Hash (cost=12.18..12.18 rows=11 width=29) (actual rows= loops=)

605. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi p_7 (cost=0.41..12.18 rows=11 width=29) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
606. 0.000 0.000 ↓ 0.0

Hash (cost=12.21..12.21 rows=5 width=21) (actual rows= loops=)

607. 0.000 0.000 ↓ 0.0

Index Scan using sh_buyin_irai_gstroom_msi_unq_idx on sh_buyin_irai_gstroom_msi v_7 (cost=0.41..12.21 rows=5 width=21) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
  • Filter: (stndrd_room_typ_flg = '1'::bpchar)
608. 0.000 0.000 ↓ 0.0

Hash (cost=33.06..33.06 rows=1,406 width=13) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 78kB
609. 0.000 0.000 ↓ 0.0

Seq Scan on crs_stndrd_ktei_ptn x_7 (cost=0.00..33.06 rows=1,406 width=13) (actual rows= loops=)

610. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

611. 0.000 0.000 ↓ 0.0

Seq Scan on cnsmtax_mst k_7 (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

612. 0.000 0.000 ↓ 0.0

Hash (cost=3.71..3.71 rows=71 width=25) (actual rows= loops=)

613. 0.000 0.000 ↓ 0.0

Seq Scan on cstclcfr_szi_slsamt aa_7 (cost=0.00..3.71 rows=71 width=25) (actual rows= loops=)

614. 0.000 0.000 ↓ 0.0

Hash (cost=1.25..1.25 rows=25 width=29) (actual rows= loops=)

615. 0.000 0.000 ↓ 0.0

Seq Scan on cstclcfr_szi_trm_no bb_5 (cost=0.00..1.25 rows=25 width=29) (actual rows= loops=)

616. 0.000 0.000 ↓ 0.0

Hash (cost=4.25..4.25 rows=25 width=10) (actual rows= loops=)

617. 0.000 0.000 ↓ 0.0

Seq Scan on cstclcfr_szi cc_5 (cost=0.00..4.25 rows=25 width=10) (actual rows= loops=)

618. 0.000 0.000 ↓ 0.0

Materialize (cost=0.28..2.30 rows=1 width=15) (actual rows= loops=)

619. 0.000 0.000 ↓ 0.0

Index Scan using pln_unq_idx on pln b_1 (cost=0.28..2.29 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
620. 0.000 0.000 ↓ 0.0

Hash (cost=2.29..2.29 rows=1 width=16) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
621. 0.000 0.000 ↓ 0.0

Index Scan using pln_hksu_unq_idx on pln_hksu c_1 (cost=0.28..2.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
622. 0.000 0.000 ↓ 0.0

Seq Scan on cnsmtax_mst d (cost=0.00..1.01 rows=1 width=23) (actual rows= loops=)

623. 0.000 0.000 ↓ 0.0

Hash (cost=39.05..39.05 rows=82 width=6) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
624. 0.000 0.000 ↓ 0.0

Index Scan using hnyo_mst_pkey_1 on hnyo_mst e (cost=0.28..39.05 rows=82 width=6) (actual rows= loops=)

  • Index Cond: ((hnyokeycd)::text = '080'::text)
625.          

CTE crstmp

626. 0.000 0.000 ↓ 0.0

Unique (cost=715.95..715.98 rows=2 width=36) (actual rows= loops=)

627. 0.000 0.000 ↓ 0.0

Sort (cost=715.95..715.96 rows=2 width=36) (actual rows= loops=)

  • Sort Key: crs_2.plnplnscd, crs_2.plnsmsino, cst_2.sttng_trm_bgn_ymd, cst_2.sttng_trm_end_ymd, hm.hnyo_3_kbnvluecd
628. 0.000 0.000 ↓ 0.0

Hash Join (cost=42.76..715.94 rows=2 width=36) (actual rows= loops=)

  • Hash Cond: ((cst_2.plnplnscd = crs_2.plnplnscd) AND (cst_2.plnsmsino = crs_2.plnsmsino))
629. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sttng_trm cst_2 (cost=0.00..635.27 rows=5,052 width=33) (actual rows= loops=)

  • Filter: (crssttngtrmno = '91'::numeric)
630. 0.000 0.000 ↓ 0.0

Hash (cost=42.74..42.74 rows=1 width=18) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
631. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.56..42.74 rows=1 width=18) (actual rows= loops=)

  • Hash Cond: ((hm.hnyovluecd)::bpchar = crs_2.gdskbn)
632. 0.000 0.000 ↓ 0.0

Index Scan using hnyo_mst_pkey_1 on hnyo_mst hm (cost=0.28..39.05 rows=82 width=6) (actual rows= loops=)

  • Index Cond: ((hnyokeycd)::text = '080'::text)
633. 0.000 0.000 ↓ 0.0

Hash (cost=3.25..3.25 rows=2 width=19) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
634. 0.000 0.000 ↓ 0.0

Index Scan using crs_01_index on crs crs_2 (cost=0.28..3.25 rows=2 width=19) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
635.          

CTE view3

636. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.13..0.14 rows=1 width=172) (actual rows= loops=)

  • Group Key: csh.plnplnscd, csh.plnsmsino, csh.sstcd, csh.stfkbn
637. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.04..0.11 rows=1 width=172) (actual rows= loops=)

  • Hash Cond: ((crstmp.plnplnscd = csh.plnplnscd) AND (crstmp.plnsmsino = csh.plnsmsino))
  • Join Filter: ((csh.use_ymd >= crstmp.sttng_trm_bgn_ymd) AND (csh.use_ymd <= crstmp.sttng_trm_end_ymd) AND ((((crstmp.hnyo_3_kbnvluecd)::text <> ALL ('{02,06}'::text[])) AND (csh.sh_buyinamt <> '0'::numeric)) OR ((crstmp.hnyo_3_kbnvluecd)::text = ANY ('{02,06}'::text[]))))
638. 0.000 0.000 ↓ 0.0

CTE Scan on crstmp (cost=0.00..0.04 rows=2 width=136) (actual rows= loops=)

639. 0.000 0.000 ↓ 0.0

Hash (cost=0.02..0.02 rows=1 width=240) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
640. 0.000 0.000 ↓ 0.0

CTE Scan on csh (cost=0.00..0.02 rows=1 width=240) (actual rows= loops=)

  • Filter: (plncd = '100426'::bpchar)
641. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=311,392.81..380,858.88 rows=10 width=2,629) (actual rows= loops=)

  • Hash Cond: ((crs.id = cm.crs_id) AND (shi.rltv_dysu = cm.rltv_dysu))
642. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=308,442.58..364,703.45 rows=4 width=2,633) (actual rows= loops=)

  • Hash Cond: ((crs.plnplnscd = shi.plnplnscd) AND (crs.plnsmsino = shi.plnsmsino) AND ((cda_1.dprtplc_areakbn)::text = (shi.dprtplc_areakbn)::text))
  • Join Filter: (shi.rltv_dysu <= crs.trvl_dysu)
643. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=304,841.77..361,098.06 rows=4 width=2,564) (actual rows= loops=)

  • Hash Cond: ((crs.plnplnscd = swi.plnplnscd) AND (crs.plnsmsino = swi.plnsmsino) AND ((cda_1.dprtplc_areakbn)::text = (swi.dprtplc_areakbn)::text))
644. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=303,311.17..359,565.16 rows=4 width=2,542) (actual rows= loops=)

  • Hash Cond: ((crs.plnplnscd = ahi.plnplnscd) AND (crs.plnsmsino = ahi.plnsmsino) AND ((cda.dprtplc_areakbn)::text = (ahi.dprtplc_areakbn)::text))
645. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=300,076.49..355,777.18 rows=4 width=2,203) (actual rows= loops=)

  • Hash Cond: ((crs.plnplnscd = aoi.plnplnscd) AND (crs.plnsmsino = aoi.plnsmsino) AND ((cda.dprtplc_areakbn)::text = (aoi.dprtplc_areakbn)::text))
646. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=296,833.81..351,983.20 rows=4 width=1,867) (actual rows= loops=)

  • Hash Cond: ((crs.plnplnscd = cda_1.plnplnscd) AND (crs.plnsmsino = cda_1.plnsmsino))
647. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=291,117.25..346,266.60 rows=4 width=1,859) (actual rows= loops=)

  • Hash Cond: ((crs.plnplnscd = cda.plnplnscd) AND (crs.plnsmsino = cda.plnsmsino) AND (csm.sh_sstcd = cda.sstcd))
648. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=285,239.50..340,358.66 rows=4 width=1,856) (actual rows= loops=)

  • Hash Cond: ((crs.plncd = sbigm.plncd) AND (csm.sh_sstcd = sbigm.sstcd) AND (view3.roomtypcd = sbigm.gstroom_roomtypcd))
649. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=285,227.25..340,346.35 rows=4 width=1,855) (actual rows= loops=)

  • Hash Cond: ((cst.crssttngtrmno = to_number((asdi_cnt.sttngtrmno)::text, '99'::text)) AND (crs.aprchchrglstcd = asdi_cnt.aprchchrglstcd) AND ((ps.stndrd_dprtplc_areakbn)::text = (asdi_cnt.dprt_areakbn)::text))
650. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=285,000.02..340,119.06 rows=4 width=1,859) (actual rows= loops=)

  • Hash Cond: ((pln.plncd = ps.plncd) AND (crs.aprchchrglstcd = ps.aprchchrglstcd))
651. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=284,996.83..340,115.82 rows=4 width=1,858) (actual rows= loops=)

  • Hash Cond: ((ssgm.sstcd = ssbm_max.sstcd) AND (ssgm.aply_bgn_ymd = ssbm_max.aply_bgn_ymd) AND (ssgm.roomtypcd = view3.roomtypcd))
652. 0.000 0.000 ↓ 0.0

Seq Scan on sh_sst_gstroom_mst ssgm (cost=0.00..41,108.50 rows=622,688 width=28) (actual rows= loops=)

  • Filter: ((langkbn)::text = 'ja'::text)
653. 0.000 0.000 ↓ 0.0

Hash (cost=284,996.76..284,996.76 rows=4 width=1,867) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
654. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=140,656.19..284,996.76 rows=4 width=1,867) (actual rows= loops=)

  • Hash Cond: ((crs.plnplnscd = view3.plnplnscd) AND (crs.plnsmsino = view3.plnsmsino) AND (csm.sh_sstcd = view3.sstcd) AND (crs.stndrd_stfkbn = view3.stfkbn))
655. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=140,656.15..284,996.65 rows=4 width=1,774) (actual rows= loops=)

  • Hash Cond: (crs.plncd = pln.plncd)
656. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=140,653.85..284,994.29 rows=4 width=1,767) (actual rows= loops=)

  • Hash Cond: ((crs.plnplnscd = ci.plnplnscd) AND (crs.plnsmsino = ci.plnsmsino))
657. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=140,436.26..284,775.05 rows=4 width=1,759) (actual rows= loops=)

  • Hash Cond: (kc.szicd = cszi.szicd)
  • Join Filter: ((min((ck.kteikbn)::text)) = '08'::text)
658. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=140,431.69..284,770.46 rows=4 width=1,700) (actual rows= loops=)

  • Hash Cond: (kc.szicd = fs.szicd)
  • Join Filter: ((min((ck.kteikbn)::text)) = '06'::text)
659. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=140,427.82..284,766.56 rows=4 width=1,638) (actual rows= loops=)

  • Hash Cond: (kc.szicd = ts.szicd)
  • Join Filter: ((min((ck.kteikbn)::text)) = '05'::text)
660. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=140,415.72..284,754.42 rows=4 width=1,545) (actual rows= loops=)

  • Hash Cond: (kc.szicd = sss.szicd)
  • Join Filter: ((min((ck.kteikbn)::text)) = '04'::text)
661. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=140,388.48..284,727.12 rows=4 width=1,424) (actual rows= loops=)

  • Hash Cond: (kc.szicd = ss_en.szicd)
  • Join Filter: ((min((ck.kteikbn)::text)) = '03'::text)
662. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=139,965.13..284,303.74 rows=4 width=1,406) (actual rows= loops=)

  • Hash Cond: (ss.szicd = sd_info.szicd)
  • Join Filter: (((SubPlan 48))::text <> '01'::text)
663. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=137,653.00..281,911.72 rows=4 width=1,410) (actual rows= loops=)

  • Hash Cond: (ss.szicd = si.szicd)
664. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=135,937.99..280,196.66 rows=4 width=1,402) (actual rows= loops=)

  • Hash Cond: (kc.szicd = ss.szicd)
  • Join Filter: ((min((ck.kteikbn)::text)) = '03'::text)
665. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=134,777.74..279,036.35 rows=4 width=1,131) (actual rows= loops=)

  • Hash Cond: ((cs.crssttngtrmno = csm.crssttngtrmno) AND (cs.plnplnscd = csm.plnplnscd) AND (cs.plnsmsino = csm.plnsmsino) AND (cs.szicd = kc.szicd))
666. 0.000 0.000 ↓ 0.0

Seq Scan on crs_shszi cs (cost=0.00..120,405.40 rows=1,590,213 width=45) (actual rows= loops=)

  • Filter: (crssttngtrmno = '91'::numeric)
667. 0.000 0.000 ↓ 0.0

Hash (cost=134,777.66..134,777.66 rows=4 width=1,134) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
668. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=119,605.24..134,777.66 rows=4 width=1,134) (actual rows= loops=)

  • Hash Cond: ((cst.crssttngtrmno = view4.crssttngtrmno) AND (crs.plnplnscd = view4.plnplnscd) AND (crs.plnsmsino = view4.plnsmsino) AND (kc.szicd = view4.szicd) AND ((min(ck.crskteisrlno)) = view4.crskteisrlno))
669. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=112,366.57..127,509.03 rows=4 width=1,134) (actual rows= loops=)

  • Hash Cond: (csm.sh_sstcd = ssbm_max.sstcd)
670. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=108,603.92..123,746.35 rows=4 width=1,079) (actual rows= loops=)

  • Hash Cond: ((CASE WHEN (ccss.id IS NOT NULL) THEN '08'::character varying WHEN (csm.slsamt_sttng_flg = '1'::bpchar) THEN '04'::character varying WHEN (csm.slsamt_appl_flg = '1'::bpchar) THEN '05'::character varying WHEN (csm.slsamt_appr_flg = '1'::bpchar) THEN '07'::character varying WHEN (csm.slsamt_sshmdshi_flg = '1'::bpchar) THEN '06'::character varying ELSE cst.plnstts END)::text = (hmm.hnyovluecd)::text)
671. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=108,599.46..123,741.77 rows=4 width=1,056) (actual rows= loops=)

  • Hash Cond: ((cst.crssttngtrmno = ccss.crssttngtrmno) AND (cst.plnplnscd = ccss.plnplnscd) AND (cst.plnsmsino = ccss.plnsmsino) AND (csm.sh_sstcd = ccss.sh_sstcd))
672. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=108,525.47..123,666.62 rows=4 width=1,063) (actual rows= loops=)

  • Hash Cond: ((ck.crssttngtrmno = cst.crssttngtrmno) AND (ck.plnplnscd = crs.plnplnscd) AND (ck.plnsmsino = crs.plnsmsino))
  • Join Filter: (((min((ck.kteikbn)::text)) = ANY ('{04,05,06,07,08}'::text[])) OR (((min((ck.kteikbn)::text)) = '03'::text) AND (kc.sstcd = csm.sh_sstcd)))
673. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=107,010.74..116,095.40 rows=186,352 width=47) (actual rows= loops=)

  • Group Key: ck.plnplnscd, ck.plnsmsino, ck.crssttngtrmno, kc.szicd, kc.sstcd
  • Filter: ((min((ck.kteikbn)::text) = ANY ('{04,05,06,07,08}'::text[])) OR (min((ck.kteikbn)::text) = '03'::text))
674. 0.000 0.000 ↓ 0.0

Sort (cost=107,010.74..107,476.62 rows=186,352 width=47) (actual rows= loops=)

  • Sort Key: ck.plnplnscd, ck.plnsmsino, ck.crssttngtrmno, kc.szicd, kc.sstcd
675. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,036.63..87,421.79 rows=186,352 width=47) (actual rows= loops=)

  • Hash Cond: ((ck.plnplnscd = kc.plnplnscd) AND (ck.plnsmsino = kc.plnsmsino) AND (ck.crskteisrlno = kc.crskteisrlno))
676. 0.000 0.000 ↓ 0.0

Seq Scan on crs_ktei ck (cost=0.00..741.91 rows=12,606 width=31) (actual rows= loops=)

  • Filter: (crssttngtrmno = '91'::numeric)
677. 0.000 0.000 ↓ 0.0

Hash (cost=4,996.30..4,996.30 rows=115,619 width=41) (actual rows= loops=)

  • Buckets: 65536 Batches: 4 Memory Usage: 2562kB
678. 0.000 0.000 ↓ 0.0

Seq Scan on ktei_cmps kc (cost=0.00..4,996.30 rows=115,619 width=41) (actual rows= loops=)

  • Filter: (crssttngtrmno = '91'::numeric)
679. 0.000 0.000 ↓ 0.0

Hash (cost=1,514.66..1,514.66 rows=4 width=965) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
680. 0.000 0.000 ↓ 0.0

Hash Join (cost=689.15..1,514.66 rows=4 width=965) (actual rows= loops=)

  • Hash Cond: ((csm.plnplnscd = crs.plnplnscd) AND (csm.plnsmsino = crs.plnsmsino))
681. 0.000 0.000 ↓ 0.0

Seq Scan on crs_shnchk_mng csm (cost=0.00..778.24 rows=3,779 width=52) (actual rows= loops=)

  • Filter: ((crssttngtrmno = '91'::numeric) AND (ktei_sttng_flg = '1'::bpchar))
682. 0.000 0.000 ↓ 0.0

Hash (cost=689.11..689.11 rows=3 width=913) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
683. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.28..689.11 rows=3 width=913) (actual rows= loops=)

  • Hash Cond: ((cst.plnplnscd = crs.plnplnscd) AND (cst.plnsmsino = crs.plnsmsino))
684. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sttng_trm cst (cost=0.00..635.27 rows=5,052 width=23) (actual rows= loops=)

  • Filter: (crssttngtrmno = '91'::numeric)
685. 0.000 0.000 ↓ 0.0

Hash (cost=3.25..3.25 rows=2 width=890) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
686. 0.000 0.000 ↓ 0.0

Index Scan using crs_01_index on crs (cost=0.28..3.25 rows=2 width=890) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
687. 0.000 0.000 ↓ 0.0

Hash (cost=46.96..46.96 rows=1,351 width=36) (actual rows= loops=)

  • Buckets: 2048 Batches: 1 Memory Usage: 106kB
688. 0.000 0.000 ↓ 0.0

Seq Scan on coopdn_crs_sh_sst ccss (cost=0.00..46.96 rows=1,351 width=36) (actual rows= loops=)

  • Filter: (crssttngtrmno = '91'::numeric)
689. 0.000 0.000 ↓ 0.0

Hash (cost=4.41..4.41 rows=4 width=26) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
690. 0.000 0.000 ↓ 0.0

Index Scan using hnyo_mst_pkey_1 on hnyo_mst hmm (cost=0.28..4.41 rows=4 width=26) (actual rows= loops=)

  • Index Cond: ((hnyokeycd)::text = '026'::text)
691. 0.000 0.000 ↓ 0.0

Hash (cost=3,762.64..3,762.64 rows=1 width=63) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
692. 0.000 0.000 ↓ 0.0

Subquery Scan on ssbm_max (cost=3,762.58..3,762.64 rows=1 width=63) (actual rows= loops=)

  • Filter: (ssbm_max.rn = 1)
693. 0.000 0.000 ↓ 0.0

WindowAgg (cost=3,762.58..3,762.62 rows=2 width=63) (actual rows= loops=)

694. 0.000 0.000 ↓ 0.0

Sort (cost=3,762.58..3,762.58 rows=2 width=63) (actual rows= loops=)

  • Sort Key: ssbm.sstcd, ssbm.aply_bgn_ymd DESC
695. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,548.89..3,762.57 rows=2 width=63) (actual rows= loops=)

  • Hash Cond: (ssbm.sstcd = csm_1.sh_sstcd)
  • Join Filter: ((cst_1.sttng_trm_bgn_ymd <= ssbm.aply_end_ymd) AND (ssbm.aply_bgn_ymd <= cst_1.sttng_trm_end_ymd))
696. 0.000 0.000 ↓ 0.0

Seq Scan on sh_sst_bsc_mst ssbm (cost=0.00..2,162.20 rows=13,663 width=72) (actual rows= loops=)

  • Filter: ((langkbn)::text = 'ja'::text)
697. 0.000 0.000 ↓ 0.0

Hash (cost=1,548.79..1,548.79 rows=8 width=26) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
698. 0.000 0.000 ↓ 0.0

Hash Join (cost=689.15..1,548.79 rows=8 width=26) (actual rows= loops=)

  • Hash Cond: ((csm_1.plnplnscd = crs_1.plnplnscd) AND (csm_1.plnsmsino = crs_1.plnsmsino))
699. 0.000 0.000 ↓ 0.0

Seq Scan on crs_shnchk_mng csm_1 (cost=0.00..757.86 rows=8,136 width=28) (actual rows= loops=)

  • Filter: (crssttngtrmno = '91'::numeric)
700. 0.000 0.000 ↓ 0.0

Hash (cost=689.11..689.11 rows=3 width=53) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
701. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.28..689.11 rows=3 width=53) (actual rows= loops=)

  • Hash Cond: ((cst_1.plnplnscd = crs_1.plnplnscd) AND (cst_1.plnsmsino = crs_1.plnsmsino))
702. 0.000 0.000 ↓ 0.0

Seq Scan on crs_sttng_trm cst_1 (cost=0.00..635.27 rows=5,052 width=38) (actual rows= loops=)

  • Filter: (crssttngtrmno = '91'::numeric)
703. 0.000 0.000 ↓ 0.0

Hash (cost=3.25..3.25 rows=2 width=15) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
704. 0.000 0.000 ↓ 0.0

Index Scan using crs_01_index on crs crs_1 (cost=0.28..3.25 rows=2 width=15) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
705. 0.000 0.000 ↓ 0.0

Hash (cost=6,969.69..6,969.69 rows=11,955 width=92) (actual rows= loops=)

  • Buckets: 65536 (originally 16384) Batches: 4 (originally 1) Memory Usage: 3585kB
706. 0.000 0.000 ↓ 0.0

Subquery Scan on view4 (cost=6,730.59..6,969.69 rows=11,955 width=92) (actual rows= loops=)

707. 0.000 0.000 ↓ 0.0

HashAggregate (cost=6,730.59..6,850.14 rows=11,955 width=34) (actual rows= loops=)

  • Group Key: ktei_cmps.plnplnscd, ktei_cmps.plnsmsino, ktei_cmps.crssttngtrmno, ktei_cmps.szicd
708. 0.000 0.000 ↓ 0.0

Seq Scan on ktei_cmps (cost=0.00..4,996.30 rows=115,619 width=34) (actual rows= loops=)

  • Filter: (crssttngtrmno = '91'::numeric)
709. 0.000 0.000 ↓ 0.0

Hash (cost=1,093.62..1,093.62 rows=5,330 width=271) (actual rows= loops=)

  • Buckets: 8192 Batches: 1 Memory Usage: 1664kB
710. 0.000 0.000 ↓ 0.0

Seq Scan on shszi ss (cost=0.00..1,093.62 rows=5,330 width=271) (actual rows= loops=)

  • Filter: ((langkbn)::text = 'ja'::text)
711. 0.000 0.000 ↓ 0.0

Hash (cost=1,690.37..1,690.37 rows=1,971 width=16) (actual rows= loops=)

  • Buckets: 8192 (originally 2048) Batches: 1 (originally 1) Memory Usage: 308kB
712. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=1,148.71..1,690.37 rows=1,971 width=16) (actual rows= loops=)

  • Hash Cond: ((si.szicd = ssi_2.szicd) AND (si.aply_bgn_ymd = ssi_2.aply_bgn_ymd) AND (si.dsplyordr = ssi_2.dsplyordr))
  • Join Filter: (ssi_2.imgcd < si.imgcd)
713. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=749.18..1,213.74 rows=2,956 width=30) (actual rows= loops=)

  • Hash Cond: ((si.szicd = ssi_1.szicd) AND (si.aply_bgn_ymd = ssi_1.aply_bgn_ymd))
  • Join Filter: (ssi_1.dsplyordr < si.dsplyordr)
714. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=366.27..741.42 rows=4,434 width=30) (actual rows= loops=)

  • Hash Cond: (si.szicd = ssi.szicd)
  • Join Filter: (ssi.aply_bgn_ymd < si.aply_bgn_ymd)
715. 0.000 0.000 ↓ 0.0

Seq Scan on shszi_szi_img si (cost=0.00..283.14 rows=6,651 width=30) (actual rows= loops=)

  • Filter: ((langkbn)::text = 'ja'::text)
716. 0.000 0.000 ↓ 0.0

Hash (cost=283.14..283.14 rows=6,651 width=17) (actual rows= loops=)

  • Buckets: 8192 Batches: 1 Memory Usage: 392kB
717. 0.000 0.000 ↓ 0.0

Seq Scan on shszi_szi_img ssi (cost=0.00..283.14 rows=6,651 width=17) (actual rows= loops=)

  • Filter: ((langkbn)::text = 'ja'::text)
718. 0.000 0.000 ↓ 0.0

Hash (cost=283.14..283.14 rows=6,651 width=22) (actual rows= loops=)

  • Buckets: 8192 Batches: 1 Memory Usage: 425kB
719. 0.000 0.000 ↓ 0.0

Seq Scan on shszi_szi_img ssi_1 (cost=0.00..283.14 rows=6,651 width=22) (actual rows= loops=)

  • Filter: ((langkbn)::text = 'ja'::text)
720. 0.000 0.000 ↓ 0.0

Hash (cost=283.14..283.14 rows=6,651 width=30) (actual rows= loops=)

  • Buckets: 8192 Batches: 1 Memory Usage: 479kB
721. 0.000 0.000 ↓ 0.0

Seq Scan on shszi_szi_img ssi_2 (cost=0.00..283.14 rows=6,651 width=30) (actual rows= loops=)

  • Filter: ((langkbn)::text = 'ja'::text)
722. 0.000 0.000 ↓ 0.0

Hash (cost=2,278.61..2,278.61 rows=2,682 width=8) (actual rows= loops=)

  • Buckets: 4096 Batches: 1 Memory Usage: 137kB
723. 0.000 0.000 ↓ 0.0

Subquery Scan on sd_info (cost=2,224.97..2,278.61 rows=2,682 width=8) (actual rows= loops=)

724. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,224.97..2,251.79 rows=2,682 width=11) (actual rows= loops=)

  • Group Key: sd.szicd, sd.sttngtrmno
725. 0.000 0.000 ↓ 0.0

Seq Scan on srssty_dscntamt sd (cost=0.00..1,909.26 rows=63,141 width=11) (actual rows= loops=)

  • Filter: (sttngtrmno = '91'::bpchar)
726.          

SubPlan (forHash Left Join)

727. 0.000 0.000 ↓ 0.0

Index Scan using hnyo_mst_pkey_1 on hnyo_mst hm_34 (cost=0.28..39.25 rows=1 width=2) (actual rows= loops=)

  • Index Cond: ((hnyokeycd)::text = '080'::text)
  • Filter: ((hnyovluecd)::bpchar = ss.gdskbn)
728. 0.000 0.000 ↓ 0.0

Hash (cost=423.34..423.34 rows=1 width=26) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
729. 0.000 0.000 ↓ 0.0

Index Scan using shszi_pkey_1 on shszi ss_en (cost=0.41..423.34 rows=1 width=26) (actual rows= loops=)

  • Index Cond: ((langkbn)::text = 'en'::text)
730. 0.000 0.000 ↓ 0.0

Hash (cost=24.33..24.33 rows=233 width=129) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 46kB
731. 0.000 0.000 ↓ 0.0

Seq Scan on snshaszi sss (cost=0.00..24.33 rows=233 width=129) (actual rows= loops=)

732. 0.000 0.000 ↓ 0.0

Hash (cost=10.93..10.93 rows=93 width=101) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
733. 0.000 0.000 ↓ 0.0

Seq Scan on trsmszi ts (cost=0.00..10.93 rows=93 width=101) (actual rows= loops=)

734. 0.000 0.000 ↓ 0.0

Hash (cost=3.39..3.39 rows=39 width=70) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
735. 0.000 0.000 ↓ 0.0

Seq Scan on frcpn_szi fs (cost=0.00..3.39 rows=39 width=70) (actual rows= loops=)

736. 0.000 0.000 ↓ 0.0

Hash (cost=4.25..4.25 rows=25 width=67) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
737. 0.000 0.000 ↓ 0.0

Seq Scan on cstclcfr_szi cszi (cost=0.00..4.25 rows=25 width=67) (actual rows= loops=)

738. 0.000 0.000 ↓ 0.0

Hash (cost=176.99..176.99 rows=2,707 width=23) (actual rows= loops=)

  • Buckets: 4096 Batches: 1 Memory Usage: 177kB
739. 0.000 0.000 ↓ 0.0

Seq Scan on crs_img ci (cost=0.00..176.99 rows=2,707 width=23) (actual rows= loops=)

  • Filter: (dsplyordr = '1'::numeric)
740. 0.000 0.000 ↓ 0.0

Hash (cost=2.29..2.29 rows=1 width=7) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
741. 0.000 0.000 ↓ 0.0

Index Only Scan using pln_unq_idx on pln (cost=0.28..2.29 rows=1 width=7) (actual rows= loops=)

  • Index Cond: (plncd = '100426'::bpchar)
742. 0.000 0.000 ↓ 0.0

Hash (cost=0.02..0.02 rows=1 width=192) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
743. 0.000 0.000 ↓ 0.0

CTE Scan on view3 (cost=0.00..0.02 rows=1 width=192) (actual rows= loops=)

744. 0.000