EXPLAIN ANALYZE
SELECT *
FROM pvp_player
JOIN profile_bit ON profile_bit.profile_id = pvp_player.profile_id
AND profile_bit.bit_name = 'ArmyBit'
WHERE pvp_player.profile_id != 'GCd67bf7370cc5d82676a5d56550273f92'
AND pvp_player.state IN (2, 3)
AND pvp_player.update_datetime > '2020-04-03'
AND pvp_player.league = 3
ORDER BY abs(pvp_player.fame - 2150) ASC
LIMIT 100;

 Limit  (cost=5823.94..5824.19 rows=100 width=1081) (actual time=26.975..26.992 rows=100 loops=1)
   ->  Sort  (cost=5823.94..5824.35 rows=161 width=1081) (actual time=26.974..26.980 rows=100 loops=1)
         Sort Key: (abs((pvp_player.fame - 2150)))
         Sort Method: top-N heapsort  Memory: 76kB
         ->  Nested Loop  (cost=0.98..5818.04 rows=161 width=1081) (actual time=0.082..25.509 rows=1617 loops=1)
               ->  Index Scan using pvp_player_league_fame_idx on pvp_player  (cost=0.43..5335.00 rows=173 width=193) (actual time=0.055..6.154 rows=1617 loops=1)
                     Index Cond: (league = 3)
                     Filter: (((profile_id)::text <> 'GCd67bf7370cc5d82676a5d56550273f92'::text) AND (state = ANY ('{2,3}'::integer[])) AND (update_datetime > '2020-04-03 00:00:00'::timestamp without time zone))
                     Rows Removed by Filter: 3681
               ->  Append  (cost=0.55..2.78 rows=1 width=884) (actual time=0.011..0.011 rows=1 loops=1617)
                     ->  Index Scan using profile_bit_armybit_pkey on profile_bit_armybit  (cost=0.55..2.77 rows=1 width=884) (actual time=0.011..0.011 rows=1 loops=1617)
                           Index Cond: (((profile_id)::text = (pvp_player.profile_id)::text) AND ((bit_name)::text = 'ArmyBit'::text))
 Planning Time: 0.832 ms
 Execution Time: 27.109 ms