[postgis-devel] gserialized_sel_internal: no statistics available on table, run ANALYZE
Paul Ramsey
pramsey at cleverelephant.ca
Wed Aug 28 15:47:22 PDT 2019
It’s possible for a table to be analyzed but have no workable stats. Full of nulls, full of empty, full of nothing.
P
> 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: entered function
> DEBUG: gserialized_sel_internal: no statistics available on table, run ANALYZE
> DEBUG: gserialized_gist_sel: selectivity is 0.0001
>
> But I just run ANALYZE so the hint is odd, what's the matter ?
>
> --strk;
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
More information about the postgis-devel
mailing list