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

[Smith, Michael ERDC-CRREL-NH]

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