SELECT "t1"."index_id" FROM "cache_table" AS "t1" INNER JOIN "houses" AS "t2" ON ("t1"."id_house" = "t2"."id") WHERE (("t2"."id_addresses""t1"."index_id" DESC LIMIT 100 OFFSET 0

___
 Limit  (cost=1001.16..14871.56 rows=100 width=4) (actual time=1077.065..2369.883 rows=100 loops=1)
   ->  Gather Merge  (cost=1001.16..520607739.31 rows=3753366 width=4) (actual time=1077.063..2369.859 rows=100 loops=1)
         Workers Planned: 2
         Workers Launched: 2
         ->  Nested Loop  (cost=1.14..520173507.72 rows=1563902 width=4) (actual time=1046.247..2069.054 rows=47 loops=3)
               ->  Parallel Index Scan Backward using cache_index_id on cache_table t1  (cost=0.57..118451325.04 rows=62600747 width=8) (actual time=0.033..146.011 rows=124137 loops=3)
               ->  Index Scan using houses_pkey on houses t2  (cost=0.56..6.42 rows=1 width=4) (actual time=0.015..0.015 rows=0 loops=372412)
                     Index Cond: (id = t1.id_house)
                     Filter: (id_addresses = ANY ('{1300337,.перечисление индексов..17572575}'::integer[]))
                     Rows Removed by Filter: 1
 Planning Time: 4.388 ms
 Execution Time: 2290.678 ms
(12 rows)