Gather Merge  (cost=2361773.42..2710634.66 rows=2913620 width=4) (actual time=4729.876..4765.026 rows=184475 loops=1)
   Workers Planned: 4
   Workers Launched: 4
   Buffers: shared hit=110115 read=968165
   I/O Timings: read=1224.873
   ->  Sort  (cost=2360773.36..2362594.37 rows=728405 width=4) (actual time=4722.823..4725.285 rows=36895 loops=5)
         Sort Key: t1.index_id DESC
         Sort Method: quicksort  Memory: 3272kB
         Worker 0:  Sort Method: quicksort  Memory: 3344kB
         Worker 1:  Sort Method: quicksort  Memory: 3272kB
         Worker 2:  Sort Method: quicksort  Memory: 3317kB
         Worker 3:  Sort Method: quicksort  Memory: 3124kB
         Buffers: shared hit=110115 read=968165
         I/O Timings: read=1224.873
         ->  Hash Join  (cost=858691.05..2289847.17 rows=728405 width=4) (actual time=112.201..4714.540 rows=36895 loops=5)
               Hash Cond: (t1.id_house = t2.id)
               Buffers: shared hit=110087 read=968165
               I/O Timings: read=1224.873
               ->  Parallel Seq Scan on cache_table t1  (cost=0.00..1332559.84 rows=37560484 width=8) (actual time=0.028..1916.792 rows=30048358 loops=5)
                     Buffers: shared hit=832 read=956123
                     I/O Timings: read=1179.342
               ->  Hash  (cost=846663.75..846663.75 rows=962184 width=4) (actual time=97.687..97.688 rows=71594 loops=5)
                     Buckets: 1048576  Batches: 1  Memory Usage: 10709kB
                     Buffers: shared hit=109087 read=12042
                     I/O Timings: read=45.532
                     ->  Index Scan using houses_index on houses t2  (cost=0.56..846663.75 rows=962184 width=4) (actual time=0.778..82.228 rows=71594 loops=5)
                           Index Cond: (id_addresses = ANY ('{1300337,большое перечисление,17572575}'::integer[]))
                           Buffers: shared hit=109087 read=12042
                           I/O Timings: read=45.532
 Planning Time: 5.372 ms
 Execution Time: 4770.648 ms
(31 rows)