Limit  (cost=497.46..1464.50 rows=1000 width=693) (actual time=7767.721..7793.047 rows=1000 loops=1)
  ->  Merge Left Join  (cost=497.46..5521612.64 rows=5709243 width=693) (actual time=7767.717..7790.274 rows=1000 loops=1)
        Merge Cond: (this_.id = (companymea2_.company_id)::bigint)
        ->  Merge Left Join  (cost=404.31..4544508.54 rows=5709243 width=625) (actual time=4211.501..4227.215 rows=1000 loops=1)
              Merge Cond: (this_.id = (ces3_.company_id)::bigint)
              ->  Merge Join  (cost=37.87..2435536.00 rows=5709243 width=123) (actual time=0.069..8.584 rows=1000 loops=1)
                    Merge Cond: (this_.id = (this_1_.company_id)::bigint)
                    ->  Index Scan using pk_comp_m on company this_  (cost=0.00..2139324.53 rows=6886598 width=107) (actual time=0.031..1.876 rows=1054 loops=1)
                          Index Cond: (id > 50000000)
                    ->  Index Scan using company_tag_company_id_idx on company_tag this_1_  (cost=0.00..207678.85 rows=5709243 width=16) (actual time=0.027..1.757 rows=1000 loops=1)
                          Index Cond: ((this_1_.company_id)::bigint > 50000000)
                          Filter: ((this_1_.tag_id)::bigint = 7)
              ->  Index Scan using company_descrs on company_descr ces3_  (cost=0.00..2073526.89 rows=1996612 width=502) (actual time=0.014..2576.013 rows=1097096 loops=1)
        ->  Index Scan using pk_comp_ms on company_measures companymea2_  (cost=0.00..889427.81 rows=6821672 width=68) (actual time=0.020..1946.255 rows=1097096 loops=1)
Total runtime: 7794.692 ms