Jan 5, 2021
For the whole column, items_purchased use
CREATE INDEX idx_purchases ON public.purchases
(items_purchased)
For a specific Key (price here) in the field use,
CREATE INDEX idx_purchases_price
ON public.purchases
((items_purchased ->> ‘price’))
Hope this helps