[MS4W-Users] how to view/debug postgis queries with MS debug informations?
giohappy at gmail.com
Wed Jun 27 11:59:48 EST 2012
Thanks Michael, I missed it!
So, the slowness is caused by AGG rendering, but I will opne a new thread
2012/6/27 Smith, Michael ERDC-CRREL-NH <Michael.Smith at usace.army.mil>
> Did you add the DEBUG 5 at the LAYER level as well as the MAP level?
> Michael Smith
> Remote Sensing GIS Center
> US Army Corps of Engineers
> *From*: G. Allegri [mailto:giohappy at gmail.com]
> *Sent*: Wednesday, June 27, 2012 09:43 AM
> *To*: ms4w-users at lists.maptools.org <ms4w-users at lists.maptools.org>
> *Subject*: [MS4W-Users] how to view/debug postgis queries with MS debug
> I need to view the exact sql query performed by MS for a PostGIS layer.
> 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.
> [Wed Jun 27 18:36:03 2012].288000 msDrawMap(): Layer 3
> (regioni.confini_regioni), 3.911s
> [Wed Jun 27 18:36:03 2012].288000 msDrawMap(): Drawing Label Cache, 0.000s
> [Wed Jun 27 18:36:03 2012].288000 msDrawMap() total time: 3.915s
> [Wed Jun 27 18:36:03 2012].296000 msSaveImage(stdout) total time: 0.008s
> [Wed Jun 27 18:36:03 2012].297000 msFreeMap(): freeing map at 03A75750.
> [Wed Jun 27 18:36:05 2012].605000 msDrawMap(): rendering using
> outputformat named AGG PNG 24 bit (AGG/PNG).
> [Wed Jun 27 18:36:05 2012].608000 msDrawMap(): WMS/WFS set-up and query,
> What is the right way to inspect what I need?
> 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).
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the MS4W-Users