Gather Merge  (cost=2833738.23..3198674.18 rows=3127804 width=4) (actual time=7096.028..7125.175 rows=184475 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   Buffers: shared hit=63550 read=966177
   ->  Sort  (cost=2832738.21..2836647.96 rows=1563902 width=4) (actual time=7087.524..7091.140 rows=61492 loops=3)
         Sort Key: t1.index_id DESC
         Sort Method: quicksort  Memory: 4350kB
         Worker 0:  Sort Method: quicksort  Memory: 4409kB
         Worker 1:  Sort Method: quicksort  Memory: 4498kB
         Buffers: shared hit=63550 read=966177
         ->  Hash Join  (cost=924548.91..2671838.35 rows=1563902 width=4) (actual time=109.589..7075.843 rows=61492 loops=3)
               Hash Cond: (t1.id_house = t2.id)
               Buffers: shared hit=63537 read=966176
               ->  Parallel Seq Scan on cache_table t1  (cost=0.00..1582962.47 rows=62600747 width=8) (actual time=0.016..2838.913 rows=50080597 loops=3)
                     Buffers: shared hit=2840 read=954115
               ->  Hash  (cost=909020.31..909020.31 rows=1242288 width=4) (actual time=96.659..96.660 rows=71594 loops=3)
                     Buckets: 2097152  Batches: 1  Memory Usage: 18901kB
                     Buffers: shared hit=60624 read=12050
                     ->  Index Scan using houses_index on houses t2  (cost=0.56..909020.31 rows=1242288 width=4) (actual time=2.465..81.727 rows=71594 loops=3)
                           Index Cond: (id_addresses = ANY ('{1300337,,17572575}'::integer[]))
                           Buffers: shared hit=60624 read=12050
 Planning Time: 4.429 ms
 Execution Time: 7130.676 ms
(23 rows)