[postgis-users] estimated extent and EPSG:5514

[Sandro Santilli]

On Mon, Nov 21, 2016 at 04:28:34PM +0100, Martin Landa wrote:
> Hi,
> 
> 2016-11-21 15:52 GMT+01:00 Paul Ramsey <pramsey at cleverelephant.ca>:
> > What does _postgis_stats( 'ruian.kraje', 'geom') do?
> 
> select _postgis_stats( 'ruian.kraje', 'geom');
> _postgis_stats |
> {"ndims":2,"size":[1,1],"extent":{"min":[-909108,-1.23343e+06],"max":[4522.92,6136.48]},"table_features":8,"sample_features":8,"not_null_features":8,"histogram_features":8,"histogram_cells":1,"cells_covered":8}

Histogram cells 1 and sample features 8 ?

How many rows do you have in that table ?
Did you change stat targets for the column ?

 SELECT attstattarget
   FROM pg_attribute
  WHERE attrelid = 'ruian.kraje'::regclass
    AND attname = 'geom';

--strk;