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

[G. Allegri]

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/056f5e68/attachment.htm