https://pastein.ru/t/2ga
Загрузка данных
Nested Loop (cost=3586763.26..3800196.88 rows=16818 width=327) (actual rows=517494 loops=1)
Buffers: shared hit=27126940 read=15184, temp read=40270 written=44630
I/O Timings: shared read=10056.656, temp read=122.017 write=561.287
CTE latest_death_info
-> Result (cost=0.42..57790.33 rows=634009 width=16) (actual rows=859075 loops=1)
Buffers: shared hit=876806
-> Unique (cost=0.42..57790.33 rows=634009 width=16) (actual rows=859075 loops=1)
Buffers: shared hit=876806
-> Index Scan using adi_last_by_individual_idx on application_death_info a_2 (cost=0.42..55594.82 rows=878205 width=16) (actual rows=874182 loops=1)
Buffers: shared hit=876806
CTE ops_sharer
-> Nested Loop Anti Join (cost=5.40..1756629.79 rows=121510 width=8) (actual rows=743051 loops=1)
Join Filter: (o.effective_date <= p.report_date)
Buffers: shared hit=11473679 read=10476, temp written=2726
I/O Timings: shared read=9950.891, temp write=25.396
InitPlan 2
-> Result (cost=0.00..0.01 rows=1 width=1) (actual rows=1 loops=1)
InitPlan 4
-> Result (cost=1.02..1.03 rows=1 width=1) (never executed)
InitPlan 3
-> Seq Scan on user_group ug (cost=0.00..1.02 rows=1 width=0) (never executed)
Filter: (user_id = (NULLIF(current_setting('app.user_id'::text, true), ''::text))::bigint)
-> Nested Loop (cost=2.93..923462.50 rows=131961 width=12) (actual rows=809067 loops=1)
Buffers: shared hit=8393734 read=2625, temp written=2726
I/O Timings: shared read=3583.386, temp write=25.396
-> Nested Loop (cost=0.43..211876.92 rows=277417 width=16) (actual rows=989370 loops=1)
Buffers: shared hit=4436267 read=2616, temp written=2726
I/O Timings: shared read=3575.040, temp write=25.396
-> Nested Loop (cost=0.00..20606.30 rows=211336 width=12) (actual rows=859074 loops=1)
Join Filter: (death_info.death_date <= p.report_date)
Rows Removed by Join Filter: 1
Buffers: shared hit=876807, temp written=2726
I/O Timings: temp write=25.396
-> Seq Scan on dia_param p (cost=0.00..1.01 rows=1 width=4) (actual rows=1 loops=1)
Buffers: shared hit=1
-> CTE Scan on latest_death_info death_info (cost=0.00..12680.18 rows=634009 width=8) (actual rows=859075 loops=1)
Buffers: shared hit=876806, temp written=2726
I/O Timings: temp write=25.396
-> Index Scan using sharer_individual_id_idx on sharer s_2 (cost=0.43..0.90 rows=1 width=12) (actual rows=1 loops=859074)
Index Cond: (individual_id = death_info.individual_id)
Buffers: shared hit=3559460 read=2616
I/O Timings: shared read=3575.040
-> Index Scan using contract_pkey on contract c (cost=2.50..2.57 rows=1 width=4) (actual rows=1 loops=989370)
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)
Rows Removed by Filter: 0
Buffers: shared hit=3957467 read=9
I/O Timings: shared read=8.346
SubPlan 5
-> Nested Loop (cost=0.00..1.03 rows=1 width=8) (never executed)
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) (never executed)
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) (never executed)
SubPlan 6
-> Nested Loop (cost=0.00..1.02 rows=1 width=8) (never executed)
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) (never executed)
-> Seq Scan on individual_groups g (cost=0.00..1.01 rows=1 width=4) (never executed)
Filter: hidden_from_external
-> Nested Loop (cost=1.43..3.09 rows=291 width=8) (actual rows=0 loops=809067)
Buffers: shared hit=3079945 read=7851
I/O Timings: shared read=6367.505
-> Nested Loop (cost=1.00..2.20 rows=2 width=16) (actual rows=0 loops=809067)
Buffers: shared hit=2817560 read=6172
I/O Timings: shared read=4948.547
-> Index Scan using ops_transfer_details_sharer_id on ops_transfer_details d (cost=0.43..0.48 rows=2 width=8) (actual rows=0 loops=809067)
Index Cond: (sharer_id = s_2.id)
Buffers: shared hit=2487361 read=5923
I/O Timings: shared read=4759.146
-> Index Scan using idx_operation_transfer_register_id on operation o (cost=0.57..0.85 rows=1 width=8) (actual rows=1 loops=66108)
Index Cond: (ops_transfer_register_id = d.ops_transfer_register_id)
Filter: (approved IS NOT NULL)
Buffers: shared hit=330199 read=249
I/O Timings: shared read=189.401
-> Index Only Scan using ops_transfer_register_pk on ops_transfer_register tr (cost=0.42..0.45 rows=1 width=4) (actual rows=1 loops=66016)
Index Cond: (id = d.ops_transfer_register_id)
Heap Fetches: 66016
Buffers: shared hit=262385 read=1679
I/O Timings: shared read=1418.958
CTE reserve_accounts
-> Aggregate (cost=295960.56..295960.57 rows=1 width=32) (actual rows=1 loops=1)
Buffers: shared hit=8 read=4
I/O Timings: shared read=1.961
-> Nested Loop (cost=0.71..295469.80 rows=196302 width=4) (actual rows=2 loops=1)
Buffers: shared hit=8 read=4
I/O Timings: shared read=1.961
-> Index Only Scan using account_type_mnemonics_idx1 on account_type at_1 (cost=0.27..4.94 rows=2 width=4) (actual rows=2 loops=1)
Index Cond: (mnemonics = ANY ('{"Р ОПС","Р ОПС ИД"}'::text[]))
Heap Fetches: 2
Buffers: shared hit=4
-> Index Scan using idx_account_account_type_id on account a_5 (cost=0.44..143971.28 rows=376115 width=8) (actual rows=1 loops=2)
Index Cond: (account_type_id = at_1.id)
Buffers: shared hit=4 read=4
I/O Timings: shared read=1.961
InitPlan 9
-> Result (cost=0.00..0.01 rows=1 width=1) (actual rows=1 loops=1)
InitPlan 11
-> Result (cost=1.02..1.03 rows=1 width=1) (never executed)
InitPlan 10
-> Seq Scan on user_group ug_2 (cost=0.00..1.02 rows=1 width=0) (never executed)
Filter: (user_id = (NULLIF(current_setting('app.user_id'::text, true), ''::text))::bigint)
-> Nested Loop (cost=1476381.10..1645037.22 rows=16818 width=327) (actual rows=517494 loops=1)
Buffers: shared hit=25056964 read=15184, temp read=40270 written=44630
I/O Timings: shared read=10056.656, temp read=122.017 write=561.287
-> Nested Loop (cost=1476378.56..1555654.30 rows=33635 width=312) (actual rows=517494 loops=1)
Buffers: shared hit=22988807 read=13365, temp read=40270 written=44630
I/O Timings: shared read=10039.890, temp read=122.017 write=561.287
-> GroupAggregate (cost=1476378.12..1479674.01 rows=33635 width=292) (actual rows=517494 loops=1)
Group Key: a.owner_sharer_id
Filter: (sum("*SELECT* 1".signed_value) <> '0'::numeric)
Rows Removed by Filter: 9659
Buffers: shared hit=20918831 read=13365, temp read=40270 written=44630
I/O Timings: shared read=10039.890, temp read=122.017 write=561.287
-> Sort (cost=1476378.12..1476462.63 rows=33804 width=46) (actual rows=1218475 loops=1)
Sort Key: a.owner_sharer_id
Sort Method: external merge Disk: 45416kB
Buffers: shared hit=20918831 read=13365, temp read=40270 written=44630
I/O Timings: shared read=10039.890, temp read=122.017 write=561.287
-> Hash Join (cost=438026.66..1473835.23 rows=33804 width=46) (actual rows=1218475 loops=1)
Hash Cond: ("*SELECT* 1".account_id = a.id)
Buffers: shared hit=20918831 read=13365, temp read=34593 written=38951
I/O Timings: shared read=10039.890, temp read=105.343 write=511.045
-> Append (cost=0.42..844841.25 rows=50834590 width=23) (actual rows=6547612 loops=1)
Buffers: shared hit=3004334 read=2889
I/O Timings: shared read=88.999
-> Subquery Scan on "*SELECT* 1" (cost=0.42..261860.47 rows=25417295 width=10) (actual rows=2753716 loops=1)
Buffers: shared hit=2651878 read=4
I/O Timings: shared read=1.961
-> Nested Loop (cost=0.42..7687.52 rows=25417295 width=10) (actual rows=2753716 loops=1)
Buffers: shared hit=2651878 read=4
I/O Timings: shared read=1.961
-> CTE Scan on reserve_accounts r (cost=0.00..0.02 rows=1 width=32) (actual rows=1 loops=1)
Buffers: shared hit=8 read=4
I/O Timings: shared read=1.961
-> Append (cost=0.42..7635.87 rows=5163 width=14) (actual rows=2753716 loops=1)
Buffers: shared hit=2651870
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=2 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=4
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6
-> 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) (actual rows=2 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=7
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6
-> 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) (actual rows=119 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=124
-> 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) (actual rows=153 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=72
-> 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) (actual rows=133 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=103
-> 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) (actual rows=191 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=121
-> 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) (actual rows=153 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=69
-> 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) (actual rows=5052 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=4668
-> 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) (actual rows=180 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=73
-> 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) (actual rows=8 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=9
-> 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) (actual rows=254 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=118
-> 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) (actual rows=106 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=55
-> 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) (actual rows=94 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=35
-> 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) (actual rows=76 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=19
-> 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) (actual rows=169 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=83
-> 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) (actual rows=84 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=30
-> 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) (actual rows=1300 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=1143
-> 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) (actual rows=75 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=41
-> 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) (actual rows=160 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=58
-> 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) (actual rows=8543 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=8001
-> 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) (actual rows=360 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=246
-> 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) (actual rows=574 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=416
-> 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) (actual rows=133 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=61
-> 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) (actual rows=105 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=59
-> 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) (actual rows=113 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=119
-> 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) (actual rows=87 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=28
-> 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) (actual rows=337 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=223
-> 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) (actual rows=104 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=76
-> 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) (actual rows=876 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=732
-> 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) (actual rows=151 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=62
-> 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) (actual rows=37 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=7
-> 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) (actual rows=15274 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=14527
-> 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) (actual rows=109 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=55
-> 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) (actual rows=149 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=51
-> 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) (actual rows=162 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=64
-> 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) (actual rows=106 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=13
-> 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) (actual rows=1114 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=916
-> 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) (actual rows=627 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=462
-> 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) (actual rows=99 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=31
-> 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) (actual rows=764 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=594
-> 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) (actual rows=1716 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=1537
-> 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) (actual rows=264 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=183
-> 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) (actual rows=143 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=66
-> 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) (actual rows=83733 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=82476
-> 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) (actual rows=55391 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=53824
-> 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) (actual rows=1223 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=953
-> 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) (actual rows=140 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=59
-> 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) (actual rows=127 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=54
-> 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) (actual rows=164 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=63
-> 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) (actual rows=93 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=24
-> 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) (actual rows=13 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6
-> 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) (actual rows=1 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=4
-> 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) (actual rows=334060 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=334644
-> 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) (actual rows=330 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=165
-> 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) (actual rows=454 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=462
-> 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) (actual rows=271688 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=270949
-> 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) (actual rows=123760 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=112283
-> 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) (actual rows=371 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=259
-> 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) (actual rows=293 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=91
-> 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) (actual rows=1313 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=1076
-> 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) (actual rows=889 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=740
-> 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) (actual rows=628 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=496
-> 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) (actual rows=779 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=588
-> 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) (actual rows=327666 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=328388
-> 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) (actual rows=52999 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=52946
-> 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) (actual rows=808 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=720
-> 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) (actual rows=923 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=775
-> 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) (actual rows=272134 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=244299
-> 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) (actual rows=1183 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=1064
-> 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) (actual rows=747 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=620
-> 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) (actual rows=6069 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=5848
-> 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) (actual rows=786 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=668
-> 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) (actual rows=28088 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=27402
-> 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) (actual rows=601 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=504
-> 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) (actual rows=21839 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=7873
-> 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) (actual rows=4658 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=4356
-> 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) (actual rows=3479 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3144
-> 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) (actual rows=3171 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3017
-> 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) (actual rows=38 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=14
-> 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) (actual rows=85968 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=85203
-> 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) (actual rows=8877 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=4349
-> 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) (actual rows=82 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=19
-> 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) (actual rows=7120 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6665
-> 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) (actual rows=2269 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2064
-> 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) (actual rows=2244 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2051
-> 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) (actual rows=2464 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2242
-> 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) (actual rows=40 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6
-> 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) (actual rows=1884 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=1703
-> 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) (actual rows=12734 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=8702
-> 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) (actual rows=33 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=4
-> 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) (actual rows=2441 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2197
-> 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) (actual rows=47216 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=46377
-> 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) (actual rows=2361 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2133
-> 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) (actual rows=2136 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=1939
-> 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) (actual rows=2460 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2252
-> 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) (actual rows=2399 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2164
-> 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) (actual rows=2379 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2157
-> 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) (actual rows=18 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6
-> 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) (actual rows=4790 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=4406
-> 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) (actual rows=43 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=8
-> 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) (actual rows=5103 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=4658
-> 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) (actual rows=2770 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2476
-> 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) (actual rows=45 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=5
-> 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) (actual rows=39200 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=38018
-> 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) (actual rows=18280 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=16756
-> 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) (actual rows=3150 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2894
-> 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) (actual rows=48 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=9
-> 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) (actual rows=6699 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6217
-> 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) (actual rows=3191 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2939
-> 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) (actual rows=3364 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3074
-> 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) (actual rows=2646 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2407
-> 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) (actual rows=2877 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2644
-> 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) (actual rows=62045 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=61503
-> 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) (actual rows=2978 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=2722
-> 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) (actual rows=50 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6
-> 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) (actual rows=37830 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=36683
-> 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) (actual rows=142 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=46
-> 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) (actual rows=6981 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6610
-> 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) (actual rows=71 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=5
-> 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) (actual rows=27484 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=27085
-> 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) (actual rows=8304 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=7942
-> 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) (actual rows=10377 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=10069
-> 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) (actual rows=5199 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=5013
-> 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) (actual rows=7170 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6848
-> 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) (actual rows=17018 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=16428
-> 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) (actual rows=4256 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=4067
-> 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) (actual rows=6248 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6071
-> 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) (actual rows=57639 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=56385
-> 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) (actual rows=7020 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6604
-> 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) (actual rows=10060 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=9647
-> 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) (actual rows=7325 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6949
-> 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) (actual rows=7624 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=7323
-> 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) (actual rows=7507 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=7115
-> 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) (actual rows=9156 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=8819
-> 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) (actual rows=9292 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=8992
-> 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) (actual rows=7260 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=6970
-> 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) (actual rows=16300 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=15703
-> 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) (actual rows=8184 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=7920
-> 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) (actual rows=8871 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=8514
-> 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) (actual rows=55181 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=53946
-> 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) (actual rows=8636 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=8319
-> 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) (actual rows=8006 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=7710
-> 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) (actual rows=8611 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=8278
-> 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) (actual rows=11358 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=10963
-> 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) (actual rows=8758 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=8547
-> 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) (actual rows=9772 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=9557
-> 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) (actual rows=8333 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=8077
-> 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) (actual rows=11563 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=11140
-> 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) (actual rows=9085 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=8946
-> 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) (actual rows=9390 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=9275
-> 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) (actual rows=13024 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=12841
-> 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) (actual rows=53366 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=52293
-> 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) (actual rows=9818 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=9644
-> 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) (actual rows=9287 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=9054
-> 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) (actual rows=10244 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=10123
-> 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) (actual rows=10006 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=9831
-> 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) (actual rows=10790 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=10524
-> 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) (actual rows=10886 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=10779
-> 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) (actual rows=10625 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=10456
-> 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) (actual rows=11350 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=11207
-> 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) (actual rows=11165 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=11034
-> 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) (actual rows=11891 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=11813
-> 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) (actual rows=10684 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=10542
-> 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) (actual rows=104449 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=103545
-> 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) (actual rows=11395 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=11302
-> 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) (actual rows=12156 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=11978
-> 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) (actual rows=11615 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=11506
-> 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) (actual rows=11650 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=11517
-> 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) (actual rows=1 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=4
-> 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) (actual rows=2 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=5
-> 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) (actual rows=0 loops=1)
Index Cond: (credit_account_id = ANY (r.ids))
Buffers: shared hit=3
-> Seq Scan on transaction_2026_11 t_202 (cost=0.00..2.85 rows=10 width=15) (actual rows=0 loops=1)
Filter: (credit_account_id = ANY (r.ids))
Rows Removed by Filter: 38
Buffers: shared hit=2
-> Seq Scan on transaction_2026_12 t_203 (cost=0.00..0.00 rows=1 width=30) (actual rows=0 loops=1)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_01 t_204 (cost=0.00..0.00 rows=1 width=30) (actual rows=0 loops=1)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_02 t_205 (cost=0.00..0.00 rows=1 width=30) (actual rows=0 loops=1)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_03 t_206 (cost=0.00..0.00 rows=1 width=30) (actual rows=0 loops=1)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_04 t_207 (cost=0.00..0.00 rows=1 width=30) (actual rows=0 loops=1)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_05 t_208 (cost=0.00..0.00 rows=1 width=30) (actual rows=0 loops=1)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_06 t_209 (cost=0.00..0.00 rows=1 width=30) (actual rows=0 loops=1)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_07 t_210 (cost=0.00..0.00 rows=1 width=30) (actual rows=0 loops=1)
Filter: (credit_account_id = ANY (r.ids))
-> Seq Scan on transaction_2027_08 t_211 (cost=0.00..0.00 rows=1 width=30) (actual rows=0 loops=1)
Filter: (credit_account_id = ANY (r.ids))
-> Subquery Scan on "*SELECT* 2" (cost=0.42..328807.83 rows=25417295 width=36) (actual rows=3793896 loops=1)
Buffers: shared hit=352456 read=2885
I/O Timings: shared read=87.038
-> Nested Loop (cost=0.42..74634.88 rows=25417295 width=36) (actual rows=3793896 loops=1)
Buffers: shared hit=352456 read=2885
I/O Timings: shared read=87.038
-> CTE Scan on reserve_accounts r_1 (cost=0.00..0.02 rows=1 width=32) (actual rows=1 loops=1)
-> Append (cost=0.42..11005.94 rows=8568 width=14) (actual rows=3793896 loops=1)
Buffers: shared hit=352456 read=2885
I/O Timings: shared read=87.038
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=2
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=2
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=6
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=6
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=6
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=6
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=6
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=6
-> 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) (actual rows=1 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=7
-> 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) (actual rows=1 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=7
-> 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) (actual rows=2 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=7
-> 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) (actual rows=2 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=7
-> 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) (actual rows=2 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=8
-> 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) (actual rows=1 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=7
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=6
-> 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) (actual rows=19 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=24
-> 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) (actual rows=19 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=16
-> 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) (actual rows=10 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=13
-> 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) (actual rows=16 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=21
-> 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) (actual rows=20 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=21
-> 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) (actual rows=8 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=11
-> 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) (actual rows=7 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=13
-> 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) (actual rows=11 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=14
-> 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) (actual rows=5 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=11
-> 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) (actual rows=4 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=8
-> 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) (actual rows=4 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=10
-> 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) (actual rows=16 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=21
-> 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) (actual rows=9 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=15
-> 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) (actual rows=19 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=23
-> 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) (actual rows=12 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=18
-> 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) (actual rows=14 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=19
-> 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) (actual rows=8 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=13
-> 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) (actual rows=23 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=25
-> 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) (actual rows=14 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=18
-> 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) (actual rows=178 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=29
-> 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) (actual rows=5 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=7
-> 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) (actual rows=3 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=9
-> 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) (actual rows=10 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=16
-> 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) (actual rows=25 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=25
-> 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) (actual rows=18 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=20
-> 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) (actual rows=23 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=27
-> 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) (actual rows=24 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=21
-> 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) (actual rows=21 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=22
-> 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) (actual rows=17 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=18
-> 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) (actual rows=33 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=29
-> 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) (actual rows=24 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=25
-> 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) (actual rows=25 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=21
-> 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) (actual rows=17 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=17
-> 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) (actual rows=10 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=12
-> 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) (actual rows=10 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=14
-> 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) (actual rows=28 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=31
-> 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) (actual rows=63 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=48
-> 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) (actual rows=58 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=51
-> 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) (actual rows=44 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=41
-> 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) (actual rows=21 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=23
-> 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) (actual rows=14 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=19
-> 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) (actual rows=14 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=15
-> 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) (actual rows=11 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=11
-> 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) (actual rows=14 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=13
-> 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) (actual rows=11 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=11
-> 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) (actual rows=20 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=19
-> 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) (actual rows=77 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=25
-> 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) (actual rows=26 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=27
-> 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) (actual rows=53 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=51
-> 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) (actual rows=67 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=59
-> 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) (actual rows=43 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=41
-> 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) (actual rows=49 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=48
-> 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) (actual rows=27 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=28
-> 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) (actual rows=30 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=31
-> 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) (actual rows=38 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=41
-> 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) (actual rows=146923 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=1637 read=31
I/O Timings: shared read=0.201
-> 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) (actual rows=36 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=21 read=16
I/O Timings: shared read=0.069
-> 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) (actual rows=30 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=11 read=17
I/O Timings: shared read=0.072
-> 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) (actual rows=10694 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=10419 read=57
I/O Timings: shared read=4.609
-> 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) (actual rows=4121 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3836 read=41
I/O Timings: shared read=2.285
-> 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) (actual rows=3503 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3230 read=25
I/O Timings: shared read=0.822
-> 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) (actual rows=2966 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=2783 read=24
I/O Timings: shared read=3.369
-> 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) (actual rows=5795 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=5471 read=35
I/O Timings: shared read=7.575
-> 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) (actual rows=3313 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3013 read=24
I/O Timings: shared read=0.876
-> 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) (actual rows=11697 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=11331 read=53
I/O Timings: shared read=1.569
-> 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) (actual rows=4063 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3749 read=33
I/O Timings: shared read=2.828
-> 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) (actual rows=4048 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3736 read=33
I/O Timings: shared read=9.044
-> 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) (actual rows=4318 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=160 read=4
I/O Timings: shared read=0.796
-> 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) (actual rows=2788 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=2532 read=22
I/O Timings: shared read=1.219
-> 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) (actual rows=3010 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=2743 read=27
I/O Timings: shared read=1.028
-> 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) (actual rows=107942 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=107395 read=491
I/O Timings: shared read=9.523
-> 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) (actual rows=12222 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=11944 read=63
I/O Timings: shared read=1.554
-> 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) (actual rows=3890 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3601 read=26
I/O Timings: shared read=1.216
-> 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) (actual rows=4543 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=4234 read=32
I/O Timings: shared read=1.168
-> 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) (actual rows=4948 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=4662 read=31
I/O Timings: shared read=1.293
-> 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) (actual rows=4309 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3945 read=30
I/O Timings: shared read=1.313
-> 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) (actual rows=4446 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=4117 read=27
I/O Timings: shared read=1.226
-> 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) (actual rows=4749 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=4418 read=29
I/O Timings: shared read=0.897
-> 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) (actual rows=4301 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3983 read=23
I/O Timings: shared read=0.886
-> 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) (actual rows=760084 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=8461 read=642
I/O Timings: shared read=9.537
-> 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) (actual rows=3322 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3020 read=23
I/O Timings: shared read=0.768
-> 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) (actual rows=4477 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=4169 read=22
I/O Timings: shared read=1.033
-> 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) (actual rows=31633 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=31217 read=155
I/O Timings: shared read=3.851
-> 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) (actual rows=1774 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=1549 read=25
I/O Timings: shared read=0.662
-> 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) (actual rows=564 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=407 read=10
I/O Timings: shared read=0.632
-> 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) (actual rows=1995 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=1757 read=19
I/O Timings: shared read=0.706
-> 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) (actual rows=2725 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=2437 read=14
I/O Timings: shared read=1.043
-> 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) (actual rows=3098 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=2781 read=19
I/O Timings: shared read=1.133
-> 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) (actual rows=12327 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=11968 read=59
I/O Timings: shared read=1.325
-> 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) (actual rows=2307 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=1989 read=21
I/O Timings: shared read=0.710
-> 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) (actual rows=2389 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=2091 read=20
I/O Timings: shared read=1.082
-> 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) (actual rows=1648100 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=21021 read=662
I/O Timings: shared read=9.118
-> 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) (actual rows=1368 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=1145
-> 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) (actual rows=1375 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=1124
-> 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) (actual rows=6071 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=5809
-> 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) (actual rows=692 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=537
-> 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) (actual rows=525 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=398
-> 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) (actual rows=756 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=574
-> 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) (actual rows=628 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=404
-> 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) (actual rows=835 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=638
-> 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) (actual rows=886 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=649
-> 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) (actual rows=610 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=417
-> 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) (actual rows=613 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=402
-> 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) (actual rows=897192 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=10467
-> 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) (actual rows=545 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=386
-> 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) (actual rows=580 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=395
-> 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) (actual rows=2708 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=2469
-> 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) (actual rows=395 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=248
-> 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) (actual rows=387 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=226
-> 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) (actual rows=399 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=248
-> 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) (actual rows=464 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=319
-> 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) (actual rows=431 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=288
-> 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) (actual rows=482 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=285
-> 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) (actual rows=393 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=222
-> 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) (actual rows=523 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=302
-> 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) (actual rows=8959 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=324
-> 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) (actual rows=362 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=220
-> 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) (actual rows=247 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=123
-> 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) (actual rows=90 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=86
-> 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) (actual rows=120 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=96
-> 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) (actual rows=366 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=280
-> 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) (actual rows=108 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=53
-> 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) (actual rows=78 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=61
-> 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) (actual rows=124 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=95
-> 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) (actual rows=146 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=124
-> 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) (actual rows=185 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=127
-> 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) (actual rows=118 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=80
-> 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) (actual rows=161 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=67
-> 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) (actual rows=114 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=90
-> 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) (actual rows=128 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=79
-> 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) (actual rows=135 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=76
-> 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) (actual rows=139 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=107
-> 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) (actual rows=157 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=106
-> 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) (actual rows=129 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=106
-> 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) (actual rows=18233 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=18081
-> 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) (actual rows=107 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=93
-> 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) (actual rows=135 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=104
-> 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) (actual rows=136 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=89
-> 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) (actual rows=167 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=132
-> 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) (actual rows=310 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=102
-> 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) (actual rows=264 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=188
-> 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) (actual rows=333 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=203
-> 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) (actual rows=307 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=204
-> 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) (actual rows=366 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=235
-> 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) (actual rows=300 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=198
-> 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) (actual rows=321 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=199
-> 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) (actual rows=358 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=229
-> 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) (actual rows=237 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=134
-> 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) (actual rows=331 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=212
-> 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) (actual rows=496 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=358
-> 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) (actual rows=531 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=398
-> 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) (actual rows=420 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=101
-> 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) (actual rows=252 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=169
-> 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) (actual rows=299 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=198
-> 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) (actual rows=301 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=218
-> 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) (actual rows=652 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=465
-> 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) (actual rows=1272 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=921
-> 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) (actual rows=1268 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=1013
-> 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) (actual rows=922 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=690
-> 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) (actual rows=0 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> 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) (actual rows=4 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=4
-> 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) (actual rows=2 loops=1)
Index Cond: (debit_account_id = ANY (r_1.ids))
Buffers: shared hit=3
-> Seq Scan on transaction_2026_11 t_414 (cost=0.00..2.85 rows=9 width=15) (actual rows=0 loops=1)
Filter: (debit_account_id = ANY (r_1.ids))
Rows Removed by Filter: 38
Buffers: shared hit=2
-> Seq Scan on transaction_2026_12 t_415 (cost=0.00..0.00 rows=1 width=30) (actual rows=0 loops=1)
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) (actual rows=0 loops=1)
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) (actual rows=0 loops=1)
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) (actual rows=0 loops=1)
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) (actual rows=0 loops=1)
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) (actual rows=0 loops=1)
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) (actual rows=0 loops=1)
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) (actual rows=0 loops=1)
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) (actual rows=0 loops=1)
Filter: (debit_account_id = ANY (r_1.ids))
-> Hash (cost=437635.45..437635.45 rows=31263 width=31) (actual rows=3418993 loops=1)
Buckets: 2097152 (originally 32768) Batches: 4 (originally 1) Memory Usage: 60833kB
Buffers: shared hit=17914497 read=10476, temp written=17265
I/O Timings: shared read=9950.891, temp write=267.457
-> Hash Join (cost=18.37..437635.45 rows=31263 width=31) (actual rows=3418993 loops=1)
Hash Cond: (a.account_type_id = at.id)
Buffers: shared hit=17914497 read=10476, temp written=4358
I/O Timings: shared read=9950.891, temp write=37.809
-> Nested Loop (cost=0.56..436201.31 rows=534826 width=12) (actual rows=3738262 loops=1)
Buffers: shared hit=17914485 read=10476, temp written=4358
I/O Timings: shared read=9950.891, temp write=37.809
-> CTE Scan on ops_sharer s_1 (cost=0.00..2430.20 rows=121510 width=4) (actual rows=743051 loops=1)
Buffers: shared hit=11473679 read=10476, temp written=4358
I/O Timings: shared read=9950.891, temp write=37.809
-> Index Scan using idx_account_owner_sharer_id on account a (cost=0.56..3.53 rows=4 width=12) (actual rows=5 loops=743051)
Index Cond: (owner_sharer_id = s_1.id)
Buffers: shared hit=6440806
-> Hash (cost=17.45..17.45 rows=28 width=27) (actual rows=28 loops=1)
Buckets: 1024 Batches: 1 Memory Usage: 10kB
Buffers: shared hit=12
-> Bitmap Heap Scan on account_type at (cost=3.03..17.45 rows=28 width=27) (actual rows=28 loops=1)
Recheck Cond: ((mnemonics)::text = ANY ('{ОПС,"ОПС ГВ","ОПС КП","Р ПП ОПС","ОПС ИД","ОПС ФР","Р ПП ОПС ИД","ДПС Г","ДПС Г ГВ","ДПС Г КП","Р ПП ДПС Г","ДПС Г ИД","ДПС Г ФР","Р ПП ДПС Г ИД","ДПС Л","ДПС Л ГВ","ДПС Л КП","Р ПП ДПС Л","ДПС Л ИД","ДПС Л ФР","Р ПП ДПС Л ИД","ДПС МК","ДПС МК ГВ","ДПС МК КП","Р ПП ДПС МК","ДПС МК ИД","ДПС МК ФР","Р ПП ДПС МК ИД"}'::text[]))
Heap Blocks: exact=8
Buffers: shared hit=12
-> Bitmap Index Scan on account_type_mnemonics_idx1 (cost=0.00..2.96 rows=28 width=0) (actual rows=28 loops=1)
Index Cond: ((mnemonics)::text = ANY ('{ОПС,"ОПС ГВ","ОПС КП","Р ПП ОПС","ОПС ИД","ОПС ФР","Р ПП ОПС ИД","ДПС Г","ДПС Г ГВ","ДПС Г КП","Р ПП ДПС Г","ДПС Г ИД","ДПС Г ФР","Р ПП ДПС Г ИД","ДПС Л","ДПС Л ГВ","ДПС Л КП","Р ПП ДПС Л","ДПС Л ИД","ДПС Л ФР","Р ПП ДПС Л ИД","ДПС МК","ДПС МК ГВ","ДПС МК КП","Р ПП ДПС МК","ДПС МК ИД","ДПС МК ФР","Р ПП ДПС МК ИД"}'::text[]))
Buffers: shared hit=4
-> Index Scan using sharer_pkey on sharer s (cost=0.43..2.25 rows=1 width=24) (actual rows=1 loops=517494)
Index Cond: (id = a.owner_sharer_id)
Buffers: shared hit=2069976
-> Index Scan using individual_pkey on individual i (cost=2.54..2.66 rows=1 width=19) (actual rows=1 loops=517494)
Index Cond: (id = s.individual_id)
Filter: CASE WHEN (InitPlan 9).col1 THEN true WHEN (InitPlan 11).col1 THEN (ANY (id = (hashed SubPlan 12).col1)) ELSE (NOT (ANY (id = (hashed SubPlan 13).col1))) END
Buffers: shared hit=2068157 read=1819
I/O Timings: shared read=16.765
SubPlan 12
-> Unique (cost=2.09..2.10 rows=2 width=8) (never executed)
-> Sort (cost=2.09..2.09 rows=2 width=8) (never executed)
Sort Key: a_6.individual_id
-> Append (cost=0.00..2.08 rows=2 width=8) (never executed)
-> Nested Loop (cost=0.00..1.03 rows=1 width=8) (never executed)
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) (never executed)
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) (never executed)
-> Nested Loop (cost=0.00..1.03 rows=1 width=8) (never executed)
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) (never executed)
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) (never executed)
Filter: (individual_id IS NOT NULL)
SubPlan 13
-> Seq Scan on rbac_public_hidden_individual (cost=0.00..0.00 rows=1 width=8) (never executed)
-> Limit (cost=0.42..2.64 rows=1 width=12) (actual rows=1 loops=517494)
Buffers: shared hit=2069976
-> Index Scan using adi_last_by_individual_idx on application_death_info a_1 (cost=0.42..2.64 rows=1 width=12) (actual rows=1 loops=517494)
Index Cond: (individual_id = s.individual_id)
Buffers: shared hit=2069976
Planning:
Buffers: shared hit=268
Planning Time: 29.066 ms
Execution Time: 62855.558 ms