Thanks Michael, I missed it!<div>So, the slowness is caused by AGG rendering, but I will opne a new thread on this.</div><div><br></div><div>giovanni<br><br><div class="gmail_quote">2012/6/27 Smith, Michael ERDC-CRREL-NH <span dir="ltr"><<a href="mailto:Michael.Smith@usace.army.mil" target="_blank">Michael.Smith@usace.army.mil</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<font style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Did you add the DEBUG 5 at the LAYER level as well as the MAP level?<br>
<br>
<br>
--------- <br>
Michael Smith <br>
Remote Sensing GIS Center <br>
US Army Corps of Engineers <br>
</font><br>
<br>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<font style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><b>From</b>: G. Allegri [mailto:<a href="mailto:giohappy@gmail.com" target="_blank">giohappy@gmail.com</a>]
<br>
<b>Sent</b>: Wednesday, June 27, 2012 09:43 AM<br>
<b>To</b>: <a href="mailto:ms4w-users@lists.maptools.org" target="_blank">ms4w-users@lists.maptools.org</a> <<a href="mailto:ms4w-users@lists.maptools.org" target="_blank">ms4w-users@lists.maptools.org</a>> <br>
<b>Subject</b>: [MS4W-Users] how to view/debug postgis queries with MS debug informations?
<br>
</font> <br>
</div><div><div class="h5">
I need to view the exact sql query performed by MS for a PostGIS layer.
<div>I thought the DEBUG 5 level would list verbose connection and query outputs, instead I can only see summery informations about layer processing and rendering times.</div>
<div><br>
</div>
<div>eg.:</div>
<div>
<div>[Wed Jun 27 18:36:03 <a href="tel:2012%5D.288000" value="+12012288000" target="_blank">2012].288000</a> msDrawMap(): Layer 3 (regioni.confini_regioni), 3.911s</div>
<div>[Wed Jun 27 18:36:03 <a href="tel:2012%5D.288000" value="+12012288000" target="_blank">2012].288000</a> msDrawMap(): Drawing Label Cache, 0.000s</div>
<div>[Wed Jun 27 18:36:03 <a href="tel:2012%5D.288000" value="+12012288000" target="_blank">2012].288000</a> msDrawMap() total time: 3.915s</div>
<div>[Wed Jun 27 18:36:03 <a href="tel:2012%5D.296000" value="+12012296000" target="_blank">2012].296000</a> msSaveImage(stdout) total time: 0.008s</div>
<div>[Wed Jun 27 18:36:03 <a href="tel:2012%5D.297000" value="+12012297000" target="_blank">2012].297000</a> msFreeMap(): freeing map at 03A75750.</div>
<div>[Wed Jun 27 18:36:05 <a href="tel:2012%5D.605000" value="+12012605000" target="_blank">2012].605000</a> msDrawMap(): rendering using outputformat named AGG PNG 24 bit (AGG/PNG).</div>
<div>[Wed Jun 27 18:36:05 <a href="tel:2012%5D.608000" value="+12012608000" target="_blank">2012].608000</a> msDrawMap(): WMS/WFS set-up and query, 0.003s</div>
</div>
<div><br>
</div>
<div>What is the right way to inspect what I need?</div>
<div><br>
</div>
<div>I need to understand where the slowness resides, because it takes too long to render this layer, which generally happens in fractions of seconds (both on other versions of Mapserver and Geoserver).</div>
<div><br>
</div>
<div>giovanni</div>
</div></div></div>
</blockquote></div><br></div>