[postgis-users] PostGIS profiling? Tools?

[Chipp Jansen]

Hello -

I'd like to profile a batch of queries on a large 'Geography' type
data-set in PostGIS - mostly I'm interested getting an idea of
performance of point-in-polygon queries (ST_Intersects) and distance
queries (ST_DWithin).

Are there any tools people use when profiling their set-ups, or any
recent benchmark examples?

Thanks much!

~ Chipp

POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September
2009" LIBXML="2.7.7" USE_STATS