Query not using index with jsonb - Postgres
Index idx_btree_ig_id will be used only if you write WHERE part like ig -&gt;&gt; 'id' = '"4878142508"'. (I assume that ig has structure like {"id": "4878142508", ...})

If you want to use operator @&gt; you need to create gin index on that column, then you can use this index like so: ig @&gt; '{"id":"4878142508"}'

CREATE INDEX idx_gin_ig_id ON public.influencers USING gin (ig jsonb_path_ops);