<div dir="ltr">Because I was a bit quick on the send this is the version details:<div><br></div><div>PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit POSTGIS="2.3.4 r16009" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.1.3, released 2017/20/01" LIBXML="2.9.3" LIBJSON="0.12" (core procs from "2.3.2 r15302" need upgrade) RASTER (raster procs from "2.3.2 r15302" need upgrade)<br></div><div><br></div><div>- Nathan</div><div><br><div class="gmail_quote"><div dir="ltr">On Wed, Aug 1, 2018 at 9:39 AM Nathan Woodrow <<a href="mailto:woodrow.nathan@gmail.com">woodrow.nathan@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">

<div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">Hey,</div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">When I run <span> </span><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">ANALYSE on some of our tables we seem to be getting the following:</span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"> <pre class="gmail-m_-6840226836468183629gmail-code-java" style="margin:0px;padding:0px;max-height:30em;overflow:auto;white-space:pre-wrap;word-wrap:normal;font-size:12px;background-color:rgb(245,245,245);text-decoration-style:initial;text-decoration-color:initial">[2018-08-01 09:20:31] [00000] no non-<span class="gmail-m_-6840226836468183629gmail-code-keyword" style="color:rgb(0,0,145)">null</span>/empty features, unable to compute statistics
[2018-08-01 09:20:31] [00000] no non-<span class="gmail-m_-6840226836468183629gmail-code-keyword" style="color:rgb(0,0,145)">null</span>/empty features, unable to compute statistics</pre> <br></span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">I found an older ticket that was meant to be fixed related to 3D data and large values on the z and m, but from what I can see we don't have any of that in our database.  Dumping the WKT doesn't return any POINTZ or anything like that.</span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Any hints on how to debug this one.  I'm going to check other tables we have but so far 2 are showing it happen and it seems to make the stats not update correctly and given the table is going to be quite large I would like to make sure they stay updated if possible.</span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Regards,</span></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Nathan</span></div>

<br></div>
</blockquote></div></div></div>