PgAdmin 'EXPLAIN'

gistfile1.txt

Aggregate  (cost=5589.73..5589.74 rows=1 width=0) (actual time=5856.243..5856.243 rows=1 loops=1)
  ->  Bitmap Heap Scan on influencers  (cost=36.65..5585.78 rows=1582 width=0) (actual time=364.965..5806.038 rows=279764 loops=1)
          Recheck Cond: ((((ig ->> 'follower_count'::text))::integer >= 1000) AND (((ig ->> 'follower_count'::text))::integer <= 10000))
                  Rows Removed by Index Recheck: 14697
                          Heap Blocks: exact=35075 lossy=26495
                                  ->  Bitmap Index Scan on idx_btree_ig_follower_count2  (cost=0.00..36.26 rows=1582 width=0) (actual time=350.187..350.187 rows=279764 loops=1)
                                                Index Cond: ((((ig ->> 'follower_count'::text))::integer >= 1000) AND (((ig ->> 'follower_count'::text))::integer <= 10000))
                                                
                                                Planning time: 8.194 ms
                                                Execution time: 5861.099 ms