Aggregate  (cost=3′094′943.07..3′094′943.08 rows=1 width=8) (actual time=6′921.602..6′921.608 rows=1 loops=1)
  Buffers: shared hit=1′625′438 read=193′132 written=573
  ->  Nested Loop Left Join  (cost=999.22..3′094′942.80 rows=111 width=0) (actual time=1′531.610..6′901.276 rows=69′661 loops=1)
        Filter: ((COALESCE(date_part('year'::text, o.buildingweardate), '3000'::double precision) > '2025'::double precision) OR (o.liquidationreasonid = 4) OR ((a1.division_id IS NOT NULL) AND (COALESCE(date_part('year'::text, a1.end_date), '3000'::double precision) > '2025'::double precision)))
        Rows Removed by Filter: 3′547
        Buffers: shared hit=1′625′438 read=193′132 written=573
        ->  Bitmap Heap Scan on object_accessibility a1  (cost=998.80..3′092′485.40 rows=311 width=24) (actual time=1′531.559..6′560.960 rows=73′208 loops=1)
              Recheck Cond: (layerservice_id = 1)
              Filter: ((state_id > '-1'::integer) AND (date_part('year'::text, bdate) <= '2025'::double precision) AND ((cardinality(act_ids) = 0) OR (act_ids && '{63000000,65000000,71000000,73000000,79000000,99000000,80000000,84000000,82000000,88000000,89000000,93000000,1000000,4000000,7000000,29000000,33000000,37000000,22000000,52000000,53000000,56000000,57000000,36000000,75000000,71800000,71900000,92000000,94000000,96000000,97000000,81000000,85000000,98000000,95000000,3000000,5000000,8000000,10000000,12000000,14000000,15000000,17000000,18000000,20000000,25000000,30000000,32000000,38000000,42000000,44000000,50000000,54000000,60000000,61000000,64000000,66000000,68000000,69000000,70000000,76000000,78000000,77000000,45000000,35000000,26000000,86000000,87000000,11000000,19000000,24000000,27000000,34000000,41000000,46000000,47000000,49000000,58000000,28000000,40000000,11800000,83000000,91000000,90000000,67000000}'::bigint[])) AND (CASE WHEN (division_id IS NOT NULL) THEN (SubPlan 1) ELSE (SubPlan 2) END = 1))
              Rows Removed by Filter: 17′961
              Heap Blocks: exact=17′128
              Buffers: shared hit=1′332′606 read=193′132 written=573
              ->  Bitmap Index Scan on object_accessibility_idx_layerservice_id  (cost=0.00..998.72 rows=90′990 width=0) (actual time=7.153..7.154 rows=91′169 loops=1)
                    Index Cond: (layerservice_id = 1)
                    Buffers: shared read=78
              SubPlan 1
                ->  Nested Loop  (cost=0.84..16.88 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=11′822)
                      Buffers: shared hit=34′722 read=744
                      ->  Index Scan using pk_division on division t  (cost=0.42..8.44 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=11′822)
                            Index Cond: (id = a1.division_id)
                            Buffers: shared hit=34′722 read=744
                      ->  Index Scan using kf_med_organization_index_by_fieldkey on organization o_1  (cost=0.42..8.44 rows=1 width=16) (never executed)
                            Index Cond: (id = t.organization_id)
              SubPlan 2
                ->  Nested Loop  (cost=0.84..16.88 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=79′347)
                      Buffers: shared hit=570′189 read=64′587 written=216
                      ->  Index Scan using pk_office_building on office_building t_1  (cost=0.42..8.44 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=79′347)
                            Index Cond: (id = a1.object_id)
                            Buffers: shared hit=264′991 read=52′397 written=172
                      ->  Index Scan using kf_med_organization_index_by_fieldkey on organization o_2  (cost=0.42..8.44 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=79′347)
                            Index Cond: (id = t_1.organization_id)
                            Buffers: shared hit=305′198 read=12′190 written=44
        ->  Index Scan using pk_office_building on office_building o  (cost=0.42..7.88 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=73′208)
              Index Cond: (id = a1.object_id)
              Filter: ((state_id <> 6) AND (state_id <> '-1'::integer))
              Rows Removed by Filter: 0
              Buffers: shared hit=292′832
Planning:
  Buffers: shared hit=44 read=41 dirtied=2
Planning Time: 3.355 ms
JIT:
  Functions: 42
  Options: Inlining true, Optimization true, Expressions true, Deforming true
  Timing: Generation 11.985 ms, Inlining 42.569 ms, Optimization 902.797 ms, Emission 572.052 ms, Total 1′529.404 ms
Execution Time: 6′933.960 ms