Re: Indexing on JSONB field not working
Jeff Janes <[email protected]> Sun, 29 Dec 2019 11:11:39 -0500
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <CAMkU=1waicvb_FODcbJeZ8sO4EqTu7wZX4rQKu88AKxoCy97Zw@mail.gmail.com> |
On Sat, Dec 28, 2019 at 2:59 PM Zhihong Zhang <[email protected]> wrote: Now we have stats, can anyone see why the index is not used? > You will have to redo the EXPLAIN (ANALYZE, BUFFERS) now that you have stats, under both settings of enable_seqscan, and show us those. Cheers, Jeff