[postgis-devel] gserialized_sel_internal: no statistics available on table, run ANALYZE

Sandro Santilli strk at kbt.io
Thu Aug 29 01:51:19 PDT 2019


On Wed, Aug 28, 2019 at 03:47:22PM -0700, Paul Ramsey wrote:
> > On Aug 27, 2019, at 12:38 AM, Sandro Santilli <strk at kbt.io> wrote:
> > 
> > Enabling debug I'm receving lots of these messages:
> > 
> >  DEBUG:  gserialized_sel_internal: no statistics available on table, run ANALYZE
> > 
> > But I just run ANALYZE so the hint is odd, what's the matter ?
>
> It’s possible for a table to be analyzed but have no workable stats. Full of nulls, full of empty, full of nothing.
> 

Right, makes sense. So then maybe the message should end with
a question mark ? "run ANALYZE" seems to be so sure about
the outcome ...

--strk;


More information about the postgis-devel mailing list