Gather Merge  (cost=2361773.42..2710634.66 rows=2913620 width=4) (actual time=4833.251..4896.560 rows=184475 loops=1)
   Workers Planned: 4
   Workers Launched: 4
   Buffers: shared hit=226923 read=851354
   I/O Timings: read=1070.438
   ->  Sort  (cost=2360773.36..2362594.37 rows=728405 width=4) (actual time=4810.168..4812.565 rows=36895 loops=5)
         Sort Key: t1.index_id DESC
         Sort Method: quicksort  Memory: 3334kB
         Worker 0:  Sort Method: quicksort  Memory: 3105kB
         Worker 1:  Sort Method: quicksort  Memory: 3336kB
         Worker 2:  Sort Method: quicksort  Memory: 3203kB
         Worker 3:  Sort Method: quicksort  Memory: 3352kB
         Buffers: shared hit=226923 read=851354
         I/O Timings: read=1070.438
         ->  Hash Join  (cost=858691.05..2289847.17 rows=728405 width=4) (actual time=50.110..4802.301 rows=36895 loops=5)
               Hash Cond: (t1.id_house = t2.id)
               Buffers: shared hit=226895 read=851354
               I/O Timings: read=1070.438
               ->  Parallel Seq Scan on cache_table t1  (cost=0.00..1332559.84 rows=37560484 width=8) (actual time=0.022..1947.030 rows=30048358 loops=5)
                     Buffers: shared hit=105601 read=851354
                     I/O Timings: read=1070.438
               ->  Hash  (cost=846663.75..846663.75 rows=962184 width=4) (actual time=45.329..45.329 rows=71594 loops=5)
                     Buckets: 1048576  Batches: 1  Memory Usage: 10709kB
                     Buffers: shared hit=121126
                     ->  Index Scan using houses_index on houses t2  (cost=0.56..846663.75 rows=962184 width=4) (actual time=0.625..31.299 rows=71594 loops=5)
                           Index Cond: (id_addresses = ANY ('{...,17572575}'::integer[]))
                           Buffers: shared hit=121126
 Planning Time: 4.144 ms
 Execution Time: 4902.129 ms
(29 rows)
__________________________
__________________________
ВТорой раз
__________________________
__________________________
 Gather Merge  (cost=2361773.42..2710634.66 rows=2913620 width=4) (actual time=4728.949..4792.368 rows=184475 loops=1)
   Workers Planned: 4
   Workers Launched: 4
   Buffers: shared hit=227083 read=851194
   I/O Timings: read=1052.640
   ->  Sort  (cost=2360773.36..2362594.37 rows=728405 width=4) (actual time=4703.901..4706.460 rows=36895 loops=5)
         Sort Key: t1.index_id DESC
         Sort Method: quicksort  Memory: 3265kB
         Worker 0:  Sort Method: quicksort  Memory: 3342kB
         Worker 1:  Sort Method: quicksort  Memory: 3149kB
         Worker 2:  Sort Method: quicksort  Memory: 3234kB
         Worker 3:  Sort Method: quicksort  Memory: 3339kB
         Buffers: shared hit=227083 read=851194
         I/O Timings: read=1052.640
         ->  Hash Join  (cost=858691.05..2289847.17 rows=728405 width=4) (actual time=57.413..4696.346 rows=36895 loops=5)
               Hash Cond: (t1.id_house = t2.id)
               Buffers: shared hit=227055 read=851194
               I/O Timings: read=1052.640
               ->  Parallel Seq Scan on cache_table t1  (cost=0.00..1332559.84 rows=37560484 width=8) (actual time=0.020..1890.739 rows=30048358 loops=5)
                     Buffers: shared hit=105761 read=851194
                     I/O Timings: read=1052.640
               ->  Hash  (cost=846663.75..846663.75 rows=962184 width=4) (actual time=48.699..48.700 rows=71594 loops=5)
                     Buckets: 1048576  Batches: 1  Memory Usage: 10709kB
                     Buffers: shared hit=121126
                     ->  Index Scan using houses_index on houses t2  (cost=0.56..846663.75 rows=962184 width=4) (actual time=0.587..34.384 rows=71594 loops=5)
                           Index Cond: (id_addresses = ANY ('{1300337,,11708015,11669326,17476104,17572575}'::integer[]))
                           Buffers: shared hit=121126
 Planning Time: 2.961 ms
 Execution Time: 4797.918 ms
(29 rows)