Re: Indexing on JSONB field not working

Zhihong Zhang <[email protected]> Sat, 28 Dec 2019 14:59:07 -0500

Newsgroups	gmane.comp.db.postgresql.bugs
Message-ID	<[email protected]>

> 
> 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?

Thanks!

Zhihong