<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Quick report</title>
<meta http-equiv="Content-Type" content="utf-8" />
<style type="text/css">
body { font-family: verdana, helvetica, sans-serif; margin: 0px; padding: 0; }
h1 { font-weight: bold; font-size: 150%; border-bottom-style: solid; border-bottom-width: 2px; margin-top: 0px; padding-bottom: 0.5ex; color: #eeeeee; }
h2 { font-size: 130%; padding-bottom: 0.5ex; color: #009ACE; border-bottom-style: solid; border-bottom-width: 2px; }
h3 { font-size: 110%; padding-bottom: 0.5ex; color: #000000; }
th { text-align: left; background-color: #009ACE; color: #eeeeee; }
#ReportHeader { padding: 10px; background-color: #009ACE; color: #eeeeee; border-bottom-style: solid; border-bottom-width: 2px; border-color: #999999; }
#ReportHeader th { width: 25%; white-space: nowrap; vertical-align: top; }
#ReportHeader td { vertical-align: top; color: #eeeeee; }
#ReportNotes { padding: 10px; background-color: #eeeeee; font-size: 80%; border-bottom-style: solid; border-bottom-width: 2px; border-color: #999999; }
.ReportSQL { margin-bottom: 10px; padding: 10px; display: block; background-color: #eeeeee; font-family: monospace; }
#ReportDetails { margin-left: 10px; margin-right: 10px; margin-bottom: 10px; }
#ReportDetails td, th { font-size: 80%; margin-left: 2px; margin-right: 2px; }
#ReportDetails th { border-bottom-color: #777777; border-bottom-style: solid; border-bottom-width: 2px; }
.ReportDetailsOddDataRow { background-color: #dddddd; }
.ReportDetailsEvenDataRow { background-color: #eeeeee; }
.ReportTableHeaderCell { background-color: #dddddd; color: #009ACE; vertical-align: top; font-size: 80%; white-space: nowrap; }
.ReportTableValueCell { vertical-align: top; font-size: 80%; white-space: nowrap; }
.ReportTableInfo { font-size: 80%; font-style: italic; }
#ReportFooter { font-weight: bold; font-size: 80%; text-align: right; background-color: #009ACE; color: #eeeeee; margin-top: 10px; padding: 2px; border-bottom-style: solid; border-bottom-width: 2px; border-top-style: solid; border-top-width: 2px; border-color: #999999; }
#ReportFooter a { color: #ffffff; text-decoration: none; }
</style>
</head>
<body>
<div id="ReportHeader"><h1>Quick report</h1><b>Generated: </b>11/27/2011 5:20:49 PM<br /><b>Database: </b>postgis_analyse_results on postgres@localhost:5441<br /></div>
<div id="ReportDetails">
<h2>Query results</h2>
<table>
<tr>
<th class="ReportTableHeaderCell" width="9.090909090909092%">spatial_class</th>
<th class="ReportTableHeaderCell" width="9.090909090909092%">num_tests</th>
<th class="ReportTableHeaderCell" width="9.090909090909092%">perc_diff_dbox_trunk</th>
<th class="ReportTableHeaderCell" width="9.090909090909092%">avg_dbox_trunk_diff_time</th>
<th class="ReportTableHeaderCell" width="9.090909090909092%">avg_trunk_time</th>
<th class="ReportTableHeaderCell" width="9.090909090909092%">avg_dbox_time</th>
<th class="ReportTableHeaderCell" width="9.090909090909092%">num_worse_than</th>
<th class="ReportTableHeaderCell" width="9.090909090909092%">num_better_than</th>
<th class="ReportTableHeaderCell" width="9.090909090909092%">max_dbox_trunk_time_worse</th>
<th class="ReportTableHeaderCell" width="9.090909090909092%">min_dbox_trunk_time_better</th>
<th class="ReportTableHeaderCell" width="9.090909090909092%">median_diff</th>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">geography</td>
<td class="ReportTableValueCell">8080</td>
<td class="ReportTableValueCell">11.442547861432</td>
<td class="ReportTableValueCell">0.406055646481178</td>
<td class="ReportTableValueCell">10.3572831423895</td>
<td class="ReportTableValueCell">10.7633387888707</td>
<td class="ReportTableValueCell">800</td>
<td class="ReportTableValueCell">479</td>
<td class="ReportTableValueCell">174</td>
<td class="ReportTableValueCell">-188</td>
<td class="ReportTableValueCell">1</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">geometry</td>
<td class="ReportTableValueCell">44733</td>
<td class="ReportTableValueCell">14.4611170958127</td>
<td class="ReportTableValueCell">0.246842812360054</td>
<td class="ReportTableValueCell">5.7820868786386</td>
<td class="ReportTableValueCell">6.02892969099866</td>
<td class="ReportTableValueCell">3396</td>
<td class="ReportTableValueCell">1672</td>
<td class="ReportTableValueCell">403</td>
<td class="ReportTableValueCell">-901</td>
<td class="ReportTableValueCell">1</td>
</tr>
</table>
<br />
<p class="ReportTableInfo">2 rows with 11 columns retrieved.</p>
<pre class="ReportSQL">SELECT spatial_class, COUNT(logid) As num_tests, <br />AVG((dbox_dur_millisec - dur_millisec)/dur_millisec)*100 As perc_diff_dbox_trunk,<br />AVG(diff) As avg_dbox_trunk_diff_time, AVG(dur_millisec) As avg_trunk_time,<br /> AVG(dbox_dur_millisec) As avg_dbox_time,<br /> COUNT(CASE WHEN (dbox_dur_millisec - dur_millisec) > 1 THEN 1 ELSE NULL END) As num_worse_than,<br /> COUNT(CASE WHEN (dbox_dur_millisec - dur_millisec) < -1 THEN 1 ELSE NULL END) As num_better_than,<br /> MAX(diff) AS max_dbox_trunk_time_worse,<br /> MIN(diff) As min_dbox_trunk_time_better,<br /> (array_agg(diff ORDER BY diff))[(COUNT(logid)/2)::integer] As median_diff <br /> FROM (<br />SELECT p2.logid, p2.func, p2.g1, p2.g2, p2.spatial_class, p2.log_sql<br />, date_part('epoch',age(p1.log_end,p1.log_start))*1000 As dur_millisec<br />, date_part('epoch',age(p2.log_end,p2.log_start))*1000 As dbox_dur_millisec,<br />date_part('epoch',age(p2.log_end,p2.log_start))*1000 - date_part('epoch',age(p1.log_end,p1.log_start))*1000 As diff,<br />100.00 - 2*(date_part('epoch',age(p2.log_end,p2.log_start)) - date_part('epoch',age(p1.log_end,p1.log_start))<br /> / (date_part('epoch',age(p1.log_end,p1.log_start)) + date_part('epoch',age(p2.log_end,p2.log_start)))*100) As perc_diff<br />FROM dbox_postgis_garden15_log As p2 INNER JOIN<br /> postgis_garden15_log As p1 ON p2.logid = p1.logid ) As foo<br />GROUP BY spatial_class;</pre>
</div>
<div id="ReportFooter">
Report generated by <a href="http://www.pgadmin.org/">pgAdmin III</a></div>
<br />
</body>
</html>