https://pastein.ru/t/N7S
Загрузка данных
Sort (cost=341505638448.11..342877713062.56 rows=548829845780 width=201)
Sort Key: t.effective_date, o.id, t.id
CTE target_accounts
-> Index Scan using idx_account_owner_sharer_id on account a_2 (cost=0.56..5.73 rows=4 width=4)
Index Cond: (owner_sharer_id = 14275376)
-> Hash Join (cost=5789326.69..22477743.06 rows=548829845780 width=201)
Hash Cond: (t.id = t_212.id)
-> Gather (cost=4314987.70..20609716.44 rows=5263186 width=201)
Workers Planned: 2
-> Hash Left Join (cost=4313987.70..20082397.84 rows=2192994 width=201)
Hash Cond: (cat.account_type_group_id = catg.id)
-> Hash Left Join (cost=4313985.98..20075877.11 rows=2192994 width=195)
Hash Cond: (ca.account_type_id = cat.id)
-> Hash Left Join (cost=4313960.89..20070045.92 rows=2192994 width=172)
Hash Cond: (dat.account_type_group_id = datg.id)
-> Hash Left Join (cost=4313959.17..20063525.18 rows=2192994 width=166)
Hash Cond: (da.account_type_id = dat.id)
-> Hash Join (cost=4313934.07..20057694.00 rows=2192994 width=143)
Hash Cond: (o.operation_type_id = ot.id)
-> Parallel Hash Left Join (cost=4313916.48..20051800.20 rows=2192994 width=62)
Hash Cond: (t.credit_account_id = ca.id)
-> Parallel Hash Left Join (cost=3476152.15..19065514.26 rows=2192994 width=58)
Hash Cond: (t.debit_account_id = da.id)
-> Parallel Hash Join (cost=2638387.81..18083512.31 rows=2192994 width=54)
Hash Cond: (t.operation_id = o.id)
Join Filter: ((t.effective_date = ANY ('{2020-03-30,2023-05-31}'::date[])) OR (o.effective_date = ANY ('{2020-03-30,2023-05-31}'::date[])))
-> Parallel Append (cost=0.00..11664950.04 rows=217243985 width=30)
-> Seq Scan on transaction_2026_12 t_203 (cost=0.00..0.00 rows=1 width=46)
-> Seq Scan on transaction_2027_01 t_204 (cost=0.00..0.00 rows=1 width=46)
-> Seq Scan on transaction_2027_02 t_205 (cost=0.00..0.00 rows=1 width=46)
-> Seq Scan on transaction_2027_03 t_206 (cost=0.00..0.00 rows=1 width=46)
-> Seq Scan on transaction_2027_04 t_207 (cost=0.00..0.00 rows=1 width=46)
-> Seq Scan on transaction_2027_05 t_208 (cost=0.00..0.00 rows=1 width=46)
-> Seq Scan on transaction_2027_06 t_209 (cost=0.00..0.00 rows=1 width=46)
-> Seq Scan on transaction_2027_07 t_210 (cost=0.00..0.00 rows=1 width=46)
-> Seq Scan on transaction_2027_08 t_211 (cost=0.00..0.00 rows=1 width=46)
-> Parallel Seq Scan on transaction_2025_12 t_191 (cost=0.00..417795.87 rows=11458987 width=30)
-> Parallel Seq Scan on transaction_2015_04 t_63 (cost=0.00..414980.71 rows=9878571 width=30)
-> Parallel Seq Scan on transaction_2010 t_11 (cost=0.00..400633.70 rows=6125170 width=30)
-> Parallel Seq Scan on transaction_2009 t_10 (cost=0.00..358756.09 rows=5712609 width=30)
-> Parallel Seq Scan on transaction_2016_12 t_83 (cost=0.00..341547.48 rows=9057048 width=30)
-> Parallel Seq Scan on transaction_2013_12 t_47 (cost=0.00..283580.22 rows=6871022 width=30)
-> Parallel Seq Scan on transaction_2020_12 t_131 (cost=0.00..277974.50 rows=7150150 width=30)
-> Parallel Seq Scan on transaction_2008 t_9 (cost=0.00..270527.72 rows=3953572 width=30)
-> Parallel Seq Scan on transaction_2013_03 t_38 (cost=0.00..256232.95 rows=5997795 width=29)
-> Parallel Seq Scan on transaction_2019_12 t_119 (cost=0.00..255423.95 rows=6925695 width=30)
-> Parallel Seq Scan on transaction_2017_12 t_95 (cost=0.00..249392.50 rows=6899550 width=30)
-> Parallel Seq Scan on transaction_2007 t_8 (cost=0.00..235997.30 rows=3813230 width=29)
-> Parallel Seq Scan on transaction_2012_12 t_35 (cost=0.00..213295.38 rows=4965138 width=30)
-> Parallel Seq Scan on transaction_2021_12 t_143 (cost=0.00..197087.13 rows=5307413 width=30)
-> Parallel Seq Scan on transaction_2018_12 t_107 (cost=0.00..186424.98 rows=5054698 width=31)
-> Parallel Seq Scan on transaction_2022_12 t_155 (cost=0.00..180124.86 rows=4861286 width=30)
-> Parallel Seq Scan on transaction_2013_09 t_44 (cost=0.00..179944.40 rows=4086640 width=29)
-> Parallel Seq Scan on transaction_2013_06 t_41 (cost=0.00..176623.69 rows=4110769 width=29)
-> Parallel Seq Scan on transaction_2015_12 t_71 (cost=0.00..175519.01 rows=4282801 width=30)
-> Parallel Seq Scan on transaction_2024_12 t_179 (cost=0.00..167516.15 rows=4580115 width=30)
-> Parallel Seq Scan on transaction_2023_12 t_167 (cost=0.00..161933.89 rows=4416489 width=30)
-> Parallel Seq Scan on transaction_2014_12 t_59 (cost=0.00..150806.99 rows=3542299 width=30)
-> Parallel Seq Scan on transaction_2016_03 t_74 (cost=0.00..150635.58 rows=3427758 width=31)
-> Parallel Seq Scan on transaction_2006 t_7 (cost=0.00..149299.82 rows=2259282 width=30)
-> Parallel Seq Scan on transaction_2011_12 t_23 (cost=0.00..134099.55 rows=3059955 width=30)
-> Parallel Seq Scan on transaction_2012_09 t_32 (cost=0.00..116134.02 rows=2533602 width=29)
-> Parallel Seq Scan on transaction_2012_03 t_26 (cost=0.00..109953.00 rows=2389000 width=29)
-> Parallel Seq Scan on transaction_2016_05 t_76 (cost=0.00..107716.77 rows=2215178 width=29)
-> Parallel Seq Scan on transaction_2015_05 t_64 (cost=0.00..98491.35 rows=2055435 width=31)
-> Parallel Seq Scan on transaction_2017_03 t_86 (cost=0.00..95135.15 rows=1956715 width=31)
-> Parallel Seq Scan on transaction_2012_06 t_29 (cost=0.00..90727.51 rows=1879951 width=29)
-> Parallel Seq Scan on transaction_2011_03 t_14 (cost=0.00..89470.10 rows=1894710 width=30)
-> Parallel Seq Scan on transaction_2005 t_6 (cost=0.00..83438.99 rows=1103399 width=29)
-> Parallel Seq Scan on transaction_2011_09 t_20 (cost=0.00..75592.82 rows=1515582 width=29)
-> Parallel Seq Scan on transaction_2011_05 t_16 (cost=0.00..72805.90 rows=1478690 width=29)
-> Parallel Seq Scan on transaction_2011_11 t_22 (cost=0.00..72476.66 rows=1455166 width=29)
-> Parallel Seq Scan on transaction_2018_03 t_98 (cost=0.00..63779.14 rows=1458214 width=31)
-> Parallel Seq Scan on transaction_2012_10 t_33 (cost=0.00..62996.45 rows=782545 width=30)
-> Parallel Seq Scan on transaction_2012_08 t_31 (cost=0.00..59024.29 rows=768429 width=30)
-> Parallel Seq Scan on transaction_2014_06 t_53 (cost=0.00..55714.45 rows=1077445 width=30)
-> Parallel Seq Scan on transaction_2016_06 t_77 (cost=0.00..50779.62 rows=840962 width=30)
-> Parallel Seq Scan on transaction_2016_09 t_80 (cost=0.00..42943.12 rows=627212 width=30)
-> Parallel Seq Scan on transaction_2014_03 t_50 (cost=0.00..41554.25 rows=645025 width=30)
-> Parallel Seq Scan on transaction_2022_03 t_146 (cost=0.00..39595.20 rows=828920 width=30)
-> Parallel Seq Scan on transaction_2015_06 t_65 (cost=0.00..38961.03 rows=558003 width=30)
-> Parallel Seq Scan on transaction_2015_11 t_70 (cost=0.00..38766.36 rows=586236 width=30)
-> Parallel Seq Scan on transaction_2019_03 t_110 (cost=0.00..38485.29 rows=849529 width=31)
-> Parallel Seq Scan on transaction_2013_04 t_39 (cost=0.00..38168.93 rows=544093 width=30)
-> Parallel Seq Scan on transaction_2014_09 t_56 (cost=0.00..37412.07 rows=476308 width=30)
-> Parallel Seq Scan on transaction_2015_07 t_66 (cost=0.00..36993.18 rows=480718 width=30)
-> Parallel Seq Scan on transaction_2019_01 t_108 (cost=0.00..35572.80 rows=653380 width=30)
-> Parallel Seq Scan on transaction_2015_09 t_68 (cost=0.00..35426.28 rows=442328 width=30)
-> Parallel Seq Scan on transaction_2013_10 t_45 (cost=0.00..35116.59 rows=456859 width=29)
-> Parallel Seq Scan on transaction_2017_05 t_88 (cost=0.00..34983.32 rows=544832 width=30)
-> Parallel Seq Scan on transaction_2013_07 t_42 (cost=0.00..34805.85 rows=435685 width=30)
-> Parallel Seq Scan on transaction_2013_05 t_40 (cost=0.00..34502.77 rows=464077 width=29)
-> Parallel Seq Scan on transaction_2014_04 t_51 (cost=0.00..34475.83 rows=435683 width=30)
-> Parallel Seq Scan on transaction_2015_01 t_60 (cost=0.00..34235.58 rows=480658 width=30)
-> Parallel Seq Scan on transaction_2016_04 t_75 (cost=0.00..34198.28 rows=448628 width=30)
-> Parallel Seq Scan on transaction_2015_10 t_69 (cost=0.00..33545.01 rows=421301 width=30)
-> Parallel Seq Scan on transaction_2012_11 t_34 (cost=0.00..33442.52 rows=427252 width=30)
-> Parallel Seq Scan on transaction_2013_11 t_46 (cost=0.00..32980.05 rows=418305 width=30)
-> Parallel Seq Scan on transaction_2014_07 t_54 (cost=0.00..32970.86 rows=399286 width=30)
-> Parallel Seq Scan on transaction_2012_05 t_28 (cost=0.00..32343.20 rows=417320 width=30)
-> Parallel Seq Scan on transaction_2013_02 t_37 (cost=0.00..32142.28 rows=413328 width=30)
-> Parallel Seq Scan on transaction_2016_07 t_78 (cost=0.00..31964.23 rows=386123 width=30)
-> Parallel Seq Scan on transaction_2011_06 t_17 (cost=0.00..31926.28 rows=426728 width=30)
-> Parallel Seq Scan on transaction_2016_10 t_81 (cost=0.00..31821.18 rows=378818 width=30)
-> Parallel Seq Scan on transaction_2012_04 t_27 (cost=0.00..31363.38 rows=401638 width=30)
-> Parallel Seq Scan on transaction_2013_08 t_43 (cost=0.00..30995.62 rows=369362 width=30)
-> Parallel Seq Scan on transaction_2016_01 t_72 (cost=0.00..30719.87 rows=375187 width=30)
-> Parallel Seq Scan on transaction_2012_07 t_30 (cost=0.00..30368.07 rows=369407 width=29)
-> Parallel Seq Scan on transaction_2015_08 t_67 (cost=0.00..30334.27 rows=338927 width=30)
-> Parallel Seq Scan on transaction_2016_08 t_79 (cost=0.00..30221.33 rows=326132 width=30)
-> Parallel Seq Scan on transaction_2014_10 t_57 (cost=0.00..30137.52 rows=336652 width=30)
-> Parallel Seq Scan on transaction_2014_11 t_58 (cost=0.00..30087.97 rows=333998 width=30)
-> Parallel Seq Scan on transaction_2014_08 t_55 (cost=0.00..30067.94 rows=336494 width=30)
-> Parallel Seq Scan on transaction_2013_01 t_36 (cost=0.00..29986.18 rows=380318 width=30)
-> Parallel Seq Scan on transaction_2015_03 t_62 (cost=0.00..29983.25 rows=341425 width=30)
-> Parallel Seq Scan on transaction_2014_02 t_49 (cost=0.00..29917.11 rows=341611 width=30)
-> Parallel Seq Scan on transaction_2014_05 t_52 (cost=0.00..29916.36 rows=339336 width=30)
-> Parallel Seq Scan on transaction_2014_01 t_48 (cost=0.00..29631.06 rows=343606 width=30)
-> Parallel Seq Scan on transaction_2015_02 t_61 (cost=0.00..29615.69 rows=334769 width=30)
-> Parallel Seq Scan on transaction_2016_11 t_82 (cost=0.00..29314.50 rows=317350 width=30)
-> Parallel Seq Scan on transaction_2016_02 t_73 (cost=0.00..29274.02 rows=323102 width=30)
-> Parallel Seq Scan on transaction_2017_04 t_87 (cost=0.00..28676.87 rows=404587 width=30)
-> Parallel Seq Scan on transaction_2012_02 t_25 (cost=0.00..28625.60 rows=341260 width=30)
-> Parallel Seq Scan on transaction_2011_10 t_21 (cost=0.00..28297.50 rows=341450 width=30)
-> Parallel Seq Scan on transaction_2011_07 t_18 (cost=0.00..28086.79 rows=343079 width=29)
-> Parallel Seq Scan on transaction_2012_01 t_24 (cost=0.00..27512.98 rows=335098 width=30)
-> Parallel Seq Scan on transaction_2026_03 t_194 (cost=0.00..27485.79 rows=576879 width=31)
-> Parallel Seq Scan on transaction_2011_08 t_19 (cost=0.00..27166.57 rows=319157 width=30)
-> Parallel Seq Scan on transaction_2017_06 t_89 (cost=0.00..27128.25 rows=358925 width=30)
-> Parallel Seq Scan on transaction_2018_07 t_102 (cost=0.00..26882.49 rows=648149 width=30)
-> Parallel Seq Scan on transaction_2011_04 t_15 (cost=0.00..26654.68 rows=317068 width=30)
-> Parallel Seq Scan on transaction_2011_02 t_13 (cost=0.00..26139.58 rows=315958 width=30)
-> Parallel Seq Scan on transaction_2020_03 t_122 (cost=0.00..26059.49 rows=541149 width=30)
-> Parallel Seq Scan on transaction_2011_01 t_12 (cost=0.00..25884.58 rows=329058 width=30)
-> Parallel Seq Scan on transaction_2017_07 t_90 (cost=0.00..25258.33 rows=318432 width=30)
-> Parallel Seq Scan on transaction_2018_09 t_104 (cost=0.00..24629.69 rows=577269 width=29)
-> Parallel Seq Scan on transaction_2017_01 t_84 (cost=0.00..24450.91 rows=338591 width=30)
-> Parallel Seq Scan on transaction_2017_08 t_91 (cost=0.00..23913.47 rows=272648 width=30)
-> Parallel Seq Scan on transaction_2017_02 t_85 (cost=0.00..22433.16 rows=260916 width=30)
-> Parallel Seq Scan on transaction_2021_03 t_134 (cost=0.00..20357.81 rows=440281 width=30)
-> Parallel Seq Scan on transaction_2024_11 t_178 (cost=0.00..19833.95 rows=410295 width=30)
-> Parallel Seq Scan on transaction_2025_09 t_188 (cost=0.00..18780.22 rows=385422 width=30)
-> Parallel Seq Scan on transaction_2025_04 t_183 (cost=0.00..18308.78 rows=391578 width=30)
-> Parallel Seq Scan on transaction_2025_03 t_182 (cost=0.00..18306.65 rows=378165 width=30)
-> Parallel Seq Scan on transaction_2020_09 t_128 (cost=0.00..18272.14 rows=367014 width=30)
-> Parallel Seq Scan on transaction_2026_07 t_198 (cost=0.00..17982.04 rows=366804 width=30)
-> Parallel Seq Scan on transaction_2021_09 t_140 (cost=0.00..17671.48 rows=347348 width=30)
-> Parallel Seq Scan on transaction_2019_02 t_109 (cost=0.00..17353.47 rows=308847 width=30)
-> Parallel Seq Scan on transaction_2026_04 t_195 (cost=0.00..17242.11 rows=368811 width=30)
-> Parallel Seq Scan on transaction_2024_09 t_176 (cost=0.00..17168.68 rows=361068 width=30)
-> Parallel Seq Scan on transaction_2022_09 t_152 (cost=0.00..17073.33 rows=339233 width=30)
-> Parallel Seq Scan on transaction_2017_11 t_94 (cost=0.00..16982.00 rows=381700 width=30)
-> Parallel Seq Scan on transaction_2025_01 t_180 (cost=0.00..16868.91 rows=350691 width=29)
-> Parallel Seq Scan on transaction_2023_03 t_158 (cost=0.00..16686.10 rows=350410 width=30)
-> Parallel Seq Scan on transaction_2021_04 t_135 (cost=0.00..16370.38 rows=346038 width=30)
-> Parallel Seq Scan on transaction_2019_10 t_117 (cost=0.00..16091.28 rows=346628 width=29)
-> Parallel Seq Scan on transaction_2020_06 t_125 (cost=0.00..15994.52 rows=311252 width=30)
-> Parallel Seq Scan on transaction_2022_06 t_149 (cost=0.00..15829.64 rows=304964 width=30)
-> Parallel Seq Scan on transaction_2025_02 t_181 (cost=0.00..15820.94 rows=320394 width=30)
-> Parallel Seq Scan on transaction_2023_09 t_164 (cost=0.00..15499.63 rows=329063 width=30)
-> Parallel Seq Scan on transaction_2018_04 t_99 (cost=0.00..15457.84 rows=322984 width=29)
-> Parallel Seq Scan on transaction_2021_06 t_137 (cost=0.00..15456.22 rows=301122 width=30)
-> Parallel Seq Scan on transaction_2025_10 t_189 (cost=0.00..15454.73 rows=319273 width=30)
-> Parallel Seq Scan on transaction_2024_03 t_170 (cost=0.00..15444.38 rows=336638 width=30)
-> Parallel Seq Scan on transaction_2025_08 t_187 (cost=0.00..15437.12 rows=295112 width=30)
-> Parallel Seq Scan on transaction_2019_09 t_116 (cost=0.00..15341.24 rows=308824 width=30)
-> Parallel Seq Scan on transaction_2024_10 t_177 (cost=0.00..15340.95 rows=326295 width=30)
-> Parallel Seq Scan on transaction_2019_04 t_111 (cost=0.00..15311.75 rows=342475 width=29)
-> Parallel Seq Scan on transaction_2025_07 t_186 (cost=0.00..15291.91 rows=335291 width=30)
-> Parallel Seq Scan on transaction_2017_09 t_92 (cost=0.00..15268.44 rows=314144 width=30)
-> Parallel Seq Scan on transaction_2018_08 t_103 (cost=0.00..15215.07 rows=309507 width=30)
-> Parallel Seq Scan on transaction_2019_06 t_113 (cost=0.00..15183.06 rows=309406 width=30)
-> Parallel Seq Scan on transaction_2018_10 t_105 (cost=0.00..14877.79 rows=309579 width=29)
-> Parallel Seq Scan on transaction_2020_07 t_126 (cost=0.00..14840.40 rows=316140 width=30)
-> Parallel Seq Scan on transaction_2026_06 t_197 (cost=0.00..14802.19 rows=296019 width=30)
-> Parallel Seq Scan on transaction_2026_05 t_196 (cost=0.00..14760.34 rows=293934 width=30)
-> Parallel Seq Scan on transaction_2017_10 t_93 (cost=0.00..14731.46 rows=308146 width=29)
-> Parallel Seq Scan on transaction_2023_04 t_159 (cost=0.00..14689.54 rows=319354 width=30)
-> Parallel Seq Scan on transaction_2022_04 t_147 (cost=0.00..14549.02 rows=317102 width=30)
-> Parallel Seq Scan on transaction_2022_07 t_150 (cost=0.00..14485.38 rows=322738 width=30)
-> Parallel Seq Scan on transaction_2020_10 t_129 (cost=0.00..14456.39 rows=295939 width=29)
-> Parallel Seq Scan on transaction_2024_04 t_171 (cost=0.00..14441.98 rows=305798 width=30)
-> Parallel Seq Scan on transaction_2024_07 t_174 (cost=0.00..14395.24 rows=307424 width=30)
-> Parallel Seq Scan on transaction_2020_01 t_120 (cost=0.00..14377.79 rows=300579 width=29)
-> Parallel Seq Scan on transaction_2025_11 t_190 (cost=0.00..14362.82 rows=286482 width=30)
-> Parallel Seq Scan on transaction_2022_08 t_151 (cost=0.00..14333.76 rows=283076 width=30)
-> Parallel Seq Scan on transaction_2026_02 t_193 (cost=0.00..14329.10 rows=288410 width=30)
-> Parallel Seq Scan on transaction_2023_07 t_162 (cost=0.00..14253.87 rows=304887 width=30)
-> Parallel Seq Scan on transaction_2019_07 t_114 (cost=0.00..14242.92 rows=313692 width=29)
-> Parallel Seq Scan on transaction_2021_10 t_141 (cost=0.00..14231.80 rows=285780 width=30)
-> Parallel Seq Scan on transaction_2018_01 t_96 (cost=0.00..14216.82 rows=295282 width=29)
-> Parallel Seq Scan on transaction_2021_07 t_138 (cost=0.00..14178.69 rows=299669 width=30)
-> Parallel Seq Scan on transaction_2018_06 t_101 (cost=0.00..14117.33 rows=287433 width=30)
-> Parallel Seq Scan on transaction_2021_02 t_133 (cost=0.00..13924.75 rows=272875 width=29)
-> Parallel Seq Scan on transaction_2025_06 t_185 (cost=0.00..13844.50 rows=284050 width=30)
-> Parallel Seq Scan on transaction_2018_05 t_100 (cost=0.00..13815.35 rows=275935 width=29)
-> Parallel Seq Scan on transaction_2020_08 t_127 (cost=0.00..13728.15 rows=268915 width=30)
-> Parallel Seq Scan on transaction_2020_04 t_123 (cost=0.00..13647.20 rows=276720 width=29)
-> Parallel Seq Scan on transaction_2019_05 t_112 (cost=0.00..13568.27 rows=274428 width=29)
-> Parallel Seq Scan on transaction_2023_10 t_165 (cost=0.00..13564.49 rows=286049 width=30)
-> Parallel Seq Scan on transaction_2022_10 t_153 (cost=0.00..13421.15 rows=271215 width=30)
-> Parallel Seq Scan on transaction_2004 t_5 (cost=0.00..13362.03 rows=252303 width=30)
-> Parallel Seq Scan on transaction_2024_08 t_175 (cost=0.00..13330.70 rows=280370 width=30)
-> Parallel Seq Scan on transaction_2021_01 t_132 (cost=0.00..13320.65 rows=263465 width=29)
-> Parallel Seq Scan on transaction_2019_08 t_115 (cost=0.00..13204.44 rows=259544 width=29)
-> Parallel Seq Scan on transaction_2023_05 t_160 (cost=0.00..13203.32 rows=270732 width=30)
-> Parallel Seq Scan on transaction_2023_02 t_157 (cost=0.00..13202.21 rows=263821 width=30)
-> Parallel Seq Scan on transaction_2024_06 t_173 (cost=0.00..12910.13 rows=269713 width=30)
-> Parallel Seq Scan on transaction_2022_05 t_148 (cost=0.00..12832.37 rows=252537 width=30)
-> Parallel Seq Scan on transaction_2020_02 t_121 (cost=0.00..12732.07 rows=247507 width=29)
-> Parallel Seq Scan on transaction_2024_02 t_169 (cost=0.00..12721.95 rows=271195 width=30)
-> Parallel Seq Scan on transaction_2024_05 t_172 (cost=0.00..12628.56 rows=264856 width=30)
-> Parallel Seq Scan on transaction_2023_08 t_163 (cost=0.00..12616.17 rows=268217 width=30)
-> Parallel Seq Scan on transaction_2020_05 t_124 (cost=0.00..12597.47 rows=247747 width=29)
-> Parallel Seq Scan on transaction_2022_11 t_154 (cost=0.00..12570.06 rows=251306 width=30)
-> Parallel Seq Scan on transaction_2020_11 t_130 (cost=0.00..12535.83 rows=244882 width=29)
-> Parallel Seq Scan on transaction_2018_11 t_106 (cost=0.00..12514.81 rows=250681 width=29)
-> Parallel Seq Scan on transaction_2021_08 t_139 (cost=0.00..12438.75 rows=243075 width=30)
-> Parallel Seq Scan on transaction_2023_11 t_166 (cost=0.00..12429.67 rows=264668 width=30)
-> Parallel Seq Scan on transaction_2021_05 t_136 (cost=0.00..12367.08 rows=241408 width=29)
-> Parallel Seq Scan on transaction_2019_11 t_118 (cost=0.00..12361.33 rows=245532 width=29)
-> Parallel Seq Scan on transaction_2022_02 t_145 (cost=0.00..12258.30 rows=237530 width=30)
-> Parallel Seq Scan on transaction_2023_06 t_161 (cost=0.00..12219.94 rows=259694 width=30)
-> Parallel Seq Scan on transaction_2022_01 t_144 (cost=0.00..12058.83 rows=238283 width=29)
-> Parallel Seq Scan on transaction_2021_11 t_142 (cost=0.00..11661.80 rows=226380 width=29)
-> Parallel Seq Scan on transaction_2018_02 t_97 (cost=0.00..11623.90 rows=231290 width=29)
-> Parallel Seq Scan on transaction_2023_01 t_156 (cost=0.00..11025.20 rows=217220 width=29)
-> Parallel Seq Scan on transaction_2025_05 t_184 (cost=0.00..11006.69 rows=223969 width=29)
-> Parallel Seq Scan on transaction_2024_01 t_168 (cost=0.00..10892.68 rows=230868 width=29)
-> Parallel Seq Scan on transaction_2000 t_1 (cost=0.00..8031.42 rows=169142 width=30)
-> Parallel Seq Scan on transaction_2026_08 t_199 (cost=0.00..6958.32 rows=156132 width=31)
-> Parallel Seq Scan on transaction_2003 t_4 (cost=0.00..4156.25 rows=111125 width=30)
-> Parallel Seq Scan on transaction_2026_01 t_192 (cost=0.00..3772.71 rows=99971 width=30)
-> Parallel Seq Scan on transaction_2002 t_3 (cost=0.00..2653.75 rows=72375 width=30)
-> Parallel Seq Scan on transaction_2026_09 t_200 (cost=0.00..2469.34 rows=91134 width=30)
-> Parallel Seq Scan on transaction_2001 t_2 (cost=0.00..2263.61 rows=61561 width=30)
-> Parallel Seq Scan on transaction_2026_10 t_201 (cost=0.00..967.61 rows=24761 width=31)
-> Parallel Seq Scan on transaction_2026_11 t_202 (cost=0.00..1.05 rows=5 width=46)
-> Parallel Hash (cost=1960167.36..1960167.36 rows=35075636 width=28)
-> Parallel Seq Scan on operation o (cost=0.00..1960167.36 rows=35075636 width=28)
-> Parallel Hash (cost=497255.15..497255.15 rows=19588815 width=12)
-> Parallel Seq Scan on account da (cost=0.00..497255.15 rows=19588815 width=12)
-> Parallel Hash (cost=497255.15..497255.15 rows=19588815 width=12)
-> Parallel Seq Scan on account ca (cost=0.00..497255.15 rows=19588815 width=12)
-> Hash (cost=15.04..15.04 rows=204 width=89)
-> Seq Scan on operation_type ot (cost=0.00..15.04 rows=204 width=89)
-> Hash (cost=18.93..18.93 rows=493 width=31)
-> Seq Scan on account_type dat (cost=0.00..18.93 rows=493 width=31)
-> Hash (cost=1.32..1.32 rows=32 width=14)
-> Seq Scan on account_type_group datg (cost=0.00..1.32 rows=32 width=14)
-> Hash (cost=18.93..18.93 rows=493 width=31)
-> Seq Scan on account_type cat (cost=0.00..18.93 rows=493 width=31)
-> Hash (cost=1.32..1.32 rows=32 width=14)
-> Seq Scan on account_type_group catg (cost=0.00..1.32 rows=32 width=14)
-> Hash (cost=1132179.22..1132179.22 rows=20855422 width=8)
-> HashAggregate (cost=760692.01..1132179.22 rows=20855422 width=8)
Group Key: t_212.id
Planned Partitions: 32
-> Append (cost=0.42..112218.73 rows=20855422 width=8)
-> Nested Loop (cost=0.42..4681.06 rows=10427711 width=8)
-> CTE Scan on target_accounts a (cost=0.00..0.08 rows=4 width=4)
-> Append (cost=0.42..1161.32 rows=892 width=12)
-> Index Scan using transaction_2000_debit_account_id_effective_date_value_idx on transaction_2000 t_213 (cost=0.42..5.62 rows=4 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2001_debit_account_id_effective_date_idx on transaction_2001 t_214 (cost=0.29..8.08 rows=6 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2002_debit_account_id_effective_date_idx on transaction_2002 t_215 (cost=0.29..7.79 rows=6 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2003_debit_account_id_effective_date_value_idx on transaction_2003 t_216 (cost=0.42..8.69 rows=7 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2004_debit_account_id_effective_date_value_idx on transaction_2004 t_217 (cost=0.42..7.50 rows=6 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2005_debit_account_id_effective_date_value_idx on transaction_2005 t_218 (cost=0.43..24.78 rows=21 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2006_debit_account_id_effective_date_operation__idx on transaction_2006 t_219 (cost=0.43..30.41 rows=26 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2007_debit_account_id_effective_date_idx on transaction_2007 t_220 (cost=0.43..33.80 rows=29 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2008_debit_account_id_effective_date_idx on transaction_2008 t_221 (cost=0.43..33.79 rows=29 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2009_debit_account_id_effective_date_idx on transaction_2009 t_222 (cost=0.43..34.81 rows=30 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2010_debit_account_id_effective_date_idx on transaction_2010 t_223 (cost=0.43..34.65 rows=30 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2011_01_debit_account_id_effective_date_value_idx on transaction_2011_01 t_224 (cost=0.42..4.80 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2011_02_debit_account_id_effective_date_value_idx on transaction_2011_02 t_225 (cost=0.42..4.73 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2011_03_debit_account_id_effective_date_value_idx on transaction_2011_03 t_226 (cost=0.43..4.32 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2011_04_debit_account_id_effective_date_value_idx on transaction_2011_04 t_227 (cost=0.42..4.80 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2011_05_debit_account_id_effective_date_value_idx on transaction_2011_05 t_228 (cost=0.43..4.82 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2011_06_debit_account_id_effective_date_value_idx on transaction_2011_06 t_229 (cost=0.42..4.81 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2011_07_debit_account_id_effective_date_value_idx on transaction_2011_07 t_230 (cost=0.42..4.82 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2011_08_debit_account_id_effective_date_value_idx on transaction_2011_08 t_231 (cost=0.42..4.81 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2011_09_debit_account_id_effective_date_value_idx on transaction_2011_09 t_232 (cost=0.43..4.84 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2011_10_debit_account_id_effective_date_value_idx on transaction_2011_10 t_233 (cost=0.42..4.83 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2011_11_debit_account_id_effective_date_value_idx on transaction_2011_11 t_234 (cost=0.43..4.84 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2011_12_debit_account_id_effective_date_idx on transaction_2011_12 t_235 (cost=0.43..5.90 rows=4 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2012_01_debit_account_id_effective_date_value_idx on transaction_2012_01 t_236 (cost=0.42..4.84 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2012_02_debit_account_id_effective_date_value_idx on transaction_2012_02 t_237 (cost=0.42..4.75 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2012_03_debit_account_id_effective_date_idx on transaction_2012_03 t_238 (cost=0.43..3.39 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2012_04_debit_account_id_effective_date_value_idx on transaction_2012_04 t_239 (cost=0.42..4.77 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2012_05_debit_account_id_effective_date_value_idx on transaction_2012_05 t_240 (cost=0.42..4.83 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2012_06_debit_account_id_effective_date_value_idx on transaction_2012_06 t_241 (cost=0.43..4.84 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2012_07_debit_account_id_effective_date_value_idx on transaction_2012_07 t_242 (cost=0.42..4.84 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2012_08_debit_account_id_effective_date_value_idx on transaction_2012_08 t_243 (cost=0.43..3.49 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2012_09_debit_account_id_effective_date_idx on transaction_2012_09 t_244 (cost=0.43..4.82 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2012_10_debit_account_id_effective_date_value_idx on transaction_2012_10 t_245 (cost=0.43..3.47 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2012_11_debit_account_id_effective_date_value_idx on transaction_2012_11 t_246 (cost=0.42..4.73 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2012_12_debit_account_id_effective_date_idx on transaction_2012_12 t_247 (cost=0.43..3.46 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2013_01_debit_account_id_effective_date_value_idx on transaction_2013_01 t_248 (cost=0.42..4.76 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2013_02_debit_account_id_effective_date_value_idx on transaction_2013_02 t_249 (cost=0.42..4.59 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2013_03_debit_account_id_effective_date_idx on transaction_2013_03 t_250 (cost=0.43..3.40 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2013_04_debit_account_id_effective_date_value_idx on transaction_2013_04 t_251 (cost=0.43..3.56 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2013_05_debit_account_id_effective_date_value_idx on transaction_2013_05 t_252 (cost=0.43..4.80 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2013_06_debit_account_id_effective_date_idx on transaction_2013_06 t_253 (cost=0.43..5.90 rows=4 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2013_07_debit_account_id_effective_date_value_idx on transaction_2013_07 t_254 (cost=0.42..4.78 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2013_08_debit_account_id_effective_date_value_idx on transaction_2013_08 t_255 (cost=0.42..4.77 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2013_09_debit_account_id_effective_date_idx on transaction_2013_09 t_256 (cost=0.43..4.47 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2013_10_debit_account_id_effective_date_value_idx on transaction_2013_10 t_257 (cost=0.43..4.75 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2013_11_debit_account_id_effective_date_value_idx on transaction_2013_11 t_258 (cost=0.42..4.82 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2013_12_debit_account_id_effective_date_idx on transaction_2013_12 t_259 (cost=0.43..6.66 rows=5 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2014_01_debit_account_id_effective_date_value_idx on transaction_2014_01 t_260 (cost=0.42..4.82 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2014_02_debit_account_id_effective_date_value_idx on transaction_2014_02 t_261 (cost=0.42..4.78 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2014_03_debit_account_id_effective_date_value_idx on transaction_2014_03 t_262 (cost=0.43..3.43 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2014_04_debit_account_id_effective_date_value_idx on transaction_2014_04 t_263 (cost=0.42..4.75 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2014_05_debit_account_id_effective_date_value_idx on transaction_2014_05 t_264 (cost=0.42..4.82 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2014_06_debit_account_id_effective_date_value_idx on transaction_2014_06 t_265 (cost=0.43..4.81 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2014_07_debit_account_id_effective_date_value_idx on transaction_2014_07 t_266 (cost=0.42..4.79 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2014_08_debit_account_id_effective_date_value_idx on transaction_2014_08 t_267 (cost=0.42..4.79 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2014_09_debit_account_id_effective_date_value_idx on transaction_2014_09 t_268 (cost=0.43..3.47 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2014_10_debit_account_id_effective_date_value_idx on transaction_2014_10 t_269 (cost=0.42..4.78 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2014_11_debit_account_id_effective_date_value_idx on transaction_2014_11 t_270 (cost=0.42..4.78 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2014_12_debit_account_id_effective_date_idx on transaction_2014_12 t_271 (cost=0.43..5.80 rows=4 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2015_01_debit_account_id_effective_date_value_idx on transaction_2015_01 t_272 (cost=0.43..4.80 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2015_02_debit_account_id_effective_date_value_idx on transaction_2015_02 t_273 (cost=0.42..4.73 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2015_03_debit_account_id_effective_date_value_idx on transaction_2015_03 t_274 (cost=0.42..3.67 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2015_04_debit_account_id_effective_date_idx on transaction_2015_04 t_275 (cost=0.44..6.17 rows=5 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2015_05_debit_account_id_effective_date_value_idx on transaction_2015_05 t_276 (cost=0.43..3.56 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2015_06_debit_account_id_effective_date_value_idx on transaction_2015_06 t_277 (cost=0.43..4.80 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2015_07_debit_account_id_effective_date_value_idx on transaction_2015_07 t_278 (cost=0.43..3.59 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2015_08_debit_account_id_effective_date_value_idx on transaction_2015_08 t_279 (cost=0.42..3.66 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2015_09_debit_account_id_effective_date_value_idx on transaction_2015_09 t_280 (cost=0.43..3.58 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2015_10_debit_account_id_effective_date_value_idx on transaction_2015_10 t_281 (cost=0.42..4.79 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2015_11_debit_account_id_effective_date_value_idx on transaction_2015_11 t_282 (cost=0.43..4.76 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2015_12_debit_account_id_effective_date_idx on transaction_2015_12 t_283 (cost=0.43..4.21 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2016_01_debit_account_id_effective_date_value_idx on transaction_2016_01 t_284 (cost=0.42..4.82 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2016_02_debit_account_id_effective_date_value_idx on transaction_2016_02 t_285 (cost=0.42..4.73 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2016_03_debit_account_id_effective_date_idx on transaction_2016_03 t_286 (cost=0.43..3.61 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2016_04_debit_account_id_effective_date_value_idx on transaction_2016_04 t_287 (cost=0.43..3.47 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2016_05_debit_account_id_effective_date_value_idx on transaction_2016_05 t_288 (cost=0.43..4.65 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2016_06_debit_account_id_effective_date_value_idx on transaction_2016_06 t_289 (cost=0.43..3.37 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2016_07_debit_account_id_effective_date_value_idx on transaction_2016_07 t_290 (cost=0.42..4.69 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2016_08_debit_account_id_effective_date_value_idx on transaction_2016_08 t_291 (cost=0.42..3.63 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2016_09_debit_account_id_effective_date_value_idx on transaction_2016_09 t_292 (cost=0.43..3.47 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2016_10_debit_account_id_effective_date_value_idx on transaction_2016_10 t_293 (cost=0.42..4.72 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2016_11_debit_account_id_effective_date_value_idx on transaction_2016_11 t_294 (cost=0.42..4.69 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2016_12_debit_account_id_effective_date_idx on transaction_2016_12 t_295 (cost=0.44..4.15 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2017_01_debit_account_id_effective_date_value_idx on transaction_2017_01 t_296 (cost=0.42..3.64 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2017_02_debit_account_id_effective_date_value_idx on transaction_2017_02 t_297 (cost=0.42..3.60 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2017_03_debit_account_id_effective_date_value_idx on transaction_2017_03 t_298 (cost=0.43..3.49 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2017_04_debit_account_id_effective_date_value_idx on transaction_2017_04 t_299 (cost=0.42..3.42 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2017_05_debit_account_id_effective_date_value_idx on transaction_2017_05 t_300 (cost=0.43..3.43 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2017_06_debit_account_id_effective_date_value_idx on transaction_2017_06 t_301 (cost=0.42..3.58 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2017_07_debit_account_id_effective_date_value_idx on transaction_2017_07 t_302 (cost=0.42..3.62 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2017_08_debit_account_id_effective_date_value_idx on transaction_2017_08 t_303 (cost=0.42..3.56 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2017_09_debit_account_id_effective_date_value_idx on transaction_2017_09 t_304 (cost=0.42..3.39 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2017_10_debit_account_id_effective_date_value_idx on transaction_2017_10 t_305 (cost=0.42..3.61 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2017_11_debit_account_id_effective_date_value_idx on transaction_2017_11 t_306 (cost=0.42..3.41 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2017_12_debit_account_id_effective_date_idx on transaction_2017_12 t_307 (cost=0.43..18.34 rows=23 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2018_01_debit_account_id_effective_date_value_idx on transaction_2018_01 t_308 (cost=0.42..3.70 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2018_02_debit_account_id_effective_date_value_idx on transaction_2018_02 t_309 (cost=0.42..3.54 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2018_03_debit_account_id_effective_date_value_idx on transaction_2018_03 t_310 (cost=0.43..3.65 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2018_04_debit_account_id_effective_date_value_idx on transaction_2018_04 t_311 (cost=0.42..3.48 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2018_05_debit_account_id_effective_date_value_idx on transaction_2018_05 t_312 (cost=0.42..3.53 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2018_06_debit_account_id_effective_date_value_idx on transaction_2018_06 t_313 (cost=0.42..3.50 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2018_07_debit_account_id_effective_date_value_idx on transaction_2018_07 t_314 (cost=0.43..3.49 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2018_08_debit_account_id_effective_date_value_idx on transaction_2018_08 t_315 (cost=0.42..3.49 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2018_09_debit_account_id_effective_date_value_idx on transaction_2018_09 t_316 (cost=0.43..3.39 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2018_10_debit_account_id_effective_date_value_idx on transaction_2018_10 t_317 (cost=0.42..3.56 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2018_11_debit_account_id_effective_date_value_idx on transaction_2018_11 t_318 (cost=0.42..3.61 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2018_12_debit_account_id_effective_date_idx on transaction_2018_12 t_319 (cost=0.43..4.49 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2019_01_debit_account_id_effective_date_value_idx on transaction_2019_01 t_320 (cost=0.43..3.47 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2019_02_debit_account_id_effective_date_value_idx on transaction_2019_02 t_321 (cost=0.42..3.59 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2019_03_debit_account_id_effective_date_value_idx on transaction_2019_03 t_322 (cost=0.43..3.49 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2019_04_debit_account_id_effective_date_value_idx on transaction_2019_04 t_323 (cost=0.42..3.54 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2019_05_debit_account_id_effective_date_value_idx on transaction_2019_05 t_324 (cost=0.42..3.57 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2019_06_debit_account_id_effective_date_value_idx on transaction_2019_06 t_325 (cost=0.42..3.62 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2019_07_debit_account_id_effective_date_value_idx on transaction_2019_07 t_326 (cost=0.42..3.60 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2019_08_debit_account_id_effective_date_value_idx on transaction_2019_08 t_327 (cost=0.42..3.57 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2019_09_debit_account_id_effective_date_value_idx on transaction_2019_09 t_328 (cost=0.42..3.53 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2019_10_debit_account_id_effective_date_value_idx on transaction_2019_10 t_329 (cost=0.42..3.59 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2019_11_debit_account_id_effective_date_value_idx on transaction_2019_11 t_330 (cost=0.42..3.51 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2019_12_debit_account_id_effective_date_idx on transaction_2019_12 t_331 (cost=0.43..60.79 rows=100 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2020_01_debit_account_id_effective_date_value_idx on transaction_2020_01 t_332 (cost=0.42..3.64 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2020_02_debit_account_id_effective_date_value_idx on transaction_2020_02 t_333 (cost=0.42..3.56 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2020_03_debit_account_id_effective_date_value_idx on transaction_2020_03 t_334 (cost=0.43..3.38 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2020_04_debit_account_id_effective_date_value_idx on transaction_2020_04 t_335 (cost=0.42..3.49 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2020_05_debit_account_id_effective_date_value_idx on transaction_2020_05 t_336 (cost=0.42..3.57 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2020_06_debit_account_id_effective_date_value_idx on transaction_2020_06 t_337 (cost=0.42..3.49 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2020_07_debit_account_id_effective_date_value_idx on transaction_2020_07 t_338 (cost=0.42..3.50 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2020_08_debit_account_id_effective_date_value_idx on transaction_2020_08 t_339 (cost=0.42..3.50 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2020_09_debit_account_id_effective_date_value_idx on transaction_2020_09 t_340 (cost=0.42..3.37 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2020_10_debit_account_id_effective_date_value_idx on transaction_2020_10 t_341 (cost=0.42..3.57 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2020_11_debit_account_id_effective_date_value_idx on transaction_2020_11 t_342 (cost=0.42..3.52 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2020_12_debit_account_id_effective_date_idx on transaction_2020_12 t_343 (cost=0.44..66.30 rows=58 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2021_01_debit_account_id_effective_date_value_idx on transaction_2021_01 t_344 (cost=0.42..3.65 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2021_02_debit_account_id_effective_date_value_idx on transaction_2021_02 t_345 (cost=0.42..3.47 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2021_03_debit_account_id_effective_date_value_idx on transaction_2021_03 t_346 (cost=0.43..3.38 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2021_04_debit_account_id_effective_date_value_idx on transaction_2021_04 t_347 (cost=0.42..3.47 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2021_05_debit_account_id_effective_date_value_idx on transaction_2021_05 t_348 (cost=0.42..3.57 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2021_06_debit_account_id_effective_date_value_idx on transaction_2021_06 t_349 (cost=0.42..3.55 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2021_07_debit_account_id_effective_date_value_idx on transaction_2021_07 t_350 (cost=0.42..3.53 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2021_08_debit_account_id_effective_date_value_idx on transaction_2021_08 t_351 (cost=0.42..3.53 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2021_09_debit_account_id_effective_date_value_idx on transaction_2021_09 t_352 (cost=0.42..3.38 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2021_10_debit_account_id_effective_date_value_idx on transaction_2021_10 t_353 (cost=0.42..3.49 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2021_11_debit_account_id_effective_date_value_idx on transaction_2021_11 t_354 (cost=0.42..3.59 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2021_12_debit_account_id_effective_date_idx on transaction_2021_12 t_355 (cost=0.43..49.69 rows=65 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2022_01_debit_account_id_effective_date_value_idx on transaction_2022_01 t_356 (cost=0.42..3.67 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2022_02_debit_account_id_effective_date_value_idx on transaction_2022_02 t_357 (cost=0.42..3.52 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2022_03_debit_account_id_effective_date_value_idx on transaction_2022_03 t_358 (cost=0.43..3.39 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2022_04_debit_account_id_effective_date_value_idx on transaction_2022_04 t_359 (cost=0.42..3.46 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2022_05_debit_account_id_effective_date_value_idx on transaction_2022_05 t_360 (cost=0.42..3.56 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2022_06_debit_account_id_effective_date_value_idx on transaction_2022_06 t_361 (cost=0.42..3.52 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2022_07_debit_account_id_effective_date_value_idx on transaction_2022_07 t_362 (cost=0.42..3.51 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2022_08_debit_account_id_effective_date_value_idx on transaction_2022_08 t_363 (cost=0.42..3.46 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2022_09_debit_account_id_effective_date_value_idx on transaction_2022_09 t_364 (cost=0.42..3.40 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2022_10_debit_account_id_effective_date_value_idx on transaction_2022_10 t_365 (cost=0.42..3.51 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2022_11_debit_account_id_effective_date_value_idx on transaction_2022_11 t_366 (cost=0.42..3.50 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2022_12_debit_account_id_effective_date_idx on transaction_2022_12 t_367 (cost=0.43..4.15 rows=3 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2023_01_debit_account_id_effective_date_value_idx on transaction_2023_01 t_368 (cost=0.42..3.67 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2023_02_debit_account_id_effective_date_value_idx on transaction_2023_02 t_369 (cost=0.42..3.55 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2023_03_debit_account_id_effective_date_value_idx on transaction_2023_03 t_370 (cost=0.42..3.45 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2023_04_debit_account_id_effective_date_value_idx on transaction_2023_04 t_371 (cost=0.42..3.51 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2023_05_debit_account_id_effective_date_value_idx on transaction_2023_05 t_372 (cost=0.42..3.57 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2023_06_debit_account_id_effective_date_value_idx on transaction_2023_06 t_373 (cost=0.42..3.55 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2023_07_debit_account_id_effective_date_value_idx on transaction_2023_07 t_374 (cost=0.42..3.48 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2023_08_debit_account_id_effective_date_value_idx on transaction_2023_08 t_375 (cost=0.42..3.52 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2023_09_debit_account_id_effective_date_value_idx on transaction_2023_09 t_376 (cost=0.42..3.34 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2023_10_debit_account_id_effective_date_value_idx on transaction_2023_10 t_377 (cost=0.42..3.47 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2023_11_debit_account_id_effective_date_value_idx on transaction_2023_11 t_378 (cost=0.42..3.47 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2023_12_debit_account_id_effective_date_idx on transaction_2023_12 t_379 (cost=0.43..4.85 rows=4 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2024_01_debit_account_id_effective_date_value_idx on transaction_2024_01 t_380 (cost=0.42..3.66 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
-> Index Scan using transaction_2024_02_debit_account_id_effective_date_value_idx on transaction_2024_02 t_381 (cost=0.42..3.43 rows=2 width=12)
Index Cond: (debit_account_id = a.id)
