[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