https://pastein.ru/t/3fa
Загрузка данных
Nested Loop (cost=4095109.16..4308542.77 rows=16818 width=327)
CTE latest_death_info
-> Result (cost=0.42..57790.33 rows=634009 width=16)
-> Unique (cost=0.42..57790.33 rows=634009 width=16)
-> Index Scan using adi_last_by_individual_idx on application_death_info a_2 (cost=0.42..55594.82 rows=878205 width=16)
CTE ops_sharer
-> Nested Loop Anti Join (cost=5.40..1756629.79 rows=121510 width=8)
Join Filter: (o.effective_date <= p.report_date)
InitPlan 2
-> Result (cost=0.00..0.01 rows=1 width=1)
InitPlan 4
-> Result (cost=1.02..1.03 rows=1 width=1)
InitPlan 3
-> Seq Scan on user_group ug (cost=0.00..1.02 rows=1 width=0)
Filter: (user_id = (NULLIF(current_setting('app.user_id'::text, true), ''::text))::bigint)
-> Nested Loop (cost=2.93..923462.50 rows=131961 width=12)
-> Nested Loop (cost=0.43..211876.92 rows=277417 width=16)
-> Nested Loop (cost=0.00..20606.30 rows=211336 width=12)
Join Filter: (death_info.death_date <= p.report_date)
-> Seq Scan on dia_param p (cost=0.00..1.01 rows=1 width=4)
-> CTE Scan on latest_death_info death_info (cost=0.00..12680.18 rows=634009 width=8)
-> Index Scan using sharer_individual_id_idx on sharer s_2 (cost=0.43..0.90 rows=1 width=12)
Index Cond: (individual_id = death_info.individual_id)
-> Index Scan using contract_pkey on contract c (cost=2.50..2.57 rows=1 width=4)
Index Cond: (id = s_2.contract_id)
Filter: (((service_type)::text = 'OPS'::text) AND CASE WHEN (InitPlan 2).col1 THEN true WHEN (InitPlan 4).col1 THEN (ANY (id = (hashed SubPlan 5).col1)) ELSE (NOT (ANY (id = (hashed SubPlan 6).col1))) END)
SubPlan 5
-> Nested Loop (cost=0.00..1.03 rows=1 width=8)
Join Filter: (ug_1.group_id = a_3.group_id)
-> Seq Scan on user_group ug_1 (cost=0.00..1.02 rows=1 width=8)
Filter: (user_id = (NULLIF(current_setting('app.user_id'::text, true), ''::text))::bigint)
-> Seq Scan on rbac_contract_access a_3 (cost=0.00..0.00 rows=1 width=16)
SubPlan 6
-> Nested Loop (cost=0.00..1.02 rows=1 width=8)
Join Filter: (a_4.group_id = g.id)
-> Seq Scan on rbac_contract_access a_4 (cost=0.00..0.00 rows=1 width=16)
-> Seq Scan on individual_groups g (cost=0.00..1.01 rows=1 width=4)
Filter: hidden_from_external
-> Nested Loop (cost=1.43..3.09 rows=291 width=8)
-> Nested Loop (cost=1.00..2.20 rows=2 width=16)
-> Index Scan using ops_transfer_details_sharer_id on ops_transfer_details d (cost=0.43..0.48 rows=2 width=8)
Index Cond: (sharer_id = s_2.id)
-> Index Scan using idx_operation_transfer_register_id on operation o (cost=0.57..0.85 rows=1 width=8)
Index Cond: (ops_transfer_register_id = d.ops_transfer_register_id)
Filter: (approved IS NOT NULL)
-> Index Only Scan using ops_transfer_register_pk on ops_transfer_register tr (cost=0.42..0.45 rows=1 width=4)
Index Cond: (id = d.ops_transfer_register_id)
CTE reserve_accounts
-> Aggregate (cost=295960.56..295960.57 rows=1 width=32)
-> Nested Loop (cost=0.71..295469.80 rows=196302 width=4)
-> Index Only Scan using account_type_mnemonics_idx1 on account_type at_1 (cost=0.27..4.94 rows=2 width=4)
Index Cond: (mnemonics = ANY ('{"Р ОПС","Р ОПС ИД"}'::text[]))
-> Index Scan using idx_account_account_type_id on account a_5 (cost=0.44..143971.28 rows=376115 width=8)
Index Cond: (account_type_id = at_1.id)
CTE reserve_movements
-> Append (cost=0.42..336495.35 rows=50834590 width=23)
-> Nested Loop (cost=0.42..7687.52 rows=25417295 width=10)
-> CTE Scan on reserve_accounts r (cost=0.00..0.02 rows=1 width=32)
-> Append (cost=0.42..7635.87 rows=5163 width=14)
-> Index Scan using transaction_2000_credit_account_id_effective_date_value_idx on transaction_2000 t_1 (cost=0.42..53.00 rows=56 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2001_credit_account_id_effective_date_value_idx on transaction_2001 t_2 (cost=0.42..56.02 rows=39 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2002_credit_account_id_effective_date_value_idx on transaction_2002 t_3 (cost=0.42..65.75 rows=46 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2003_credit_account_id_effective_date_value_idx on transaction_2003 t_4 (cost=0.42..32.61 rows=26 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2004_credit_account_id_effective_date_value_idx on transaction_2004 t_5 (cost=0.42..36.13 rows=30 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2005_credit_account_id_effective_date_value_idx on transaction_2005 t_6 (cost=0.43..89.16 rows=85 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2006_credit_account_id_effective_date_value_idx on transaction_2006 t_7 (cost=0.43..83.43 rows=88 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2007_credit_account_id_effective_date_value_idx on transaction_2007 t_8 (cost=0.43..104.68 rows=110 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2008_credit_account_id_effective_date_value_idx on transaction_2008 t_9 (cost=0.43..145.62 rows=143 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2009_credit_account_id_effective_date_value_idx on transaction_2009 t_10 (cost=0.43..110.61 rows=126 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2010_credit_account_id_effective_date_value_idx on transaction_2010 t_11 (cost=0.43..131.60 rows=151 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2011_01_credit_account_id_effective_date_value_idx on transaction_2011_01 t_12 (cost=0.42..35.15 rows=20 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2011_02_credit_account_id_effective_date_value_idx on transaction_2011_02 t_13 (cost=0.42..37.80 rows=21 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2011_03_credit_account_id_effective_date_value_idx on transaction_2011_03 t_14 (cost=0.43..33.04 rows=24 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2011_04_credit_account_id_effective_date_value_idx on transaction_2011_04 t_15 (cost=0.42..37.53 rows=22 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2011_05_credit_account_id_effective_date_value_idx on transaction_2011_05 t_16 (cost=0.43..28.05 rows=14 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2011_06_credit_account_id_effective_date_value_idx on transaction_2011_06 t_17 (cost=0.42..38.89 rows=22 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2011_07_credit_account_id_effective_date_value_idx on transaction_2011_07 t_18 (cost=0.42..38.83 rows=22 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2011_08_credit_account_id_effective_date_value_idx on transaction_2011_08 t_19 (cost=0.42..39.43 rows=22 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2011_09_credit_account_id_effective_date_value_idx on transaction_2011_09 t_20 (cost=0.43..27.21 rows=14 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2011_10_credit_account_id_effective_date_value_idx on transaction_2011_10 t_21 (cost=0.42..37.86 rows=21 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2011_11_credit_account_id_effective_date_value_idx on transaction_2011_11 t_22 (cost=0.43..27.55 rows=14 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2011_12_credit_account_id_effective_date_value_idx on transaction_2011_12 t_23 (cost=0.43..27.28 rows=13 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2012_01_credit_account_id_effective_date_value_idx on transaction_2012_01 t_24 (cost=0.42..36.53 rows=21 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2012_02_credit_account_id_effective_date_value_idx on transaction_2012_02 t_25 (cost=0.42..40.10 rows=23 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2012_03_credit_account_id_effective_date_value_idx on transaction_2012_03 t_26 (cost=0.43..48.66 rows=34 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2012_04_credit_account_id_effective_date_value_idx on transaction_2012_04 t_27 (cost=0.42..36.72 rows=22 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2012_05_credit_account_id_effective_date_value_idx on transaction_2012_05 t_28 (cost=0.42..36.98 rows=20 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2012_06_credit_account_id_effective_date_value_idx on transaction_2012_06 t_29 (cost=0.43..27.07 rows=13 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2012_07_credit_account_id_effective_date_value_idx on transaction_2012_07 t_30 (cost=0.42..38.66 rows=22 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2012_08_credit_account_id_effective_date_value_idx on transaction_2012_08 t_31 (cost=0.43..29.20 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2012_09_credit_account_id_effective_date_value_idx on transaction_2012_09 t_32 (cost=0.43..26.22 rows=13 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2012_10_credit_account_id_effective_date_value_idx on transaction_2012_10 t_33 (cost=0.43..28.84 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2012_11_credit_account_id_effective_date_value_idx on transaction_2012_11 t_34 (cost=0.42..36.74 rows=21 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2012_12_credit_account_id_effective_date_value_idx on transaction_2012_12 t_35 (cost=0.43..33.34 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2013_01_credit_account_id_effective_date_value_idx on transaction_2013_01 t_36 (cost=0.42..35.10 rows=21 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2013_02_credit_account_id_effective_date_value_idx on transaction_2013_02 t_37 (cost=0.42..39.27 rows=25 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2013_03_credit_account_id_effective_date_value_idx on transaction_2013_03 t_38 (cost=0.43..67.11 rows=48 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2013_04_credit_account_id_effective_date_value_idx on transaction_2013_04 t_39 (cost=0.43..36.69 rows=25 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2013_05_credit_account_id_effective_date_value_idx on transaction_2013_05 t_40 (cost=0.43..33.14 rows=20 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2013_06_credit_account_id_effective_date_value_idx on transaction_2013_06 t_41 (cost=0.43..29.75 rows=13 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2013_07_credit_account_id_effective_date_value_idx on transaction_2013_07 t_42 (cost=0.42..36.20 rows=22 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2013_08_credit_account_id_effective_date_value_idx on transaction_2013_08 t_43 (cost=0.42..38.16 rows=22 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2013_09_credit_account_id_effective_date_value_idx on transaction_2013_09 t_44 (cost=0.43..28.13 rows=12 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2013_10_credit_account_id_effective_date_value_idx on transaction_2013_10 t_45 (cost=0.43..35.67 rows=20 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2013_11_credit_account_id_effective_date_value_idx on transaction_2013_11 t_46 (cost=0.42..34.90 rows=21 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2013_12_credit_account_id_effective_date_value_idx on transaction_2013_12 t_47 (cost=0.43..34.57 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2014_01_credit_account_id_effective_date_value_idx on transaction_2014_01 t_48 (cost=0.42..38.92 rows=22 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2014_02_credit_account_id_effective_date_value_idx on transaction_2014_02 t_49 (cost=0.42..40.30 rows=23 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2014_03_credit_account_id_effective_date_value_idx on transaction_2014_03 t_50 (cost=0.43..44.08 rows=41 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2014_04_credit_account_id_effective_date_value_idx on transaction_2014_04 t_51 (cost=0.42..34.57 rows=21 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2014_05_credit_account_id_effective_date_value_idx on transaction_2014_05 t_52 (cost=0.42..39.27 rows=22 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2014_06_credit_account_id_effective_date_value_idx on transaction_2014_06 t_53 (cost=0.43..28.67 rows=15 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2014_07_credit_account_id_effective_date_value_idx on transaction_2014_07 t_54 (cost=0.42..38.30 rows=21 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2014_08_credit_account_id_effective_date_value_idx on transaction_2014_08 t_55 (cost=0.42..40.26 rows=23 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2014_09_credit_account_id_effective_date_value_idx on transaction_2014_09 t_56 (cost=0.43..33.48 rows=20 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2014_10_credit_account_id_effective_date_value_idx on transaction_2014_10 t_57 (cost=0.42..40.32 rows=23 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2014_11_credit_account_id_effective_date_value_idx on transaction_2014_11 t_58 (cost=0.42..40.27 rows=23 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2014_12_credit_account_id_effective_date_value_idx on transaction_2014_12 t_59 (cost=0.43..34.37 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2015_01_credit_account_id_effective_date_value_idx on transaction_2015_01 t_60 (cost=0.43..30.90 rows=19 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2015_02_credit_account_id_effective_date_value_idx on transaction_2015_02 t_61 (cost=0.42..39.69 rows=23 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2015_03_credit_account_id_effective_date_value_idx on transaction_2015_03 t_62 (cost=0.42..40.69 rows=24 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2015_04_credit_account_id_effective_date_value_idx on transaction_2015_04 t_63 (cost=0.56..51.08 rows=31 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2015_05_credit_account_id_effective_date_value_idx on transaction_2015_05 t_64 (cost=0.43..79.16 rows=97 width=15)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2015_06_credit_account_id_effective_date_value_idx on transaction_2015_06 t_65 (cost=0.43..29.95 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2015_07_credit_account_id_effective_date_value_idx on transaction_2015_07 t_66 (cost=0.43..35.83 rows=23 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2015_08_credit_account_id_effective_date_value_idx on transaction_2015_08 t_67 (cost=0.42..39.70 rows=23 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2015_09_credit_account_id_effective_date_value_idx on transaction_2015_09 t_68 (cost=0.43..34.96 rows=20 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2015_10_credit_account_id_effective_date_value_idx on transaction_2015_10 t_69 (cost=0.42..33.33 rows=20 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2015_11_credit_account_id_effective_date_value_idx on transaction_2015_11 t_70 (cost=0.43..38.31 rows=30 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2015_12_credit_account_id_effective_date_value_idx on transaction_2015_12 t_71 (cost=0.43..29.85 rows=13 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2016_01_credit_account_id_effective_date_value_idx on transaction_2016_01 t_72 (cost=0.42..33.96 rows=20 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2016_02_credit_account_id_effective_date_value_idx on transaction_2016_02 t_73 (cost=0.42..40.67 rows=24 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2016_03_credit_account_id_effective_date_value_idx on transaction_2016_03 t_74 (cost=0.43..98.26 rows=144 width=15)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2016_04_credit_account_id_effective_date_value_idx on transaction_2016_04 t_75 (cost=0.43..38.09 rows=28 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2016_05_credit_account_id_effective_date_value_idx on transaction_2016_05 t_76 (cost=0.43..29.66 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2016_06_credit_account_id_effective_date_value_idx on transaction_2016_06 t_77 (cost=0.43..42.23 rows=41 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2016_07_credit_account_id_effective_date_value_idx on transaction_2016_07 t_78 (cost=0.42..34.66 rows=21 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2016_08_credit_account_id_effective_date_value_idx on transaction_2016_08 t_79 (cost=0.42..39.34 rows=23 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2016_09_credit_account_id_effective_date_value_idx on transaction_2016_09 t_80 (cost=0.43..34.39 rows=26 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2016_10_credit_account_id_effective_date_value_idx on transaction_2016_10 t_81 (cost=0.42..35.17 rows=21 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2016_11_credit_account_id_effective_date_value_idx on transaction_2016_11 t_82 (cost=0.42..38.71 rows=22 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2016_12_credit_account_id_effective_date_value_idx on transaction_2016_12 t_83 (cost=0.56..57.61 rows=37 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2017_01_credit_account_id_effective_date_value_idx on transaction_2017_01 t_84 (cost=0.42..34.49 rows=21 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2017_02_credit_account_id_effective_date_value_idx on transaction_2017_02 t_85 (cost=0.42..37.98 rows=22 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2017_03_credit_account_id_effective_date_value_idx on transaction_2017_03 t_86 (cost=0.43..57.29 rows=70 width=15)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2017_04_credit_account_id_effective_date_value_idx on transaction_2017_04 t_87 (cost=0.42..36.07 rows=28 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2017_05_credit_account_id_effective_date_value_idx on transaction_2017_05 t_88 (cost=0.43..56.47 rows=61 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2017_06_credit_account_id_effective_date_value_idx on transaction_2017_06 t_89 (cost=0.42..32.86 rows=20 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2017_07_credit_account_id_effective_date_value_idx on transaction_2017_07 t_90 (cost=0.42..34.03 rows=21 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2017_08_credit_account_id_effective_date_value_idx on transaction_2017_08 t_91 (cost=0.42..37.88 rows=23 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2017_09_credit_account_id_effective_date_value_idx on transaction_2017_09 t_92 (cost=0.42..28.16 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2017_10_credit_account_id_effective_date_value_idx on transaction_2017_10 t_93 (cost=0.42..28.57 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2017_11_credit_account_id_effective_date_value_idx on transaction_2017_11 t_94 (cost=0.42..45.12 rows=42 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2017_12_credit_account_id_effective_date_value_idx on transaction_2017_12 t_95 (cost=0.56..38.93 rows=20 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2018_01_credit_account_id_effective_date_value_idx on transaction_2018_01 t_96 (cost=0.42..28.57 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2018_02_credit_account_id_effective_date_value_idx on transaction_2018_02 t_97 (cost=0.42..31.24 rows=16 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2018_03_credit_account_id_effective_date_value_idx on transaction_2018_03 t_98 (cost=0.43..126.23 rows=166 width=15)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2018_04_credit_account_id_effective_date_value_idx on transaction_2018_04 t_99 (cost=0.42..27.19 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2018_05_credit_account_id_effective_date_value_idx on transaction_2018_05 t_100 (cost=0.42..29.21 rows=16 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2018_06_credit_account_id_effective_date_value_idx on transaction_2018_06 t_101 (cost=0.42..27.74 rows=15 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2018_07_credit_account_id_effective_date_value_idx on transaction_2018_07 t_102 (cost=0.43..32.22 rows=19 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2018_08_credit_account_id_effective_date_value_idx on transaction_2018_08 t_103 (cost=0.42..32.32 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2018_09_credit_account_id_effective_date_value_idx on transaction_2018_09 t_104 (cost=0.43..29.78 rows=18 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2018_10_credit_account_id_effective_date_value_idx on transaction_2018_10 t_105 (cost=0.42..30.07 rows=17 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2018_11_credit_account_id_effective_date_value_idx on transaction_2018_11 t_106 (cost=0.42..32.66 rows=17 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2018_12_credit_account_id_effective_date_value_idx on transaction_2018_12 t_107 (cost=0.43..29.85 rows=13 width=15)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2019_01_credit_account_id_effective_date_value_idx on transaction_2019_01 t_108 (cost=0.43..27.05 rows=13 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2019_02_credit_account_id_effective_date_value_idx on transaction_2019_02 t_109 (cost=0.42..28.63 rows=15 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2019_03_credit_account_id_effective_date_value_idx on transaction_2019_03 t_110 (cost=0.43..77.55 rows=80 width=15)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2019_04_credit_account_id_effective_date_value_idx on transaction_2019_04 t_111 (cost=0.42..27.96 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2019_05_credit_account_id_effective_date_value_idx on transaction_2019_05 t_112 (cost=0.42..28.99 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2019_06_credit_account_id_effective_date_value_idx on transaction_2019_06 t_113 (cost=0.42..29.75 rows=15 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2019_07_credit_account_id_effective_date_value_idx on transaction_2019_07 t_114 (cost=0.42..29.08 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2019_08_credit_account_id_effective_date_value_idx on transaction_2019_08 t_115 (cost=0.42..31.41 rows=16 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2019_09_credit_account_id_effective_date_value_idx on transaction_2019_09 t_116 (cost=0.42..30.79 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2019_10_credit_account_id_effective_date_value_idx on transaction_2019_10 t_117 (cost=0.42..28.95 rows=16 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2019_11_credit_account_id_effective_date_value_idx on transaction_2019_11 t_118 (cost=0.42..31.07 rows=16 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2019_12_credit_account_id_effective_date_value_idx on transaction_2019_12 t_119 (cost=0.56..36.69 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2020_01_credit_account_id_effective_date_value_idx on transaction_2020_01 t_120 (cost=0.42..29.76 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2020_02_credit_account_id_effective_date_value_idx on transaction_2020_02 t_121 (cost=0.42..31.35 rows=16 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2020_03_credit_account_id_effective_date_value_idx on transaction_2020_03 t_122 (cost=0.43..41.45 rows=37 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2020_04_credit_account_id_effective_date_value_idx on transaction_2020_04 t_123 (cost=0.42..26.46 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2020_05_credit_account_id_effective_date_value_idx on transaction_2020_05 t_124 (cost=0.42..29.62 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2020_06_credit_account_id_effective_date_value_idx on transaction_2020_06 t_125 (cost=0.42..29.65 rows=15 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2020_07_credit_account_id_effective_date_value_idx on transaction_2020_07 t_126 (cost=0.42..28.68 rows=15 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2020_08_credit_account_id_effective_date_value_idx on transaction_2020_08 t_127 (cost=0.42..30.51 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2020_09_credit_account_id_effective_date_value_idx on transaction_2020_09 t_128 (cost=0.42..28.69 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2020_10_credit_account_id_effective_date_value_idx on transaction_2020_10 t_129 (cost=0.42..30.12 rows=16 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2020_11_credit_account_id_effective_date_value_idx on transaction_2020_11 t_130 (cost=0.42..31.20 rows=16 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2020_12_credit_account_id_effective_date_value_idx on transaction_2020_12 t_131 (cost=0.56..34.49 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2021_01_credit_account_id_effective_date_value_idx on transaction_2021_01 t_132 (cost=0.42..30.09 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2021_02_credit_account_id_effective_date_value_idx on transaction_2021_02 t_133 (cost=0.42..32.62 rows=19 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2021_03_credit_account_id_effective_date_value_idx on transaction_2021_03 t_134 (cost=0.42..37.34 rows=30 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2021_04_credit_account_id_effective_date_value_idx on transaction_2021_04 t_135 (cost=0.42..29.39 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2021_05_credit_account_id_effective_date_value_idx on transaction_2021_05 t_136 (cost=0.42..29.84 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2021_06_credit_account_id_effective_date_value_idx on transaction_2021_06 t_137 (cost=0.42..29.85 rows=15 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2021_07_credit_account_id_effective_date_value_idx on transaction_2021_07 t_138 (cost=0.42..30.12 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2021_08_credit_account_id_effective_date_value_idx on transaction_2021_08 t_139 (cost=0.42..31.24 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2021_09_credit_account_id_effective_date_value_idx on transaction_2021_09 t_140 (cost=0.42..28.87 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2021_10_credit_account_id_effective_date_value_idx on transaction_2021_10 t_141 (cost=0.42..30.69 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2021_11_credit_account_id_effective_date_value_idx on transaction_2021_11 t_142 (cost=0.42..30.99 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2021_12_credit_account_id_effective_date_value_idx on transaction_2021_12 t_143 (cost=0.43..32.06 rows=15 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2022_01_credit_account_id_effective_date_value_idx on transaction_2022_01 t_144 (cost=0.42..29.89 rows=14 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2022_02_credit_account_id_effective_date_value_idx on transaction_2022_02 t_145 (cost=0.42..31.14 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2022_03_credit_account_id_effective_date_value_idx on transaction_2022_03 t_146 (cost=0.43..38.52 rows=23 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2022_04_credit_account_id_effective_date_value_idx on transaction_2022_04 t_147 (cost=0.42..28.33 rows=15 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2022_05_credit_account_id_effective_date_value_idx on transaction_2022_05 t_148 (cost=0.42..30.76 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2022_06_credit_account_id_effective_date_value_idx on transaction_2022_06 t_149 (cost=0.42..30.98 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2022_07_credit_account_id_effective_date_value_idx on transaction_2022_07 t_150 (cost=0.42..30.56 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2022_08_credit_account_id_effective_date_value_idx on transaction_2022_08 t_151 (cost=0.42..29.71 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2022_09_credit_account_id_effective_date_value_idx on transaction_2022_09 t_152 (cost=0.42..29.04 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2022_10_credit_account_id_effective_date_value_idx on transaction_2022_10 t_153 (cost=0.42..30.17 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2022_11_credit_account_id_effective_date_value_idx on transaction_2022_11 t_154 (cost=0.42..31.93 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2022_12_credit_account_id_effective_date_value_idx on transaction_2022_12 t_155 (cost=0.43..29.80 rows=13 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2023_01_credit_account_id_effective_date_value_idx on transaction_2023_01 t_156 (cost=0.42..31.83 rows=15 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2023_02_credit_account_id_effective_date_value_idx on transaction_2023_02 t_157 (cost=0.42..30.47 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2023_03_credit_account_id_effective_date_value_idx on transaction_2023_03 t_158 (cost=0.42..37.88 rows=30 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2023_04_credit_account_id_effective_date_value_idx on transaction_2023_04 t_159 (cost=0.42..28.40 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2023_05_credit_account_id_effective_date_value_idx on transaction_2023_05 t_160 (cost=0.42..30.44 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2023_06_credit_account_id_effective_date_value_idx on transaction_2023_06 t_161 (cost=0.42..30.59 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2023_07_credit_account_id_effective_date_value_idx on transaction_2023_07 t_162 (cost=0.42..29.68 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2023_08_credit_account_id_effective_date_value_idx on transaction_2023_08 t_163 (cost=0.42..31.24 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2023_09_credit_account_id_effective_date_value_idx on transaction_2023_09 t_164 (cost=0.42..27.93 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2023_10_credit_account_id_effective_date_value_idx on transaction_2023_10 t_165 (cost=0.42..30.71 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2023_11_credit_account_id_effective_date_value_idx on transaction_2023_11 t_166 (cost=0.42..30.18 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2023_12_credit_account_id_effective_date_value_idx on transaction_2023_12 t_167 (cost=0.43..30.18 rows=14 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2024_01_credit_account_id_effective_date_value_idx on transaction_2024_01 t_168 (cost=0.42..31.52 rows=16 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2024_02_credit_account_id_effective_date_value_idx on transaction_2024_02 t_169 (cost=0.42..30.68 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2024_03_credit_account_id_effective_date_value_idx on transaction_2024_03 t_170 (cost=0.42..35.53 rows=27 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2024_04_credit_account_id_effective_date_value_idx on transaction_2024_04 t_171 (cost=0.42..30.11 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2024_05_credit_account_id_effective_date_value_idx on transaction_2024_05 t_172 (cost=0.42..30.96 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2024_06_credit_account_id_effective_date_value_idx on transaction_2024_06 t_173 (cost=0.42..30.72 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2024_07_credit_account_id_effective_date_value_idx on transaction_2024_07 t_174 (cost=0.42..30.13 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2024_08_credit_account_id_effective_date_value_idx on transaction_2024_08 t_175 (cost=0.42..30.41 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2024_09_credit_account_id_effective_date_value_idx on transaction_2024_09 t_176 (cost=0.42..27.71 rows=17 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2024_10_credit_account_id_effective_date_value_idx on transaction_2024_10 t_177 (cost=0.42..31.05 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2024_11_credit_account_id_effective_date_value_idx on transaction_2024_11 t_178 (cost=0.42..40.57 rows=25 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2024_12_credit_account_id_effective_date_value_idx on transaction_2024_12 t_179 (cost=0.43..30.50 rows=14 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2025_01_credit_account_id_effective_date_value_idx on transaction_2025_01 t_180 (cost=0.42..39.51 rows=23 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2025_02_credit_account_id_effective_date_value_idx on transaction_2025_02 t_181 (cost=0.42..30.66 rows=19 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2025_03_credit_account_id_effective_date_value_idx on transaction_2025_03 t_182 (cost=0.42..40.35 rows=32 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2025_04_credit_account_id_effective_date_value_idx on transaction_2025_04 t_183 (cost=0.42..33.07 rows=24 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2025_05_credit_account_id_effective_date_value_idx on transaction_2025_05 t_184 (cost=0.42..32.03 rows=16 width=13)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2025_06_credit_account_id_effective_date_value_idx on transaction_2025_06 t_185 (cost=0.42..30.80 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2025_07_credit_account_id_effective_date_value_idx on transaction_2025_07 t_186 (cost=0.42..30.40 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2025_08_credit_account_id_effective_date_value_idx on transaction_2025_08 t_187 (cost=0.42..31.24 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2025_09_credit_account_id_effective_date_value_idx on transaction_2025_09 t_188 (cost=0.42..27.20 rows=16 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2025_10_credit_account_id_effective_date_value_idx on transaction_2025_10 t_189 (cost=0.42..31.14 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2025_11_credit_account_id_effective_date_value_idx on transaction_2025_11 t_190 (cost=0.42..31.10 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2025_12_credit_account_id_effective_date_value_idx on transaction_2025_12 t_191 (cost=0.56..53.46 rows=33 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2026_01_credit_account_id_effective_date_value_idx on transaction_2026_01 t_192 (cost=0.42..28.14 rows=15 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2026_02_credit_account_id_effective_date_value_idx on transaction_2026_02 t_193 (cost=0.42..30.74 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2026_03_credit_account_id_effective_date_value_idx on transaction_2026_03 t_194 (cost=0.43..77.05 rows=73 width=15)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2026_04_credit_account_id_effective_date_value_idx on transaction_2026_04 t_195 (cost=0.42..30.62 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2026_05_credit_account_id_effective_date_value_idx on transaction_2026_05 t_196 (cost=0.42..30.95 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2026_06_credit_account_id_effective_date_value_idx on transaction_2026_06 t_197 (cost=0.42..30.77 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2026_07_credit_account_id_effective_date_value_idx on transaction_2026_07 t_198 (cost=0.42..33.03 rows=18 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2026_08_credit_account_id_effective_date_value_idx on transaction_2026_08 t_199 (cost=0.42..27.41 rows=11 width=15)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2026_09_credit_account_id_effective_date_value_idx on transaction_2026_09 t_200 (cost=0.42..28.86 rows=13 width=14)
Index Cond: (credit_account_id = ANY (r.ids))
-> Index Scan using transaction_2026_10_credit_account_id_effective_date_value_idx on transaction_2026_10 t_201 (cost=0.42..36.41 rows=19 width=15)
Index Cond: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2026_11 t_202 (cost=0.00..2.85 rows=10 width=15)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2026_12 t_203 (cost=0.00..0.00 rows=1 width=30)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_01 t_204 (cost=0.00..0.00 rows=1 width=30)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_02 t_205 (cost=0.00..0.00 rows=1 width=30)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_03 t_206 (cost=0.00..0.00 rows=1 width=30)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_04 t_207 (cost=0.00..0.00 rows=1 width=30)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_05 t_208 (cost=0.00..0.00 rows=1 width=30)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_06 t_209 (cost=0.00..0.00 rows=1 width=30)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_07 t_210 (cost=0.00..0.00 rows=1 width=30)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_08 t_211 (cost=0.00..0.00 rows=1 width=30)
Filter: (credit_account_id = ANY (r.ids))
-> Nested Loop (cost=0.42..74634.88 rows=25417295 width=36)
-> CTE Scan on reserve_accounts r_1 (cost=0.00..0.02 rows=1 width=32)
-> Append (cost=0.42..11005.94 rows=8568 width=14)
-> Index Scan using transaction_2000_debit_account_id_effective_date_value_idx on transaction_2000 t_213 (cost=0.42..53.01 rows=38 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2001_debit_account_id_effective_date_idx on transaction_2001 t_214 (cost=0.29..81.84 rows=62 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2002_debit_account_id_effective_date_idx on transaction_2002 t_215 (cost=0.29..79.48 rows=62 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2003_debit_account_id_effective_date_value_idx on transaction_2003 t_216 (cost=0.42..83.02 rows=67 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2004_debit_account_id_effective_date_value_idx on transaction_2004 t_217 (cost=0.42..75.98 rows=62 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2005_debit_account_id_effective_date_value_idx on transaction_2005 t_218 (cost=0.43..252.10 rows=214 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2006_debit_account_id_effective_date_operation__idx on transaction_2006 t_219 (cost=0.43..305.26 rows=261 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2007_debit_account_id_effective_date_idx on transaction_2007 t_220 (cost=0.43..335.80 rows=288 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2008_debit_account_id_effective_date_idx on transaction_2008 t_221 (cost=0.43..342.21 rows=294 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2009_debit_account_id_effective_date_idx on transaction_2009 t_222 (cost=0.43..345.91 rows=298 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2010_debit_account_id_effective_date_idx on transaction_2010 t_223 (cost=0.43..345.64 rows=299 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2011_01_debit_account_id_effective_date_value_idx on transaction_2011_01 t_224 (cost=0.42..42.25 rows=25 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2011_02_debit_account_id_effective_date_value_idx on transaction_2011_02 t_225 (cost=0.42..42.50 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2011_03_debit_account_id_effective_date_value_idx on transaction_2011_03 t_226 (cost=0.43..37.17 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2011_04_debit_account_id_effective_date_value_idx on transaction_2011_04 t_227 (cost=0.42..43.41 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2011_05_debit_account_id_effective_date_value_idx on transaction_2011_05 t_228 (cost=0.43..48.86 rows=31 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2011_06_debit_account_id_effective_date_value_idx on transaction_2011_06 t_229 (cost=0.42..43.54 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2011_07_debit_account_id_effective_date_value_idx on transaction_2011_07 t_230 (cost=0.42..43.60 rows=26 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2011_08_debit_account_id_effective_date_value_idx on transaction_2011_08 t_231 (cost=0.42..43.49 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2011_09_debit_account_id_effective_date_value_idx on transaction_2011_09 t_232 (cost=0.43..48.15 rows=30 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2011_10_debit_account_id_effective_date_value_idx on transaction_2011_10 t_233 (cost=0.42..43.78 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2011_11_debit_account_id_effective_date_value_idx on transaction_2011_11 t_234 (cost=0.43..48.21 rows=30 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2011_12_debit_account_id_effective_date_idx on transaction_2011_12 t_235 (cost=0.43..54.62 rows=36 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2012_01_debit_account_id_effective_date_value_idx on transaction_2012_01 t_236 (cost=0.42..43.84 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2012_02_debit_account_id_effective_date_value_idx on transaction_2012_02 t_237 (cost=0.42..42.72 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2012_03_debit_account_id_effective_date_idx on transaction_2012_03 t_238 (cost=0.43..33.45 rows=24 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2012_04_debit_account_id_effective_date_value_idx on transaction_2012_04 t_239 (cost=0.42..43.04 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2012_05_debit_account_id_effective_date_value_idx on transaction_2012_05 t_240 (cost=0.42..44.76 rows=27 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2012_06_debit_account_id_effective_date_value_idx on transaction_2012_06 t_241 (cost=0.43..50.32 rows=32 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2012_07_debit_account_id_effective_date_value_idx on transaction_2012_07 t_242 (cost=0.42..44.89 rows=27 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2012_08_debit_account_id_effective_date_value_idx on transaction_2012_08 t_243 (cost=0.43..30.80 rows=18 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2012_09_debit_account_id_effective_date_idx on transaction_2012_09 t_244 (cost=0.43..52.35 rows=34 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2012_10_debit_account_id_effective_date_value_idx on transaction_2012_10 t_245 (cost=0.43..34.57 rows=23 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2012_11_debit_account_id_effective_date_value_idx on transaction_2012_11 t_246 (cost=0.42..43.53 rows=27 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2012_12_debit_account_id_effective_date_idx on transaction_2012_12 t_247 (cost=0.43..34.14 rows=23 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2013_01_debit_account_id_effective_date_value_idx on transaction_2013_01 t_248 (cost=0.42..42.85 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2013_02_debit_account_id_effective_date_value_idx on transaction_2013_02 t_249 (cost=0.42..39.78 rows=25 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2013_03_debit_account_id_effective_date_idx on transaction_2013_03 t_250 (cost=0.43..33.79 rows=24 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2013_04_debit_account_id_effective_date_value_idx on transaction_2013_04 t_251 (cost=0.43..37.48 rows=24 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2013_05_debit_account_id_effective_date_value_idx on transaction_2013_05 t_252 (cost=0.43..45.51 rows=28 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2013_06_debit_account_id_effective_date_idx on transaction_2013_06 t_253 (cost=0.43..55.31 rows=37 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2013_07_debit_account_id_effective_date_value_idx on transaction_2013_07 t_254 (cost=0.42..43.20 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2013_08_debit_account_id_effective_date_value_idx on transaction_2013_08 t_255 (cost=0.42..43.01 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2013_09_debit_account_id_effective_date_idx on transaction_2013_09 t_256 (cost=0.43..46.41 rows=34 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2013_10_debit_account_id_effective_date_value_idx on transaction_2013_10 t_257 (cost=0.43..43.88 rows=27 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2013_11_debit_account_id_effective_date_value_idx on transaction_2013_11 t_258 (cost=0.42..43.57 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2013_12_debit_account_id_effective_date_idx on transaction_2013_12 t_259 (cost=0.43..58.54 rows=43 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2014_01_debit_account_id_effective_date_value_idx on transaction_2014_01 t_260 (cost=0.42..43.62 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2014_02_debit_account_id_effective_date_value_idx on transaction_2014_02 t_261 (cost=0.42..43.09 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2014_03_debit_account_id_effective_date_value_idx on transaction_2014_03 t_262 (cost=0.43..31.31 rows=20 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2014_04_debit_account_id_effective_date_value_idx on transaction_2014_04 t_263 (cost=0.42..42.90 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2014_05_debit_account_id_effective_date_value_idx on transaction_2014_05 t_264 (cost=0.42..43.57 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2014_06_debit_account_id_effective_date_value_idx on transaction_2014_06 t_265 (cost=0.43..45.72 rows=28 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2014_07_debit_account_id_effective_date_value_idx on transaction_2014_07 t_266 (cost=0.42..43.20 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2014_08_debit_account_id_effective_date_value_idx on transaction_2014_08 t_267 (cost=0.42..42.09 rows=25 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2014_09_debit_account_id_effective_date_value_idx on transaction_2014_09 t_268 (cost=0.43..33.70 rows=22 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2014_10_debit_account_id_effective_date_value_idx on transaction_2014_10 t_269 (cost=0.42..42.11 rows=25 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2014_11_debit_account_id_effective_date_value_idx on transaction_2014_11 t_270 (cost=0.42..42.09 rows=25 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2014_12_debit_account_id_effective_date_idx on transaction_2014_12 t_271 (cost=0.43..53.35 rows=36 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2015_01_debit_account_id_effective_date_value_idx on transaction_2015_01 t_272 (cost=0.43..43.34 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2015_02_debit_account_id_effective_date_value_idx on transaction_2015_02 t_273 (cost=0.42..41.39 rows=25 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2015_03_debit_account_id_effective_date_value_idx on transaction_2015_03 t_274 (cost=0.42..40.98 rows=25 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2015_04_debit_account_id_effective_date_idx on transaction_2015_04 t_275 (cost=0.44..51.73 rows=41 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2015_05_debit_account_id_effective_date_value_idx on transaction_2015_05 t_276 (cost=0.43..30.05 rows=16 width=15)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2015_06_debit_account_id_effective_date_value_idx on transaction_2015_06 t_277 (cost=0.43..43.37 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2015_07_debit_account_id_effective_date_value_idx on transaction_2015_07 t_278 (cost=0.43..38.06 rows=24 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2015_08_debit_account_id_effective_date_value_idx on transaction_2015_08 t_279 (cost=0.42..40.79 rows=25 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2015_09_debit_account_id_effective_date_value_idx on transaction_2015_09 t_280 (cost=0.43..37.90 rows=24 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2015_10_debit_account_id_effective_date_value_idx on transaction_2015_10 t_281 (cost=0.42..43.29 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2015_11_debit_account_id_effective_date_value_idx on transaction_2015_11 t_282 (cost=0.43..42.80 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2015_12_debit_account_id_effective_date_idx on transaction_2015_12 t_283 (cost=0.43..37.55 rows=28 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2016_01_debit_account_id_effective_date_value_idx on transaction_2016_01 t_284 (cost=0.42..43.56 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2016_02_debit_account_id_effective_date_value_idx on transaction_2016_02 t_285 (cost=0.42..42.57 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2016_03_debit_account_id_effective_date_idx on transaction_2016_03 t_286 (cost=0.43..32.77 rows=18 width=15)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2016_04_debit_account_id_effective_date_value_idx on transaction_2016_04 t_287 (cost=0.43..33.75 rows=22 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2016_05_debit_account_id_effective_date_value_idx on transaction_2016_05 t_288 (cost=0.43..44.49 rows=29 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2016_06_debit_account_id_effective_date_value_idx on transaction_2016_06 t_289 (cost=0.43..29.48 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2016_07_debit_account_id_effective_date_value_idx on transaction_2016_07 t_290 (cost=0.42..41.00 rows=25 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2016_08_debit_account_id_effective_date_value_idx on transaction_2016_08 t_291 (cost=0.42..39.15 rows=24 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2016_09_debit_account_id_effective_date_value_idx on transaction_2016_09 t_292 (cost=0.43..35.25 rows=24 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2016_10_debit_account_id_effective_date_value_idx on transaction_2016_10 t_293 (cost=0.42..42.37 rows=26 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2016_11_debit_account_id_effective_date_value_idx on transaction_2016_11 t_294 (cost=0.42..40.93 rows=25 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2016_12_debit_account_id_effective_date_idx on transaction_2016_12 t_295 (cost=0.44..41.14 rows=34 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2017_01_debit_account_id_effective_date_value_idx on transaction_2017_01 t_296 (cost=0.42..35.33 rows=20 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2017_02_debit_account_id_effective_date_value_idx on transaction_2017_02 t_297 (cost=0.42..34.50 rows=20 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2017_03_debit_account_id_effective_date_value_idx on transaction_2017_03 t_298 (cost=0.43..29.91 rows=17 width=15)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2017_04_debit_account_id_effective_date_value_idx on transaction_2017_04 t_299 (cost=0.42..29.53 rows=18 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2017_05_debit_account_id_effective_date_value_idx on transaction_2017_05 t_300 (cost=0.43..27.35 rows=15 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2017_06_debit_account_id_effective_date_value_idx on transaction_2017_06 t_301 (cost=0.42..35.16 rows=21 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2017_07_debit_account_id_effective_date_value_idx on transaction_2017_07 t_302 (cost=0.42..35.81 rows=21 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2017_08_debit_account_id_effective_date_value_idx on transaction_2017_08 t_303 (cost=0.42..33.74 rows=20 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2017_09_debit_account_id_effective_date_value_idx on transaction_2017_09 t_304 (cost=0.42..29.06 rows=18 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2017_10_debit_account_id_effective_date_value_idx on transaction_2017_10 t_305 (cost=0.42..34.68 rows=20 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2017_11_debit_account_id_effective_date_value_idx on transaction_2017_11 t_306 (cost=0.42..27.84 rows=16 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2017_12_debit_account_id_effective_date_idx on transaction_2017_12 t_307 (cost=0.43..177.69 rows=225 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2018_01_debit_account_id_effective_date_value_idx on transaction_2018_01 t_308 (cost=0.42..36.56 rows=20 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2018_02_debit_account_id_effective_date_value_idx on transaction_2018_02 t_309 (cost=0.42..32.59 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2018_03_debit_account_id_effective_date_value_idx on transaction_2018_03 t_310 (cost=0.43..32.40 rows=17 width=15)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2018_04_debit_account_id_effective_date_value_idx on transaction_2018_04 t_311 (cost=0.42..32.25 rows=20 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2018_05_debit_account_id_effective_date_value_idx on transaction_2018_05 t_312 (cost=0.42..33.27 rows=20 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2018_06_debit_account_id_effective_date_value_idx on transaction_2018_06 t_313 (cost=0.42..32.60 rows=20 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2018_07_debit_account_id_effective_date_value_idx on transaction_2018_07 t_314 (cost=0.43..34.28 rows=22 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2018_08_debit_account_id_effective_date_value_idx on transaction_2018_08 t_315 (cost=0.42..31.60 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2018_09_debit_account_id_effective_date_value_idx on transaction_2018_09 t_316 (cost=0.43..31.29 rows=21 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2018_10_debit_account_id_effective_date_value_idx on transaction_2018_10 t_317 (cost=0.42..32.89 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2018_11_debit_account_id_effective_date_value_idx on transaction_2018_11 t_318 (cost=0.42..33.79 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2018_12_debit_account_id_effective_date_idx on transaction_2018_12 t_319 (cost=0.43..38.49 rows=25 width=15)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2019_01_debit_account_id_effective_date_value_idx on transaction_2019_01 t_320 (cost=0.43..30.45 rows=18 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2019_02_debit_account_id_effective_date_value_idx on transaction_2019_02 t_321 (cost=0.42..33.56 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2019_03_debit_account_id_effective_date_value_idx on transaction_2019_03 t_322 (cost=0.43..33.29 rows=21 width=15)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2019_04_debit_account_id_effective_date_value_idx on transaction_2019_04 t_323 (cost=0.42..32.57 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2019_05_debit_account_id_effective_date_value_idx on transaction_2019_05 t_324 (cost=0.42..32.15 rows=18 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2019_06_debit_account_id_effective_date_value_idx on transaction_2019_06 t_325 (cost=0.42..33.97 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2019_07_debit_account_id_effective_date_value_idx on transaction_2019_07 t_326 (cost=0.42..33.70 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2019_08_debit_account_id_effective_date_value_idx on transaction_2019_08 t_327 (cost=0.42..33.01 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2019_09_debit_account_id_effective_date_value_idx on transaction_2019_09 t_328 (cost=0.42..32.30 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2019_10_debit_account_id_effective_date_value_idx on transaction_2019_10 t_329 (cost=0.42..33.41 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2019_11_debit_account_id_effective_date_value_idx on transaction_2019_11 t_330 (cost=0.42..32.10 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2019_12_debit_account_id_effective_date_idx on transaction_2019_12 t_331 (cost=0.43..573.21 rows=949 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2020_01_debit_account_id_effective_date_value_idx on transaction_2020_01 t_332 (cost=0.42..35.27 rows=20 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2020_02_debit_account_id_effective_date_value_idx on transaction_2020_02 t_333 (cost=0.42..33.03 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2020_03_debit_account_id_effective_date_value_idx on transaction_2020_03 t_334 (cost=0.43..31.71 rows=22 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2020_04_debit_account_id_effective_date_value_idx on transaction_2020_04 t_335 (cost=0.42..31.54 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2020_05_debit_account_id_effective_date_value_idx on transaction_2020_05 t_336 (cost=0.42..33.16 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2020_06_debit_account_id_effective_date_value_idx on transaction_2020_06 t_337 (cost=0.42..32.58 rows=20 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2020_07_debit_account_id_effective_date_value_idx on transaction_2020_07 t_338 (cost=0.42..32.64 rows=20 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2020_08_debit_account_id_effective_date_value_idx on transaction_2020_08 t_339 (cost=0.42..31.84 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2020_09_debit_account_id_effective_date_value_idx on transaction_2020_09 t_340 (cost=0.42..29.62 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2020_10_debit_account_id_effective_date_value_idx on transaction_2020_10 t_341 (cost=0.42..33.08 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2020_11_debit_account_id_effective_date_value_idx on transaction_2020_11 t_342 (cost=0.42..32.37 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2020_12_debit_account_id_effective_date_idx on transaction_2020_12 t_343 (cost=0.44..668.66 rows=585 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2021_01_debit_account_id_effective_date_value_idx on transaction_2021_01 t_344 (cost=0.42..34.46 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2021_02_debit_account_id_effective_date_value_idx on transaction_2021_02 t_345 (cost=0.42..30.42 rows=18 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2021_03_debit_account_id_effective_date_value_idx on transaction_2021_03 t_346 (cost=0.42..28.81 rows=18 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2021_04_debit_account_id_effective_date_value_idx on transaction_2021_04 t_347 (cost=0.42..32.15 rows=20 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2021_05_debit_account_id_effective_date_value_idx on transaction_2021_05 t_348 (cost=0.42..33.12 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2021_06_debit_account_id_effective_date_value_idx on transaction_2021_06 t_349 (cost=0.42..33.59 rows=20 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2021_07_debit_account_id_effective_date_value_idx on transaction_2021_07 t_350 (cost=0.42..33.14 rows=20 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2021_08_debit_account_id_effective_date_value_idx on transaction_2021_08 t_351 (cost=0.42..32.36 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2021_09_debit_account_id_effective_date_value_idx on transaction_2021_09 t_352 (cost=0.42..28.87 rows=18 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2021_10_debit_account_id_effective_date_value_idx on transaction_2021_10 t_353 (cost=0.42..32.49 rows=20 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2021_11_debit_account_id_effective_date_value_idx on transaction_2021_11 t_354 (cost=0.42..33.45 rows=19 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2021_12_debit_account_id_effective_date_idx on transaction_2021_12 t_355 (cost=0.43..484.37 rows=638 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2022_01_debit_account_id_effective_date_value_idx on transaction_2022_01 t_356 (cost=0.42..35.89 rows=20 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2022_02_debit_account_id_effective_date_value_idx on transaction_2022_02 t_357 (cost=0.42..32.05 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2022_03_debit_account_id_effective_date_value_idx on transaction_2022_03 t_358 (cost=0.43..29.80 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2022_04_debit_account_id_effective_date_value_idx on transaction_2022_04 t_359 (cost=0.42..31.00 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2022_05_debit_account_id_effective_date_value_idx on transaction_2022_05 t_360 (cost=0.42..32.83 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2022_06_debit_account_id_effective_date_value_idx on transaction_2022_06 t_361 (cost=0.42..33.17 rows=20 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2022_07_debit_account_id_effective_date_value_idx on transaction_2022_07 t_362 (cost=0.42..31.89 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2022_08_debit_account_id_effective_date_value_idx on transaction_2022_08 t_363 (cost=0.42..30.30 rows=18 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2022_09_debit_account_id_effective_date_value_idx on transaction_2022_09 t_364 (cost=0.42..29.22 rows=18 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2022_10_debit_account_id_effective_date_value_idx on transaction_2022_10 t_365 (cost=0.42..32.00 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2022_11_debit_account_id_effective_date_value_idx on transaction_2022_11 t_366 (cost=0.42..31.80 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2022_12_debit_account_id_effective_date_idx on transaction_2022_12 t_367 (cost=0.43..40.84 rows=34 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2023_01_debit_account_id_effective_date_value_idx on transaction_2023_01 t_368 (cost=0.42..35.90 rows=20 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2023_02_debit_account_id_effective_date_value_idx on transaction_2023_02 t_369 (cost=0.42..32.73 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2023_03_debit_account_id_effective_date_value_idx on transaction_2023_03 t_370 (cost=0.42..30.86 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2023_04_debit_account_id_effective_date_value_idx on transaction_2023_04 t_371 (cost=0.42..31.97 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2023_05_debit_account_id_effective_date_value_idx on transaction_2023_05 t_372 (cost=0.42..33.11 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2023_06_debit_account_id_effective_date_value_idx on transaction_2023_06 t_373 (cost=0.42..32.74 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2023_07_debit_account_id_effective_date_value_idx on transaction_2023_07 t_374 (cost=0.42..33.05 rows=21 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2023_08_debit_account_id_effective_date_value_idx on transaction_2023_08 t_375 (cost=0.42..32.25 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2023_09_debit_account_id_effective_date_value_idx on transaction_2023_09 t_376 (cost=0.42..27.49 rows=17 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2023_10_debit_account_id_effective_date_value_idx on transaction_2023_10 t_377 (cost=0.42..31.23 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2023_11_debit_account_id_effective_date_value_idx on transaction_2023_11 t_378 (cost=0.42..31.16 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2023_12_debit_account_id_effective_date_idx on transaction_2023_12 t_379 (cost=0.43..44.93 rows=40 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2024_01_debit_account_id_effective_date_value_idx on transaction_2024_01 t_380 (cost=0.42..36.75 rows=21 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2024_02_debit_account_id_effective_date_value_idx on transaction_2024_02 t_381 (cost=0.42..30.55 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2024_03_debit_account_id_effective_date_value_idx on transaction_2024_03 t_382 (cost=0.42..29.40 rows=18 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2024_04_debit_account_id_effective_date_value_idx on transaction_2024_04 t_383 (cost=0.42..30.11 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2024_05_debit_account_id_effective_date_value_idx on transaction_2024_05 t_384 (cost=0.42..30.78 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2024_06_debit_account_id_effective_date_value_idx on transaction_2024_06 t_385 (cost=0.42..30.63 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2024_07_debit_account_id_effective_date_value_idx on transaction_2024_07 t_386 (cost=0.42..32.95 rows=23 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2024_08_debit_account_id_effective_date_value_idx on transaction_2024_08 t_387 (cost=0.42..30.20 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2024_09_debit_account_id_effective_date_value_idx on transaction_2024_09 t_388 (cost=0.42..27.06 rows=17 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2024_10_debit_account_id_effective_date_value_idx on transaction_2024_10 t_389 (cost=0.42..30.11 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2024_11_debit_account_id_effective_date_value_idx on transaction_2024_11 t_390 (cost=0.42..30.25 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2024_12_debit_account_id_effective_date_idx on transaction_2024_12 t_391 (cost=0.43..43.32 rows=40 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2025_01_debit_account_id_effective_date_value_idx on transaction_2025_01 t_392 (cost=0.42..37.70 rows=22 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2025_02_debit_account_id_effective_date_value_idx on transaction_2025_02 t_393 (cost=0.42..29.01 rows=18 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2025_03_debit_account_id_effective_date_value_idx on transaction_2025_03 t_394 (cost=0.42..29.73 rows=18 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2025_04_debit_account_id_effective_date_value_idx on transaction_2025_04 t_395 (cost=0.42..31.02 rows=23 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2025_05_debit_account_id_effective_date_value_idx on transaction_2025_05 t_396 (cost=0.42..35.23 rows=20 width=13)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2025_06_debit_account_id_effective_date_value_idx on transaction_2025_06 t_397 (cost=0.42..30.54 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2025_07_debit_account_id_effective_date_value_idx on transaction_2025_07 t_398 (cost=0.42..31.33 rows=21 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2025_08_debit_account_id_effective_date_value_idx on transaction_2025_08 t_399 (cost=0.42..30.35 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2025_09_debit_account_id_effective_date_value_idx on transaction_2025_09 t_400 (cost=0.42..26.29 rows=16 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2025_10_debit_account_id_effective_date_value_idx on transaction_2025_10 t_401 (cost=0.42..30.25 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2025_11_debit_account_id_effective_date_value_idx on transaction_2025_11 t_402 (cost=0.42..30.35 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2025_12_debit_account_id_effective_date_idx on transaction_2025_12 t_403 (cost=0.44..98.64 rows=100 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2026_01_debit_account_id_effective_date_value_idx on transaction_2026_01 t_404 (cost=0.42..26.03 rows=13 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2026_02_debit_account_id_effective_date_value_idx on transaction_2026_02 t_405 (cost=0.42..30.03 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2026_03_debit_account_id_effective_date_value_idx on transaction_2026_03 t_406 (cost=0.43..30.18 rows=16 width=15)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2026_04_debit_account_id_effective_date_value_idx on transaction_2026_04 t_407 (cost=0.42..29.64 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2026_05_debit_account_id_effective_date_value_idx on transaction_2026_05 t_408 (cost=0.42..30.05 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2026_06_debit_account_id_effective_date_value_idx on transaction_2026_06 t_409 (cost=0.42..30.13 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2026_07_debit_account_id_effective_date_value_idx on transaction_2026_07 t_410 (cost=0.42..32.19 rows=19 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2026_08_debit_account_id_effective_date_value_idx on transaction_2026_08 t_411 (cost=0.42..24.72 rows=10 width=15)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2026_09_debit_account_id_effective_date_value_idx on transaction_2026_09 t_412 (cost=0.42..26.36 rows=10 width=14)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Index Scan using transaction_2026_10_debit_account_id_effective_date_idx on transaction_2026_10 t_413 (cost=0.29..25.05 rows=10 width=15)
Index Cond: (debit_account_id = ANY (r_1.ids))
-> Seq Scan on transaction_2026_11 t_414 (cost=0.00..2.85 rows=9 width=15)
Filter: (debit_account_id = ANY (r_1.ids))
-> Seq Scan on transaction_2026_12 t_415 (cost=0.00..0.00 rows=1 width=30)
Filter: (debit_account_id = ANY (r_1.ids))
-> Seq Scan on transaction_2027_01 t_416 (cost=0.00..0.00 rows=1 width=30)
Filter: (debit_account_id = ANY (r_1.ids))
-> Seq Scan on transaction_2027_02 t_417 (cost=0.00..0.00 rows=1 width=30)
Filter: (debit_account_id = ANY (r_1.ids))
-> Seq Scan on transaction_2027_03 t_418 (cost=0.00..0.00 rows=1 width=30)
Filter: (debit_account_id = ANY (r_1.ids))
-> Seq Scan on transaction_2027_04 t_419 (cost=0.00..0.00 rows=1 width=30)
Filter: (debit_account_id = ANY (r_1.ids))
-> Seq Scan on transaction_2027_05 t_420 (cost=0.00..0.00 rows=1 width=30)
Filter: (debit_account_id = ANY (r_1.ids))
-> Seq Scan on transaction_2027_06 t_421 (cost=0.00..0.00 rows=1 width=30)
Filter: (debit_account_id = ANY (r_1.ids))
-> Seq Scan on transaction_2027_07 t_422 (cost=0.00..0.00 rows=1 width=30)
Filter: (debit_account_id = ANY (r_1.ids))
-> Seq Scan on transaction_2027_08 t_423 (cost=0.00..0.00 rows=1 width=30)
Filter: (debit_account_id = ANY (r_1.ids))
InitPlan 10
-> Result (cost=0.00..0.01 rows=1 width=1)
InitPlan 12
-> Result (cost=1.02..1.03 rows=1 width=1)
InitPlan 11
-> Seq Scan on user_group ug_2 (cost=0.00..1.02 rows=1 width=0)
Filter: (user_id = (NULLIF(current_setting('app.user_id'::text, true), ''::text))::bigint)
-> Nested Loop (cost=1648231.65..1816887.76 rows=16818 width=327)
-> Nested Loop (cost=1648229.11..1727504.85 rows=33635 width=312)
-> GroupAggregate (cost=1648228.67..1651524.56 rows=33635 width=292)
Group Key: a.owner_sharer_id
Filter: (sum(m.signed_value) <> '0'::numeric)
-> Sort (cost=1648228.67..1648313.18 rows=33804 width=59)
Sort Key: a.owner_sharer_id
-> Hash Join (cost=438026.24..1645685.78 rows=33804 width=59)
Hash Cond: (m.account_id = a.id)
-> CTE Scan on reserve_movements m (cost=0.00..1016691.80 rows=50834590 width=36)
-> Hash (cost=437635.45..437635.45 rows=31263 width=31)
-> Hash Join (cost=18.37..437635.45 rows=31263 width=31)
Hash Cond: (a.account_type_id = at.id)
-> Nested Loop (cost=0.56..436201.31 rows=534826 width=12)
-> CTE Scan on ops_sharer s_1 (cost=0.00..2430.20 rows=121510 width=4)
-> Index Scan using idx_account_owner_sharer_id on account a (cost=0.56..3.53 rows=4 width=12)
Index Cond: (owner_sharer_id = s_1.id)
-> Hash (cost=17.45..17.45 rows=28 width=27)
-> Bitmap Heap Scan on account_type at (cost=3.03..17.45 rows=28 width=27)
Recheck Cond: ((mnemonics)::text = ANY ('{ОПС,"ОПС ГВ","ОПС КП","Р ПП ОПС","ОПС ИД","ОПС ФР","Р ПП ОПС ИД","ДПС Г","ДПС Г ГВ","ДПС Г КП","Р ПП ДПС Г","ДПС Г ИД","ДПС Г ФР","Р ПП ДПС Г ИД","ДПС Л","ДПС Л ГВ","ДПС Л КП","Р ПП ДПС Л","ДПС Л ИД","ДПС Л ФР","Р ПП ДПС Л ИД","ДПС МК","ДПС МК ГВ","ДПС МК КП","Р ПП ДПС МК","ДПС МК ИД","ДПС МК ФР","Р ПП ДПС МК ИД"}'::text[]))
-> Bitmap Index Scan on account_type_mnemonics_idx1 (cost=0.00..2.96 rows=28 width=0)
Index Cond: ((mnemonics)::text = ANY ('{ОПС,"ОПС ГВ","ОПС КП","Р ПП ОПС","ОПС ИД","ОПС ФР","Р ПП ОПС ИД","ДПС Г","ДПС Г ГВ","ДПС Г КП","Р ПП ДПС Г","ДПС Г ИД","ДПС Г ФР","Р ПП ДПС Г ИД","ДПС Л","ДПС Л ГВ","ДПС Л КП","Р ПП ДПС Л","ДПС Л ИД","ДПС Л ФР","Р ПП ДПС Л ИД","ДПС МК","ДПС МК ГВ","ДПС МК КП","Р ПП ДПС МК","ДПС МК ИД","ДПС МК ФР","Р ПП ДПС МК ИД"}'::text[]))
-> Index Scan using sharer_pkey on sharer s (cost=0.43..2.25 rows=1 width=24)
Index Cond: (id = a.owner_sharer_id)
-> Index Scan using individual_pkey on individual i (cost=2.54..2.66 rows=1 width=19)
Index Cond: (id = s.individual_id)
Filter: CASE WHEN (InitPlan 10).col1 THEN true WHEN (InitPlan 12).col1 THEN (ANY (id = (hashed SubPlan 13).col1)) ELSE (NOT (ANY (id = (hashed SubPlan 14).col1))) END
SubPlan 13
-> Unique (cost=2.09..2.10 rows=2 width=8)
-> Sort (cost=2.09..2.09 rows=2 width=8)
Sort Key: a_6.individual_id
-> Append (cost=0.00..2.08 rows=2 width=8)
-> Nested Loop (cost=0.00..1.03 rows=1 width=8)
Join Filter: (ug_3.group_id = a_6.group_id)
-> Seq Scan on user_group ug_3 (cost=0.00..1.02 rows=1 width=8)
Filter: (user_id = (NULLIF(current_setting('app.user_id'::text, true), ''::text))::bigint)
-> Seq Scan on group_individual_access a_6 (cost=0.00..0.00 rows=1 width=16)
-> Nested Loop (cost=0.00..1.03 rows=1 width=8)
Join Filter: (ug_4.group_id = a_7.group_id)
-> Seq Scan on user_group ug_4 (cost=0.00..1.02 rows=1 width=8)
Filter: (user_id = (NULLIF(current_setting('app.user_id'::text, true), ''::text))::bigint)
-> Seq Scan on group_contract_access a_7 (cost=0.00..0.00 rows=1 width=16)
Filter: (individual_id IS NOT NULL)
SubPlan 14
-> Seq Scan on rbac_public_hidden_individual (cost=0.00..0.00 rows=1 width=8)
-> Limit (cost=0.42..2.64 rows=1 width=12)
-> Index Scan using adi_last_by_individual_idx on application_death_info a_1 (cost=0.42..2.64 rows=1 width=12)
Index Cond: (individual_id = s.individual_id)