https://pastein.ru/t/WhN
Загрузка данных
Limit (cost=262932.41..262978.86 rows=20 width=46)
-> Incremental Sort (cost=262932.41..1963559340.65 rows=845373873 width=46)
Sort Key: o.id, t.id
Presorted Key: o.id
-> Merge Join (cost=7105.20..1919249372.32 rows=845373873 width=46)
Merge Cond: (src.operation_id = t.operation_id)
-> Nested Loop (cost=7006.75..125030302.07 rows=140273 width=34)
Join Filter: (e.id = ed.eps_id)
-> Nested Loop (cost=7006.75..123399565.02 rows=68115 width=24)
Join Filter: (src.id = et.eps_transaction_source_id)
-> Nested Loop (cost=6970.27..39032.81 rows=3755 width=12)
-> Gather Merge (cost=6969.69..17074.09 rows=86758 width=8)
Workers Planned: 2
-> Sort (cost=5969.67..6060.04 rows=36149 width=8)
Sort Key: src.operation_id
-> Parallel Index Scan using eps_transaction_source_pkey on eps_transaction_source src (cost=0.29..3232.89 rows=36149 width=8)
-> Memoize (cost=0.58..2.60 rows=1 width=4)
Cache Key: src.operation_id
Cache Mode: logical
-> Index Scan using operation_pkey on operation o (cost=0.57..2.59 rows=1 width=4)
Index Cond: (id = src.operation_id)
Filter: ((operation_date >= to_date('22.05.2024'::text, 'DD.MM.YYYY'::text)) AND (operation_date <= to_date('01.10.2026'::text, 'DD.MM.YYYY'::text)))
-> Materialize (cost=36.48..102201.78 rows=1573775 width=20)
-> Hash Join (cost=36.48..85110.90 rows=1573775 width=20)
Hash Cond: (et.eps_id = e.id)
-> Seq Scan on eps_transaction et (cost=0.00..76669.32 rows=3184532 width=16)
-> Hash (cost=31.69..31.69 rows=383 width=4)
-> Seq Scan on eps e (cost=0.00..31.69 rows=383 width=4)
Filter: ((service_type)::text = 'NPO'::text)
-> Materialize (cost=0.00..67.94 rows=1596 width=22)
-> Seq Scan on eps_detail ed (cost=0.00..59.96 rows=1596 width=22)
-> Materialize (cost=98.46..1782841340.94 rows=521291789 width=24)
-> Nested Loop Left Join (cost=98.46..1781538111.47 rows=521291789 width=24)
-> Nested Loop Left Join (cost=97.89..1206366737.80 rows=521291789 width=24)
-> Nested Loop Left Join (cost=97.33..631195364.13 rows=521291789 width=24)
-> Merge Append (cost=96.90..139893001.35 rows=521291789 width=20)
Sort Key: t.operation_id
-> Index Scan using transaction_2000_operation_id_value_idx on transaction_2000 t_1 (cost=0.42..57607.88 rows=405941 width=20)
-> Index Scan using transaction_2001_operation_id_value_idx on transaction_2001 t_2 (cost=0.42..15873.51 rows=104654 width=20)
-> Index Scan using transaction_2002_operation_id_value_idx on transaction_2002 t_3 (cost=0.42..18353.45 rows=123038 width=20)
-> Index Scan using transaction_2003_operation_id_value_idx on transaction_2003 t_4 (cost=0.42..27388.79 rows=188912 width=20)
-> Index Scan using transaction_2004_operation_id_value_idx on transaction_2004 t_5 (cost=0.42..93493.57 rows=605528 width=20)
-> Index Scan using transaction_2005_operation_id_value_idx on transaction_2005 t_6 (cost=0.43..416372.88 rows=2648195 width=20)
-> Index Scan using transaction_2006_operation_id_value_idx on transaction_2006 t_7 (cost=0.43..905327.66 rows=5422576 width=20)
-> Index Scan using transaction_2007_operation_id_value_idx on transaction_2007 t_8 (cost=0.43..1539698.74 rows=9152259 width=20)
-> Index Scan using transaction_2008_operation_id_value_idx on transaction_2008 t_9 (cost=0.43..1479104.44 rows=9489503 width=20)
-> Index Scan using transaction_2009_operation_id_value_idx on transaction_2009 t_10 (cost=0.56..2386520.26 rows=13721370 width=20)
-> Index Scan using transaction_2010_operation_id_value_idx on transaction_2010 t_11 (cost=0.56..2398806.55 rows=14711366 width=20)
-> Index Scan using transaction_2011_01_operation_id_value_idx on transaction_2011_01 t_12 (cost=0.42..135653.55 rows=789774 width=20)
-> Index Scan using transaction_2011_02_operation_id_value_idx on transaction_2011_02 t_13 (cost=0.42..134319.36 rows=758328 width=20)
-> Index Scan using transaction_2011_03_operation_id_value_idx on transaction_2011_03 t_14 (cost=0.43..1081556.10 rows=4547817 width=20)
-> Index Scan using transaction_2011_04_operation_id_value_idx on transaction_2011_04 t_15 (cost=0.42..137102.13 rows=760995 width=20)
-> Index Scan using transaction_2011_05_operation_id_value_idx on transaction_2011_05 t_16 (cost=0.43..899329.46 rows=3549411 width=20)
-> Index Scan using transaction_2011_06_operation_id_value_idx on transaction_2011_06 t_17 (cost=0.42..170470.90 rows=1024147 width=20)
-> Index Scan using transaction_2011_07_operation_id_value_idx on transaction_2011_07 t_18 (cost=0.42..147782.37 rows=823422 width=20)
-> Index Scan using transaction_2011_08_operation_id_value_idx on transaction_2011_08 t_19 (cost=0.42..141132.10 rows=765976 width=20)
-> Index Scan using transaction_2011_09_operation_id_value_idx on transaction_2011_09 t_20 (cost=0.43..855180.29 rows=3637817 width=20)
-> Index Scan using transaction_2011_10_operation_id_value_idx on transaction_2011_10 t_21 (cost=0.42..149012.56 rows=819446 width=20)
-> Index Scan using transaction_2011_11_operation_id_value_idx on transaction_2011_11 t_22 (cost=0.43..846127.59 rows=3492880 width=20)
-> Index Scan using transaction_2011_12_operation_id_value_idx on transaction_2011_12 t_23 (cost=0.43..1925145.37 rows=7345151 width=20)
-> Index Scan using transaction_2012_01_operation_id_value_idx on transaction_2012_01 t_24 (cost=0.42..142333.19 rows=804303 width=20)
-> Index Scan using transaction_2012_02_operation_id_value_idx on transaction_2012_02 t_25 (cost=0.42..147831.02 rows=819020 width=20)
-> Index Scan using transaction_2012_03_operation_id_value_idx on transaction_2012_03 t_26 (cost=0.43..1407970.50 rows=5734266 width=20)
-> Index Scan using transaction_2012_04_operation_id_value_idx on transaction_2012_04 t_27 (cost=0.42..166601.88 rows=963999 width=20)
-> Index Scan using transaction_2012_05_operation_id_value_idx on transaction_2012_05 t_28 (cost=0.42..174636.71 rows=1001603 width=20)
-> Index Scan using transaction_2012_06_operation_id_value_idx on transaction_2012_06 t_29 (cost=0.43..1121327.29 rows=4512445 width=20)
-> Index Scan using transaction_2012_07_operation_id_value_idx on transaction_2012_07 t_30 (cost=0.42..161136.93 rows=886643 width=20)
-> Index Scan using transaction_2012_08_operation_id_value_idx on transaction_2012_08 t_31 (cost=0.43..350485.15 rows=1844406 width=20)
-> Index Scan using transaction_2012_09_operation_id_value_idx on transaction_2012_09 t_32 (cost=0.43..1543860.33 rows=6081386 width=20)
-> Index Scan using transaction_2012_10_operation_id_value_idx on transaction_2012_10 t_33 (cost=0.43..347767.83 rows=1878284 width=20)
-> Index Scan using transaction_2012_11_operation_id_value_idx on transaction_2012_11 t_34 (cost=0.42..178706.57 rows=1025445 width=20)
-> Index Scan using transaction_2012_12_operation_id_value_idx on transaction_2012_12 t_35 (cost=0.56..3037781.91 rows=11918446 width=20)
-> Index Scan using transaction_2013_01_operation_id_value_idx on transaction_2013_01 t_36 (cost=0.42..160436.35 rows=912841 width=20)
-> Index Scan using transaction_2013_02_operation_id_value_idx on transaction_2013_02 t_37 (cost=0.42..170066.68 rows=991996 width=20)
-> Index Scan using transaction_2013_03_operation_id_value_idx on transaction_2013_03 t_38 (cost=0.56..3844560.50 rows=14396758 width=20)
-> Index Scan using transaction_2013_04_operation_id_value_idx on transaction_2013_04 t_39 (cost=0.43..212348.98 rows=1305911 width=20)
-> Index Scan using transaction_2013_05_operation_id_value_idx on transaction_2013_05 t_40 (cost=0.43..190932.78 rows=1113904 width=20)
-> Index Scan using transaction_2013_06_operation_id_value_idx on transaction_2013_06 t_41 (cost=0.43..2691387.70 rows=9867548 width=20)
-> Index Scan using transaction_2013_07_operation_id_value_idx on transaction_2013_07 t_42 (cost=0.42..179536.49 rows=1045682 width=20)
-> Index Scan using transaction_2013_08_operation_id_value_idx on transaction_2013_08 t_43 (cost=0.42..162808.07 rows=886511 width=20)
-> Index Scan using transaction_2013_09_operation_id_value_idx on transaction_2013_09 t_44 (cost=0.43..2599945.42 rows=9809352 width=20)
-> Index Scan using transaction_2013_10_operation_id_value_idx on transaction_2013_10 t_45 (cost=0.43..189979.82 rows=1096620 width=20)
-> Index Scan using transaction_2013_11_operation_id_value_idx on transaction_2013_11 t_46 (cost=0.42..175666.24 rows=1003975 width=20)
-> Index Scan using transaction_2013_12_operation_id_value_idx on transaction_2013_12 t_47 (cost=0.56..4195270.45 rows=16493573 width=20)
-> Index Scan using transaction_2014_01_operation_id_value_idx on transaction_2014_01 t_48 (cost=0.42..150468.64 rows=824692 width=20)
-> Index Scan using transaction_2014_02_operation_id_value_idx on transaction_2014_02 t_49 (cost=0.42..154733.62 rows=819930 width=20)
-> Index Scan using transaction_2014_03_operation_id_value_idx on transaction_2014_03 t_50 (cost=0.43..245883.02 rows=1548240 width=20)
-> Index Scan using transaction_2014_04_operation_id_value_idx on transaction_2014_04 t_51 (cost=0.42..185246.41 rows=1045674 width=20)
-> Index Scan using transaction_2014_05_operation_id_value_idx on transaction_2014_05 t_52 (cost=0.42..155239.83 rows=814468 width=20)
-> Index Scan using transaction_2014_06_operation_id_value_idx on transaction_2014_06 t_53 (cost=0.43..566123.09 rows=2586335 width=20)
-> Index Scan using transaction_2014_07_operation_id_value_idx on transaction_2014_07 t_54 (cost=0.42..185288.85 rows=958338 width=20)
-> Index Scan using transaction_2014_08_operation_id_value_idx on transaction_2014_08 t_55 (cost=0.42..154552.83 rows=807630 width=20)
-> Index Scan using transaction_2014_09_operation_id_value_idx on transaction_2014_09 t_56 (cost=0.43..192042.35 rows=1143217 width=20)
-> Index Scan using transaction_2014_10_operation_id_value_idx on transaction_2014_10 t_57 (cost=0.42..154012.87 rows=808094 width=20)
-> Index Scan using transaction_2014_11_operation_id_value_idx on transaction_2014_11 t_58 (cost=0.42..152242.08 rows=801639 width=20)
-> Index Scan using transaction_2014_12_operation_id_value_idx on transaction_2014_12 t_59 (cost=0.43..1799447.65 rows=8502801 width=20)
-> Index Scan using transaction_2015_01_operation_id_value_idx on transaction_2015_01 t_60 (cost=0.43..198937.05 rows=1153621 width=20)
-> Index Scan using transaction_2015_02_operation_id_value_idx on transaction_2015_02 t_61 (cost=0.42..154149.02 rows=803478 width=20)
-> Index Scan using transaction_2015_03_operation_id_value_idx on transaction_2015_03 t_62 (cost=0.42..154375.75 rows=819549 width=20)
-> Index Scan using transaction_2015_04_operation_id_value_idx on transaction_2015_04 t_63 (cost=0.56..6634793.70 rows=23713121 width=20)
-> Index Scan using transaction_2015_05_operation_id_value_idx on transaction_2015_05 t_64 (cost=0.43..903249.86 rows=4933925 width=20)
-> Index Scan using transaction_2015_06_operation_id_value_idx on transaction_2015_06 t_65 (cost=0.43..241368.06 rows=1339297 width=20)
-> Index Scan using transaction_2015_07_operation_id_value_idx on transaction_2015_07 t_66 (cost=0.43..196065.02 rows=1153866 width=20)
-> Index Scan using transaction_2015_08_operation_id_value_idx on transaction_2015_08 t_67 (cost=0.42..157672.24 rows=813508 width=20)
-> Index Scan using transaction_2015_09_operation_id_value_idx on transaction_2015_09 t_68 (cost=0.43..185811.51 rows=1061847 width=20)
-> Index Scan using transaction_2015_10_operation_id_value_idx on transaction_2015_10 t_69 (cost=0.42..180245.36 rows=1011272 width=20)
-> Index Scan using transaction_2015_11_operation_id_value_idx on transaction_2015_11 t_70 (cost=0.43..257032.44 rows=1407276 width=20)
-> Index Scan using transaction_2015_12_operation_id_value_idx on transaction_2015_12 t_71 (cost=0.43..2548787.32 rows=10281397 width=20)
-> Index Scan using transaction_2016_01_operation_id_value_idx on transaction_2016_01 t_72 (cost=0.42..161220.19 rows=900628 width=20)
-> Index Scan using transaction_2016_02_operation_id_value_idx on transaction_2016_02 t_73 (cost=0.42..156019.72 rows=775531 width=20)
-> Index Scan using transaction_2016_03_operation_id_value_idx on transaction_2016_03 t_74 (cost=0.43..1576196.62 rows=8227821 width=20)
-> Index Scan using transaction_2016_04_operation_id_value_idx on transaction_2016_04 t_75 (cost=0.43..182316.26 rows=1077182 width=20)
-> Index Scan using transaction_2016_05_operation_id_value_idx on transaction_2016_05 t_76 (cost=0.43..1301048.06 rows=5317553 width=20)
-> Index Scan using transaction_2016_06_operation_id_value_idx on transaction_2016_06 t_77 (cost=0.43..328685.86 rows=2018552 width=20)
-> Index Scan using transaction_2016_07_operation_id_value_idx on transaction_2016_07 t_78 (cost=0.42..168830.47 rows=926870 width=20)
-> Index Scan using transaction_2016_08_operation_id_value_idx on transaction_2016_08 t_79 (cost=0.42..157277.83 rows=782782 width=20)
-> Index Scan using transaction_2016_09_operation_id_value_idx on transaction_2016_09 t_80 (cost=0.43..249047.12 rows=1505521 width=20)
-> Index Scan using transaction_2016_10_operation_id_value_idx on transaction_2016_10 t_81 (cost=0.42..166804.20 rows=909331 width=20)
-> Index Scan using transaction_2016_11_operation_id_value_idx on transaction_2016_11 t_82 (cost=0.42..156903.96 rows=761781 width=20)
-> Index Scan using transaction_2016_12_operation_id_value_idx on transaction_2016_12 t_83 (cost=0.56..5878994.31 rows=21740928 width=20)
-> Index Scan using transaction_2017_01_operation_id_value_idx on transaction_2017_01 t_84 (cost=0.42..138009.64 rows=812618 width=20)
-> Index Scan using transaction_2017_02_operation_id_value_idx on transaction_2017_02 t_85 (cost=0.42..116342.56 rows=626199 width=20)
-> Index Scan using transaction_2017_03_operation_id_value_idx on transaction_2017_03 t_86 (cost=0.43..924532.24 rows=4696331 width=20)
-> Index Scan using transaction_2017_04_operation_id_value_idx on transaction_2017_04 t_87 (cost=0.42..156778.50 rows=971751 width=20)
-> Index Scan using transaction_2017_05_operation_id_value_idx on transaction_2017_05 t_88 (cost=0.43..223393.56 rows=1307751 width=20)
-> Index Scan using transaction_2017_06_operation_id_value_idx on transaction_2017_06 t_89 (cost=0.42..143679.98 rows=861511 width=20)
-> Index Scan using transaction_2017_07_operation_id_value_idx on transaction_2017_07 t_90 (cost=0.42..132945.27 rows=764762 width=20)
-> Index Scan using transaction_2017_08_operation_id_value_idx on transaction_2017_08 t_91 (cost=0.42..121247.49 rows=654323 width=20)
-> Index Scan using transaction_2017_09_operation_id_value_idx on transaction_2017_09 t_92 (cost=0.42..109822.79 rows=753883 width=20)
-> Index Scan using transaction_2017_10_operation_id_value_idx on transaction_2017_10 t_93 (cost=0.42..120402.52 rows=739550 width=20)
-> Index Scan using transaction_2017_11_operation_id_value_idx on transaction_2017_11 t_94 (cost=0.42..140980.75 rows=916011 width=20)
-> Index Scan using transaction_2017_12_operation_id_value_idx on transaction_2017_12 t_95 (cost=0.56..4418946.65 rows=16554296 width=20)
-> Index Scan using transaction_2018_01_operation_id_value_idx on transaction_2018_01 t_96 (cost=0.42..108954.42 rows=708676 width=20)
-> Index Scan using transaction_2018_02_operation_id_value_idx on transaction_2018_02 t_97 (cost=0.42..89050.27 rows=555097 width=20)
-> Index Scan using transaction_2018_03_operation_id_value_idx on transaction_2018_03 t_98 (cost=0.43..602470.34 rows=3500700 width=20)
-> Index Scan using transaction_2018_04_operation_id_value_idx on transaction_2018_04 t_99 (cost=0.42..118867.44 rows=775098 width=20)
-> Index Scan using transaction_2018_05_operation_id_value_idx on transaction_2018_05 t_100 (cost=0.42..101203.63 rows=662185 width=20)
-> Index Scan using transaction_2018_06_operation_id_value_idx on transaction_2018_06 t_101 (cost=0.42..101849.68 rows=689839 width=20)
-> Index Scan using transaction_2018_07_operation_id_value_idx on transaction_2018_07 t_102 (cost=0.43..301905.15 rows=1555558 width=20)
-> Index Scan using transaction_2018_08_operation_id_value_idx on transaction_2018_08 t_103 (cost=0.42..117066.75 rows=742756 width=20)
-> Index Scan using transaction_2018_09_operation_id_value_idx on transaction_2018_09 t_104 (cost=0.43..263215.56 rows=1385446 width=20)
-> Index Scan using transaction_2018_10_operation_id_value_idx on transaction_2018_10 t_105 (cost=0.42..118169.46 rows=742990 width=20)
-> Index Scan using transaction_2018_11_operation_id_value_idx on transaction_2018_11 t_106 (cost=0.42..106328.32 rows=601574 width=20)
-> Index Scan using transaction_2018_12_operation_id_value_idx on transaction_2018_12 t_107 (cost=0.56..3219295.29 rows=12134303 width=20)
-> Index Scan using transaction_2019_01_operation_id_value_idx on transaction_2019_01 t_108 (cost=0.43..263982.76 rows=1568678 width=20)
-> Index Scan using transaction_2019_02_operation_id_value_idx on transaction_2019_02 t_109 (cost=0.42..115800.16 rows=741232 width=20)
-> Index Scan using transaction_2019_03_operation_id_value_idx on transaction_2019_03 t_110 (cost=0.43..324191.83 rows=2039531 width=20)
-> Index Scan using transaction_2019_04_operation_id_value_idx on transaction_2019_04 t_111 (cost=0.42..123995.09 rows=821940 width=20)
-> Index Scan using transaction_2019_05_operation_id_value_idx on transaction_2019_05 t_112 (cost=0.42..102846.31 rows=658626 width=20)
-> Index Scan using transaction_2019_06_operation_id_value_idx on transaction_2019_06 t_113 (cost=0.42..114841.05 rows=742575 width=20)
-> Index Scan using transaction_2019_07_operation_id_value_idx on transaction_2019_07 t_114 (cost=0.42..116434.27 rows=752862 width=20)
-> Index Scan using transaction_2019_08_operation_id_value_idx on transaction_2019_08 t_115 (cost=0.42..93652.78 rows=622906 width=20)
-> Index Scan using transaction_2019_09_operation_id_value_idx on transaction_2019_09 t_116 (cost=0.42..117219.93 rows=741117 width=20)
-> Index Scan using transaction_2019_10_operation_id_value_idx on transaction_2019_10 t_117 (cost=0.42..120355.23 rows=831908 width=20)
-> Index Scan using transaction_2019_11_operation_id_value_idx on transaction_2019_11 t_118 (cost=0.42..95505.64 rows=589219 width=20)
-> Index Scan using transaction_2019_12_operation_id_value_idx on transaction_2019_12 t_119 (cost=0.56..4372371.92 rows=16624887 width=20)
-> Index Scan using transaction_2020_01_operation_id_value_idx on transaction_2020_01 t_120 (cost=0.42..110536.97 rows=721389 width=20)
-> Index Scan using transaction_2020_02_operation_id_value_idx on transaction_2020_02 t_121 (cost=0.42..102646.00 rows=594017 width=20)
-> Index Scan using transaction_2020_03_operation_id_value_idx on transaction_2020_03 t_122 (cost=0.43..193994.68 rows=1298632 width=20)
-> Index Scan using transaction_2020_04_operation_id_value_idx on transaction_2020_04 t_123 (cost=0.42..100088.33 rows=664127 width=20)
-> Index Scan using transaction_2020_05_operation_id_value_idx on transaction_2020_05 t_124 (cost=0.42..94051.44 rows=594592 width=20)
-> Index Scan using transaction_2020_06_operation_id_value_idx on transaction_2020_06 t_125 (cost=0.42..110388.77 rows=746948 width=20)
-> Index Scan using transaction_2020_07_operation_id_value_idx on transaction_2020_07 t_126 (cost=0.42..117194.48 rows=758735 width=20)
-> Index Scan using transaction_2020_08_operation_id_value_idx on transaction_2020_08 t_127 (cost=0.42..97039.45 rows=645397 width=20)
-> Index Scan using transaction_2020_09_operation_id_value_idx on transaction_2020_09 t_128 (cost=0.42..132326.14 rows=880774 width=20)
-> Index Scan using transaction_2020_10_operation_id_value_idx on transaction_2020_10 t_129 (cost=0.42..110376.66 rows=710253 width=20)
-> Index Scan using transaction_2020_11_operation_id_value_idx on transaction_2020_11 t_130 (cost=0.42..97852.35 rows=587718 width=20)
-> Index Scan using transaction_2020_12_operation_id_value_idx on transaction_2020_12 t_131 (cost=0.56..4138580.10 rows=17163856 width=20)
-> Index Scan using transaction_2021_01_operation_id_value_idx on transaction_2021_01 t_132 (cost=0.42..97268.78 rows=632317 width=20)
-> Index Scan using transaction_2021_02_operation_id_value_idx on transaction_2021_02 t_133 (cost=0.42..108513.14 rows=654842 width=20)
-> Index Scan using transaction_2021_03_operation_id_value_idx on transaction_2021_03 t_134 (cost=0.43..162895.16 rows=1056675 width=20)
-> Index Scan using transaction_2021_04_operation_id_value_idx on transaction_2021_04 t_135 (cost=0.42..121668.47 rows=830490 width=20)
-> Index Scan using transaction_2021_05_operation_id_value_idx on transaction_2021_05 t_136 (cost=0.42..94539.32 rows=579379 width=20)
-> Index Scan using transaction_2021_06_operation_id_value_idx on transaction_2021_06 t_137 (cost=0.42..107852.24 rows=722692 width=20)
-> Index Scan using transaction_2021_07_operation_id_value_idx on transaction_2021_07 t_138 (cost=0.42..110495.61 rows=719205 width=20)
-> Index Scan using transaction_2021_08_operation_id_value_idx on transaction_2021_08 t_139 (cost=0.42..95554.40 rows=583380 width=20)
-> Index Scan using transaction_2021_09_operation_id_value_idx on transaction_2021_09 t_140 (cost=0.42..125689.42 rows=833577 width=20)
-> Index Scan using transaction_2021_10_operation_id_value_idx on transaction_2021_10 t_141 (cost=0.42..106001.39 rows=685873 width=20)
-> Index Scan using transaction_2021_11_operation_id_value_idx on transaction_2021_11 t_142 (cost=0.42..91157.51 rows=543311 width=20)
-> Index Scan using transaction_2021_12_operation_id_value_idx on transaction_2021_12 t_143 (cost=0.56..3121551.14 rows=12740222 width=20)
-> Index Scan using transaction_2022_01_operation_id_value_idx on transaction_2022_01 t_144 (cost=0.42..91622.38 rows=571880 width=20)
-> Index Scan using transaction_2022_02_operation_id_value_idx on transaction_2022_02 t_145 (cost=0.42..94685.83 rows=570071 width=20)
-> Index Scan using transaction_2022_03_operation_id_value_idx on transaction_2022_03 t_146 (cost=0.43..357401.85 rows=1990652 width=20)
-> Index Scan using transaction_2022_04_operation_id_value_idx on transaction_2022_04 t_147 (cost=0.42..120005.20 rows=761045 width=20)
-> Index Scan using transaction_2022_05_operation_id_value_idx on transaction_2022_05 t_148 (cost=0.42..97172.62 rows=606088 width=20)
-> Index Scan using transaction_2022_06_operation_id_value_idx on transaction_2022_06 t_149 (cost=0.42..111917.57 rows=731856 width=20)
-> Index Scan using transaction_2022_07_operation_id_value_idx on transaction_2022_07 t_150 (cost=0.42..116546.06 rows=774572 width=20)
-> Index Scan using transaction_2022_08_operation_id_value_idx on transaction_2022_08 t_151 (cost=0.42..105762.51 rows=679383 width=20)
-> Index Scan using transaction_2022_09_operation_id_value_idx on transaction_2022_09 t_152 (cost=0.42..124209.55 rows=814160 width=20)
-> Index Scan using transaction_2022_10_operation_id_value_idx on transaction_2022_10 t_153 (cost=0.42..101860.24 rows=650917 width=20)
-> Index Scan using transaction_2022_11_operation_id_value_idx on transaction_2022_11 t_154 (cost=0.42..96983.83 rows=603135 width=20)
-> Index Scan using transaction_2022_12_operation_id_value_idx on transaction_2022_12 t_155 (cost=0.56..3063697.00 rows=11669175 width=20)
-> Index Scan using transaction_2023_01_operation_id_value_idx on transaction_2023_01 t_156 (cost=0.42..86722.34 rows=521328 width=20)
-> Index Scan using transaction_2023_02_operation_id_value_idx on transaction_2023_02 t_157 (cost=0.42..125216.01 rows=633171 width=20)
-> Index Scan using transaction_2023_03_operation_id_value_idx on transaction_2023_03 t_158 (cost=0.42..140817.00 rows=840985 width=20)
-> Index Scan using transaction_2023_04_operation_id_value_idx on transaction_2023_04 t_159 (cost=0.42..138086.23 rows=766449 width=20)
-> Index Scan using transaction_2023_05_operation_id_value_idx on transaction_2023_05 t_160 (cost=0.42..121976.69 rows=649757 width=20)
-> Index Scan using transaction_2023_06_operation_id_value_idx on transaction_2023_06 t_161 (cost=0.42..123579.79 rows=623265 width=20)
-> Index Scan using transaction_2023_07_operation_id_value_idx on transaction_2023_07 t_162 (cost=0.42..135064.62 rows=731728 width=20)
-> Index Scan using transaction_2023_08_operation_id_value_idx on transaction_2023_08 t_163 (cost=0.42..123727.96 rows=643721 width=20)
-> Index Scan using transaction_2023_09_operation_id_value_idx on transaction_2023_09 t_164 (cost=0.42..136240.12 rows=789751 width=20)
-> Index Scan using transaction_2023_10_operation_id_value_idx on transaction_2023_10 t_165 (cost=0.42..130276.24 rows=686517 width=20)
-> Index Scan using transaction_2023_11_operation_id_value_idx on transaction_2023_11 t_166 (cost=0.42..127832.19 rows=635137 width=20)
-> Index Scan using transaction_2023_12_operation_id_value_idx on transaction_2023_12 t_167 (cost=0.56..2814424.49 rows=10601843 width=20)
-> Index Scan using transaction_2024_01_operation_id_value_idx on transaction_2024_01 t_168 (cost=0.42..119281.78 rows=554083 width=20)
-> Index Scan using transaction_2024_02_operation_id_value_idx on transaction_2024_02 t_169 (cost=0.42..124849.61 rows=650803 width=20)
-> Index Scan using transaction_2024_03_operation_id_value_idx on transaction_2024_03 t_170 (cost=0.42..142270.36 rows=807930 width=20)
-> Index Scan using transaction_2024_04_operation_id_value_idx on transaction_2024_04 t_171 (cost=0.42..137650.27 rows=733916 width=20)
-> Index Scan using transaction_2024_05_operation_id_value_idx on transaction_2024_05 t_172 (cost=0.42..125386.97 rows=635590 width=20)
-> Index Scan using transaction_2024_06_operation_id_value_idx on transaction_2024_06 t_173 (cost=0.42..126222.72 rows=647185 width=20)
-> Index Scan using transaction_2024_07_operation_id_value_idx on transaction_2024_07 t_174 (cost=0.42..139931.87 rows=737818 width=20)
-> Index Scan using transaction_2024_08_operation_id_value_idx on transaction_2024_08 t_175 (cost=0.42..132722.54 rows=672889 width=20)
-> Index Scan using transaction_2024_09_operation_id_value_idx on transaction_2024_09 t_176 (cost=0.42..156143.31 rows=866563 width=20)
-> Index Scan using transaction_2024_10_operation_id_value_idx on transaction_2024_10 t_177 (cost=0.42..162192.17 rows=783108 width=20)
-> Index Scan using transaction_2024_11_operation_id_value_idx on transaction_2024_11 t_178 (cost=0.42..173172.75 rows=984709 width=20)
-> Index Scan using transaction_2024_12_operation_id_value_idx on transaction_2024_12 t_179 (cost=0.56..2954881.42 rows=10993217 width=20)
-> Index Scan using transaction_2025_01_operation_id_value_idx on transaction_2025_01 t_180 (cost=0.42..164803.53 rows=841658 width=20)
-> Index Scan using transaction_2025_02_operation_id_value_idx on transaction_2025_02 t_181 (cost=0.42..137874.25 rows=768946 width=20)
-> Index Scan using transaction_2025_03_operation_id_value_idx on transaction_2025_03 t_182 (cost=0.42..180104.99 rows=907597 width=20)
-> Index Scan using transaction_2025_04_operation_id_value_idx on transaction_2025_04 t_183 (cost=0.42..170081.57 rows=939786 width=20)
-> Index Scan using transaction_2025_05_operation_id_value_idx on transaction_2025_05 t_184 (cost=0.42..124173.21 rows=537526 width=20)
-> Index Scan using transaction_2025_06_operation_id_value_idx on transaction_2025_06 t_185 (cost=0.42..135311.44 rows=681719 width=20)
-> Index Scan using transaction_2025_07_operation_id_value_idx on transaction_2025_07 t_186 (cost=0.42..157356.09 rows=804699 width=20)
-> Index Scan using transaction_2025_08_operation_id_value_idx on transaction_2025_08 t_187 (cost=0.42..147419.27 rows=708269 width=20)
-> Index Scan using transaction_2025_09_operation_id_value_idx on transaction_2025_09 t_188 (cost=0.42..174818.73 rows=925014 width=20)
-> Index Scan using transaction_2025_10_operation_id_value_idx on transaction_2025_10 t_189 (cost=0.42..161862.03 rows=766256 width=20)
-> Index Scan using transaction_2025_11_operation_id_value_idx on transaction_2025_11 t_190 (cost=0.42..141094.43 rows=687557 width=20)
-> Index Scan using transaction_2025_12_operation_id_value_idx on transaction_2025_12 t_191 (cost=0.56..7458363.63 rows=27499733 width=20)
-> Index Scan using transaction_2026_01_operation_id_value_idx on transaction_2026_01 t_192 (cost=0.42..34596.02 rows=169950 width=20)
-> Index Scan using transaction_2026_02_operation_id_value_idx on transaction_2026_02 t_193 (cost=0.42..135906.66 rows=692185 width=20)
-> Index Scan using transaction_2026_03_operation_id_value_idx on transaction_2026_03 t_194 (cost=0.43..288090.28 rows=1384510 width=20)
-> Index Scan using transaction_2026_04_operation_id_value_idx on transaction_2026_04 t_195 (cost=0.42..183609.55 rows=885147 width=20)
-> Index Scan using transaction_2026_05_operation_id_value_idx on transaction_2026_05 t_196 (cost=0.42..143709.15 rows=705441 width=20)
-> Index Scan using transaction_2026_06_operation_id_value_idx on transaction_2026_06 t_197 (cost=0.42..140837.32 rows=710445 width=20)
-> Index Scan using transaction_2026_07_operation_id_value_idx on transaction_2026_07 t_198 (cost=0.42..218233.41 rows=880329 width=20)
-> Index Scan using transaction_2026_08_operation_id_value_idx on transaction_2026_08 t_199 (cost=0.42..64445.40 rows=357241 width=20)
-> Index Scan using transaction_2026_09_operation_id_value_idx on transaction_2026_09 t_200 (cost=0.41..7782.04 rows=45066 width=20)
-> Index Scan using transaction_2026_10_operation_id_value_idx on transaction_2026_10 t_201 (cost=0.14..5.87 rows=92 width=20)
-> Index Scan using transaction_2026_11_operation_id_value_idx on transaction_2026_11 t_202 (cost=0.14..3.57 rows=9 width=20)
-> Index Scan using transaction_2026_12_operation_id_value_idx on transaction_2026_12 t_203 (cost=0.12..2.34 rows=1 width=20)
-> Index Scan using transaction_2027_01_operation_id_value_idx on transaction_2027_01 t_204 (cost=0.12..2.34 rows=1 width=20)
-> Index Scan using transaction_2027_02_operation_id_value_idx on transaction_2027_02 t_205 (cost=0.12..2.34 rows=1 width=20)
-> Index Scan using transaction_2027_03_operation_id_value_idx on transaction_2027_03 t_206 (cost=0.12..2.34 rows=1 width=20)
-> Index Scan using transaction_2027_04_operation_id_value_idx on transaction_2027_04 t_207 (cost=0.12..2.34 rows=1 width=20)
-> Index Scan using transaction_2027_05_operation_id_value_idx on transaction_2027_05 t_208 (cost=0.12..2.34 rows=1 width=20)
-> Index Scan using transaction_2027_06_operation_id_value_idx on transaction_2027_06 t_209 (cost=0.12..2.34 rows=1 width=20)
-> Index Scan using transaction_2027_07_operation_id_value_idx on transaction_2027_07 t_210 (cost=0.12..2.34 rows=1 width=20)
-> Index Scan using transaction_2027_08_operation_id_value_idx on transaction_2027_08 t_211 (cost=0.12..2.34 rows=1 width=20)
-> Index Scan using transaction_extended_pkey on transaction_extended te (cost=0.42..0.94 rows=1 width=8)
Index Cond: (transaction_id = t.id)
-> Index Scan using account_pkey on account da (cost=0.56..1.10 rows=1 width=8)
Index Cond: (id = t.debit_account_id)
-> Index Scan using account_pkey on account ca (cost=0.56..1.10 rows=1 width=8)
Index Cond: (id = t.credit_account_id)
