Gather Merge  (cost=2673231.92..2958061.04 rows=2441222 width=4) (actual time=6639.362..6668.176 rows=184475 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   Buffers: shared hit=60710 read=969017
   ->  Sort  (cost=2672231.90..2675283.43 rows=1220611 width=4) (actual time=6633.177..6636.633 rows=61492 loops=3)
         Sort Key: t1.index_id DESC
         Sort Method: quicksort  Memory: 4551kB
         Worker 0:  Sort Method: quicksort  Memory: 4318kB
         Worker 1:  Sort Method: quicksort  Memory: 4387kB
         Buffers: shared hit=60710 read=969017
         ->  Hash Join  (cost=801542.98..2548833.18 rows=1220611 width=4) (actual time=108.660..6622.228 rows=61492 loops=3)
               Hash Cond: (t1.id_house = t2.id)
               Buffers: shared hit=60697 read=969016
               ->  Parallel Seq Scan on cache_table t1  (cost=0.00..1582963.07 rows=62600807 width=8) (actual time=0.013..2717.742 rows=50080597 loops=3)
                     Buffers: shared read=956955
               ->  Hash  (cost=789413.83..789413.83 rows=970332 width=4) (actual time=95.449..95.450 rows=71594 loops=3)
                     Buckets: 1048576  Batches: 1  Memory Usage: 10709kB
                     Buffers: shared hit=60624 read=12050
                     ->  Index Scan using houses_index on houses t2  (cost=0.56..789413.83 rows=970332 width=4) (actual time=0.884..81.254 rows=71594 loops=3)
                           Index Cond: (id_addresses = ANY ('{1300337,перечисление,17572575}'::integer[]))
                           Buffers: shared hit=60624 read=12050
 Planning Time: 3.169 ms
 Execution Time: 6673.639 ms
(23 rows)