PostGIS Question

[Stephen Woodbridge]

I'm newbie to PostGIS, I am wondering if the mapserver integration uses 
the PostGIS spatial indexes when rendering a map or if it needs to be 
made explicitly in the layer definition?

Does the final SQL do something like:

select whatever, the_geom
   from table
where the_geom && bbox2d(image_extents) and ...

I am guessing/hoping it probably does. Is there an easy way to get 
mapserver to  dump the SQL to a log file for inspection?

Thanks,
   -Steve W.