Gather Merge  (cost=2367447.44..2718206.24 rows=2929468 width=4) (actual time=5072.982..5130.550 rows=184475 loops=1)
   Workers Planned: 4
   Workers Launched: 4
   Buffers: shared hit=195981 read=882299
   I/O Timings: read=1309.979
   ->  Sort  (cost=2366447.38..2368278.30 rows=732367 width=4) (actual time=5064.794..5067.143 rows=36895 loops=5)
         Sort Key: t1.index_id DESC
         Sort Method: quicksort  Memory: 3282kB
         Worker 0:  Sort Method: quicksort  Memory: 3277kB
         Worker 1:  Sort Method: quicksort  Memory: 3214kB
         Worker 2:  Sort Method: quicksort  Memory: 3294kB
         Worker 3:  Sort Method: quicksort  Memory: 3263kB
         Buffers: shared hit=195981 read=882299
         I/O Timings: read=1309.979
         ->  Hash Join  (cost=863950.63..2295106.75 rows=732367 width=4) (actual time=196.184..5056.828 rows=36895 loops=5)
               Hash Cond: (t1.id_house = t2.id)
               Buffers: shared hit=195953 read=882299
               I/O Timings: read=1309.979
               ->  Parallel Seq Scan on cache_table t1  (cost=0.00..1332559.84 rows=37560484 width=8) (actual time=0.035..2019.457 rows=30048358 loops=5)
                     Buffers: shared hit=85962 read=870993
                     I/O Timings: read=1193.774
               ->  Hash  (cost=851821.48..851821.48 rows=970332 width=4) (actual time=179.976..179.977 rows=71594 loops=5)
                     Buckets: 1048576  Batches: 1  Memory Usage: 10709kB
                     Buffers: shared hit=109823 read=11306
                     I/O Timings: read=116.205
                     ->  Index Scan using houses_index on houses t2  (cost=0.56..851821.48 rows=970332 width=4) (actual time=0.922..161.247 rows=71594 loops=5)
                           Index Cond: (id_addresses = ANY ('преечисление,17572575}'::integer[]))
                           Buffers: shared hit=109823 read=11306
                           I/O Timings: read=116.205
 Planning Time: 5.624 ms
 Execution Time: 5136.369 ms
(31 rows)