Re: Indexing on JSONB field not working

Jeff Janes <[email protected]> Fri, 20 Dec 2019 17:57:37 -0500

Newsgroups	gmane.comp.db.postgresql.bugs
Message-ID	<CAMkU=1zPbphLfucRN7j7bAwb=9YAGB0cucc_t_MaqKk+rwYTQw@mail.gmail.com>

On Fri, Dec 20, 2019 at 5:12 PM Zhihong Zhang <[email protected]> wrote:

> I have an index on JSONB fields like this,
>
>
>
> CREATE INDEX float_number_index_path2
>
>     ON public.assets USING btree
>
>     (((_doc #> '{floatValue}'::text[])::double precision) ASC NULLS LAST)
>
>     TABLESPACE pg_default;
>
>
>
> However query doesn’t use it,
>

Did you analyze the table after building the index?  Expression indexes
have their own statistics, but they don't get populated until the table is
analyzed.

Cheers,

Jeff