Limit  (cost=293.40..1028.60 rows=1000 width=1209) (actual time=0.128..24.751 rows=1000 loops=1)
  ->  Merge Left Join  (cost=293.40..4197731.11 rows=5709243 width=1209) (actual time=0.124..21.968 rows=1000 loops=1)
        Merge Cond: (this_.id = (companymea2_.company_id)::bigint)
        ->  Merge Left Join  (cost=246.59..3681230.10 rows=5709243 width=1141) (actual time=0.099..15.284 rows=1000 loops=1)
              Merge Cond: (this_.id = (ces3_.company_id)::bigint)
              ->  Merge Join  (cost=37.87..2435536.00 rows=5709243 width=639) (actual time=0.074..8.487 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=623) (actual time=0.037..1.860 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.758 rows=1000 loops=1)
                          Index Cond: ((this_1_.company_id)::bigint > 50000000)
                          Filter: ((this_1_.tag_id)::bigint = 7)
              ->  Index Scan using cws_company_descr_unique on company_descr ces3_  (cost=0.00..1169511.92 rows=5757068 width=502) (actual time=0.020..1.788 rows=1054 loops=1)
                    Index Cond: ((ces3_.company_id)::bigint > 50000000)
        ->  Index Scan using pk_comp_ms on company_measures companymea2_  (cost=0.00..440945.79 rows=5688885 width=68) (actual time=0.019..1.729 rows=1054 loops=1)
              Index Cond: ((companymea2_.company_id)::bigint > 50000000)
Total runtime: 26.327 ms