[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