https://pastein.ru/t/caa
Загрузка данных
Insert on report.dia_rops (cost=14655379.19..14657148.71 rows=0 width=0)
CTE latest_death_info
-> Result (cost=0.42..57790.33 rows=634009 width=16)
Output: a_1.individual_id, a_1.death_date, a_1.version
-> Unique (cost=0.42..57790.33 rows=634009 width=16)
Output: a_1.id, a_1.number, a_1.date, a_1.death_date, a_1.death_info_date, a_1.death_certificate_date, a_1.death_certificate_number, a_1.death_info_certificate_code, a_1.comment, a_1.accepted, a_1.rejected, a_1.canceled, a_1.version, a_1.agent_id, a_1.individual_id, a_1.individual_document_id, a_1.death_certificate_place, a_1.person_death_registration_id, a_1.person_id, a_1.death_info_received_type_code, a_1.ops_transfer_register_id, a_1.source_document_info, a_1.is_svo, a_1.previous_death_info_id, a_1.is_not_death_date, a_1.death_date_month, a_1.death_date_year, a_1.transfered_balance_to_sr
-> Index Scan using adi_last_by_individual_idx on ourpension.application_death_info a_1 (cost=0.42..55594.82 rows=878205 width=16)
Output: a_1.id, a_1.number, a_1.date, a_1.death_date, a_1.death_info_date, a_1.death_certificate_date, a_1.death_certificate_number, a_1.death_info_certificate_code, a_1.comment, a_1.accepted, a_1.rejected, a_1.canceled, a_1.version, a_1.agent_id, a_1.individual_id, a_1.individual_document_id, a_1.death_certificate_place, a_1.person_death_registration_id, a_1.person_id, a_1.death_info_received_type_code, a_1.ops_transfer_register_id, a_1.source_document_info, a_1.is_svo, a_1.previous_death_info_id, a_1.is_not_death_date, a_1.death_date_month, a_1.death_date_year, a_1.transfered_balance_to_sr
CTE ops_sharer
-> Nested Loop Anti Join (cost=5.40..1756629.79 rows=121510 width=8)
Output: s_3.id, death_info.death_date
Join Filter: (o.effective_date <= p.report_date)
InitPlan 2
-> Result (cost=0.00..0.01 rows=1 width=1)
Output: (NULLIF(current_setting('app.user_id'::text, true), ''::text) IS NULL)
InitPlan 4
-> Result (cost=1.02..1.03 rows=1 width=1)
Output: (InitPlan 3).col1
InitPlan 3
-> Seq Scan on ourpension.user_group ug (cost=0.00..1.02 rows=1 width=0)
Filter: (ug.user_id = (NULLIF(current_setting('app.user_id'::text, true), ''::text))::bigint)
-> Nested Loop (cost=2.93..923462.50 rows=131961 width=12)
Output: death_info.death_date, p.report_date, s_3.id
Inner Unique: true
-> Nested Loop (cost=0.43..211876.92 rows=277417 width=16)
Output: death_info.death_date, p.report_date, s_3.id, s_3.contract_id
-> Nested Loop (cost=0.00..20606.30 rows=211336 width=12)
Output: death_info.death_date, death_info.individual_id, p.report_date
Join Filter: (death_info.death_date <= p.report_date)
-> Seq Scan on report.dia_param p (cost=0.00..1.01 rows=1 width=4)
Output: p.report_date, p.unload_perconal_data, p."user", p.register_kind
-> CTE Scan on latest_death_info death_info (cost=0.00..12680.18 rows=634009 width=8)
Output: death_info.individual_id, death_info.death_date
-> Index Scan using sharer_individual_id_idx on ourpension.sharer s_3 (cost=0.43..0.90 rows=1 width=12)
Output: s_3.id, s_3.annulled, s_3.approved, s_3.created, s_3.init_order_date, s_3.init_order_number, s_3.version, s_3.annulled_agent_id, s_3.approved_agent_id, s_3.contract_id, s_3.created_agent_id, s_3.individual_id, s_3.sharer, s_3.bank_details_id, s_3.number, s_3.close_date, s_3.closed, s_3.closed_agent_id, s_3.closed_reason_id, s_3.pension_program_id, s_3.inheritance_type_code, s_3.investor_pension, s_3.first_payment_persent, s_3.retiree, s_3.service_length, s_3.dismiss_date, s_3.district_k, s_3.monthly_salary, s_3.periodicity_code, s_3.payout_duration, s_3.open_date, s_3.npo_pension_type_id, s_3.comment, s_3.sharer_id_1c, s_3.contract_id_1c, s_3.person_id, s_3.scheme_id, s_3.not_displayed_in_lkk, s_3.code_1c, s_3.entity_id, s_3.inheritance_on_accum, s_3.inheritance_on_pay
Index Cond: (s_3.individual_id = death_info.individual_id)
-> Index Scan using contract_pkey on ourpension.contract c (cost=2.50..2.57 rows=1 width=4)
Output: c.id
Index Cond: (c.id = s_3.contract_id)
Filter: (((c.service_type)::text = 'OPS'::text) AND CASE WHEN (InitPlan 2).col1 THEN true WHEN (InitPlan 4).col1 THEN (ANY (c.id = (hashed SubPlan 5).col1)) ELSE (NOT (ANY (c.id = (hashed SubPlan 6).col1))) END)
SubPlan 5
-> Nested Loop (cost=0.00..1.03 rows=1 width=8)
Output: a_2.contract_id
Join Filter: (ug_1.group_id = a_2.group_id)
-> Seq Scan on ourpension.user_group ug_1 (cost=0.00..1.02 rows=1 width=8)
Output: ug_1.user_id, ug_1.group_id, ug_1.created_at
Filter: (ug_1.user_id = (NULLIF(current_setting('app.user_id'::text, true), ''::text))::bigint)
-> Seq Scan on ourpension.rbac_contract_access a_2 (cost=0.00..0.00 rows=1 width=16)
Output: a_2.group_id, a_2.contract_id
SubPlan 6
-> Nested Loop (cost=0.00..1.02 rows=1 width=8)
Output: a_3.contract_id
Inner Unique: true
Join Filter: (a_3.group_id = g.id)
-> Seq Scan on ourpension.rbac_contract_access a_3 (cost=0.00..0.00 rows=1 width=16)
Output: a_3.group_id, a_3.contract_id
-> Seq Scan on ourpension.individual_groups g (cost=0.00..1.01 rows=1 width=4)
Output: g.id
Filter: g.hidden_from_external
-> Nested Loop (cost=1.43..3.09 rows=291 width=8)
Output: d.sharer_id, o.effective_date
Inner Unique: true
-> Nested Loop (cost=1.00..2.20 rows=2 width=16)
Output: d.ops_transfer_register_id, d.sharer_id, o.ops_transfer_register_id, o.effective_date
-> Index Scan using ops_transfer_details_sharer_id on back_office.ops_transfer_details d (cost=0.43..0.48 rows=2 width=8)
Output: d.ops_transfer_register_id, d.sharer_id, d.ops_fixing_id, d.new_insurer, d.previos_insurer, d.transfer_type, d.transfer_reason, d.pension_type, d.smev_uier_id, d.new_insurer_inn, d.balance, d.balance_sv, d.balance_dsv, d.balance_vr, d.balance_sofn, d.balance_msk, d.revenue, d.revenue_sv, d.revenue_dsv, d.revenue_vr, d.revenue_sofn, d.revenue_msk, d.transfer, d.transfer_sv, d.transfer_dsv, d.transfer_vr, d.transfer_sofn, d.transfer_msk, d.version, d.transfer_revenue_sv, d.transfer_revenue_dsv, d.transfer_revenue_vr, d.transfer_revenue_sofn, d.transfer_revenue_msk, d.transfer_revenue, d.fund_id, d.reserve, d.fund_bank_payment_type_id, d.entity_id
Index Cond: (d.sharer_id = s_3.id)
-> Index Scan using idx_operation_transfer_register_id on back_office.operation o (cost=0.57..0.85 rows=1 width=8)
Output: o.id, o.operation_type_id, o.author_agent_id, o.approver_agent_id, o.remover_agent_id, o.operation_date, o.effective_date, o.created, o.approved, o.deleted, o.query_datasource_file_id, o.version, o.period_date, o.comment, o.ops_payment_decision_id, o.payment_order_register_id, o.investment_revenue_calculation_id, o.pension_calculation_id, o.inheritance_calculation_id, o.termination_contract_calculation_id, o.payment_register_id, o.payment_return_id, o.inherited_payment_id, o.ops_assignee_decision_id, o.ops_payment_register_id, o.ops_fixing_id, o.ops_transfer_register_id, o.ops_payment_return_id, o.operation_document_id, o.revoked, o.revoker_agent_id, o.compensation_calculation_id, o.resumption_id, o.overpayment_return_id, o.inheritance_pension_calculation_id, o.ops_court_decision_id, o.ops_income_payment_order_id_1c, o.ops_deposit_enrollment_operation_id_1c, o.ops_transfer_to_reserve_id_1c, o.ops_payment_decision_id_1c, o.ops_transfer_to_assignee_reserve_id_1c, o.ops_investment_revenue_enrollment_id_1c, o.pension_charge_from_reserve_id_1c, o.ops_assignee_decision_id_1c, o.assignee_charge_from_reserve_id_1c, o.ops_transfer_operation_id_1c, o.ops_transfer_register_id_1c, o.ops_payment_register_hash_id_1c, o.ops_payment_register_operation_id_1c, o.ops_payment_return_hash_id_1c, o.ops_payment_return_operation_id_1c, o.ops_transfer_from_rops_operation_hash_id_1c, o.ops_correction_pfr_operation_hash_id_1c, o.ops_transfers_between_accounts_operation_hash_id_1c, o.ops_transfers_to_fund_reserve_pair_operation_hash_id_1c, o.ops_transfers_to_fund_reserve_single_operation_hash_id_1c, o.ops_misgrading_adjustment_operation_hash_id_1c, o.ops_manual_temporary_operation_hash_id_1c, o.ops_pension_savings_enrollment_operation_hash_id_1c, o.ops_income_from_own_funds_operation_hash_id_1c, o.ops_compensation_from_own_funds_operation_hash_id_1c, o.ops_commission_np_from_fund_reserve_operation_hash_id_1c, o.ops_return_from_fund_reserve_operation_id, o.ops_termination_pension_payments_operation_hash_id_1c, o.id_1c, o."incoming_order_id_1с", o.pension_calculation_id_1c, o.termination_contract_calculation_id_1c, o."inheritance_calculation_id_1с", o.payment_order_number, o.date_order_number, o.payment_return_id_1c, o.death_info_id, o.ops_transfer_pds_operation_hash_id_1c, o.npo_fixing_id, o.insurance_reserve_register_id, o.pds_payment_decision_id, o.accrual_repurchase_payments_inheritors_details_id, o.accrual_repurchase_amount_payments_details_id, o.pds_assignee_decision_id, o.ops_recovery_enrollment_operation_hash_id_1c
Index Cond: (o.ops_transfer_register_id = d.ops_transfer_register_id)
Filter: (o.approved IS NOT NULL)
-> Index Only Scan using ops_transfer_register_pk on back_office.ops_transfer_register tr (cost=0.42..0.45 rows=1 width=4)
Output: tr.id
Index Cond: (tr.id = d.ops_transfer_register_id)
-> Subquery Scan on "*SELECT*" (cost=12840959.07..12842728.59 rows=100 width=765)
Output: "*SELECT*".nextval, "*SELECT*".insurance_number, "*SELECT*".ops, "*SELECT*".ops_id, "*SELECT*".dps_l, "*SELECT*".dps_l_id, "*SELECT*".dps_g, "*SELECT*".dps_g_id, "*SELECT*".dps_mk, "*SELECT*".dps_mk_id, "*SELECT*".balance, "*SELECT*".currval, NULL::character varying(200), "*SELECT*".death_date, "*SELECT*".number, "*SELECT*".id
-> Nested Loop (cost=12840959.07..12842724.59 rows=100 width=343)
Output: nextval('report.dia_rops_id_sequence'::regclass), currval('report.dia_register_id_sequence'::regclass), i.insurance_number, s.number, a.death_date, (sum("*SELECT* 1".ops)), (sum("*SELECT* 1".ops_id)), (sum("*SELECT* 1".dps_l)), (sum("*SELECT* 1".dps_l_id)), (sum("*SELECT* 1".dps_g)), (sum("*SELECT* 1".dps_g_id)), (sum("*SELECT* 1".dps_mk)), (sum("*SELECT* 1".dps_mk_id)), (sum("*SELECT* 1".balance)), s.id
InitPlan 8
-> Result (cost=0.00..0.01 rows=1 width=1)
Output: (NULLIF(current_setting('app.user_id'::text, true), ''::text) IS NULL)
InitPlan 10
-> Result (cost=1.02..1.03 rows=1 width=1)
Output: (InitPlan 9).col1
InitPlan 9
-> Seq Scan on ourpension.user_group ug_2 (cost=0.00..1.02 rows=1 width=0)
Filter: (ug_2.user_id = (NULLIF(current_setting('app.user_id'::text, true), ''::text))::bigint)
-> Nested Loop (cost=12840957.60..12842456.79 rows=100 width=327)
Output: (sum("*SELECT* 1".ops)), (sum("*SELECT* 1".ops_id)), (sum("*SELECT* 1".dps_l)), (sum("*SELECT* 1".dps_l_id)), (sum("*SELECT* 1".dps_g)), (sum("*SELECT* 1".dps_g_id)), (sum("*SELECT* 1".dps_mk)), (sum("*SELECT* 1".dps_mk_id)), (sum("*SELECT* 1".balance)), s.number, s.id, s.individual_id, i.insurance_number
Inner Unique: true
-> Nested Loop (cost=12840955.05..12841927.96 rows=199 width=312)
Output: (sum("*SELECT* 1".ops)), (sum("*SELECT* 1".ops_id)), (sum("*SELECT* 1".dps_l)), (sum("*SELECT* 1".dps_l_id)), (sum("*SELECT* 1".dps_g)), (sum("*SELECT* 1".dps_g_id)), (sum("*SELECT* 1".dps_mk)), (sum("*SELECT* 1".dps_mk_id)), (sum("*SELECT* 1".balance)), s.number, s.id, s.individual_id
Inner Unique: true
-> GroupAggregate (cost=12840954.62..12841398.13 rows=199 width=292)
Output: "*SELECT* 1".sharer_id, sum("*SELECT* 1".ops), sum("*SELECT* 1".ops_id), sum("*SELECT* 1".dps_g), sum("*SELECT* 1".dps_g_id), sum("*SELECT* 1".dps_l), sum("*SELECT* 1".dps_l_id), sum("*SELECT* 1".dps_mk), sum("*SELECT* 1".dps_mk_id), sum("*SELECT* 1".balance)
Group Key: "*SELECT* 1".sharer_id
Filter: (sum("*SELECT* 1".balance) <> '0'::numeric)
-> Merge Append (cost=12840954.62..12841318.98 rows=2886 width=292)
Sort Key: "*SELECT* 1".sharer_id
-> Subquery Scan on "*SELECT* 1" (cost=7012313.48..7012464.99 rows=1443 width=292)
Output: "*SELECT* 1".sharer_id, "*SELECT* 1".ops, "*SELECT* 1".ops_id, "*SELECT* 1".dps_g, "*SELECT* 1".dps_g_id, "*SELECT* 1".dps_l, "*SELECT* 1".dps_l_id, "*SELECT* 1".dps_mk, "*SELECT* 1".dps_mk_id, "*SELECT* 1".balance
-> GroupAggregate (cost=7012313.48..7012450.56 rows=1443 width=292)
Output: da.owner_sharer_id, sum(t.value), sum(CASE WHEN ((dat.mnemonics)::text = ANY ('{ОПС,"ОПС ГВ","ОПС КП","Р ПП ОПС"}'::text[])) THEN t.value ELSE '0'::numeric END), sum(CASE WHEN ((dat.mnemonics)::text = ANY ('{"ОПС ИД","ОПС ФР","Р ПП ОПС ИД"}'::text[])) THEN t.value ELSE '0'::numeric END), sum(CASE WHEN ((dat.mnemonics)::text = ANY ('{"ДПС Г","ДПС Г ГВ","ДПС Г КП","Р ПП ДПС Г"}'::text[])) THEN t.value ELSE '0'::numeric END), sum(CASE WHEN ((dat.mnemonics)::text = ANY ('{"ДПС Г ИД","ДПС Г ФР","Р ПП ДПС Г ИД"}'::text[])) THEN t.value ELSE '0'::numeric END), sum(CASE WHEN ((dat.mnemonics)::text = ANY ('{"ДПС Л","ДПС Л ГВ","ДПС Л КП","Р ПП ДПС Л"}'::text[])) THEN t.value ELSE '0'::numeric END), sum(CASE WHEN ((dat.mnemonics)::text = ANY ('{"ДПС Л ИД","ДПС Л ФР","Р ПП ДПС Л ИД"}'::text[])) THEN t.value ELSE '0'::numeric END), sum(CASE WHEN ((dat.mnemonics)::text = ANY ('{"ДПС МК","ДПС МК ГВ","ДПС МК КП","Р ПП ДПС МК"}'::text[])) THEN t.value ELSE '0'::numeric END), sum(CASE WHEN ((dat.mnemonics)::text = ANY ('{"ДПС МК ИД","ДПС МК ФР","Р ПП ДПС МК ИД"}'::text[])) THEN t.value ELSE '0'::numeric END)
Group Key: da.owner_sharer_id
-> Sort (cost=7012313.48..7012317.09 rows=1443 width=33)
Output: da.owner_sharer_id, t.value, dat.mnemonics
Sort Key: da.owner_sharer_id
-> Nested Loop (cost=19.64..7012237.76 rows=1443 width=33)
Output: da.owner_sharer_id, t.value, dat.mnemonics
Inner Unique: true
-> Nested Loop (cost=19.35..7003551.90 rows=345709 width=37)
Output: da.owner_sharer_id, dat.mnemonics, t.value, ca.account_type_id
Inner Unique: true
-> Nested Loop (cost=18.79..6729535.71 rows=345709 width=37)
Output: da.owner_sharer_id, dat.mnemonics, t.value, t.credit_account_id
-> Hash Join (cost=18.37..437635.45 rows=31263 width=31)
Output: da.owner_sharer_id, da.id, dat.mnemonics
Inner Unique: true
Hash Cond: (da.account_type_id = dat.id)
-> Nested Loop (cost=0.56..436201.31 rows=534826 width=12)
Output: da.owner_sharer_id, da.account_type_id, da.id
-> CTE Scan on ops_sharer s_1 (cost=0.00..2430.20 rows=121510 width=4)
Output: s_1.id, s_1.individual_death_date
-> Index Scan using idx_account_owner_sharer_id on back_office.account da (cost=0.56..3.53 rows=4 width=12)
Output: da.id, da.operation_id, da.account_type_id, da.owner_contract_id, da.owner_sharer_id, da.owner_individual_id, da.owner_entity_id, da.version
Index Cond: (da.owner_sharer_id = s_1.id)
-> Hash (cost=17.45..17.45 rows=28 width=27)
Output: dat.mnemonics, dat.id
-> Bitmap Heap Scan on back_office.account_type dat (cost=3.03..17.45 rows=28 width=27)
Output: dat.mnemonics, dat.id
Recheck Cond: ((dat.mnemonics)::text = ANY ('{ОПС,"ОПС ГВ","ОПС КП","Р ПП ОПС","ОПС ИД","ОПС ФР","Р ПП ОПС ИД","ДПС Г","ДПС Г ГВ","ДПС Г КП","Р ПП ДПС Г","ДПС Г ИД","ДПС Г ФР","Р ПП ДПС Г ИД","ДПС Л","ДПС Л ГВ","ДПС Л КП","Р ПП ДПС Л","ДПС Л ИД","ДПС Л ФР","Р ПП ДПС Л ИД","ДПС МК","ДПС МК ГВ","ДПС МК КП","Р ПП ДПС МК","ДПС МК ИД","ДПС МК ФР","Р ПП ДПС МК ИД"}'::text[]))
-> Bitmap Index Scan on account_type_mnemonics_idx1 (cost=0.00..2.96 rows=28 width=0)
Index Cond: ((dat.mnemonics)::text = ANY ('{ОПС,"ОПС ГВ","ОПС КП","Р ПП ОПС","ОПС ИД","ОПС ФР","Р ПП ОПС ИД","ДПС Г","ДПС Г ГВ","ДПС Г КП","Р ПП ДПС Г","ДПС Г ИД","ДПС Г ФР","Р ПП ДПС Г ИД","ДПС Л","ДПС Л ГВ","ДПС Л КП","Р ПП ДПС Л","ДПС Л ИД","ДПС Л ФР","Р ПП ДПС Л ИД","ДПС МК","ДПС МК ГВ","ДПС МК КП","Р ПП ДПС МК","ДПС МК ИД","ДПС МК ФР","Р ПП ДПС МК ИД"}'::text[]))
-> Append (cost=0.42..192.42 rows=884 width=14)
-> Index Scan using transaction_2000_debit_account_id_effective_date_idx on back_office.transaction_2000 t_1 (cost=0.42..0.91 rows=4 width=14)
Output: t_1.value, t_1.debit_account_id, t_1.credit_account_id
Index Cond: (t_1.debit_account_id = da.id)
-> Index Scan using transaction_2001_debit_account_id_effective_date_idx on back_office.transaction_2001 t_2 (cost=0.29..1.02 rows=6 width=14)
Output: t_2.value, t_2.debit_account_id, t_2.credit_account_id
Index Cond: (t_2.debit_account_id = da.id)
-> Index Scan using transaction_2002_debit_account_id_effective_date_idx on back_office.transaction_2002 t_3 (cost=0.29..1.00 rows=6 width=14)
Output: t_3.value, t_3.debit_account_id, t_3.credit_account_id
Index Cond: (t_3.debit_account_id = da.id)
-> Index Scan using transaction_2003_debit_account_id_effective_date_idx on back_office.transaction_2003 t_4 (cost=0.42..1.21 rows=7 width=14)
Output: t_4.value, t_4.debit_account_id, t_4.credit_account_id
Index Cond: (t_4.debit_account_id = da.id)
-> Index Scan using transaction_2004_debit_account_id_effective_date_idx on back_office.transaction_2004 t_5 (cost=0.42..1.10 rows=6 width=14)
Output: t_5.value, t_5.debit_account_id, t_5.credit_account_id
Index Cond: (t_5.debit_account_id = da.id)
-> Index Scan using transaction_2005_debit_account_id_effective_date_idx on back_office.transaction_2005 t_6 (cost=0.43..2.78 rows=21 width=13)
Output: t_6.value, t_6.debit_account_id, t_6.credit_account_id
Index Cond: (t_6.debit_account_id = da.id)
-> Index Scan using transaction_2006_debit_account_id_effective_date_idx on back_office.transaction_2006 t_7 (cost=0.43..3.34 rows=26 width=14)
Output: t_7.value, t_7.debit_account_id, t_7.credit_account_id
Index Cond: (t_7.debit_account_id = da.id)
-> Index Scan using transaction_2007_debit_account_id_effective_date_idx on back_office.transaction_2007 t_8 (cost=0.43..3.69 rows=29 width=13)
Output: t_8.value, t_8.debit_account_id, t_8.credit_account_id
Index Cond: (t_8.debit_account_id = da.id)
-> Index Scan using transaction_2008_debit_account_id_effective_date_idx on back_office.transaction_2008 t_9 (cost=0.43..3.69 rows=29 width=14)
Output: t_9.value, t_9.debit_account_id, t_9.credit_account_id
Index Cond: (t_9.debit_account_id = da.id)
-> Index Scan using transaction_2009_debit_account_id_effective_date_idx on back_office.transaction_2009 t_10 (cost=0.43..3.81 rows=30 width=14)
Output: t_10.value, t_10.debit_account_id, t_10.credit_account_id
Index Cond: (t_10.debit_account_id = da.id)
-> Index Scan using transaction_2010_debit_account_id_effective_date_idx on back_office.transaction_2010 t_11 (cost=0.43..3.81 rows=30 width=14)
Output: t_11.value, t_11.debit_account_id, t_11.credit_account_id
Index Cond: (t_11.debit_account_id = da.id)
-> Index Scan using transaction_2011_01_debit_account_id_effective_date_idx on back_office.transaction_2011_01 t_12 (cost=0.42..0.83 rows=3 width=14)
Output: t_12.value, t_12.debit_account_id, t_12.credit_account_id
Index Cond: (t_12.debit_account_id = da.id)
-> Index Scan using transaction_2011_02_debit_account_id_effective_date_idx on back_office.transaction_2011_02 t_13 (cost=0.42..0.83 rows=3 width=14)
Output: t_13.value, t_13.debit_account_id, t_13.credit_account_id
Index Cond: (t_13.debit_account_id = da.id)
-> Index Scan using transaction_2011_03_debit_account_id_effective_date_idx on back_office.transaction_2011_03 t_14 (cost=0.43..0.80 rows=3 width=14)
Output: t_14.value, t_14.debit_account_id, t_14.credit_account_id
Index Cond: (t_14.debit_account_id = da.id)
-> Index Scan using transaction_2011_04_debit_account_id_effective_date_idx on back_office.transaction_2011_04 t_15 (cost=0.42..0.83 rows=3 width=14)
Output: t_15.value, t_15.debit_account_id, t_15.credit_account_id
Index Cond: (t_15.debit_account_id = da.id)
-> Index Scan using transaction_2011_05_debit_account_id_effective_date_idx on back_office.transaction_2011_05 t_16 (cost=0.43..0.84 rows=3 width=13)
Output: t_16.value, t_16.debit_account_id, t_16.credit_account_id
Index Cond: (t_16.debit_account_id = da.id)
-> Index Scan using transaction_2011_06_debit_account_id_effective_date_idx on back_office.transaction_2011_06 t_17 (cost=0.42..0.84 rows=3 width=14)
Output: t_17.value, t_17.debit_account_id, t_17.credit_account_id
Index Cond: (t_17.debit_account_id = da.id)
-> Index Scan using transaction_2011_07_debit_account_id_effective_date_idx on back_office.transaction_2011_07 t_18 (cost=0.42..0.84 rows=3 width=13)
Output: t_18.value, t_18.debit_account_id, t_18.credit_account_id
Index Cond: (t_18.debit_account_id = da.id)
-> Index Scan using transaction_2011_08_debit_account_id_effective_date_idx on back_office.transaction_2011_08 t_19 (cost=0.42..0.83 rows=3 width=14)
Output: t_19.value, t_19.debit_account_id, t_19.credit_account_id
Index Cond: (t_19.debit_account_id = da.id)
-> Index Scan using transaction_2011_09_debit_account_id_effective_date_idx on back_office.transaction_2011_09 t_20 (cost=0.43..0.84 rows=3 width=13)
Output: t_20.value, t_20.debit_account_id, t_20.credit_account_id
Index Cond: (t_20.debit_account_id = da.id)
-> Index Scan using transaction_2011_10_debit_account_id_effective_date_idx on back_office.transaction_2011_10 t_21 (cost=0.42..0.84 rows=3 width=14)
Output: t_21.value, t_21.debit_account_id, t_21.credit_account_id
Index Cond: (t_21.debit_account_id = da.id)
-> Index Scan using transaction_2011_11_debit_account_id_effective_date_idx on back_office.transaction_2011_11 t_22 (cost=0.43..0.84 rows=3 width=13)
Output: t_22.value, t_22.debit_account_id, t_22.credit_account_id
Index Cond: (t_22.debit_account_id = da.id)
-> Index Scan using transaction_2011_12_debit_account_id_effective_date_idx on back_office.transaction_2011_12 t_23 (cost=0.43..0.95 rows=4 width=14)
Output: t_23.value, t_23.debit_account_id, t_23.credit_account_id
Index Cond: (t_23.debit_account_id = da.id)
-> Index Scan using transaction_2012_01_debit_account_id_effective_date_idx on back_office.transaction_2012_01 t_24 (cost=0.42..0.84 rows=3 width=14)
Output: t_24.value, t_24.debit_account_id, t_24.credit_account_id
Index Cond: (t_24.debit_account_id = da.id)
-> Index Scan using transaction_2012_02_debit_account_id_effective_date_idx on back_office.transaction_2012_02 t_25 (cost=0.42..0.83 rows=3 width=14)
Output: t_25.value, t_25.debit_account_id, t_25.credit_account_id
Index Cond: (t_25.debit_account_id = da.id)
-> Index Scan using transaction_2012_03_debit_account_id_effective_date_idx on back_office.transaction_2012_03 t_26 (cost=0.43..0.71 rows=2 width=13)
Output: t_26.value, t_26.debit_account_id, t_26.credit_account_id
Index Cond: (t_26.debit_account_id = da.id)
-> Index Scan using transaction_2012_04_debit_account_id_effective_date_idx on back_office.transaction_2012_04 t_27 (cost=0.42..0.83 rows=3 width=14)
Output: t_27.value, t_27.debit_account_id, t_27.credit_account_id
Index Cond: (t_27.debit_account_id = da.id)
-> Index Scan using transaction_2012_05_debit_account_id_effective_date_idx on back_office.transaction_2012_05 t_28 (cost=0.42..0.84 rows=3 width=14)
Output: t_28.value, t_28.debit_account_id, t_28.credit_account_id
Index Cond: (t_28.debit_account_id = da.id)
-> Index Scan using transaction_2012_06_debit_account_id_effective_date_idx on back_office.transaction_2012_06 t_29 (cost=0.43..0.85 rows=3 width=13)
Output: t_29.value, t_29.debit_account_id, t_29.credit_account_id
Index Cond: (t_29.debit_account_id = da.id)
-> Index Scan using transaction_2012_07_debit_account_id_effective_date_idx on back_office.transaction_2012_07 t_30 (cost=0.42..0.84 rows=3 width=13)
Output: t_30.value, t_30.debit_account_id, t_30.credit_account_id
Index Cond: (t_30.debit_account_id = da.id)
-> Index Scan using transaction_2012_08_debit_account_id_effective_date_idx on back_office.transaction_2012_08 t_31 (cost=0.43..0.71 rows=2 width=14)
Output: t_31.value, t_31.debit_account_id, t_31.credit_account_id
Index Cond: (t_31.debit_account_id = da.id)
-> Index Scan using transaction_2012_09_debit_account_id_effective_date_idx on back_office.transaction_2012_09 t_32 (cost=0.43..0.85 rows=3 width=13)
Output: t_32.value, t_32.debit_account_id, t_32.credit_account_id
Index Cond: (t_32.debit_account_id = da.id)
-> Index Scan using transaction_2012_10_debit_account_id_effective_date_idx on back_office.transaction_2012_10 t_33 (cost=0.43..0.71 rows=2 width=14)
Output: t_33.value, t_33.debit_account_id, t_33.credit_account_id
Index Cond: (t_33.debit_account_id = da.id)
-> Index Scan using transaction_2012_11_debit_account_id_effective_date_idx on back_office.transaction_2012_11 t_34 (cost=0.42..0.83 rows=3 width=14)
Output: t_34.value, t_34.debit_account_id, t_34.credit_account_id
Index Cond: (t_34.debit_account_id = da.id)
-> Index Scan using transaction_2012_12_debit_account_id_effective_date_idx on back_office.transaction_2012_12 t_35 (cost=0.43..0.72 rows=2 width=14)
Output: t_35.value, t_35.debit_account_id, t_35.credit_account_id
Index Cond: (t_35.debit_account_id = da.id)
-> Index Scan using transaction_2013_01_debit_account_id_effective_date_idx on back_office.transaction_2013_01 t_36 (cost=0.42..0.83 rows=3 width=14)
Output: t_36.value, t_36.debit_account_id, t_36.credit_account_id
Index Cond: (t_36.debit_account_id = da.id)
-> Index Scan using transaction_2013_02_debit_account_id_effective_date_idx on back_office.transaction_2013_02 t_37 (cost=0.42..0.82 rows=3 width=14)
Output: t_37.value, t_37.debit_account_id, t_37.credit_account_id
Index Cond: (t_37.debit_account_id = da.id)
-> Index Scan using transaction_2013_03_debit_account_id_effective_date_idx on back_office.transaction_2013_03 t_38 (cost=0.43..0.72 rows=2 width=13)
Output: t_38.value, t_38.debit_account_id, t_38.credit_account_id
Index Cond: (t_38.debit_account_id = da.id)
-> Index Scan using transaction_2013_04_debit_account_id_effective_date_idx on back_office.transaction_2013_04 t_39 (cost=0.43..0.72 rows=2 width=14)
Output: t_39.value, t_39.debit_account_id, t_39.credit_account_id
Index Cond: (t_39.debit_account_id = da.id)
-> Index Scan using transaction_2013_05_debit_account_id_effective_date_idx on back_office.transaction_2013_05 t_40 (cost=0.43..0.84 rows=3 width=13)
Output: t_40.value, t_40.debit_account_id, t_40.credit_account_id
Index Cond: (t_40.debit_account_id = da.id)
-> Index Scan using transaction_2013_06_debit_account_id_effective_date_idx on back_office.transaction_2013_06 t_41 (cost=0.43..0.96 rows=4 width=13)
Output: t_41.value, t_41.debit_account_id, t_41.credit_account_id
Index Cond: (t_41.debit_account_id = da.id)
-> Index Scan using transaction_2013_07_debit_account_id_effective_date_idx on back_office.transaction_2013_07 t_42 (cost=0.42..0.83 rows=3 width=14)
Output: t_42.value, t_42.debit_account_id, t_42.credit_account_id
Index Cond: (t_42.debit_account_id = da.id)
-> Index Scan using transaction_2013_08_debit_account_id_effective_date_idx on back_office.transaction_2013_08 t_43 (cost=0.42..0.83 rows=3 width=14)
Output: t_43.value, t_43.debit_account_id, t_43.credit_account_id
Index Cond: (t_43.debit_account_id = da.id)
-> Index Scan using transaction_2013_09_debit_account_id_effective_date_idx on back_office.transaction_2013_09 t_44 (cost=0.43..0.82 rows=3 width=13)
Output: t_44.value, t_44.debit_account_id, t_44.credit_account_id
Index Cond: (t_44.debit_account_id = da.id)
-> Index Scan using transaction_2013_10_debit_account_id_effective_date_idx on back_office.transaction_2013_10 t_45 (cost=0.43..0.83 rows=3 width=13)
Output: t_45.value, t_45.debit_account_id, t_45.credit_account_id
Index Cond: (t_45.debit_account_id = da.id)
-> Index Scan using transaction_2013_11_debit_account_id_effective_date_idx on back_office.transaction_2013_11 t_46 (cost=0.42..0.84 rows=3 width=14)
Output: t_46.value, t_46.debit_account_id, t_46.credit_account_id
Index Cond: (t_46.debit_account_id = da.id)
-> Index Scan using transaction_2013_12_debit_account_id_effective_date_idx on back_office.transaction_2013_12 t_47 (cost=0.43..0.94 rows=4 width=14)
Output: t_47.value, t_47.debit_account_id, t_47.credit_account_id
Index Cond: (t_47.debit_account_id = da.id)
-> Index Scan using transaction_2014_01_debit_account_id_effective_date_idx on back_office.transaction_2014_01 t_48 (cost=0.42..0.83 rows=3 width=14)
Output: t_48.value, t_48.debit_account_id, t_48.credit_account_id
Index Cond: (t_48.debit_account_id = da.id)
-> Index Scan using transaction_2014_02_debit_account_id_effective_date_idx on back_office.transaction_2014_02 t_49 (cost=0.42..0.83 rows=3 width=14)
Output: t_49.value, t_49.debit_account_id, t_49.credit_account_id
Index Cond: (t_49.debit_account_id = da.id)
-> Index Scan using transaction_2014_03_debit_account_id_effective_date_idx on back_office.transaction_2014_03 t_50 (cost=0.43..0.71 rows=2 width=14)
Output: t_50.value, t_50.debit_account_id, t_50.credit_account_id
Index Cond: (t_50.debit_account_id = da.id)
-> Index Scan using transaction_2014_04_debit_account_id_effective_date_idx on back_office.transaction_2014_04 t_51 (cost=0.42..0.83 rows=3 width=14)
Output: t_51.value, t_51.debit_account_id, t_51.credit_account_id
Index Cond: (t_51.debit_account_id = da.id)
-> Index Scan using transaction_2014_05_debit_account_id_effective_date_idx on back_office.transaction_2014_05 t_52 (cost=0.42..0.83 rows=3 width=14)
Output: t_52.value, t_52.debit_account_id, t_52.credit_account_id
Index Cond: (t_52.debit_account_id = da.id)
-> Index Scan using transaction_2014_06_debit_account_id_effective_date_idx on back_office.transaction_2014_06 t_53 (cost=0.43..0.84 rows=3 width=14)
Output: t_53.value, t_53.debit_account_id, t_53.credit_account_id
Index Cond: (t_53.debit_account_id = da.id)
-> Index Scan using transaction_2014_07_debit_account_id_effective_date_idx on back_office.transaction_2014_07 t_54 (cost=0.42..0.83 rows=3 width=14)
Output: t_54.value, t_54.debit_account_id, t_54.credit_account_id
Index Cond: (t_54.debit_account_id = da.id)
-> Index Scan using transaction_2014_08_debit_account_id_effective_date_idx on back_office.transaction_2014_08 t_55 (cost=0.42..0.83 rows=3 width=14)
Output: t_55.value, t_55.debit_account_id, t_55.credit_account_id
Index Cond: (t_55.debit_account_id = da.id)
-> Index Scan using transaction_2014_09_debit_account_id_effective_date_idx on back_office.transaction_2014_09 t_56 (cost=0.43..0.71 rows=2 width=14)
Output: t_56.value, t_56.debit_account_id, t_56.credit_account_id
Index Cond: (t_56.debit_account_id = da.id)
-> Index Scan using transaction_2014_10_debit_account_id_effective_date_idx on back_office.transaction_2014_10 t_57 (cost=0.42..0.83 rows=3 width=14)
Output: t_57.value, t_57.debit_account_id, t_57.credit_account_id
Index Cond: (t_57.debit_account_id = da.id)
-> Index Scan using transaction_2014_11_debit_account_id_effective_date_idx on back_office.transaction_2014_11 t_58 (cost=0.42..0.83 rows=3 width=14)
Output: t_58.value, t_58.debit_account_id, t_58.credit_account_id
Index Cond: (t_58.debit_account_id = da.id)
-> Index Scan using transaction_2014_12_debit_account_id_effective_date_idx on back_office.transaction_2014_12 t_59 (cost=0.43..0.95 rows=4 width=14)
Output: t_59.value, t_59.debit_account_id, t_59.credit_account_id
Index Cond: (t_59.debit_account_id = da.id)
-> Index Scan using transaction_2015_01_debit_account_id_effective_date_idx on back_office.transaction_2015_01 t_60 (cost=0.43..0.84 rows=3 width=14)
Output: t_60.value, t_60.debit_account_id, t_60.credit_account_id
Index Cond: (t_60.debit_account_id = da.id)
-> Index Scan using transaction_2015_02_debit_account_id_effective_date_idx on back_office.transaction_2015_02 t_61 (cost=0.42..0.73 rows=2 width=14)
Output: t_61.value, t_61.debit_account_id, t_61.credit_account_id
Index Cond: (t_61.debit_account_id = da.id)
-> Index Scan using transaction_2015_03_debit_account_id_effective_date_idx on back_office.transaction_2015_03 t_62 (cost=0.42..0.72 rows=2 width=14)
Output: t_62.value, t_62.debit_account_id, t_62.credit_account_id
Index Cond: (t_62.debit_account_id = da.id)
-> Index Scan using transaction_2015_04_debit_account_id_effective_date_idx on back_office.transaction_2015_04 t_63 (cost=0.44..0.92 rows=4 width=14)
Output: t_63.value, t_63.debit_account_id, t_63.credit_account_id
Index Cond: (t_63.debit_account_id = da.id)
-> Index Scan using transaction_2015_05_debit_account_id_effective_date_idx on back_office.transaction_2015_05 t_64 (cost=0.43..0.73 rows=2 width=15)
Output: t_64.value, t_64.debit_account_id, t_64.credit_account_id
Index Cond: (t_64.debit_account_id = da.id)
-> Index Scan using transaction_2015_06_debit_account_id_effective_date_idx on back_office.transaction_2015_06 t_65 (cost=0.43..0.84 rows=3 width=14)
Output: t_65.value, t_65.debit_account_id, t_65.credit_account_id
Index Cond: (t_65.debit_account_id = da.id)
-> Index Scan using transaction_2015_07_debit_account_id_effective_date_idx on back_office.transaction_2015_07 t_66 (cost=0.43..0.72 rows=2 width=14)
Output: t_66.value, t_66.debit_account_id, t_66.credit_account_id
Index Cond: (t_66.debit_account_id = da.id)
-> Index Scan using transaction_2015_08_debit_account_id_effective_date_idx on back_office.transaction_2015_08 t_67 (cost=0.42..0.72 rows=2 width=14)
Output: t_67.value, t_67.debit_account_id, t_67.credit_account_id
Index Cond: (t_67.debit_account_id = da.id)
-> Index Scan using transaction_2015_09_debit_account_id_effective_date_idx on back_office.transaction_2015_09 t_68 (cost=0.43..0.72 rows=2 width=14)
Output: t_68.value, t_68.debit_account_id, t_68.credit_account_id
Index Cond: (t_68.debit_account_id = da.id)
-> Index Scan using transaction_2015_10_debit_account_id_effective_date_idx on back_office.transaction_2015_10 t_69 (cost=0.42..0.83 rows=3 width=14)
Output: t_69.value, t_69.debit_account_id, t_69.credit_account_id
Index Cond: (t_69.debit_account_id = da.id)
-> Index Scan using transaction_2015_11_debit_account_id_effective_date_idx on back_office.transaction_2015_11 t_70 (cost=0.43..0.83 rows=3 width=14)
Output: t_70.value, t_70.debit_account_id, t_70.credit_account_id
Index Cond: (t_70.debit_account_id = da.id)
-> Index Scan using transaction_2015_12_debit_account_id_effective_date_idx on back_office.transaction_2015_12 t_71 (cost=0.43..0.80 rows=3 width=14)
Output: t_71.value, t_71.debit_account_id, t_71.credit_account_id
Index Cond: (t_71.debit_account_id = da.id)
-> Index Scan using transaction_2016_01_debit_account_id_effective_date_idx on back_office.transaction_2016_01 t_72 (cost=0.42..0.83 rows=3 width=14)
Output: t_72.value, t_72.debit_account_id, t_72.credit_account_id
Index Cond: (t_72.debit_account_id = da.id)
-> Index Scan using transaction_2016_02_debit_account_id_effective_date_idx on back_office.transaction_2016_02 t_73 (cost=0.42..0.83 rows=3 width=14)
Output: t_73.value, t_73.debit_account_id, t_73.credit_account_id
Index Cond: (t_73.debit_account_id = da.id)
-> Index Scan using transaction_2016_03_debit_account_id_effective_date_idx on back_office.transaction_2016_03 t_74 (cost=0.43..0.73 rows=2 width=15)
Output: t_74.value, t_74.debit_account_id, t_74.credit_account_id
Index Cond: (t_74.debit_account_id = da.id)
-> Index Scan using transaction_2016_04_debit_account_id_effective_date_idx on back_office.transaction_2016_04 t_75 (cost=0.43..0.71 rows=2 width=14)
Output: t_75.value, t_75.debit_account_id, t_75.credit_account_id
Index Cond: (t_75.debit_account_id = da.id)
-> Index Scan using transaction_2016_05_debit_account_id_effective_date_idx on back_office.transaction_2016_05 t_76 (cost=0.43..0.83 rows=3 width=13)
Output: t_76.value, t_76.debit_account_id, t_76.credit_account_id
Index Cond: (t_76.debit_account_id = da.id)
-> Index Scan using transaction_2016_06_debit_account_id_effective_date_idx on back_office.transaction_2016_06 t_77 (cost=0.43..0.70 rows=2 width=14)
Output: t_77.value, t_77.debit_account_id, t_77.credit_account_id
Index Cond: (t_77.debit_account_id = da.id)
-> Index Scan using transaction_2016_07_debit_account_id_effective_date_idx on back_office.transaction_2016_07 t_78 (cost=0.42..0.82 rows=3 width=14)
Output: t_78.value, t_78.debit_account_id, t_78.credit_account_id
Index Cond: (t_78.debit_account_id = da.id)
-> Index Scan using transaction_2016_08_debit_account_id_effective_date_idx on back_office.transaction_2016_08 t_79 (cost=0.42..0.72 rows=2 width=14)
Output: t_79.value, t_79.debit_account_id, t_79.credit_account_id
Index Cond: (t_79.debit_account_id = da.id)
-> Index Scan using transaction_2016_09_debit_account_id_effective_date_idx on back_office.transaction_2016_09 t_80 (cost=0.43..0.71 rows=2 width=14)
Output: t_80.value, t_80.debit_account_id, t_80.credit_account_id
Index Cond: (t_80.debit_account_id = da.id)
-> Index Scan using transaction_2016_10_debit_account_id_effective_date_idx on back_office.transaction_2016_10 t_81 (cost=0.42..0.83 rows=3 width=14)
Output: t_81.value, t_81.debit_account_id, t_81.credit_account_id
Index Cond: (t_81.debit_account_id = da.id)
-> Index Scan using transaction_2016_11_debit_account_id_effective_date_idx on back_office.transaction_2016_11 t_82 (cost=0.42..0.82 rows=3 width=14)
Output: t_82.value, t_82.debit_account_id, t_82.credit_account_id
Index Cond: (t_82.debit_account_id = da.id)
-> Index Scan using transaction_2016_12_debit_account_id_effective_date_idx on back_office.transaction_2016_12 t_83 (cost=0.44..0.80 rows=3 width=14)
Output: t_83.value, t_83.debit_account_id, t_83.credit_account_id
Index Cond: (t_83.debit_account_id = da.id)
-> Index Scan using transaction_2017_01_debit_account_id_effective_date_idx on back_office.transaction_2017_01 t_84 (cost=0.42..0.72 rows=2 width=14)
Output: t_84.value, t_84.debit_account_id, t_84.credit_account_id
Index Cond: (t_84.debit_account_id = da.id)
-> Index Scan using transaction_2017_02_debit_account_id_effective_date_idx on back_office.transaction_2017_02 t_85 (cost=0.42..0.72 rows=2 width=14)
Output: t_85.value, t_85.debit_account_id, t_85.credit_account_id
Index Cond: (t_85.debit_account_id = da.id)
-> Index Scan using transaction_2017_03_debit_account_id_effective_date_idx on back_office.transaction_2017_03 t_86 (cost=0.43..0.72 rows=2 width=15)
Output: t_86.value, t_86.debit_account_id, t_86.credit_account_id
Index Cond: (t_86.debit_account_id = da.id)
-> Index Scan using transaction_2017_04_debit_account_id_effective_date_idx on back_office.transaction_2017_04 t_87 (cost=0.42..0.70 rows=2 width=14)
Output: t_87.value, t_87.debit_account_id, t_87.credit_account_id
Index Cond: (t_87.debit_account_id = da.id)
-> Index Scan using transaction_2017_05_debit_account_id_effective_date_idx on back_office.transaction_2017_05 t_88 (cost=0.43..0.63 rows=1 width=14)
Output: t_88.value, t_88.debit_account_id, t_88.credit_account_id
Index Cond: (t_88.debit_account_id = da.id)
-> Index Scan using transaction_2017_06_debit_account_id_effective_date_idx on back_office.transaction_2017_06 t_89 (cost=0.42..0.72 rows=2 width=14)
Output: t_89.value, t_89.debit_account_id, t_89.credit_account_id
Index Cond: (t_89.debit_account_id = da.id)
-> Index Scan using transaction_2017_07_debit_account_id_effective_date_idx on back_office.transaction_2017_07 t_90 (cost=0.42..0.72 rows=2 width=14)
Output: t_90.value, t_90.debit_account_id, t_90.credit_account_id
Index Cond: (t_90.debit_account_id = da.id)
-> Index Scan using transaction_2017_08_debit_account_id_effective_date_idx on back_office.transaction_2017_08 t_91 (cost=0.42..0.71 rows=2 width=14)
Output: t_91.value, t_91.debit_account_id, t_91.credit_account_id
Index Cond: (t_91.debit_account_id = da.id)
-> Index Scan using transaction_2017_09_debit_account_id_effective_date_idx on back_office.transaction_2017_09 t_92 (cost=0.42..0.70 rows=2 width=14)
Output: t_92.value, t_92.debit_account_id, t_92.credit_account_id
Index Cond: (t_92.debit_account_id = da.id)
-> Index Scan using transaction_2017_10_debit_account_id_effective_date_idx on back_office.transaction_2017_10 t_93 (cost=0.42..0.72 rows=2 width=13)
Output: t_93.value, t_93.debit_account_id, t_93.credit_account_id
Index Cond: (t_93.debit_account_id = da.id)
-> Index Scan using transaction_2017_11_debit_account_id_effective_date_idx on back_office.transaction_2017_11 t_94 (cost=0.42..0.70 rows=2 width=14)
Output: t_94.value, t_94.debit_account_id, t_94.credit_account_id
Index Cond: (t_94.debit_account_id = da.id)
-> Index Scan using transaction_2017_12_debit_account_id_effective_date_idx on back_office.transaction_2017_12 t_95 (cost=0.43..2.31 rows=23 width=14)
Output: t_95.value, t_95.debit_account_id, t_95.credit_account_id
Index Cond: (t_95.debit_account_id = da.id)
-> Index Scan using transaction_2018_01_debit_account_id_effective_date_idx on back_office.transaction_2018_01 t_96 (cost=0.42..0.73 rows=2 width=13)
Output: t_96.value, t_96.debit_account_id, t_96.credit_account_id
Index Cond: (t_96.debit_account_id = da.id)
-> Index Scan using transaction_2018_02_debit_account_id_effective_date_idx on back_office.transaction_2018_02 t_97 (cost=0.42..0.71 rows=2 width=13)
Output: t_97.value, t_97.debit_account_id, t_97.credit_account_id
Index Cond: (t_97.debit_account_id = da.id)
-> Index Scan using transaction_2018_03_debit_account_id_effective_date_idx on back_office.transaction_2018_03 t_98 (cost=0.43..0.73 rows=2 width=15)
Output: t_98.value, t_98.debit_account_id, t_98.credit_account_id
Index Cond: (t_98.debit_account_id = da.id)
-> Index Scan using transaction_2018_04_debit_account_id_effective_date_idx on back_office.transaction_2018_04 t_99 (cost=0.42..0.71 rows=2 width=13)
Output: t_99.value, t_99.debit_account_id, t_99.credit_account_id
Index Cond: (t_99.debit_account_id = da.id)
-> Index Scan using transaction_2018_05_debit_account_id_effective_date_idx on back_office.transaction_2018_05 t_100 (cost=0.42..0.71 rows=2 width=13)
Output: t_100.value, t_100.debit_account_id, t_100.credit_account_id
Index Cond: (t_100.debit_account_id = da.id)
-> Index Scan using transaction_2018_06_debit_account_id_effective_date_idx on back_office.transaction_2018_06 t_101 (cost=0.42..0.71 rows=2 width=14)
Output: t_101.value, t_101.debit_account_id, t_101.credit_account_id
Index Cond: (t_101.debit_account_id = da.id)
-> Index Scan using transaction_2018_07_debit_account_id_effective_date_idx on back_office.transaction_2018_07 t_102 (cost=0.43..0.71 rows=2 width=14)
Output: t_102.value, t_102.debit_account_id, t_102.credit_account_id
Index Cond: (t_102.debit_account_id = da.id)
-> Index Scan using transaction_2018_08_debit_account_id_effective_date_idx on back_office.transaction_2018_08 t_103 (cost=0.42..0.71 rows=2 width=14)
Output: t_103.value, t_103.debit_account_id, t_103.credit_account_id
Index Cond: (t_103.debit_account_id = da.id)
-> Index Scan using transaction_2018_09_debit_account_id_effective_date_idx on back_office.transaction_2018_09 t_104 (cost=0.43..0.70 rows=2 width=13)
Output: t_104.value, t_104.debit_account_id, t_104.credit_account_id
Index Cond: (t_104.debit_account_id = da.id)
-> Index Scan using transaction_2018_10_debit_account_id_effective_date_idx on back_office.transaction_2018_10 t_105 (cost=0.42..0.72 rows=2 width=13)
Output: t_105.value, t_105.debit_account_id, t_105.credit_account_id
Index Cond: (t_105.debit_account_id = da.id)
-> Index Scan using transaction_2018_11_debit_account_id_effective_date_idx on back_office.transaction_2018_11 t_106 (cost=0.42..0.72 rows=2 width=13)
Output: t_106.value, t_106.debit_account_id, t_106.credit_account_id
Index Cond: (t_106.debit_account_id = da.id)
-> Index Scan using transaction_2018_12_debit_account_id_effective_date_idx on back_office.transaction_2018_12 t_107 (cost=0.43..0.82 rows=3 width=15)
Output: t_107.value, t_107.debit_account_id, t_107.credit_account_id
Index Cond: (t_107.debit_account_id = da.id)
-> Index Scan using transaction_2019_01_debit_account_id_effective_date_idx on back_office.transaction_2019_01 t_108 (cost=0.43..0.71 rows=2 width=14)
Output: t_108.value, t_108.debit_account_id, t_108.credit_account_id
Index Cond: (t_108.debit_account_id = da.id)
-> Index Scan using transaction_2019_02_debit_account_id_effective_date_idx on back_office.transaction_2019_02 t_109 (cost=0.42..0.72 rows=2 width=14)
Output: t_109.value, t_109.debit_account_id, t_109.credit_account_id
Index Cond: (t_109.debit_account_id = da.id)
-> Index Scan using transaction_2019_03_debit_account_id_effective_date_idx on back_office.transaction_2019_03 t_110 (cost=0.43..0.71 rows=2 width=15)
Output: t_110.value, t_110.debit_account_id, t_110.credit_account_id
Index Cond: (t_110.debit_account_id = da.id)
-> Index Scan using transaction_2019_04_debit_account_id_effective_date_idx on back_office.transaction_2019_04 t_111 (cost=0.42..0.71 rows=2 width=13)
Output: t_111.value, t_111.debit_account_id, t_111.credit_account_id
Index Cond: (t_111.debit_account_id = da.id)
-> Index Scan using transaction_2019_05_debit_account_id_effective_date_idx on back_office.transaction_2019_05 t_112 (cost=0.42..0.72 rows=2 width=13)
Output: t_112.value, t_112.debit_account_id, t_112.credit_account_id
Index Cond: (t_112.debit_account_id = da.id)
-> Index Scan using transaction_2019_06_debit_account_id_effective_date_idx on back_office.transaction_2019_06 t_113 (cost=0.42..0.72 rows=2 width=14)
Output: t_113.value, t_113.debit_account_id, t_113.credit_account_id
Index Cond: (t_113.debit_account_id = da.id)
-> Index Scan using transaction_2019_07_debit_account_id_effective_date_idx on back_office.transaction_2019_07 t_114 (cost=0.42..0.72 rows=2 width=13)
Output: t_114.value, t_114.debit_account_id, t_114.credit_account_id
Index Cond: (t_114.debit_account_id = da.id)
-> Index Scan using transaction_2019_08_debit_account_id_effective_date_idx on back_office.transaction_2019_08 t_115 (cost=0.42..0.72 rows=2 width=13)
Output: t_115.value, t_115.debit_account_id, t_115.credit_account_id
Index Cond: (t_115.debit_account_id = da.id)
-> Index Scan using transaction_2019_09_debit_account_id_effective_date_idx on back_office.transaction_2019_09 t_116 (cost=0.42..0.71 rows=2 width=14)
Output: t_116.value, t_116.debit_account_id, t_116.credit_account_id
Index Cond: (t_116.debit_account_id = da.id)
-> Index Scan using transaction_2019_10_debit_account_id_effective_date_idx on back_office.transaction_2019_10 t_117 (cost=0.42..0.72 rows=2 width=13)
Output: t_117.value, t_117.debit_account_id, t_117.credit_account_id
Index Cond: (t_117.debit_account_id = da.id)
-> Index Scan using transaction_2019_11_debit_account_id_effective_date_idx on back_office.transaction_2019_11 t_118 (cost=0.42..0.71 rows=2 width=13)
Output: t_118.value, t_118.debit_account_id, t_118.credit_account_id
Index Cond: (t_118.debit_account_id = da.id)
-> Index Scan using transaction_2019_12_debit_account_id_effective_date_idx on back_office.transaction_2019_12 t_119 (cost=0.43..6.79 rows=95 width=14)
Output: t_119.value, t_119.debit_account_id, t_119.credit_account_id
Index Cond: (t_119.debit_account_id = da.id)
-> Index Scan using transaction_2020_01_debit_account_id_effective_date_idx on back_office.transaction_2020_01 t_120 (cost=0.42..0.72 rows=2 width=13)
Output: t_120.value, t_120.debit_account_id, t_120.credit_account_id
Index Cond: (t_120.debit_account_id = da.id)
-> Index Scan using transaction_2020_02_debit_account_id_effective_date_value_idx on back_office.transaction_2020_02 t_121 (cost=0.42..0.72 rows=2 width=13)
Output: t_121.value, t_121.debit_account_id, t_121.credit_account_id
Index Cond: (t_121.debit_account_id = da.id)
-> Index Scan using transaction_2020_03_debit_account_id_effective_date_idx on back_office.transaction_2020_03 t_122 (cost=0.43..0.70 rows=2 width=14)
Output: t_122.value, t_122.debit_account_id, t_122.credit_account_id
Index Cond: (t_122.debit_account_id = da.id)
-> Index Scan using transaction_2020_04_debit_account_id_effective_date_idx on back_office.transaction_2020_04 t_123 (cost=0.42..0.71 rows=2 width=13)
Output: t_123.value, t_123.debit_account_id, t_123.credit_account_id
Index Cond: (t_123.debit_account_id = da.id)
-> Index Scan using transaction_2020_05_debit_account_id_effective_date_idx on back_office.transaction_2020_05 t_124 (cost=0.42..0.72 rows=2 width=13)
Output: t_124.value, t_124.debit_account_id, t_124.credit_account_id
Index Cond: (t_124.debit_account_id = da.id)
-> Index Scan using transaction_2020_06_debit_account_id_effective_date_idx on back_office.transaction_2020_06 t_125 (cost=0.42..0.71 rows=2 width=14)
Output: t_125.value, t_125.debit_account_id, t_125.credit_account_id
Index Cond: (t_125.debit_account_id = da.id)
-> Index Scan using transaction_2020_07_debit_account_id_effective_date_idx on back_office.transaction_2020_07 t_126 (cost=0.42..0.71 rows=2 width=14)
Output: t_126.value, t_126.debit_account_id, t_126.credit_account_id
Index Cond: (t_126.debit_account_id = da.id)
-> Index Scan using transaction_2020_08_debit_account_id_effective_date_idx on back_office.transaction_2020_08 t_127 (cost=0.42..0.71 rows=2 width=14)
Output: t_127.value, t_127.debit_account_id, t_127.credit_account_id
Index Cond: (t_127.debit_account_id = da.id)
-> Index Scan using transaction_2020_09_debit_account_id_effective_date_idx on back_office.transaction_2020_09 t_128 (cost=0.42..0.70 rows=2 width=14)
Output: t_128.value, t_128.debit_account_id, t_128.credit_account_id
Index Cond: (t_128.debit_account_id = da.id)
-> Index Scan using transaction_2020_10_debit_account_id_effective_date_idx on back_office.transaction_2020_10 t_129 (cost=0.42..0.72 rows=2 width=13)
Output: t_129.value, t_129.debit_account_id, t_129.credit_account_id
Index Cond: (t_129.debit_account_id = da.id)
-> Index Scan using transaction_2020_11_debit_account_id_effective_date_idx on back_office.transaction_2020_11 t_130 (cost=0.42..0.71 rows=2 width=13)
Output: t_130.value, t_130.debit_account_id, t_130.credit_account_id
Index Cond: (t_130.debit_account_id = da.id)
-> Index Scan using transaction_2020_12_debit_account_id_effective_date_idx on back_office.transaction_2020_12 t_131 (cost=0.44..7.02 rows=59 width=14)
Output: t_131.value, t_131.debit_account_id, t_131.credit_account_id
Index Cond: (t_131.debit_account_id = da.id)
-> Index Scan using transaction_2021_01_debit_account_id_effective_date_idx on back_office.transaction_2021_01 t_132 (cost=0.42..0.72 rows=2 width=13)
Output: t_132.value, t_132.debit_account_id, t_132.credit_account_id
Index Cond: (t_132.debit_account_id = da.id)
-> Index Scan using transaction_2021_02_debit_account_id_effective_date_idx on back_office.transaction_2021_02 t_133 (cost=0.42..0.71 rows=2 width=13)
Output: t_133.value, t_133.debit_account_id, t_133.credit_account_id
Index Cond: (t_133.debit_account_id = da.id)
-> Index Scan using transaction_2021_03_debit_account_id_effective_date_idx on back_office.transaction_2021_03 t_134 (cost=0.42..0.70 rows=2 width=14)
Output: t_134.value, t_134.debit_account_id, t_134.credit_account_id
Index Cond: (t_134.debit_account_id = da.id)
-> Index Scan using transaction_2021_04_debit_account_id_effective_date_idx on back_office.transaction_2021_04 t_135 (cost=0.42..0.71 rows=2 width=14)
Output: t_135.value, t_135.debit_account_id, t_135.credit_account_id
Index Cond: (t_135.debit_account_id = da.id)
-> Index Scan using transaction_2021_05_debit_account_id_effective_date_idx on back_office.transaction_2021_05 t_136 (cost=0.42..0.72 rows=2 width=13)
Output: t_136.value, t_136.debit_account_id, t_136.credit_account_id
Index Cond: (t_136.debit_account_id = da.id)
-> Index Scan using transaction_2021_06_debit_account_id_effective_date_idx on back_office.transaction_2021_06 t_137 (cost=0.42..0.71 rows=2 width=14)
Output: t_137.value, t_137.debit_account_id, t_137.credit_account_id
Index Cond: (t_137.debit_account_id = da.id)
-> Index Scan using transaction_2021_07_debit_account_id_effective_date_idx on back_office.transaction_2021_07 t_138 (cost=0.42..0.71 rows=2 width=14)
Output: t_138.value, t_138.debit_account_id, t_138.credit_account_id
Index Cond: (t_138.debit_account_id = da.id)
-> Index Scan using transaction_2021_08_debit_account_id_effective_date_idx on back_office.transaction_2021_08 t_139 (cost=0.42..0.71 rows=2 width=14)
Output: t_139.value, t_139.debit_account_id, t_139.credit_account_id
Index Cond: (t_139.debit_account_id = da.id)
-> Index Scan using transaction_2021_09_debit_account_id_effective_date_idx on back_office.transaction_2021_09 t_140 (cost=0.42..0.70 rows=2 width=14)
Output: t_140.value, t_140.debit_account_id, t_140.credit_account_id
Index Cond: (t_140.debit_account_id = da.id)
-> Index Scan using transaction_2021_10_debit_account_id_effective_date_idx on back_office.transaction_2021_10 t_141 (cost=0.42..0.71 rows=2 width=14)
Output: t_141.value, t_141.debit_account_id, t_141.credit_account_id
Index Cond: (t_141.debit_account_id = da.id)
-> Index Scan using transaction_2021_11_debit_account_id_effective_date_idx on back_office.transaction_2021_11 t_142 (cost=0.42..0.72 rows=2 width=13)
Output: t_142.value, t_142.debit_account_id, t_142.credit_account_id
Index Cond: (t_142.debit_account_id = da.id)
-> Index Scan using transaction_2021_12_debit_account_id_effective_date_idx on back_office.transaction_2021_12 t_143 (cost=0.43..5.50 rows=64 width=14)
Output: t_143.value, t_143.debit_account_id, t_143.credit_account_id
Index Cond: (t_143.debit_account_id = da.id)
-> Index Scan using transaction_2022_01_debit_account_id_effective_date_idx on back_office.transaction_2022_01 t_144 (cost=0.42..0.72 rows=2 width=13)
Output: t_144.value, t_144.debit_account_id, t_144.credit_account_id
Index Cond: (t_144.debit_account_id = da.id)
-> Index Scan using transaction_2022_02_debit_account_id_effective_date_idx on back_office.transaction_2022_02 t_145 (cost=0.42..0.71 rows=2 width=14)
Output: t_145.value, t_145.debit_account_id, t_145.credit_account_id
Index Cond: (t_145.debit_account_id = da.id)
-> Index Scan using transaction_2022_03_debit_account_id_effective_date_idx on back_office.transaction_2022_03 t_146 (cost=0.43..0.70 rows=2 width=14)
Output: t_146.value, t_146.debit_account_id, t_146.credit_account_id
Index Cond: (t_146.debit_account_id = da.id)
-> Index Scan using transaction_2022_04_debit_account_id_effective_date_idx on back_office.transaction_2022_04 t_147 (cost=0.42..0.71 rows=2 width=14)
Output: t_147.value, t_147.debit_account_id, t_147.credit_account_id
Index Cond: (t_147.debit_account_id = da.id)
-> Index Scan using transaction_2022_05_debit_account_id_effective_date_idx on back_office.transaction_2022_05 t_148 (cost=0.42..0.71 rows=2 width=14)
Output: t_148.value, t_148.debit_account_id, t_148.credit_account_id
Index Cond: (t_148.debit_account_id = da.id)
-> Index Scan using transaction_2022_06_debit_account_id_effective_date_idx on back_office.transaction_2022_06 t_149 (cost=0.42..0.71 rows=2 width=14)
Output: t_149.value, t_149.debit_account_id, t_149.credit_account_id
Index Cond: (t_149.debit_account_id = da.id)
-> Index Scan using transaction_2022_07_debit_account_id_effective_date_idx on back_office.transaction_2022_07 t_150 (cost=0.42..0.71 rows=2 width=14)
Output: t_150.value, t_150.debit_account_id, t_150.credit_account_id
Index Cond: (t_150.debit_account_id = da.id)
-> Index Scan using transaction_2022_08_debit_account_id_effective_date_idx on back_office.transaction_2022_08 t_151 (cost=0.42..0.71 rows=2 width=14)
Output: t_151.value, t_151.debit_account_id, t_151.credit_account_id
Index Cond: (t_151.debit_account_id = da.id)
-> Index Scan using transaction_2022_09_debit_account_id_effective_date_idx on back_office.transaction_2022_09 t_152 (cost=0.42..0.70 rows=2 width=14)
Output: t_152.value, t_152.debit_account_id, t_152.credit_account_id
Index Cond: (t_152.debit_account_id = da.id)
-> Index Scan using transaction_2022_10_debit_account_id_effective_date_idx on back_office.transaction_2022_10 t_153 (cost=0.42..0.71 rows=2 width=14)
Output: t_153.value, t_153.debit_account_id, t_153.credit_account_id
Index Cond: (t_153.debit_account_id = da.id)
-> Index Scan using transaction_2022_11_debit_account_id_effective_date_idx on back_office.transaction_2022_11 t_154 (cost=0.42..0.71 rows=2 width=14)
Output: t_154.value, t_154.debit_account_id, t_154.credit_account_id
Index Cond: (t_154.debit_account_id = da.id)
-> Index Scan using transaction_2022_12_debit_account_id_effective_date_idx on back_office.transaction_2022_12 t_155 (cost=0.43..0.79 rows=3 width=14)
Output: t_155.value, t_155.debit_account_id, t_155.credit_account_id
Index Cond: (t_155.debit_account_id = da.id)
-> Index Scan using transaction_2023_01_debit_account_id_effective_date_idx on back_office.transaction_2023_01 t_156 (cost=0.42..0.72 rows=2 width=13)
Output: t_156.value, t_156.debit_account_id, t_156.credit_account_id
Index Cond: (t_156.debit_account_id = da.id)
-> Index Scan using transaction_2023_02_debit_account_id_effective_date_idx on back_office.transaction_2023_02 t_157 (cost=0.42..0.71 rows=2 width=14)
Output: t_157.value, t_157.debit_account_id, t_157.credit_account_id
Index Cond: (t_157.debit_account_id = da.id)
-> Index Scan using transaction_2023_03_debit_account_id_effective_date_idx on back_office.transaction_2023_03 t_158 (cost=0.42..0.71 rows=2 width=14)
Output: t_158.value, t_158.debit_account_id, t_158.credit_account_id
Index Cond: (t_158.debit_account_id = da.id)
-> Index Scan using transaction_2023_04_debit_account_id_effective_date_idx on back_office.transaction_2023_04 t_159 (cost=0.42..0.71 rows=2 width=14)
Output: t_159.value, t_159.debit_account_id, t_159.credit_account_id
Index Cond: (t_159.debit_account_id = da.id)
-> Index Scan using transaction_2023_05_debit_account_id_effective_date_idx on back_office.transaction_2023_05 t_160 (cost=0.42..0.72 rows=2 width=14)
Output: t_160.value, t_160.debit_account_id, t_160.credit_account_id
Index Cond: (t_160.debit_account_id = da.id)
-> Index Scan using transaction_2023_06_debit_account_id_effective_date_idx on back_office.transaction_2023_06 t_161 (cost=0.42..0.71 rows=2 width=14)
Output: t_161.value, t_161.debit_account_id, t_161.credit_account_id
Index Cond: (t_161.debit_account_id = da.id)
-> Index Scan using transaction_2023_07_debit_account_id_effective_date_idx on back_office.transaction_2023_07 t_162 (cost=0.42..0.71 rows=2 width=14)
Output: t_162.value, t_162.debit_account_id, t_162.credit_account_id
Index Cond: (t_162.debit_account_id = da.id)
-> Index Scan using transaction_2023_08_debit_account_id_effective_date_idx on back_office.transaction_2023_08 t_163 (cost=0.42..0.71 rows=2 width=14)
Output: t_163.value, t_163.debit_account_id, t_163.credit_account_id
Index Cond: (t_163.debit_account_id = da.id)
-> Index Scan using transaction_2023_09_debit_account_id_effective_date_idx on back_office.transaction_2023_09 t_164 (cost=0.42..0.70 rows=2 width=14)
Output: t_164.value, t_164.debit_account_id, t_164.credit_account_id
Index Cond: (t_164.debit_account_id = da.id)
-> Index Scan using transaction_2023_10_debit_account_id_effective_date_idx on back_office.transaction_2023_10 t_165 (cost=0.42..0.71 rows=2 width=14)
Output: t_165.value, t_165.debit_account_id, t_165.credit_account_id
Index Cond: (t_165.debit_account_id = da.id)
-> Index Scan using transaction_2023_11_debit_account_id_effective_date_idx on back_office.transaction_2023_11 t_166 (cost=0.42..0.71 rows=2 width=14)
Output: t_166.value, t_166.debit_account_id, t_166.credit_account_id
Index Cond: (t_166.debit_account_id = da.id)
-> Index Scan using transaction_2023_12_debit_account_id_effective_date_idx on back_office.transaction_2023_12 t_167 (cost=0.43..0.87 rows=4 width=14)
Output: t_167.value, t_167.debit_account_id, t_167.credit_account_id
Index Cond: (t_167.debit_account_id = da.id)
-> Index Scan using transaction_2024_01_debit_account_id_effective_date_idx on back_office.transaction_2024_01 t_168 (cost=0.42..0.72 rows=2 width=13)
Output: t_168.value, t_168.debit_account_id, t_168.credit_account_id
Index Cond: (t_168.debit_account_id = da.id)
-> Index Scan using transaction_2024_02_debit_account_id_effective_date_idx on back_office.transaction_2024_02 t_169 (cost=0.42..0.70 rows=2 width=14)
Output: t_169.value, t_169.debit_account_id, t_169.credit_account_id
Index Cond: (t_169.debit_account_id = da.id)
-> Index Scan using transaction_2024_03_debit_account_id_effective_date_idx on back_office.transaction_2024_03 t_170 (cost=0.42..0.70 rows=2 width=14)
Output: t_170.value, t_170.debit_account_id, t_170.credit_account_id
Index Cond: (t_170.debit_account_id = da.id)
-> Index Scan using transaction_2024_04_debit_account_id_effective_date_idx on back_office.transaction_2024_04 t_171 (cost=0.42..0.70 rows=2 width=14)
Output: t_171.value, t_171.debit_account_id, t_171.credit_account_id
Index Cond: (t_171.debit_account_id = da.id)
-> Index Scan using transaction_2024_05_debit_account_id_effective_date_idx on back_office.transaction_2024_05 t_172 (cost=0.42..0.71 rows=2 width=14)
Output: t_172.value, t_172.debit_account_id, t_172.credit_account_id
Index Cond: (t_172.debit_account_id = da.id)
-> Index Scan using transaction_2024_06_debit_account_id_effective_date_idx on back_office.transaction_2024_06 t_173 (cost=0.42..0.70 rows=2 width=14)
Output: t_173.value, t_173.debit_account_id, t_173.credit_account_id
Index Cond: (t_173.debit_account_id = da.id)
-> Index Scan using transaction_2024_07_debit_account_id_effective_date_idx on back_office.transaction_2024_07 t_174 (cost=0.42..0.70 rows=2 width=14)
Output: t_174.value, t_174.debit_account_id, t_174.credit_account_id
Index Cond: (t_174.debit_account_id = da.id)
-> Index Scan using transaction_2024_08_debit_account_id_effective_date_idx on back_office.transaction_2024_08 t_175 (cost=0.42..0.70 rows=2 width=14)
Output: t_175.value, t_175.debit_account_id, t_175.credit_account_id
Index Cond: (t_175.debit_account_id = da.id)
-> Index Scan using transaction_2024_09_debit_account_id_effective_date_idx on back_office.transaction_2024_09 t_176 (cost=0.42..0.69 rows=2 width=14)
Output: t_176.value, t_176.debit_account_id, t_176.credit_account_id
Index Cond: (t_176.debit_account_id = da.id)
-> Index Scan using transaction_2024_10_debit_account_id_effective_date_idx on back_office.transaction_2024_10 t_177 (cost=0.42..0.70 rows=2 width=14)
Output: t_177.value, t_177.debit_account_id, t_177.credit_account_id
Index Cond: (t_177.debit_account_id = da.id)
-> Index Scan using transaction_2024_11_debit_account_id_effective_date_idx on back_office.transaction_2024_11 t_178 (cost=0.42..0.70 rows=2 width=14)
Output: t_178.value, t_178.debit_account_id, t_178.credit_account_id
Index Cond: (t_178.debit_account_id = da.id)
-> Index Scan using transaction_2024_12_debit_account_id_effective_date_idx on back_office.transaction_2024_12 t_179 (cost=0.43..0.86 rows=4 width=14)
Output: t_179.value, t_179.debit_account_id, t_179.credit_account_id
Index Cond: (t_179.debit_account_id = da.id)
-> Index Scan using transaction_2025_01_debit_account_id_effective_date_idx on back_office.transaction_2025_01 t_180 (cost=0.42..0.72 rows=2 width=13)
Output: t_180.value, t_180.debit_account_id, t_180.credit_account_id
Index Cond: (t_180.debit_account_id = da.id)
-> Index Scan using transaction_2025_02_debit_account_id_effective_date_idx on back_office.transaction_2025_02 t_181 (cost=0.42..0.70 rows=2 width=14)
Output: t_181.value, t_181.debit_account_id, t_181.credit_account_id
Index Cond: (t_181.debit_account_id = da.id)
-> Index Scan using transaction_2025_03_debit_account_id_effective_date_idx on back_office.transaction_2025_03 t_182 (cost=0.42..0.70 rows=2 width=14)
Output: t_182.value, t_182.debit_account_id, t_182.credit_account_id
Index Cond: (t_182.debit_account_id = da.id)
-> Index Scan using transaction_2025_04_debit_account_id_effective_date_idx on back_office.transaction_2025_04 t_183 (cost=0.42..0.69 rows=2 width=14)
Output: t_183.value, t_183.debit_account_id, t_183.credit_account_id
Index Cond: (t_183.debit_account_id = da.id)
-> Index Scan using transaction_2025_05_debit_account_id_effective_date_idx on back_office.transaction_2025_05 t_184 (cost=0.42..0.72 rows=2 width=13)
Output: t_184.value, t_184.debit_account_id, t_184.credit_account_id
Index Cond: (t_184.debit_account_id = da.id)
-> Index Scan using transaction_2025_06_debit_account_id_effective_date_idx on back_office.transaction_2025_06 t_185 (cost=0.42..0.70 rows=2 width=14)
Output: t_185.value, t_185.debit_account_id, t_185.credit_account_id
Index Cond: (t_185.debit_account_id = da.id)
-> Index Scan using transaction_2025_07_debit_account_id_effective_date_idx on back_office.transaction_2025_07 t_186 (cost=0.42..0.70 rows=2 width=14)
Output: t_186.value, t_186.debit_account_id, t_186.credit_account_id
Index Cond: (t_186.debit_account_id = da.id)
-> Index Scan using transaction_2025_08_debit_account_id_effective_date_idx on back_office.transaction_2025_08 t_187 (cost=0.42..0.70 rows=2 width=14)
Output: t_187.value, t_187.debit_account_id, t_187.credit_account_id
Index Cond: (t_187.debit_account_id = da.id)
-> Index Scan using transaction_2025_09_debit_account_id_effective_date_idx on back_office.transaction_2025_09 t_188 (cost=0.42..0.69 rows=2 width=14)
Output: t_188.value, t_188.debit_account_id, t_188.credit_account_id
Index Cond: (t_188.debit_account_id = da.id)
-> Index Scan using transaction_2025_10_debit_account_id_effective_date_idx on back_office.transaction_2025_10 t_189 (cost=0.42..0.70 rows=2 width=14)
Output: t_189.value, t_189.debit_account_id, t_189.credit_account_id
Index Cond: (t_189.debit_account_id = da.id)
-> Index Scan using transaction_2025_11_debit_account_id_effective_date_idx on back_office.transaction_2025_11 t_190 (cost=0.42..0.70 rows=2 width=14)
Output: t_190.value, t_190.debit_account_id, t_190.credit_account_id
Index Cond: (t_190.debit_account_id = da.id)
-> Index Scan using transaction_2025_12_debit_account_id_effective_date_idx on back_office.transaction_2025_12 t_191 (cost=0.44..1.42 rows=10 width=14)
Output: t_191.value, t_191.debit_account_id, t_191.credit_account_id
Index Cond: (t_191.debit_account_id = da.id)
-> Index Scan using transaction_2026_01_debit_account_id_effective_date_operati_idx on back_office.transaction_2026_01 t_192 (cost=0.42..0.62 rows=1 width=14)
Output: t_192.value, t_192.debit_account_id, t_192.credit_account_id
Index Cond: (t_192.debit_account_id = da.id)
-> Index Scan using transaction_2026_02_debit_account_id_effective_date_idx on back_office.transaction_2026_02 t_193 (cost=0.42..0.70 rows=2 width=14)
Output: t_193.value, t_193.debit_account_id, t_193.credit_account_id
Index Cond: (t_193.debit_account_id = da.id)
-> Index Scan using transaction_2026_03_debit_account_id_effective_date_idx on back_office.transaction_2026_03 t_194 (cost=0.43..0.72 rows=2 width=15)
Output: t_194.value, t_194.debit_account_id, t_194.credit_account_id
Index Cond: (t_194.debit_account_id = da.id)
-> Index Scan using transaction_2026_04_debit_account_id_effective_date_idx on back_office.transaction_2026_04 t_195 (cost=0.42..0.70 rows=2 width=14)
Output: t_195.value, t_195.debit_account_id, t_195.credit_account_id
Index Cond: (t_195.debit_account_id = da.id)
-> Index Scan using transaction_2026_05_debit_account_id_effective_date_idx on back_office.transaction_2026_05 t_196 (cost=0.42..0.70 rows=2 width=14)
Output: t_196.value, t_196.debit_account_id, t_196.credit_account_id
Index Cond: (t_196.debit_account_id = da.id)
-> Index Scan using transaction_2026_06_debit_account_id_effective_date_idx on back_office.transaction_2026_06 t_197 (cost=0.42..0.70 rows=2 width=14)
Output: t_197.value, t_197.debit_account_id, t_197.credit_account_id
Index Cond: (t_197.debit_account_id = da.id)
-> Index Scan using transaction_2026_07_debit_account_id_effective_date_idx on back_office.transaction_2026_07 t_198 (cost=0.42..0.71 rows=2 width=14)
Output: t_198.value, t_198.debit_account_id, t_198.credit_account_id
Index Cond: (t_198.debit_account_id = da.id)
-> Index Scan using transaction_2026_08_debit_account_id_effective_date_idx on back_office.transaction_2026_08 t_199 (cost=0.42..0.62 rows=1 width=15)
Output: t_199.value, t_199.debit_account_id, t_199.credit_account_id
Index Cond: (t_199.debit_account_id = da.id)
-> Index Scan using transaction_2026_09_debit_account_id_effective_date_idx on back_office.transaction_2026_09 t_200 (cost=0.42..0.62 rows=1 width=14)
Output: t_200.value, t_200.debit_account_id, t_200.credit_account_id
Index Cond: (t_200.debit_account_id = da.id)
-> Index Scan using transaction_2026_10_debit_account_id_effective_date_idx on back_office.transaction_2026_10 t_201 (cost=0.29..0.49 rows=1 width=15)
Output: t_201.value, t_201.debit_account_id, t_201.credit_account_id
Index Cond: (t_201.debit_account_id = da.id)
-> Index Scan using transaction_2026_11_debit_account_id_effective_date_value_idx on back_office.transaction_2026_11 t_202 (cost=0.14..0.16 rows=1 width=15)
Output: t_202.value, t_202.debit_account_id, t_202.credit_account_id
Index Cond: (t_202.debit_account_id = da.id)
-> Seq Scan on back_office.transaction_2026_12 t_203 (cost=0.00..0.00 rows=1 width=30)
Output: t_203.value, t_203.debit_account_id, t_203.credit_account_id
Filter: (t_203.debit_account_id = da.id)
-> Seq Scan on back_office.transaction_2027_01 t_204 (cost=0.00..0.00 rows=1 width=30)
Output: t_204.value, t_204.debit_account_id, t_204.credit_account_id
Filter: (t_204.debit_account_id = da.id)
-> Seq Scan on back_office.transaction_2027_02 t_205 (cost=0.00..0.00 rows=1 width=30)
Output: t_205.value, t_205.debit_account_id, t_205.credit_account_id
Filter: (t_205.debit_account_id = da.id)
-> Seq Scan on back_office.transaction_2027_03 t_206 (cost=0.00..0.00 rows=1 width=30)
Output: t_206.value, t_206.debit_account_id, t_206.credit_account_id
Filter: (t_206.debit_account_id = da.id)
-> Seq Scan on back_office.transaction_2027_04 t_207 (cost=0.00..0.00 rows=1 width=30)
Output: t_207.value, t_207.debit_account_id, t_207.credit_account_id
Filter: (t_207.debit_account_id = da.id)
-> Seq Scan on back_office.transaction_2027_05 t_208 (cost=0.00..0.00 rows=1 width=30)
Output: t_208.value, t_208.debit_account_id, t_208.credit_account_id
Filter: (t_208.debit_account_id = da.id)
-> Seq Scan on back_office.transaction_2027_06 t_209 (cost=0.00..0.00 rows=1 width=30)
Output: t_209.value, t_209.debit_account_id, t_209.credit_account_id
Filter: (t_209.debit_account_id = da.id)
-> Seq Scan on back_office.transaction_2027_07 t_210 (cost=0.00..0.00 rows=1 width=30)
Output: t_210.value, t_210.debit_account_id, t_210.credit_account_id
Filter: (t_210.debit_account_id = da.id)
-> Seq Scan on back_office.transaction_2027_08 t_211 (cost=0.00..0.00 rows=1 width=30)
Output: t_211.value, t_211.debit_account_id, t_211.credit_account_id
Filter: (t_211.debit_account_id = da.id)
-> Index Scan using account_pkey on back_office.account ca (cost=0.56..0.79 rows=1 width=8)
Output: ca.id, ca.operation_id, ca.account_type_id, ca.owner_contract_id, ca.owner_sharer_id, ca.owner_individual_id, ca.owner_entity_id, ca.version
Index Cond: (ca.id = t.credit_account_id)
-> Memoize (cost=0.28..0.38 rows=1 width=4)
Output: cat.id
Cache Key: ca.account_type_id
Cache Mode: logical
-> Index Scan using account_type_pkey on back_office.account_type cat (cost=0.27..0.37 rows=1 width=4)
Output: cat.id
Index Cond: (cat.id = ca.account_type_id)
Filter: ((cat.mnemonics)::text = ANY ('{"Р ОПС","Р ОПС ИД"}'::text[]))
-> Subquery Scan on "*SELECT* 2" (cost=5828641.13..5828825.11 rows=1443 width=292)
Output: "*SELECT* 2".sharer_id, "*SELECT* 2".ops, "*SELECT* 2".ops_id, "*SELECT* 2".dps_g, "*SELECT* 2".dps_g_id, "*SELECT* 2".dps_l, "*SELECT* 2".dps_l_id, "*SELECT* 2".dps_mk, "*SELECT* 2".dps_mk_id, "*SELECT* 2".balance
-> GroupAggregate (cost=5828641.13..5828810.68 rows=1443 width=292)
Output: ca_1.owner_sharer_id, (- sum(t_212.value)), (- sum(CASE WHEN ((cat_1.mnemonics)::text = ANY ('{ОПС,"ОПС ГВ","ОПС КП","Р ПП ОПС"}'::text[])) THEN t_212.value ELSE '0'::numeric END)), (- sum(CASE WHEN ((cat_1.mnemonics)::text = ANY ('{"ОПС ИД","ОПС ФР","Р ПП ОПС ИД"}'::text[])) THEN t_212.value ELSE '0'::numeric END)), (- sum(CASE WHEN ((cat_1.mnemonics)::text = ANY ('{"ДПС Г","ДПС Г ГВ","ДПС Г КП","Р ПП ДПС Г"}'::text[])) THEN t_212.value ELSE '0'::numeric END)), (- sum(CASE WHEN ((cat_1.mnemonics)::text = ANY ('{"ДПС Г ИД","ДПС Г ФР","Р ПП ДПС Г ИД"}'::text[])) THEN t_212.value ELSE '0'::numeric END)), (- sum(CASE WHEN ((cat_1.mnemonics)::text = ANY ('{"ДПС Л","ДПС Л ГВ","ДПС Л КП","Р ПП ДПС Л"}'::text[])) THEN t_212.value ELSE '0'::numeric END)), (- sum(CASE WHEN ((cat_1.mnemonics)::text = ANY ('{"ДПС Л ИД","ДПС Л ФР","Р ПП ДПС Л ИД"}'::text[])) THEN t_212.value ELSE '0'::numeric END)), (- sum(CASE WHEN ((cat_1.mnemonics)::text = ANY ('{"ДПС МК","ДПС МК ГВ","ДПС МК КП","Р ПП ДПС МК"}'::text[])) THEN t_212.value ELSE '0'::numeric END)), (- sum(CASE WHEN ((cat_1.mnemonics)::text = ANY ('{"ДПС МК ИД","ДПС МК ФР","Р ПП ДПС МК ИД"}'::text[])) THEN t_212.value ELSE '0'::numeric END))
Group Key: ca_1.owner_sharer_id
-> Sort (cost=5828641.13..5828644.74 rows=1443 width=33)
Output: ca_1.owner_sharer_id, t_212.value, cat_1.mnemonics
Sort Key: ca_1.owner_sharer_id
-> Nested Loop (cost=19.64..5828565.41 rows=1443 width=33)
Output: ca_1.owner_sharer_id, t_212.value, cat_1.mnemonics
Inner Unique: true
-> Nested Loop (cost=19.35..5819879.56 rows=345709 width=37)
Output: ca_1.owner_sharer_id, cat_1.mnemonics, t_212.value, da_1.account_type_id
Inner Unique: true
-> Nested Loop (cost=18.79..5545863.36 rows=345709 width=37)
Output: ca_1.owner_sharer_id, cat_1.mnemonics, t_212.value, t_212.debit_account_id
-> Hash Join (cost=18.37..437635.45 rows=31263 width=31)
Output: ca_1.owner_sharer_id, ca_1.id, cat_1.mnemonics
Inner Unique: true
Hash Cond: (ca_1.account_type_id = cat_1.id)
-> Nested Loop (cost=0.56..436201.31 rows=534826 width=12)
Output: ca_1.owner_sharer_id, ca_1.account_type_id, ca_1.id
-> CTE Scan on ops_sharer s_2 (cost=0.00..2430.20 rows=121510 width=4)
Output: s_2.id, s_2.individual_death_date
-> Index Scan using idx_account_owner_sharer_id on back_office.account ca_1 (cost=0.56..3.53 rows=4 width=12)
Output: ca_1.id, ca_1.operation_id, ca_1.account_type_id, ca_1.owner_contract_id, ca_1.owner_sharer_id, ca_1.owner_individual_id, ca_1.owner_entity_id, ca_1.version
Index Cond: (ca_1.owner_sharer_id = s_2.id)
-> Hash (cost=17.45..17.45 rows=28 width=27)
Output: cat_1.mnemonics, cat_1.id
-> Bitmap Heap Scan on back_office.account_type cat_1 (cost=3.03..17.45 rows=28 width=27)
Output: cat_1.mnemonics, cat_1.id
Recheck Cond: ((cat_1.mnemonics)::text = ANY ('{ОПС,"ОПС ГВ","ОПС КП","Р ПП ОПС","ОПС ИД","ОПС ФР","Р ПП ОПС ИД","ДПС Г","ДПС Г ГВ","ДПС Г КП","Р ПП ДПС Г","ДПС Г ИД","ДПС Г ФР","Р ПП ДПС Г ИД","ДПС Л","ДПС Л ГВ","ДПС Л КП","Р ПП ДПС Л","ДПС Л ИД","ДПС Л ФР","Р ПП ДПС Л ИД","ДПС МК","ДПС МК ГВ","ДПС МК КП","Р ПП ДПС МК","ДПС МК ИД","ДПС МК ФР","Р ПП ДПС МК ИД"}'::text[]))
-> Bitmap Index Scan on account_type_mnemonics_idx1 (cost=0.00..2.96 rows=28 width=0)
Index Cond: ((cat_1.mnemonics)::text = ANY ('{ОПС,"ОПС ГВ","ОПС КП","Р ПП ОПС","ОПС ИД","ОПС ФР","Р ПП ОПС ИД","ДПС Г","ДПС Г ГВ","ДПС Г КП","Р ПП ДПС Г","ДПС Г ИД","ДПС Г ФР","Р ПП ДПС Г ИД","ДПС Л","ДПС Л ГВ","ДПС Л КП","Р ПП ДПС Л","ДПС Л ИД","ДПС Л ФР","Р ПП ДПС Л ИД","ДПС МК","ДПС МК ГВ","ДПС МК КП","Р ПП ДПС МК","ДПС МК ИД","ДПС МК ФР","Р ПП ДПС МК ИД"}'::text[]))
-> Append (cost=0.42..158.03 rows=537 width=14)
-> Index Scan using transaction_2000_credit_account_id_effective_date_value_idx on back_office.transaction_2000 t_213 (cost=0.42..0.98 rows=6 width=14)
Output: t_213.value, t_213.credit_account_id, t_213.debit_account_id
Index Cond: (t_213.credit_account_id = ca_1.id)
-> Index Scan using transaction_2001_credit_account_id_effective_date_value_idx on back_office.transaction_2001 t_214 (cost=0.42..0.92 rows=4 width=14)
Output: t_214.value, t_214.credit_account_id, t_214.debit_account_id
Index Cond: (t_214.credit_account_id = ca_1.id)
-> Index Scan using transaction_2002_credit_account_id_effective_date_value_idx on back_office.transaction_2002 t_215 (cost=0.42..1.04 rows=5 width=14)
Output: t_215.value, t_215.credit_account_id, t_215.debit_account_id
Index Cond: (t_215.credit_account_id = ca_1.id)
-> Index Scan using transaction_2003_credit_account_id_effective_date_value_idx on back_office.transaction_2003 t_216 (cost=0.42..0.76 rows=3 width=14)
Output: t_216.value, t_216.credit_account_id, t_216.debit_account_id
Index Cond: (t_216.credit_account_id = ca_1.id)
-> Index Scan using transaction_2004_credit_account_id_effective_date_value_idx on back_office.transaction_2004 t_217 (cost=0.42..0.77 rows=3 width=14)
Output: t_217.value, t_217.credit_account_id, t_217.debit_account_id
Index Cond: (t_217.credit_account_id = ca_1.id)
-> Index Scan using transaction_2005_credit_account_id_effective_date_value_idx on back_office.transaction_2005 t_218 (cost=0.43..1.25 rows=8 width=13)
Output: t_218.value, t_218.credit_account_id, t_218.debit_account_id
Index Cond: (t_218.credit_account_id = ca_1.id)
-> Index Scan using transaction_2006_credit_account_id_effective_date_value_idx on back_office.transaction_2006 t_219 (cost=0.43..1.28 rows=9 width=14)
Output: t_219.value, t_219.credit_account_id, t_219.debit_account_id
Index Cond: (t_219.credit_account_id = ca_1.id)
-> Index Scan using transaction_2007_credit_account_id_effective_date_value_idx on back_office.transaction_2007 t_220 (cost=0.43..1.50 rows=11 width=13)
Output: t_220.value, t_220.credit_account_id, t_220.debit_account_id
Index Cond: (t_220.credit_account_id = ca_1.id)
-> Index Scan using transaction_2008_credit_account_id_effective_date_value_idx on back_office.transaction_2008 t_221 (cost=0.43..1.87 rows=14 width=14)
Output: t_221.value, t_221.credit_account_id, t_221.debit_account_id
Index Cond: (t_221.credit_account_id = ca_1.id)
-> Index Scan using transaction_2009_credit_account_id_effective_date_value_idx on back_office.transaction_2009 t_222 (cost=0.43..1.63 rows=13 width=14)
Output: t_222.value, t_222.credit_account_id, t_222.debit_account_id
Index Cond: (t_222.credit_account_id = ca_1.id)
-> Index Scan using transaction_2010_credit_account_id_effective_date_value_idx on back_office.transaction_2010 t_223 (cost=0.43..1.82 rows=15 width=14)
Output: t_223.value, t_223.credit_account_id, t_223.debit_account_id
Index Cond: (t_223.credit_account_id = ca_1.id)
-> Index Scan using transaction_2011_01_credit_account_id_effective_date_value_idx on back_office.transaction_2011_01 t_224 (cost=0.42..0.72 rows=2 width=14)
Output: t_224.value, t_224.credit_account_id, t_224.debit_account_id
Index Cond: (t_224.credit_account_id = ca_1.id)
-> Index Scan using transaction_2011_02_credit_account_id_effective_date_value_idx on back_office.transaction_2011_02 t_225 (cost=0.42..0.73 rows=2 width=14)
Output: t_225.value, t_225.credit_account_id, t_225.debit_account_id
Index Cond: (t_225.credit_account_id = ca_1.id)
-> Index Scan using transaction_2011_03_credit_account_id_effective_date_value_idx on back_office.transaction_2011_03 t_226 (cost=0.43..0.71 rows=2 width=14)
Output: t_226.value, t_226.credit_account_id, t_226.debit_account_id
Index Cond: (t_226.credit_account_id = ca_1.id)
-> Index Scan using transaction_2011_04_credit_account_id_effective_date_value_idx on back_office.transaction_2011_04 t_227 (cost=0.42..0.72 rows=2 width=14)
Output: t_227.value, t_227.credit_account_id, t_227.debit_account_id
Index Cond: (t_227.credit_account_id = ca_1.id)
-> Index Scan using transaction_2011_05_credit_account_id_effective_date_value_idx on back_office.transaction_2011_05 t_228 (cost=0.43..0.63 rows=1 width=13)
Output: t_228.value, t_228.credit_account_id, t_228.debit_account_id
Index Cond: (t_228.credit_account_id = ca_1.id)
-> Index Scan using transaction_2011_06_credit_account_id_effective_date_value_idx on back_office.transaction_2011_06 t_229 (cost=0.42..0.73 rows=2 width=14)
Output: t_229.value, t_229.credit_account_id, t_229.debit_account_id
Index Cond: (t_229.credit_account_id = ca_1.id)
-> Index Scan using transaction_2011_07_credit_account_id_effective_date_value_idx on back_office.transaction_2011_07 t_230 (cost=0.42..0.73 rows=2 width=13)
Output: t_230.value, t_230.credit_account_id, t_230.debit_account_id
Index Cond: (t_230.credit_account_id = ca_1.id)
-> Index Scan using transaction_2011_08_credit_account_id_effective_date_value_idx on back_office.transaction_2011_08 t_231 (cost=0.42..0.73 rows=2 width=14)
Output: t_231.value, t_231.credit_account_id, t_231.debit_account_id
Index Cond: (t_231.credit_account_id = ca_1.id)
-> Index Scan using transaction_2011_09_credit_account_id_effective_date_value_idx on back_office.transaction_2011_09 t_232 (cost=0.43..0.63 rows=1 width=13)
Output: t_232.value, t_232.credit_account_id, t_232.debit_account_id
Index Cond: (t_232.credit_account_id = ca_1.id)
-> Index Scan using transaction_2011_10_credit_account_id_effective_date_value_idx on back_office.transaction_2011_10 t_233 (cost=0.42..0.73 rows=2 width=14)
Output: t_233.value, t_233.credit_account_id, t_233.debit_account_id
Index Cond: (t_233.credit_account_id = ca_1.id)
-> Index Scan using transaction_2011_11_credit_account_id_effective_date_value_idx on back_office.transaction_2011_11 t_234 (cost=0.43..0.63 rows=1 width=13)
Output: t_234.value, t_234.credit_account_id, t_234.debit_account_id
Index Cond: (t_234.credit_account_id = ca_1.id)
-> Index Scan using transaction_2011_12_credit_account_id_effective_date_value_idx on back_office.transaction_2011_12 t_235 (cost=0.43..0.64 rows=1 width=14)
Output: t_235.value, t_235.credit_account_id, t_235.debit_account_id
Index Cond: (t_235.credit_account_id = ca_1.id)
-> Index Scan using transaction_2012_01_credit_account_id_effective_date_value_idx on back_office.transaction_2012_01 t_236 (cost=0.42..0.72 rows=2 width=14)
Output: t_236.value, t_236.credit_account_id, t_236.debit_account_id
Index Cond: (t_236.credit_account_id = ca_1.id)
-> Index Scan using transaction_2012_02_credit_account_id_effective_date_value_idx on back_office.transaction_2012_02 t_237 (cost=0.42..0.73 rows=2 width=14)
Output: t_237.value, t_237.credit_account_id, t_237.debit_account_id
Index Cond: (t_237.credit_account_id = ca_1.id)
-> Index Scan using transaction_2012_03_credit_account_id_effective_date_value_idx on back_office.transaction_2012_03 t_238 (cost=0.43..0.84 rows=3 width=13)
Output: t_238.value, t_238.credit_account_id, t_238.debit_account_id
Index Cond: (t_238.credit_account_id = ca_1.id)
-> Index Scan using transaction_2012_04_credit_account_id_effective_date_value_idx on back_office.transaction_2012_04 t_239 (cost=0.42..0.72 rows=2 width=14)
Output: t_239.value, t_239.credit_account_id, t_239.debit_account_id
Index Cond: (t_239.credit_account_id = ca_1.id)
-> Index Scan using transaction_2012_05_credit_account_id_effective_date_value_idx on back_office.transaction_2012_05 t_240 (cost=0.42..0.73 rows=2 width=14)
Output: t_240.value, t_240.credit_account_id, t_240.debit_account_id
Index Cond: (t_240.credit_account_id = ca_1.id)
-> Index Scan using transaction_2012_06_credit_account_id_effective_date_value_idx on back_office.transaction_2012_06 t_241 (cost=0.43..0.64 rows=1 width=13)
Output: t_241.value, t_241.credit_account_id, t_241.debit_account_id
Index Cond: (t_241.credit_account_id = ca_1.id)
-> Index Scan using transaction_2012_07_credit_account_id_effective_date_value_idx on back_office.transaction_2012_07 t_242 (cost=0.42..0.73 rows=2 width=13)
Output: t_242.value, t_242.credit_account_id, t_242.debit_account_id
Index Cond: (t_242.credit_account_id = ca_1.id)
-> Index Scan using transaction_2012_08_credit_account_id_effective_date_value_idx on back_office.transaction_2012_08 t_243 (cost=0.43..0.71 rows=2 width=14)
Output: t_243.value, t_243.credit_account_id, t_243.debit_account_id
Index Cond: (t_243.credit_account_id = ca_1.id)
-> Index Scan using transaction_2012_09_credit_account_id_effective_date_value_idx on back_office.transaction_2012_09 t_244 (cost=0.43..0.64 rows=1 width=13)
Output: t_244.value, t_244.credit_account_id, t_244.debit_account_id
Index Cond: (t_244.credit_account_id = ca_1.id)
-> Index Scan using transaction_2012_10_credit_account_id_effective_date_value_idx on back_office.transaction_2012_10 t_245 (cost=0.43..0.71 rows=2 width=14)
Output: t_245.value, t_245.credit_account_id, t_245.debit_account_id
Index Cond: (t_245.credit_account_id = ca_1.id)
-> Index Scan using transaction_2012_11_credit_account_id_effective_date_value_idx on back_office.transaction_2012_11 t_246 (cost=0.42..0.72 rows=2 width=14)
Output: t_246.value, t_246.credit_account_id, t_246.debit_account_id
Index Cond: (t_246.credit_account_id = ca_1.id)
-> Index Scan using transaction_2012_12_credit_account_id_effective_date_value_idx on back_office.transaction_2012_12 t_247 (cost=0.43..0.76 rows=2 width=14)
Output: t_247.value, t_247.credit_account_id, t_247.debit_account_id
Index Cond: (t_247.credit_account_id = ca_1.id)
-> Index Scan using transaction_2013_01_credit_account_id_effective_date_value_idx on back_office.transaction_2013_01 t_248 (cost=0.42..0.72 rows=2 width=14)
Output: t_248.value, t_248.credit_account_id, t_248.debit_account_id
Index Cond: (t_248.credit_account_id = ca_1.id)
-> Index Scan using transaction_2013_02_credit_account_id_effective_date_value_idx on back_office.transaction_2013_02 t_249 (cost=0.42..0.72 rows=2 width=14)
Output: t_249.value, t_249.credit_account_id, t_249.debit_account_id
Index Cond: (t_249.credit_account_id = ca_1.id)
-> Index Scan using transaction_2013_03_credit_account_id_effective_date_value_idx on back_office.transaction_2013_03 t_250 (cost=0.43..1.09 rows=5 width=13)
Output: t_250.value, t_250.credit_account_id, t_250.debit_account_id
Index Cond: (t_250.credit_account_id = ca_1.id)
-> Index Scan using transaction_2013_04_credit_account_id_effective_date_value_idx on back_office.transaction_2013_04 t_251 (cost=0.43..0.80 rows=3 width=14)
Output: t_251.value, t_251.credit_account_id, t_251.debit_account_id
Index Cond: (t_251.credit_account_id = ca_1.id)
-> Index Scan using transaction_2013_05_credit_account_id_effective_date_value_idx on back_office.transaction_2013_05 t_252 (cost=0.43..0.72 rows=2 width=13)
Output: t_252.value, t_252.credit_account_id, t_252.debit_account_id
Index Cond: (t_252.credit_account_id = ca_1.id)
-> Index Scan using transaction_2013_06_credit_account_id_effective_date_value_idx on back_office.transaction_2013_06 t_253 (cost=0.43..0.64 rows=1 width=13)
Output: t_253.value, t_253.credit_account_id, t_253.debit_account_id
Index Cond: (t_253.credit_account_id = ca_1.id)
-> Index Scan using transaction_2013_07_credit_account_id_effective_date_value_idx on back_office.transaction_2013_07 t_254 (cost=0.42..0.72 rows=2 width=14)
Output: t_254.value, t_254.credit_account_id, t_254.debit_account_id
Index Cond: (t_254.credit_account_id = ca_1.id)
-> Index Scan using transaction_2013_08_credit_account_id_effective_date_value_idx on back_office.transaction_2013_08 t_255 (cost=0.42..0.73 rows=2 width=14)
Output: t_255.value, t_255.credit_account_id, t_255.debit_account_id
Index Cond: (t_255.credit_account_id = ca_1.id)
-> Index Scan using transaction_2013_09_credit_account_id_effective_date_value_idx on back_office.transaction_2013_09 t_256 (cost=0.43..0.65 rows=1 width=13)
Output: t_256.value, t_256.credit_account_id, t_256.debit_account_id
Index Cond: (t_256.credit_account_id = ca_1.id)
-> Index Scan using transaction_2013_10_credit_account_id_effective_date_value_idx on back_office.transaction_2013_10 t_257 (cost=0.43..0.73 rows=2 width=13)
Output: t_257.value, t_257.credit_account_id, t_257.debit_account_id
Index Cond: (t_257.credit_account_id = ca_1.id)
-> Index Scan using transaction_2013_11_credit_account_id_effective_date_value_idx on back_office.transaction_2013_11 t_258 (cost=0.42..0.72 rows=2 width=14)
Output: t_258.value, t_258.credit_account_id, t_258.debit_account_id
Index Cond: (t_258.credit_account_id = ca_1.id)
-> Index Scan using transaction_2013_12_credit_account_id_effective_date_value_idx on back_office.transaction_2013_12 t_259 (cost=0.43..0.76 rows=2 width=14)
Output: t_259.value, t_259.credit_account_id, t_259.debit_account_id
Index Cond: (t_259.credit_account_id = ca_1.id)
-> Index Scan using transaction_2014_01_credit_account_id_effective_date_value_idx on back_office.transaction_2014_01 t_260 (cost=0.42..0.73 rows=2 width=14)
Output: t_260.value, t_260.credit_account_id, t_260.debit_account_id
Index Cond: (t_260.credit_account_id = ca_1.id)
-> Index Scan using transaction_2014_02_credit_account_id_effective_date_value_idx on back_office.transaction_2014_02 t_261 (cost=0.42..0.73 rows=2 width=14)
Output: t_261.value, t_261.credit_account_id, t_261.debit_account_id
Index Cond: (t_261.credit_account_id = ca_1.id)
-> Index Scan using transaction_2014_03_credit_account_id_effective_date_value_idx on back_office.transaction_2014_03 t_262 (cost=0.43..0.85 rows=4 width=14)
Output: t_262.value, t_262.credit_account_id, t_262.debit_account_id
Index Cond: (t_262.credit_account_id = ca_1.id)
-> Index Scan using transaction_2014_04_credit_account_id_effective_date_value_idx on back_office.transaction_2014_04 t_263 (cost=0.42..0.72 rows=2 width=14)
Output: t_263.value, t_263.credit_account_id, t_263.debit_account_id
Index Cond: (t_263.credit_account_id = ca_1.id)
-> Index Scan using transaction_2014_05_credit_account_id_effective_date_value_idx on back_office.transaction_2014_05 t_264 (cost=0.42..0.73 rows=2 width=14)
Output: t_264.value, t_264.credit_account_id, t_264.debit_account_id
Index Cond: (t_264.credit_account_id = ca_1.id)
-> Index Scan using transaction_2014_06_credit_account_id_effective_date_value_idx on back_office.transaction_2014_06 t_265 (cost=0.43..0.72 rows=2 width=14)
Output: t_265.value, t_265.credit_account_id, t_265.debit_account_id
Index Cond: (t_265.credit_account_id = ca_1.id)
-> Index Scan using transaction_2014_07_credit_account_id_effective_date_value_idx on back_office.transaction_2014_07 t_266 (cost=0.42..0.73 rows=2 width=14)
Output: t_266.value, t_266.credit_account_id, t_266.debit_account_id
Index Cond: (t_266.credit_account_id = ca_1.id)
-> Index Scan using transaction_2014_08_credit_account_id_effective_date_value_idx on back_office.transaction_2014_08 t_267 (cost=0.42..0.73 rows=2 width=14)
Output: t_267.value, t_267.credit_account_id, t_267.debit_account_id
Index Cond: (t_267.credit_account_id = ca_1.id)
-> Index Scan using transaction_2014_09_credit_account_id_effective_date_value_idx on back_office.transaction_2014_09 t_268 (cost=0.43..0.72 rows=2 width=14)
Output: t_268.value, t_268.credit_account_id, t_268.debit_account_id
Index Cond: (t_268.credit_account_id = ca_1.id)
-> Index Scan using transaction_2014_10_credit_account_id_effective_date_value_idx on back_office.transaction_2014_10 t_269 (cost=0.42..0.73 rows=2 width=14)
Output: t_269.value, t_269.credit_account_id, t_269.debit_account_id
Index Cond: (t_269.credit_account_id = ca_1.id)
-> Index Scan using transaction_2014_11_credit_account_id_effective_date_value_idx on back_office.transaction_2014_11 t_270 (cost=0.42..0.73 rows=2 width=14)
Output: t_270.value, t_270.credit_account_id, t_270.debit_account_id
Index Cond: (t_270.credit_account_id = ca_1.id)
-> Index Scan using transaction_2014_12_credit_account_id_effective_date_value_idx on back_office.transaction_2014_12 t_271 (cost=0.43..0.76 rows=2 width=14)
Output: t_271.value, t_271.credit_account_id, t_271.debit_account_id
Index Cond: (t_271.credit_account_id = ca_1.id)
-> Index Scan using transaction_2015_01_credit_account_id_effective_date_value_idx on back_office.transaction_2015_01 t_272 (cost=0.43..0.71 rows=2 width=14)
Output: t_272.value, t_272.credit_account_id, t_272.debit_account_id
Index Cond: (t_272.credit_account_id = ca_1.id)
-> Index Scan using transaction_2015_02_credit_account_id_effective_date_value_idx on back_office.transaction_2015_02 t_273 (cost=0.42..0.73 rows=2 width=14)
Output: t_273.value, t_273.credit_account_id, t_273.debit_account_id
Index Cond: (t_273.credit_account_id = ca_1.id)
-> Index Scan using transaction_2015_03_credit_account_id_effective_date_value_idx on back_office.transaction_2015_03 t_274 (cost=0.42..0.73 rows=2 width=14)
Output: t_274.value, t_274.credit_account_id, t_274.debit_account_id
Index Cond: (t_274.credit_account_id = ca_1.id)
-> Index Scan using transaction_2015_04_credit_account_id_effective_date_value_idx on back_office.transaction_2015_04 t_275 (cost=0.56..1.02 rows=3 width=14)
Output: t_275.value, t_275.credit_account_id, t_275.debit_account_id
Index Cond: (t_275.credit_account_id = ca_1.id)
-> Index Scan using transaction_2015_05_credit_account_id_effective_date_value_idx on back_office.transaction_2015_05 t_276 (cost=0.43..1.27 rows=10 width=15)
Output: t_276.value, t_276.credit_account_id, t_276.debit_account_id
Index Cond: (t_276.credit_account_id = ca_1.id)
-> Index Scan using transaction_2015_06_credit_account_id_effective_date_value_idx on back_office.transaction_2015_06 t_277 (cost=0.43..0.71 rows=2 width=14)
Output: t_277.value, t_277.credit_account_id, t_277.debit_account_id
Index Cond: (t_277.credit_account_id = ca_1.id)
-> Index Scan using transaction_2015_07_credit_account_id_effective_date_value_idx on back_office.transaction_2015_07 t_278 (cost=0.43..0.72 rows=2 width=14)
Output: t_278.value, t_278.credit_account_id, t_278.debit_account_id
Index Cond: (t_278.credit_account_id = ca_1.id)
-> Index Scan using transaction_2015_08_credit_account_id_effective_date_value_idx on back_office.transaction_2015_08 t_279 (cost=0.42..0.73 rows=2 width=14)
Output: t_279.value, t_279.credit_account_id, t_279.debit_account_id
Index Cond: (t_279.credit_account_id = ca_1.id)
-> Index Scan using transaction_2015_09_credit_account_id_effective_date_value_idx on back_office.transaction_2015_09 t_280 (cost=0.43..0.72 rows=2 width=14)
Output: t_280.value, t_280.credit_account_id, t_280.debit_account_id
Index Cond: (t_280.credit_account_id = ca_1.id)
-> Index Scan using transaction_2015_10_credit_account_id_effective_date_value_idx on back_office.transaction_2015_10 t_281 (cost=0.42..0.71 rows=2 width=14)
Output: t_281.value, t_281.credit_account_id, t_281.debit_account_id
Index Cond: (t_281.credit_account_id = ca_1.id)
-> Index Scan using transaction_2015_11_credit_account_id_effective_date_value_idx on back_office.transaction_2015_11 t_282 (cost=0.43..0.78 rows=3 width=14)
Output: t_282.value, t_282.credit_account_id, t_282.debit_account_id
Index Cond: (t_282.credit_account_id = ca_1.id)
-> Index Scan using transaction_2015_12_credit_account_id_effective_date_value_idx on back_office.transaction_2015_12 t_283 (cost=0.43..0.65 rows=1 width=14)
Output: t_283.value, t_283.credit_account_id, t_283.debit_account_id
Index Cond: (t_283.credit_account_id = ca_1.id)
-> Index Scan using transaction_2016_01_credit_account_id_effective_date_value_idx on back_office.transaction_2016_01 t_284 (cost=0.42..0.72 rows=2 width=14)
Output: t_284.value, t_284.credit_account_id, t_284.debit_account_id
Index Cond: (t_284.credit_account_id = ca_1.id)
-> Index Scan using transaction_2016_02_credit_account_id_effective_date_value_idx on back_office.transaction_2016_02 t_285 (cost=0.42..0.73 rows=2 width=14)
Output: t_285.value, t_285.credit_account_id, t_285.debit_account_id
Index Cond: (t_285.credit_account_id = ca_1.id)
-> Index Scan using transaction_2016_03_credit_account_id_effective_date_value_idx on back_office.transaction_2016_03 t_286 (cost=0.43..1.48 rows=14 width=15)
Output: t_286.value, t_286.credit_account_id, t_286.debit_account_id
Index Cond: (t_286.credit_account_id = ca_1.id)
-> Index Scan using transaction_2016_04_credit_account_id_effective_date_value_idx on back_office.transaction_2016_04 t_287 (cost=0.43..0.79 rows=3 width=14)
Output: t_287.value, t_287.credit_account_id, t_287.debit_account_id
Index Cond: (t_287.credit_account_id = ca_1.id)
-> Index Scan using transaction_2016_05_credit_account_id_effective_date_value_idx on back_office.transaction_2016_05 t_288 (cost=0.43..0.73 rows=2 width=13)
Output: t_288.value, t_288.credit_account_id, t_288.debit_account_id
Index Cond: (t_288.credit_account_id = ca_1.id)
-> Index Scan using transaction_2016_06_credit_account_id_effective_date_value_idx on back_office.transaction_2016_06 t_289 (cost=0.43..0.84 rows=4 width=14)
Output: t_289.value, t_289.credit_account_id, t_289.debit_account_id
Index Cond: (t_289.credit_account_id = ca_1.id)
-> Index Scan using transaction_2016_07_credit_account_id_effective_date_value_idx on back_office.transaction_2016_07 t_290 (cost=0.42..0.72 rows=2 width=14)
Output: t_290.value, t_290.credit_account_id, t_290.debit_account_id
Index Cond: (t_290.credit_account_id = ca_1.id)
-> Index Scan using transaction_2016_08_credit_account_id_effective_date_value_idx on back_office.transaction_2016_08 t_291 (cost=0.42..0.73 rows=2 width=14)
Output: t_291.value, t_291.credit_account_id, t_291.debit_account_id
Index Cond: (t_291.credit_account_id = ca_1.id)
-> Index Scan using transaction_2016_09_credit_account_id_effective_date_value_idx on back_office.transaction_2016_09 t_292 (cost=0.43..0.78 rows=3 width=14)
Output: t_292.value, t_292.credit_account_id, t_292.debit_account_id
Index Cond: (t_292.credit_account_id = ca_1.id)
-> Index Scan using transaction_2016_10_credit_account_id_effective_date_value_idx on back_office.transaction_2016_10 t_293 (cost=0.42..0.72 rows=2 width=14)
Output: t_293.value, t_293.credit_account_id, t_293.debit_account_id
Index Cond: (t_293.credit_account_id = ca_1.id)
-> Index Scan using transaction_2016_11_credit_account_id_effective_date_value_idx on back_office.transaction_2016_11 t_294 (cost=0.42..0.73 rows=2 width=14)
Output: t_294.value, t_294.credit_account_id, t_294.debit_account_id
Index Cond: (t_294.credit_account_id = ca_1.id)
-> Index Scan using transaction_2016_12_credit_account_id_effective_date_value_idx on back_office.transaction_2016_12 t_295 (cost=0.56..1.13 rows=4 width=14)
Output: t_295.value, t_295.credit_account_id, t_295.debit_account_id
Index Cond: (t_295.credit_account_id = ca_1.id)
-> Index Scan using transaction_2017_01_credit_account_id_effective_date_value_idx on back_office.transaction_2017_01 t_296 (cost=0.42..0.71 rows=2 width=14)
Output: t_296.value, t_296.credit_account_id, t_296.debit_account_id
Index Cond: (t_296.credit_account_id = ca_1.id)
-> Index Scan using transaction_2017_02_credit_account_id_effective_date_value_idx on back_office.transaction_2017_02 t_297 (cost=0.42..0.73 rows=2 width=14)
Output: t_297.value, t_297.credit_account_id, t_297.debit_account_id
Index Cond: (t_297.credit_account_id = ca_1.id)
-> Index Scan using transaction_2017_03_credit_account_id_effective_date_value_idx on back_office.transaction_2017_03 t_298 (cost=0.43..1.03 rows=7 width=15)
Output: t_298.value, t_298.credit_account_id, t_298.debit_account_id
Index Cond: (t_298.credit_account_id = ca_1.id)
-> Index Scan using transaction_2017_04_credit_account_id_effective_date_value_idx on back_office.transaction_2017_04 t_299 (cost=0.42..0.78 rows=3 width=14)
Output: t_299.value, t_299.credit_account_id, t_299.debit_account_id
Index Cond: (t_299.credit_account_id = ca_1.id)
-> Index Scan using transaction_2017_05_credit_account_id_effective_date_value_idx on back_office.transaction_2017_05 t_300 (cost=0.43..0.98 rows=6 width=14)
Output: t_300.value, t_300.credit_account_id, t_300.debit_account_id
Index Cond: (t_300.credit_account_id = ca_1.id)
-> Index Scan using transaction_2017_06_credit_account_id_effective_date_value_idx on back_office.transaction_2017_06 t_301 (cost=0.42..0.71 rows=2 width=14)
Output: t_301.value, t_301.credit_account_id, t_301.debit_account_id
Index Cond: (t_301.credit_account_id = ca_1.id)
-> Index Scan using transaction_2017_07_credit_account_id_effective_date_value_idx on back_office.transaction_2017_07 t_302 (cost=0.42..0.71 rows=2 width=14)
Output: t_302.value, t_302.credit_account_id, t_302.debit_account_id
Index Cond: (t_302.credit_account_id = ca_1.id)
-> Index Scan using transaction_2017_08_credit_account_id_effective_date_value_idx on back_office.transaction_2017_08 t_303 (cost=0.42..0.72 rows=2 width=14)
Output: t_303.value, t_303.credit_account_id, t_303.debit_account_id
Index Cond: (t_303.credit_account_id = ca_1.id)
-> Index Scan using transaction_2017_09_credit_account_id_effective_date_value_idx on back_office.transaction_2017_09 t_304 (cost=0.42..0.70 rows=2 width=14)
Output: t_304.value, t_304.credit_account_id, t_304.debit_account_id
Index Cond: (t_304.credit_account_id = ca_1.id)
-> Index Scan using transaction_2017_10_credit_account_id_effective_date_value_idx on back_office.transaction_2017_10 t_305 (cost=0.42..0.71 rows=2 width=13)
Output: t_305.value, t_305.credit_account_id, t_305.debit_account_id
Index Cond: (t_305.credit_account_id = ca_1.id)
-> Index Scan using transaction_2017_11_credit_account_id_effective_date_value_idx on back_office.transaction_2017_11 t_306 (cost=0.42..0.85 rows=4 width=14)
Output: t_306.value, t_306.credit_account_id, t_306.debit_account_id
Index Cond: (t_306.credit_account_id = ca_1.id)
-> Index Scan using transaction_2017_12_credit_account_id_effective_date_value_idx on back_office.transaction_2017_12 t_307 (cost=0.56..0.89 rows=2 width=14)
Output: t_307.value, t_307.credit_account_id, t_307.debit_account_id
Index Cond: (t_307.credit_account_id = ca_1.id)
-> Index Scan using transaction_2018_01_credit_account_id_effective_date_value_idx on back_office.transaction_2018_01 t_308 (cost=0.42..0.71 rows=2 width=13)
Output: t_308.value, t_308.credit_account_id, t_308.debit_account_id
Index Cond: (t_308.credit_account_id = ca_1.id)
-> Index Scan using transaction_2018_02_credit_account_id_effective_date_value_idx on back_office.transaction_2018_02 t_309 (cost=0.42..0.72 rows=2 width=13)
Output: t_309.value, t_309.credit_account_id, t_309.debit_account_id
Index Cond: (t_309.credit_account_id = ca_1.id)
-> Index Scan using transaction_2018_03_credit_account_id_effective_date_value_idx on back_office.transaction_2018_03 t_310 (cost=0.43..1.77 rows=17 width=15)
Output: t_310.value, t_310.credit_account_id, t_310.debit_account_id
Index Cond: (t_310.credit_account_id = ca_1.id)
-> Index Scan using transaction_2018_04_credit_account_id_effective_date_value_idx on back_office.transaction_2018_04 t_311 (cost=0.42..0.70 rows=2 width=13)
Output: t_311.value, t_311.credit_account_id, t_311.debit_account_id
Index Cond: (t_311.credit_account_id = ca_1.id)
-> Index Scan using transaction_2018_05_credit_account_id_effective_date_value_idx on back_office.transaction_2018_05 t_312 (cost=0.42..0.71 rows=2 width=13)
Output: t_312.value, t_312.credit_account_id, t_312.debit_account_id
Index Cond: (t_312.credit_account_id = ca_1.id)
-> Index Scan using transaction_2018_06_credit_account_id_effective_date_value_idx on back_office.transaction_2018_06 t_313 (cost=0.42..0.71 rows=2 width=14)
Output: t_313.value, t_313.credit_account_id, t_313.debit_account_id
Index Cond: (t_313.credit_account_id = ca_1.id)
-> Index Scan using transaction_2018_07_credit_account_id_effective_date_value_idx on back_office.transaction_2018_07 t_314 (cost=0.43..0.72 rows=2 width=14)
Output: t_314.value, t_314.credit_account_id, t_314.debit_account_id
Index Cond: (t_314.credit_account_id = ca_1.id)
-> Index Scan using transaction_2018_08_credit_account_id_effective_date_value_idx on back_office.transaction_2018_08 t_315 (cost=0.42..0.72 rows=2 width=14)
Output: t_315.value, t_315.credit_account_id, t_315.debit_account_id
Index Cond: (t_315.credit_account_id = ca_1.id)
-> Index Scan using transaction_2018_09_credit_account_id_effective_date_value_idx on back_office.transaction_2018_09 t_316 (cost=0.43..0.71 rows=2 width=13)
Output: t_316.value, t_316.credit_account_id, t_316.debit_account_id
Index Cond: (t_316.credit_account_id = ca_1.id)
-> Index Scan using transaction_2018_10_credit_account_id_effective_date_value_idx on back_office.transaction_2018_10 t_317 (cost=0.42..0.71 rows=2 width=13)
Output: t_317.value, t_317.credit_account_id, t_317.debit_account_id
Index Cond: (t_317.credit_account_id = ca_1.id)
-> Index Scan using transaction_2018_11_credit_account_id_effective_date_value_idx on back_office.transaction_2018_11 t_318 (cost=0.42..0.72 rows=2 width=13)
Output: t_318.value, t_318.credit_account_id, t_318.debit_account_id
Index Cond: (t_318.credit_account_id = ca_1.id)
-> Index Scan using transaction_2018_12_credit_account_id_effective_date_value_idx on back_office.transaction_2018_12 t_319 (cost=0.43..0.65 rows=1 width=15)
Output: t_319.value, t_319.credit_account_id, t_319.debit_account_id
Index Cond: (t_319.credit_account_id = ca_1.id)
-> Index Scan using transaction_2019_01_credit_account_id_effective_date_value_idx on back_office.transaction_2019_01 t_320 (cost=0.43..0.63 rows=1 width=14)
Output: t_320.value, t_320.credit_account_id, t_320.debit_account_id
Index Cond: (t_320.credit_account_id = ca_1.id)
-> Index Scan using transaction_2019_02_credit_account_id_effective_date_value_idx on back_office.transaction_2019_02 t_321 (cost=0.42..0.62 rows=1 width=14)
Output: t_321.value, t_321.credit_account_id, t_321.debit_account_id
Index Cond: (t_321.credit_account_id = ca_1.id)
-> Index Scan using transaction_2019_03_credit_account_id_effective_date_value_idx on back_office.transaction_2019_03 t_322 (cost=0.43..1.19 rows=8 width=15)
Output: t_322.value, t_322.credit_account_id, t_322.debit_account_id
Index Cond: (t_322.credit_account_id = ca_1.id)
-> Index Scan using transaction_2019_04_credit_account_id_effective_date_value_idx on back_office.transaction_2019_04 t_323 (cost=0.42..0.71 rows=2 width=13)
Output: t_323.value, t_323.credit_account_id, t_323.debit_account_id
Index Cond: (t_323.credit_account_id = ca_1.id)
-> Index Scan using transaction_2019_05_credit_account_id_effective_date_value_idx on back_office.transaction_2019_05 t_324 (cost=0.42..0.62 rows=1 width=13)
Output: t_324.value, t_324.credit_account_id, t_324.debit_account_id
Index Cond: (t_324.credit_account_id = ca_1.id)
-> Index Scan using transaction_2019_06_credit_account_id_effective_date_value_idx on back_office.transaction_2019_06 t_325 (cost=0.42..0.72 rows=2 width=14)
Output: t_325.value, t_325.credit_account_id, t_325.debit_account_id
Index Cond: (t_325.credit_account_id = ca_1.id)
-> Index Scan using transaction_2019_07_credit_account_id_effective_date_value_idx on back_office.transaction_2019_07 t_326 (cost=0.42..0.71 rows=2 width=13)
Output: t_326.value, t_326.credit_account_id, t_326.debit_account_id
Index Cond: (t_326.credit_account_id = ca_1.id)
-> Index Scan using transaction_2019_08_credit_account_id_effective_date_value_idx on back_office.transaction_2019_08 t_327 (cost=0.42..0.72 rows=2 width=13)
Output: t_327.value, t_327.credit_account_id, t_327.debit_account_id
Index Cond: (t_327.credit_account_id = ca_1.id)
-> Index Scan using transaction_2019_09_credit_account_id_effective_date_value_idx on back_office.transaction_2019_09 t_328 (cost=0.42..0.72 rows=2 width=14)
Output: t_328.value, t_328.credit_account_id, t_328.debit_account_id
Index Cond: (t_328.credit_account_id = ca_1.id)
-> Index Scan using transaction_2019_10_credit_account_id_effective_date_value_idx on back_office.transaction_2019_10 t_329 (cost=0.42..0.71 rows=2 width=13)
Output: t_329.value, t_329.credit_account_id, t_329.debit_account_id
Index Cond: (t_329.credit_account_id = ca_1.id)
-> Index Scan using transaction_2019_11_credit_account_id_effective_date_value_idx on back_office.transaction_2019_11 t_330 (cost=0.42..0.72 rows=2 width=13)
Output: t_330.value, t_330.credit_account_id, t_330.debit_account_id
Index Cond: (t_330.credit_account_id = ca_1.id)
-> Index Scan using transaction_2019_12_credit_account_id_effective_date_value_idx on back_office.transaction_2019_12 t_331 (cost=0.56..0.89 rows=2 width=14)
Output: t_331.value, t_331.credit_account_id, t_331.debit_account_id
Index Cond: (t_331.credit_account_id = ca_1.id)
-> Index Scan using transaction_2020_01_credit_account_id_effective_date_value_idx on back_office.transaction_2020_01 t_332 (cost=0.42..0.72 rows=2 width=13)
Output: t_332.value, t_332.credit_account_id, t_332.debit_account_id
Index Cond: (t_332.credit_account_id = ca_1.id)
-> Index Scan using transaction_2020_02_credit_account_id_effective_date_value_idx on back_office.transaction_2020_02 t_333 (cost=0.42..0.72 rows=2 width=13)
Output: t_333.value, t_333.credit_account_id, t_333.debit_account_id
Index Cond: (t_333.credit_account_id = ca_1.id)
-> Index Scan using transaction_2020_03_credit_account_id_effective_date_value_idx on back_office.transaction_2020_03 t_334 (cost=0.43..0.85 rows=4 width=14)
Output: t_334.value, t_334.credit_account_id, t_334.debit_account_id
Index Cond: (t_334.credit_account_id = ca_1.id)
-> Index Scan using transaction_2020_04_credit_account_id_effective_date_value_idx on back_office.transaction_2020_04 t_335 (cost=0.42..0.70 rows=2 width=13)
Output: t_335.value, t_335.credit_account_id, t_335.debit_account_id
Index Cond: (t_335.credit_account_id = ca_1.id)
-> Index Scan using transaction_2020_05_credit_account_id_effective_date_value_idx on back_office.transaction_2020_05 t_336 (cost=0.42..0.62 rows=1 width=13)
Output: t_336.value, t_336.credit_account_id, t_336.debit_account_id
Index Cond: (t_336.credit_account_id = ca_1.id)
-> Index Scan using transaction_2020_06_credit_account_id_effective_date_value_idx on back_office.transaction_2020_06 t_337 (cost=0.42..0.72 rows=2 width=14)
Output: t_337.value, t_337.credit_account_id, t_337.debit_account_id
Index Cond: (t_337.credit_account_id = ca_1.id)
-> Index Scan using transaction_2020_07_credit_account_id_effective_date_value_idx on back_office.transaction_2020_07 t_338 (cost=0.42..0.71 rows=2 width=14)
Output: t_338.value, t_338.credit_account_id, t_338.debit_account_id
Index Cond: (t_338.credit_account_id = ca_1.id)
-> Index Scan using transaction_2020_08_credit_account_id_effective_date_value_idx on back_office.transaction_2020_08 t_339 (cost=0.42..0.72 rows=2 width=14)
Output: t_339.value, t_339.credit_account_id, t_339.debit_account_id
Index Cond: (t_339.credit_account_id = ca_1.id)
-> Index Scan using transaction_2020_09_credit_account_id_effective_date_value_idx on back_office.transaction_2020_09 t_340 (cost=0.42..0.71 rows=2 width=14)
Output: t_340.value, t_340.credit_account_id, t_340.debit_account_id
Index Cond: (t_340.credit_account_id = ca_1.id)
-> Index Scan using transaction_2020_10_credit_account_id_effective_date_value_idx on back_office.transaction_2020_10 t_341 (cost=0.42..0.72 rows=2 width=13)
Output: t_341.value, t_341.credit_account_id, t_341.debit_account_id
Index Cond: (t_341.credit_account_id = ca_1.id)
-> Index Scan using transaction_2020_11_credit_account_id_effective_date_value_idx on back_office.transaction_2020_11 t_342 (cost=0.42..0.72 rows=2 width=13)
Output: t_342.value, t_342.credit_account_id, t_342.debit_account_id
Index Cond: (t_342.credit_account_id = ca_1.id)
-> Index Scan using transaction_2020_12_credit_account_id_effective_date_value_idx on back_office.transaction_2020_12 t_343 (cost=0.56..0.90 rows=2 width=14)
Output: t_343.value, t_343.credit_account_id, t_343.debit_account_id
Index Cond: (t_343.credit_account_id = ca_1.id)
-> Index Scan using transaction_2021_01_credit_account_id_effective_date_value_idx on back_office.transaction_2021_01 t_344 (cost=0.42..0.62 rows=1 width=13)
Output: t_344.value, t_344.credit_account_id, t_344.debit_account_id
Index Cond: (t_344.credit_account_id = ca_1.id)
-> Index Scan using transaction_2021_02_credit_account_id_effective_date_value_idx on back_office.transaction_2021_02 t_345 (cost=0.42..0.71 rows=2 width=13)
Output: t_345.value, t_345.credit_account_id, t_345.debit_account_id
Index Cond: (t_345.credit_account_id = ca_1.id)
-> Index Scan using transaction_2021_03_credit_account_id_effective_date_value_idx on back_office.transaction_2021_03 t_346 (cost=0.42..0.78 rows=3 width=14)
Output: t_346.value, t_346.credit_account_id, t_346.debit_account_id
Index Cond: (t_346.credit_account_id = ca_1.id)
-> Index Scan using transaction_2021_04_credit_account_id_effective_date_value_idx on back_office.transaction_2021_04 t_347 (cost=0.42..0.71 rows=2 width=14)
Output: t_347.value, t_347.credit_account_id, t_347.debit_account_id
Index Cond: (t_347.credit_account_id = ca_1.id)
-> Index Scan using transaction_2021_05_credit_account_id_effective_date_value_idx on back_office.transaction_2021_05 t_348 (cost=0.42..0.62 rows=1 width=13)
Output: t_348.value, t_348.credit_account_id, t_348.debit_account_id
Index Cond: (t_348.credit_account_id = ca_1.id)
-> Index Scan using transaction_2021_06_credit_account_id_effective_date_value_idx on back_office.transaction_2021_06 t_349 (cost=0.42..0.72 rows=2 width=14)
Output: t_349.value, t_349.credit_account_id, t_349.debit_account_id
Index Cond: (t_349.credit_account_id = ca_1.id)
-> Index Scan using transaction_2021_07_credit_account_id_effective_date_value_idx on back_office.transaction_2021_07 t_350 (cost=0.42..0.72 rows=2 width=14)
Output: t_350.value, t_350.credit_account_id, t_350.debit_account_id
Index Cond: (t_350.credit_account_id = ca_1.id)
-> Index Scan using transaction_2021_08_credit_account_id_effective_date_value_idx on back_office.transaction_2021_08 t_351 (cost=0.42..0.72 rows=2 width=14)
Output: t_351.value, t_351.credit_account_id, t_351.debit_account_id
Index Cond: (t_351.credit_account_id = ca_1.id)
-> Index Scan using transaction_2021_09_credit_account_id_effective_date_value_idx on back_office.transaction_2021_09 t_352 (cost=0.42..0.71 rows=2 width=14)
Output: t_352.value, t_352.credit_account_id, t_352.debit_account_id
Index Cond: (t_352.credit_account_id = ca_1.id)
-> Index Scan using transaction_2021_10_credit_account_id_effective_date_value_idx on back_office.transaction_2021_10 t_353 (cost=0.42..0.71 rows=2 width=14)
Output: t_353.value, t_353.credit_account_id, t_353.debit_account_id
Index Cond: (t_353.credit_account_id = ca_1.id)
-> Index Scan using transaction_2021_11_credit_account_id_effective_date_value_idx on back_office.transaction_2021_11 t_354 (cost=0.42..0.73 rows=2 width=13)
Output: t_354.value, t_354.credit_account_id, t_354.debit_account_id
Index Cond: (t_354.credit_account_id = ca_1.id)
-> Index Scan using transaction_2021_12_credit_account_id_effective_date_value_idx on back_office.transaction_2021_12 t_355 (cost=0.43..0.65 rows=1 width=14)
Output: t_355.value, t_355.credit_account_id, t_355.debit_account_id
Index Cond: (t_355.credit_account_id = ca_1.id)
-> Index Scan using transaction_2022_01_credit_account_id_effective_date_value_idx on back_office.transaction_2022_01 t_356 (cost=0.42..0.62 rows=1 width=13)
Output: t_356.value, t_356.credit_account_id, t_356.debit_account_id
Index Cond: (t_356.credit_account_id = ca_1.id)
-> Index Scan using transaction_2022_02_credit_account_id_effective_date_value_idx on back_office.transaction_2022_02 t_357 (cost=0.42..0.72 rows=2 width=14)
Output: t_357.value, t_357.credit_account_id, t_357.debit_account_id
Index Cond: (t_357.credit_account_id = ca_1.id)
-> Index Scan using transaction_2022_03_credit_account_id_effective_date_value_idx on back_office.transaction_2022_03 t_358 (cost=0.43..0.73 rows=2 width=14)
Output: t_358.value, t_358.credit_account_id, t_358.debit_account_id
Index Cond: (t_358.credit_account_id = ca_1.id)
-> Index Scan using transaction_2022_04_credit_account_id_effective_date_value_idx on back_office.transaction_2022_04 t_359 (cost=0.42..0.71 rows=2 width=14)
Output: t_359.value, t_359.credit_account_id, t_359.debit_account_id
Index Cond: (t_359.credit_account_id = ca_1.id)
-> Index Scan using transaction_2022_05_credit_account_id_effective_date_value_idx on back_office.transaction_2022_05 t_360 (cost=0.42..0.72 rows=2 width=14)
Output: t_360.value, t_360.credit_account_id, t_360.debit_account_id
Index Cond: (t_360.credit_account_id = ca_1.id)
-> Index Scan using transaction_2022_06_credit_account_id_effective_date_value_idx on back_office.transaction_2022_06 t_361 (cost=0.42..0.72 rows=2 width=14)
Output: t_361.value, t_361.credit_account_id, t_361.debit_account_id
Index Cond: (t_361.credit_account_id = ca_1.id)
-> Index Scan using transaction_2022_07_credit_account_id_effective_date_value_idx on back_office.transaction_2022_07 t_362 (cost=0.42..0.71 rows=2 width=14)
Output: t_362.value, t_362.credit_account_id, t_362.debit_account_id
Index Cond: (t_362.credit_account_id = ca_1.id)
-> Index Scan using transaction_2022_08_credit_account_id_effective_date_value_idx on back_office.transaction_2022_08 t_363 (cost=0.42..0.71 rows=2 width=14)
Output: t_363.value, t_363.credit_account_id, t_363.debit_account_id
Index Cond: (t_363.credit_account_id = ca_1.id)
-> Index Scan using transaction_2022_09_credit_account_id_effective_date_value_idx on back_office.transaction_2022_09 t_364 (cost=0.42..0.71 rows=2 width=14)
Output: t_364.value, t_364.credit_account_id, t_364.debit_account_id
Index Cond: (t_364.credit_account_id = ca_1.id)
-> Index Scan using transaction_2022_10_credit_account_id_effective_date_value_idx on back_office.transaction_2022_10 t_365 (cost=0.42..0.72 rows=2 width=14)
Output: t_365.value, t_365.credit_account_id, t_365.debit_account_id
Index Cond: (t_365.credit_account_id = ca_1.id)
-> Index Scan using transaction_2022_11_credit_account_id_effective_date_value_idx on back_office.transaction_2022_11 t_366 (cost=0.42..0.72 rows=2 width=14)
Output: t_366.value, t_366.credit_account_id, t_366.debit_account_id
Index Cond: (t_366.credit_account_id = ca_1.id)
-> Index Scan using transaction_2022_12_credit_account_id_effective_date_value_idx on back_office.transaction_2022_12 t_367 (cost=0.43..0.65 rows=1 width=14)
Output: t_367.value, t_367.credit_account_id, t_367.debit_account_id
Index Cond: (t_367.credit_account_id = ca_1.id)
-> Index Scan using transaction_2023_01_credit_account_id_effective_date_value_idx on back_office.transaction_2023_01 t_368 (cost=0.42..0.73 rows=2 width=13)
Output: t_368.value, t_368.credit_account_id, t_368.debit_account_id
Index Cond: (t_368.credit_account_id = ca_1.id)
-> Index Scan using transaction_2023_02_credit_account_id_effective_date_value_idx on back_office.transaction_2023_02 t_369 (cost=0.42..0.71 rows=2 width=14)
Output: t_369.value, t_369.credit_account_id, t_369.debit_account_id
Index Cond: (t_369.credit_account_id = ca_1.id)
-> Index Scan using transaction_2023_03_credit_account_id_effective_date_value_idx on back_office.transaction_2023_03 t_370 (cost=0.42..0.78 rows=3 width=14)
Output: t_370.value, t_370.credit_account_id, t_370.debit_account_id
Index Cond: (t_370.credit_account_id = ca_1.id)
-> Index Scan using transaction_2023_04_credit_account_id_effective_date_value_idx on back_office.transaction_2023_04 t_371 (cost=0.42..0.71 rows=2 width=14)
Output: t_371.value, t_371.credit_account_id, t_371.debit_account_id
Index Cond: (t_371.credit_account_id = ca_1.id)
-> Index Scan using transaction_2023_05_credit_account_id_effective_date_value_idx on back_office.transaction_2023_05 t_372 (cost=0.42..0.71 rows=2 width=14)
Output: t_372.value, t_372.credit_account_id, t_372.debit_account_id
Index Cond: (t_372.credit_account_id = ca_1.id)
-> Index Scan using transaction_2023_06_credit_account_id_effective_date_value_idx on back_office.transaction_2023_06 t_373 (cost=0.42..0.71 rows=2 width=14)
Output: t_373.value, t_373.credit_account_id, t_373.debit_account_id
Index Cond: (t_373.credit_account_id = ca_1.id)
-> Index Scan using transaction_2023_07_credit_account_id_effective_date_value_idx on back_office.transaction_2023_07 t_374 (cost=0.42..0.71 rows=2 width=14)
Output: t_374.value, t_374.credit_account_id, t_374.debit_account_id
Index Cond: (t_374.credit_account_id = ca_1.id)
-> Index Scan using transaction_2023_08_credit_account_id_effective_date_value_idx on back_office.transaction_2023_08 t_375 (cost=0.42..0.71 rows=2 width=14)
Output: t_375.value, t_375.credit_account_id, t_375.debit_account_id
Index Cond: (t_375.credit_account_id = ca_1.id)
-> Index Scan using transaction_2023_09_credit_account_id_effective_date_value_idx on back_office.transaction_2023_09 t_376 (cost=0.42..0.70 rows=2 width=14)
Output: t_376.value, t_376.credit_account_id, t_376.debit_account_id
Index Cond: (t_376.credit_account_id = ca_1.id)
-> Index Scan using transaction_2023_10_credit_account_id_effective_date_value_idx on back_office.transaction_2023_10 t_377 (cost=0.42..0.71 rows=2 width=14)
Output: t_377.value, t_377.credit_account_id, t_377.debit_account_id
Index Cond: (t_377.credit_account_id = ca_1.id)
-> Index Scan using transaction_2023_11_credit_account_id_effective_date_value_idx on back_office.transaction_2023_11 t_378 (cost=0.42..0.71 rows=2 width=14)
Output: t_378.value, t_378.credit_account_id, t_378.debit_account_id
Index Cond: (t_378.credit_account_id = ca_1.id)
-> Index Scan using transaction_2023_12_credit_account_id_effective_date_value_idx on back_office.transaction_2023_12 t_379 (cost=0.43..0.65 rows=1 width=14)
Output: t_379.value, t_379.credit_account_id, t_379.debit_account_id
Index Cond: (t_379.credit_account_id = ca_1.id)
-> Index Scan using transaction_2024_01_credit_account_id_effective_date_value_idx on back_office.transaction_2024_01 t_380 (cost=0.42..0.72 rows=2 width=13)
Output: t_380.value, t_380.credit_account_id, t_380.debit_account_id
Index Cond: (t_380.credit_account_id = ca_1.id)
-> Index Scan using transaction_2024_02_credit_account_id_effective_date_value_idx on back_office.transaction_2024_02 t_381 (cost=0.42..0.71 rows=2 width=14)
Output: t_381.value, t_381.credit_account_id, t_381.debit_account_id
Index Cond: (t_381.credit_account_id = ca_1.id)
-> Index Scan using transaction_2024_03_credit_account_id_effective_date_value_idx on back_office.transaction_2024_03 t_382 (cost=0.42..0.78 rows=3 width=14)
Output: t_382.value, t_382.credit_account_id, t_382.debit_account_id
Index Cond: (t_382.credit_account_id = ca_1.id)
-> Index Scan using transaction_2024_04_credit_account_id_effective_date_value_idx on back_office.transaction_2024_04 t_383 (cost=0.42..0.71 rows=2 width=14)
Output: t_383.value, t_383.credit_account_id, t_383.debit_account_id
Index Cond: (t_383.credit_account_id = ca_1.id)
-> Index Scan using transaction_2024_05_credit_account_id_effective_date_value_idx on back_office.transaction_2024_05 t_384 (cost=0.42..0.71 rows=2 width=14)
Output: t_384.value, t_384.credit_account_id, t_384.debit_account_id
Index Cond: (t_384.credit_account_id = ca_1.id)
-> Index Scan using transaction_2024_06_credit_account_id_effective_date_value_idx on back_office.transaction_2024_06 t_385 (cost=0.42..0.71 rows=2 width=14)
Output: t_385.value, t_385.credit_account_id, t_385.debit_account_id
Index Cond: (t_385.credit_account_id = ca_1.id)
-> Index Scan using transaction_2024_07_credit_account_id_effective_date_value_idx on back_office.transaction_2024_07 t_386 (cost=0.42..0.71 rows=2 width=14)
Output: t_386.value, t_386.credit_account_id, t_386.debit_account_id
Index Cond: (t_386.credit_account_id = ca_1.id)
-> Index Scan using transaction_2024_08_credit_account_id_effective_date_value_idx on back_office.transaction_2024_08 t_387 (cost=0.42..0.71 rows=2 width=14)
Output: t_387.value, t_387.credit_account_id, t_387.debit_account_id
Index Cond: (t_387.credit_account_id = ca_1.id)
-> Index Scan using transaction_2024_09_credit_account_id_effective_date_value_idx on back_office.transaction_2024_09 t_388 (cost=0.42..0.70 rows=2 width=14)
Output: t_388.value, t_388.credit_account_id, t_388.debit_account_id
Index Cond: (t_388.credit_account_id = ca_1.id)
-> Index Scan using transaction_2024_10_credit_account_id_effective_date_value_idx on back_office.transaction_2024_10 t_389 (cost=0.42..0.71 rows=2 width=14)
Output: t_389.value, t_389.credit_account_id, t_389.debit_account_id
Index Cond: (t_389.credit_account_id = ca_1.id)
-> Index Scan using transaction_2024_11_credit_account_id_effective_date_value_idx on back_office.transaction_2024_11 t_390 (cost=0.42..0.72 rows=2 width=14)
Output: t_390.value, t_390.credit_account_id, t_390.debit_account_id
Index Cond: (t_390.credit_account_id = ca_1.id)
-> Index Scan using transaction_2024_12_credit_account_id_effective_date_value_idx on back_office.transaction_2024_12 t_391 (cost=0.43..0.65 rows=1 width=14)
Output: t_391.value, t_391.credit_account_id, t_391.debit_account_id
Index Cond: (t_391.credit_account_id = ca_1.id)
-> Index Scan using transaction_2025_01_credit_account_id_effective_date_value_idx on back_office.transaction_2025_01 t_392 (cost=0.42..0.73 rows=2 width=13)
Output: t_392.value, t_392.credit_account_id, t_392.debit_account_id
Index Cond: (t_392.credit_account_id = ca_1.id)
-> Index Scan using transaction_2025_02_credit_account_id_effective_date_value_idx on back_office.transaction_2025_02 t_393 (cost=0.42..0.71 rows=2 width=14)
Output: t_393.value, t_393.credit_account_id, t_393.debit_account_id
Index Cond: (t_393.credit_account_id = ca_1.id)
-> Index Scan using transaction_2025_03_credit_account_id_effective_date_value_idx on back_office.transaction_2025_03 t_394 (cost=0.42..0.78 rows=3 width=14)
Output: t_394.value, t_394.credit_account_id, t_394.debit_account_id
Index Cond: (t_394.credit_account_id = ca_1.id)
-> Index Scan using transaction_2025_04_credit_account_id_effective_date_value_idx on back_office.transaction_2025_04 t_395 (cost=0.42..0.70 rows=2 width=14)
Output: t_395.value, t_395.credit_account_id, t_395.debit_account_id
Index Cond: (t_395.credit_account_id = ca_1.id)
-> Index Scan using transaction_2025_05_credit_account_id_effective_date_value_idx on back_office.transaction_2025_05 t_396 (cost=0.42..0.73 rows=2 width=13)
Output: t_396.value, t_396.credit_account_id, t_396.debit_account_id
Index Cond: (t_396.credit_account_id = ca_1.id)
-> Index Scan using transaction_2025_06_credit_account_id_effective_date_value_idx on back_office.transaction_2025_06 t_397 (cost=0.42..0.71 rows=2 width=14)
Output: t_397.value, t_397.credit_account_id, t_397.debit_account_id
Index Cond: (t_397.credit_account_id = ca_1.id)
-> Index Scan using transaction_2025_07_credit_account_id_effective_date_value_idx on back_office.transaction_2025_07 t_398 (cost=0.42..0.71 rows=2 width=14)
Output: t_398.value, t_398.credit_account_id, t_398.debit_account_id
Index Cond: (t_398.credit_account_id = ca_1.id)
-> Index Scan using transaction_2025_08_credit_account_id_effective_date_value_idx on back_office.transaction_2025_08 t_399 (cost=0.42..0.71 rows=2 width=14)
Output: t_399.value, t_399.credit_account_id, t_399.debit_account_id
Index Cond: (t_399.credit_account_id = ca_1.id)
-> Index Scan using transaction_2025_09_credit_account_id_effective_date_value_idx on back_office.transaction_2025_09 t_400 (cost=0.42..0.70 rows=2 width=14)
Output: t_400.value, t_400.credit_account_id, t_400.debit_account_id
Index Cond: (t_400.credit_account_id = ca_1.id)
-> Index Scan using transaction_2025_10_credit_account_id_effective_date_value_idx on back_office.transaction_2025_10 t_401 (cost=0.42..0.71 rows=2 width=14)
Output: t_401.value, t_401.credit_account_id, t_401.debit_account_id
Index Cond: (t_401.credit_account_id = ca_1.id)
-> Index Scan using transaction_2025_11_credit_account_id_effective_date_value_idx on back_office.transaction_2025_11 t_402 (cost=0.42..0.71 rows=2 width=14)
Output: t_402.value, t_402.credit_account_id, t_402.debit_account_id
Index Cond: (t_402.credit_account_id = ca_1.id)
-> Index Scan using transaction_2025_12_credit_account_id_effective_date_value_idx on back_office.transaction_2025_12 t_403 (cost=0.56..1.03 rows=3 width=14)
Output: t_403.value, t_403.credit_account_id, t_403.debit_account_id
Index Cond: (t_403.credit_account_id = ca_1.id)
-> Index Scan using transaction_2026_01_credit_account_id_effective_date_value_idx on back_office.transaction_2026_01 t_404 (cost=0.42..0.62 rows=1 width=14)
Output: t_404.value, t_404.credit_account_id, t_404.debit_account_id
Index Cond: (t_404.credit_account_id = ca_1.id)
-> Index Scan using transaction_2026_02_credit_account_id_effective_date_value_idx on back_office.transaction_2026_02 t_405 (cost=0.42..0.71 rows=2 width=14)
Output: t_405.value, t_405.credit_account_id, t_405.debit_account_id
Index Cond: (t_405.credit_account_id = ca_1.id)
-> Index Scan using transaction_2026_03_credit_account_id_effective_date_value_idx on back_office.transaction_2026_03 t_406 (cost=0.43..1.14 rows=7 width=15)
Output: t_406.value, t_406.credit_account_id, t_406.debit_account_id
Index Cond: (t_406.credit_account_id = ca_1.id)
-> Index Scan using transaction_2026_04_credit_account_id_effective_date_value_idx on back_office.transaction_2026_04 t_407 (cost=0.42..0.71 rows=2 width=14)
Output: t_407.value, t_407.credit_account_id, t_407.debit_account_id
Index Cond: (t_407.credit_account_id = ca_1.id)
-> Index Scan using transaction_2026_05_credit_account_id_effective_date_value_idx on back_office.transaction_2026_05 t_408 (cost=0.42..0.71 rows=2 width=14)
Output: t_408.value, t_408.credit_account_id, t_408.debit_account_id
Index Cond: (t_408.credit_account_id = ca_1.id)
-> Index Scan using transaction_2026_06_credit_account_id_effective_date_value_idx on back_office.transaction_2026_06 t_409 (cost=0.42..0.71 rows=2 width=14)
Output: t_409.value, t_409.credit_account_id, t_409.debit_account_id
Index Cond: (t_409.credit_account_id = ca_1.id)
-> Index Scan using transaction_2026_07_credit_account_id_effective_date_value_idx on back_office.transaction_2026_07 t_410 (cost=0.42..0.72 rows=2 width=14)
Output: t_410.value, t_410.credit_account_id, t_410.debit_account_id
Index Cond: (t_410.credit_account_id = ca_1.id)
-> Index Scan using transaction_2026_08_credit_account_id_effective_date_value_idx on back_office.transaction_2026_08 t_411 (cost=0.42..0.62 rows=1 width=15)
Output: t_411.value, t_411.credit_account_id, t_411.debit_account_id
Index Cond: (t_411.credit_account_id = ca_1.id)
-> Index Scan using transaction_2026_09_credit_account_id_effective_date_value_idx on back_office.transaction_2026_09 t_412 (cost=0.42..0.62 rows=1 width=14)
Output: t_412.value, t_412.credit_account_id, t_412.debit_account_id
Index Cond: (t_412.credit_account_id = ca_1.id)
-> Index Scan using transaction_2026_10_credit_account_id_effective_date_value_idx on back_office.transaction_2026_10 t_413 (cost=0.42..0.72 rows=2 width=15)
Output: t_413.value, t_413.credit_account_id, t_413.debit_account_id
Index Cond: (t_413.credit_account_id = ca_1.id)
-> Index Scan using transaction_2026_11_credit_account_id_effective_date_value_idx on back_office.transaction_2026_11 t_414 (cost=0.14..0.16 rows=1 width=15)
Output: t_414.value, t_414.credit_account_id, t_414.debit_account_id
Index Cond: (t_414.credit_account_id = ca_1.id)
-> Seq Scan on back_office.transaction_2026_12 t_415 (cost=0.00..0.00 rows=1 width=30)
Output: t_415.value, t_415.credit_account_id, t_415.debit_account_id
Filter: (t_415.credit_account_id = ca_1.id)
-> Seq Scan on back_office.transaction_2027_01 t_416 (cost=0.00..0.00 rows=1 width=30)
Output: t_416.value, t_416.credit_account_id, t_416.debit_account_id
Filter: (t_416.credit_account_id = ca_1.id)
-> Seq Scan on back_office.transaction_2027_02 t_417 (cost=0.00..0.00 rows=1 width=30)
Output: t_417.value, t_417.credit_account_id, t_417.debit_account_id
Filter: (t_417.credit_account_id = ca_1.id)
-> Seq Scan on back_office.transaction_2027_03 t_418 (cost=0.00..0.00 rows=1 width=30)
Output: t_418.value, t_418.credit_account_id, t_418.debit_account_id
Filter: (t_418.credit_account_id = ca_1.id)
-> Seq Scan on back_office.transaction_2027_04 t_419 (cost=0.00..0.00 rows=1 width=30)
Output: t_419.value, t_419.credit_account_id, t_419.debit_account_id
Filter: (t_419.credit_account_id = ca_1.id)
-> Seq Scan on back_office.transaction_2027_05 t_420 (cost=0.00..0.00 rows=1 width=30)
Output: t_420.value, t_420.credit_account_id, t_420.debit_account_id
Filter: (t_420.credit_account_id = ca_1.id)
-> Seq Scan on back_office.transaction_2027_06 t_421 (cost=0.00..0.00 rows=1 width=30)
Output: t_421.value, t_421.credit_account_id, t_421.debit_account_id
Filter: (t_421.credit_account_id = ca_1.id)
-> Seq Scan on back_office.transaction_2027_07 t_422 (cost=0.00..0.00 rows=1 width=30)
Output: t_422.value, t_422.credit_account_id, t_422.debit_account_id
Filter: (t_422.credit_account_id = ca_1.id)
-> Seq Scan on back_office.transaction_2027_08 t_423 (cost=0.00..0.00 rows=1 width=30)
Output: t_423.value, t_423.credit_account_id, t_423.debit_account_id
Filter: (t_423.credit_account_id = ca_1.id)
-> Index Scan using account_pkey on back_office.account da_1 (cost=0.56..0.79 rows=1 width=8)
Output: da_1.id, da_1.operation_id, da_1.account_type_id, da_1.owner_contract_id, da_1.owner_sharer_id, da_1.owner_individual_id, da_1.owner_entity_id, da_1.version
Index Cond: (da_1.id = t_212.debit_account_id)
-> Memoize (cost=0.28..0.38 rows=1 width=4)
Output: dat_1.id
Cache Key: da_1.account_type_id
Cache Mode: logical
-> Index Scan using account_type_pkey on back_office.account_type dat_1 (cost=0.27..0.37 rows=1 width=4)
Output: dat_1.id
Index Cond: (dat_1.id = da_1.account_type_id)
Filter: ((dat_1.mnemonics)::text = ANY ('{"Р ОПС","Р ОПС ИД"}'::text[]))
-> Index Scan using sharer_pkey on ourpension.sharer s (cost=0.43..2.65 rows=1 width=24)
Output: s.id, s.annulled, s.approved, s.created, s.init_order_date, s.init_order_number, s.version, s.annulled_agent_id, s.approved_agent_id, s.contract_id, s.created_agent_id, s.individual_id, s.sharer, s.bank_details_id, s.number, s.close_date, s.closed, s.closed_agent_id, s.closed_reason_id, s.pension_program_id, s.inheritance_type_code, s.investor_pension, s.first_payment_persent, s.retiree, s.service_length, s.dismiss_date, s.district_k, s.monthly_salary, s.periodicity_code, s.payout_duration, s.open_date, s.npo_pension_type_id, s.comment, s.sharer_id_1c, s.contract_id_1c, s.person_id, s.scheme_id, s.not_displayed_in_lkk, s.code_1c, s.entity_id, s.inheritance_on_accum, s.inheritance_on_pay
Index Cond: (s.id = "*SELECT* 1".sharer_id)
-> Index Scan using individual_pkey on ourpension.individual i (cost=2.54..2.66 rows=1 width=19)
Output: i.insurance_number, i.id
Index Cond: (i.id = s.individual_id)
Filter: CASE WHEN (InitPlan 8).col1 THEN true WHEN (InitPlan 10).col1 THEN (ANY (i.id = (hashed SubPlan 11).col1)) ELSE (NOT (ANY (i.id = (hashed SubPlan 12).col1))) END
SubPlan 11
-> Unique (cost=2.09..2.10 rows=2 width=8)
Output: a_4.individual_id
-> Sort (cost=2.09..2.09 rows=2 width=8)
Output: a_4.individual_id
Sort Key: a_4.individual_id
-> Append (cost=0.00..2.08 rows=2 width=8)
-> Nested Loop (cost=0.00..1.03 rows=1 width=8)
Output: a_4.individual_id
Join Filter: (ug_3.group_id = a_4.group_id)
-> Seq Scan on ourpension.user_group ug_3 (cost=0.00..1.02 rows=1 width=8)
Output: ug_3.user_id, ug_3.group_id, ug_3.created_at
Filter: (ug_3.user_id = (NULLIF(current_setting('app.user_id'::text, true), ''::text))::bigint)
-> Seq Scan on ourpension.group_individual_access a_4 (cost=0.00..0.00 rows=1 width=16)
Output: a_4.group_id, a_4.individual_id, a_4.created_at
-> Nested Loop (cost=0.00..1.03 rows=1 width=8)
Output: a_5.individual_id
Join Filter: (ug_4.group_id = a_5.group_id)
-> Seq Scan on ourpension.user_group ug_4 (cost=0.00..1.02 rows=1 width=8)
Output: ug_4.user_id, ug_4.group_id, ug_4.created_at
Filter: (ug_4.user_id = (NULLIF(current_setting('app.user_id'::text, true), ''::text))::bigint)
-> Seq Scan on ourpension.group_contract_access a_5 (cost=0.00..0.00 rows=1 width=16)
Output: a_5.individual_id, a_5.group_id
Filter: (a_5.individual_id IS NOT NULL)
SubPlan 12
-> Seq Scan on ourpension.rbac_public_hidden_individual (cost=0.00..0.00 rows=1 width=8)
Output: rbac_public_hidden_individual.individual_id
-> Limit (cost=0.42..2.64 rows=1 width=12)
Output: a.death_date, a.version
-> Index Scan using adi_last_by_individual_idx on ourpension.application_death_info a (cost=0.42..2.64 rows=1 width=12)
Output: a.death_date, a.version
Index Cond: (a.individual_id = s.individual_id)
Query Identifier: -5422521937317931823