Insert on tt778  (cost=19′371.02..19′414.00 rows=0 width=0) (actual time=210′080.150..210′080.163 rows=0 loops=1)
  ->  Subquery Scan on "*ВЫБРАТЬ*"  (cost=19′371.02..19′414.00 rows=200 width=304) (actual time=210′051.595..210′061.457 rows=2′409 loops=1)
        ->  GroupAggregate  (cost=19′371.02..19′412.60 rows=200 width=338) (actual time=210′051.592..210′060.530 rows=2′409 loops=1)
              Group Key: t3._fld51275_type, t3._fld51275_rtref, ('\\x08'::bytea), ('\\x08'::bytea), ('\\x000001f6'::bytea), t3._fld51273rref, t3._fld51275_rrref, t3._fld51272rref, t3._fld51271rref, t3._fld51274rref, ('\\x08'::bytea), ('\\x0000074e'::bytea)
              ->  Sort  (cost=19′371.02..19′372.45 rows=1′435 width=373) (actual time=210′051.546..210′051.902 rows=6′774 loops=1)
                    Sort Key: t3._fld51275_type, t3._fld51275_rtref, ('\\x08'::bytea), ('\\x08'::bytea), ('\\x000001f6'::bytea), t3._fld51273rref, t3._fld51275_rrref, t3._fld51272rref, t3._fld51271rref, t3._fld51274rref
                    Sort Method: quicksort  Memory: 1992kB
                    ->  Nested Loop  (cost=173.03..19′218.50 rows=1′435 width=373) (actual time=1.396..209′985.129 rows=6′774 loops=1)
                          ->  Append  (cost=172.91..18′861.30 rows=1′435 width=339) (actual time=1.383..209′878.819 rows=6′774 loops=1)
                                ->  Hash Left Join  (cost=172.91..1′170.58 rows=389 width=444) (actual time=1.382..7.028 rows=1′495 loops=1)
                                      Hash Cond: (t3._fld51274rref = t4._IDrref)
                                      ->  GroupAggregate  (cost=0.22..995.92 rows=389 width=284) (actual time=0.038..4.980 rows=1′495 loops=1)
                                            Group Key: t3._fld51272rref, t3._fld51273rref, t3._fld51274rref, t3._fld51275_type, t3._fld51275_rtref, t3._fld51275_rrref, t3._fld51271rref
                                            Filter: ((sum(t3._fld51276) <> '0'::numeric) ИЛИ (sum(t3._fld51278) <> '0'::numeric) ИЛИ (sum(t3._fld51280) <> '0'::numeric) ИЛИ (sum(t3._fld73777) <> '0'::numeric) ИЛИ (sum(t3._fld51279) <> '0'::numeric) ИЛИ (sum(t3._fld51277) <> '0'::numeric))
                                            Rows Removed by Filter: 67
                                            ->  Index Scan using .Индекс_1[АналитикаРасходов,СтатьяРасходов,НаправлениеДеятельности] on _accumrgt51295 t3  (cost=0.22..985.74 rows=394 width=111) (actual time=0.025..2.214 rows=1′629 loops=1)
                                                  Index Cond: ((_fld1877 = '0'::numeric) И (_period = '2022-08-01 00:00:00'::timestamp without time zone) И (_fld51271rref = '\\x208c52540092367f11e21844d367ef26'::bytea))
                                                  Filter: (((_fld51276 <> '0'::numeric) ИЛИ (_fld51278 <> '0'::numeric) ИЛИ (_fld51280 <> '0'::numeric) ИЛИ (_fld73777 <> '0'::numeric) ИЛИ (_fld51279 <> '0'::numeric) ИЛИ (_fld51277 <> '0'::numeric)) И ((_fld51276 <> '0'::numeric) ИЛИ (_fld51278 <> '0'::numeric) ИЛИ (_fld51280 <> '0'::numeric) ИЛИ (_fld73777 <> '0'::numeric) ИЛИ (_fld51279 <> '0'::numeric) ИЛИ (_fld51277 <> '0'::numeric)))
                                                  Rows Removed by Filter: 1′100
                                      ->  Hash  (cost=170.35..170.35 rows=1′174 width=34) (actual time=1.331..1.333 rows=1′174 loops=1)
                                            Buckets: 2′048  Batches: 1  Memory Usage: 91kB
                                            ->  Seq Scan on _chrc1870 t4  (cost=0.00..170.35 rows=1′174 width=34) (actual time=0.006..1.178 rows=1′174 loops=1)
                                                  Filter: (_fld1877 = '0'::numeric)
                                ->  Nested Loop Anti Join  (cost=0.00..9′020.66 rows=1 width=396) (actual time=46.687..209′832.109 rows=4′210 loops=1)
                                      Join Filter: ((t7._q_001_f_003_type = t8._q_000_f_000_type) И (t7._q_001_f_003_rrref = t8._q_000_f_000_rrref) И (t7._q_001_f_004rref = t8._q_000_f_001rref) И (t7._q_001_f_005_type = t8._q_000_f_002_type) И (t7._q_001_f_005_rrref = t8._q_000_f_002_rrref) И (t7._q_001_f_006rref = t8._q_000_f_003rref) И (t7._q_001_f_007_type = t8._q_000_f_004_type) И (t7._q_001_f_007_rtref = t8._q_000_f_004_rtref) И (t7._q_001_f_007_rrref = t8._q_000_f_004_rrref) И (t7._q_001_f_008_type = t8._q_000_f_005_type) И (t7._q_001_f_008_rrref = t8._q_000_f_005_rrref) И (t7._q_001_f_009_type = t8._q_000_f_006_type) И (t7._q_001_f_009_rtref = t8._q_000_f_006_rtref) И (t7._q_001_f_009_rrref = t8._q_000_f_006_rrref) И (t7._q_001_f_010_type = t8._q_000_f_007_type) И (t7._q_001_f_010_rrref = t8._q_000_f_007_rrref))
                                      ->  Nested Loop Left Join  (cost=0.00..9′019.63 rows=1 width=276) (actual time=46.669..209′769.124 rows=4′210 loops=1)
                                            Join Filter: ((t7._q_001_f_002 = t5._q_000_f_002) И (t7._q_001_f_001_type = t5._q_000_f_001_type) И (t7._q_001_f_001_rtref = t5._q_000_f_001_rtref) И (t7._q_001_f_001_rrref = t5._q_000_f_001_rrref) И (t7._q_001_f_077_s = t5._q_000_f_036) И (t7._q_001_f_072_rrref = t5._q_000_f_035rref))
                                            ->  Nested Loop Left Join  (cost=0.00..351.68 rows=1 width=226) (actual time=0.015..29.458 rows=4′210 loops=1)
                                                  Join Filter: false
                                                  Filter: ((_q_000_f_001_type ЕСТЬNULL) И (_q_000_f_001_rtref ЕСТЬNULL) И (_q_000_f_001_rrref ЕСТЬNULL))
                                                  ->  Seq Scan on tt210 t5  (cost=0.00..351.68 rows=1 width=226) (actual time=0.013..19.270 rows=4′210 loops=1)
                                                        Filter: (((_q_000_f_014rref <> '\\x98809e83d175a1584382d7ba82e6dbf8'::bytea) ИЛИ _q_000_f_037 ИЛИ _q_000_f_028) И ('\\x08'::bytea = ВЫБОР КОГДА (_q_000_f_006rref IS NOT NULL) ТОГДА '\\x08'::bytea ИНАЧЕ NULL::bytea КОНЕЦ) И ('\\x0000074e'::bytea = ВЫБОР КОГДА (_q_000_f_006rref IS NOT NULL) ТОГДА '\\x0000074e'::bytea ИНАЧЕ NULL::bytea КОНЕЦ) И ((_q_000_f_001_type <> '\\x08'::bytea) ИЛИ (_q_000_f_001_rtref <> '\\x00000392'::bytea)) И ((_q_000_f_001_type <> '\\x08'::bytea) ИЛИ (_q_000_f_001_rtref <> '\\x00000396'::bytea) ИЛИ _q_000_f_028 ИЛИ _q_000_f_027))
                                                  ->  Result  (cost=0.00..0.00 rows=0 width=96) (actual time=0.000..0.000 rows=0 loops=4′210)
                                                        One-Time Filter: false
                                            ->  Seq Scan on tt578 t7  (cost=0.00..8′667.91 rows=5 width=280) (actual time=49.815..49.815 rows=0 loops=4′210)
                                                  Filter: ((_q_001_f_077_type = '\\x05'::bytea) И (_q_001_f_072_type = '\\x08'::bytea) И (_q_001_f_037_type = '\\x08'::bytea) И (_q_001_f_037_rrref = '\\x897d06a658816dbd47a8d404131bc658'::bytea))
                                                  Rows Removed by Filter: 55′582
                                      ->  Seq Scan on tt777 t8  (cost=0.00..1.00 rows=1 width=512) (actual time=0.000..0.000 rows=0 loops=4′210)
                                ->  Seq Scan on tt578 t9  (cost=0.00..8′667.91 rows=1′045 width=252) (actual time=0.681..34.989 rows=1′069 loops=1)
                                      Filter: ((_q_001_f_037_type = '\\x08'::bytea) И (_q_001_f_047_type = '\\x08'::bytea) И (_q_001_f_037_rrref = '\\x98809e83d175a1584382d7ba82e6dbf8'::bytea) И ('\\x0000074e'::bytea = _q_001_f_047_rtref))
                                      Rows Removed by Filter: 54′513
                          ->  Index Scan using _chrc1870_s_hpk on _chrc1870 t10  (cost=0.11..0.25 rows=1 width=52) (actual time=0.012..0.012 rows=1 loops=6′774)
                                Index Cond: ((_fld1877 = '0'::numeric) И (_IDrref = t3._fld51274rref))