Re: Indexing on JSONB field not working

The stats was sent in a previous email. Let me know if you can’t find it.

Zhihong

> On Dec 28, 2019, at 6:56 PM, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> wrote:
>
> On Sat, Dec 28, 2019 at 02:59:07PM -0500, Zhihong Zhang wrote:
>>>
>>> Only one of your indexes is over an expression. The index over a
>>> plain column will never have stats, as column stats are stored with
>>> the table, not the index.
>>>
>>
>> Oh. That explains it. I tweaked a few server parameters, wonder if that
>> made the difference. I changed,
>>
>> pg_stat_statements.track: ALL
>>
>> track_activity_query_size: 2048
>>
>> Now we have stats, can anyone see why the index is not used?
>>
>
> I don't follow. Neither of these configuration options should affect
> which indexes have stats. The expression index should have stats no
> matter how these two GUCs are set.
>
> But once again, you're making claims without actually showing us the
> data. How do you know we have stats now? Show us pg_stats data and
> the explain plans.
>
>
> regards
>
> --
> Tomas Vondra http://www.2ndQuadrant.com
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services