From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | Zhihong Zhang <zhihong(at)gmail(dot)com> |
Cc: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Indexing on JSONB field not working |
Date: | 2019-12-26 16:50:24 |
Message-ID: | CAMkU=1w8UyLY1e4N6m5nB9CmG1wjizqFS--Lmi3GZ4j1+JUP3Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
>
> On Dec 21, 2019, at 10:17 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>
> Can you show the output of:
>
> select * from pg_stats where tablename ='float_number_index_path2'
>
> For readability, use the output format which shows the columns down the
> screen, not across. In psql, that would toggled on with \x.
>
>
On Thu, Dec 26, 2019 at 11:30 AM Zhihong Zhang <zhihong(at)gmail(dot)com> wrote:
> That command yields nothing.
>
Did you use the actual name of the index (in case its actual name differs
from what you showed us in the CREATE INDEX)? If you did and it doesn't
show anything, then I don't think the table has been ANALYZED since the
index was created. Note that ANALYZE and EXPLAIN ANALYZE are different
things. You need to run "ANALYZE assets;" or "VACUUM ANALYZE assets;"
Cheers,
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Zhihong Zhang | 2019-12-26 16:58:27 | Re: Indexing on JSONB field not working |
Previous Message | Zhihong Zhang | 2019-12-26 16:30:47 | Re: Indexing on JSONB field not working |