Re: PostgreSQL 12.3 slow index scan chosen

2020-06-20 Thread Tom Lane
I wrote: > ... oh, now I see: apparently, your filter condition is such that *no* > rows of the objectcustomfieldvalues table get past the filter: > > -> Index Scan using objectcustomfieldvalues3 on > objectcustomfieldvalues objectcustomfieldvalues_1 (cost=0.56..807603.40 > rows=9

Re: PostgreSQL 12.3 slow index scan chosen

2020-06-20 Thread Kenneth Marshall
On Sat, Jun 20, 2020 at 02:22:03PM -0400, Tom Lane wrote: > I wrote: > > ... oh, now I see: apparently, your filter condition is such that *no* > > rows of the objectcustomfieldvalues table get past the filter: > > > > -> Index Scan using objectcustomfieldvalues3 on > > objectcustom