Changes between Version 50 and Version 51 of DevWikiGardenTest

Timestamp:

Dec 3, 2010, 7:45:40 AM (13 years ago)

Author:

robe

Comment:

—

DevWikiGardenTest

@@ -30 +30 @@
    * ''log_output'' - an xml field that contains the query_to_xml output of the query.
 
-There is also a companion for raster testing: raster_gardentest.sql.xsl. The raster one doesn't
-currently create logging tables but will soon.
+There is also a companion for raster testing: raster_gardentest.sql.xsl. The raster one currently only has a '''raster_garden_log''' table
+which is lacking a log_sql field.  This will be added soon.  The structure follows the same pattern as postgis_garden_log
+except that g1/g2 fields may refer to a pixeltype or geometry type.
 
 -- to run:
@@ -65 +66 @@
  FROM postgis_garden_log 
 WHERE func = 'ST_3DDistance' AND log_end IS NOT NULL ;
+}}}
+
+-- basic stats getting timings in milliseconds of garden test just for ST_Intersects function --
+{{{
+SELECT logid, log_label, g1, g2, date_part('epoch',age(log_end,log_start))*1000 As dur_millisec
+ FROM raster_garden_log 
+WHERE func = 'ST_Intersects'  ;
 }}}