[MS4W-Users] how to view/debug postgis queries with MS debug informations?

[G. Allegri]

Thanks Michael, I missed it!
So, the slowness is caused by AGG rendering, but I will opne a new thread
on this.

giovanni

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
> informations?
>
>  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.
>
>  eg.:
>  [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,
> 0.003s
>
>  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).
>
>  giovanni
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/ms4w-users/attachments/20120627/b988c810/attachment.htm