<?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>explain analyse select </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>explain analyse select </h1><b>erzeugt: </b>21.08.2008 09:50:49<br /><b>Datenbank: </b>gis auf betula.lr.fal.de:5432<br /></div>
<div id="ReportDetails">
<h2>Abfrageergebnis</h2>
<table>
<tr>
<th class="ReportTableHeaderCell" width="100%">QUERY PLAN</th>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">GroupAggregate (cost=1057.70..1247.77 rows=1180 width=271) (actual time=614.929..656.331 rows=629 loops=1)</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell"> -> Sort (cost=1057.70..1067.22 rows=3810 width=271) (actual time=614.850..616.765 rows=8325 loops=1)</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell"> Sort Key: p.polygon_id, p.the_geom</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell"> -> Nested Loop (cost=0.00..831.09 rows=3810 width=271) (actual time=48.290..599.998 rows=8325 loops=1)</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell"> Join Filter: _st_within(h.the_geom, p.the_geom)</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell"> -> Seq Scan on ni_polygone_bsp p (cost=0.00..55.80 rows=1180 width=243) (actual time=16.873..52.071 rows=1180 loops=1)</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell"> -> Index Scan using g_id_hb on ni_hoehendaten_bsp h (cost=0.00..0.64 rows=1 width=53) (actual time=0.143..0.402 rows=26 loops=1180)</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell"> Index Cond: (h.the_geom && p.the_geom)</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell"> Filter: (h.the_geom && p.the_geom)</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">Total runtime: 675.377 ms</td>
</tr>
</table>
<br />
<p class="ReportTableInfo">10 rows with 1 columns retrieved.</p>
<pre class="ReportSQL">explain analyse select<br />polygon_id,<br />count(hoehe) as hoehe_count,<br />min(hoehe) as hoehe_min,<br />max(hoehe) as hoehe_max,<br />avg(hoehe) as hoehe_avg,<br />--stdev(hoehe) as hoehe_stdev,<br />count(neigung) as neig_count,<br />min(neigung) as neig_min,<br />max(neigung) as neig_max,<br />avg(neigung) as neig_avg,<br />--stdev(neigung) as neig_stdev,<br />count(exposition) as expos_count,<br />min(exposition) as expos_min,<br />max(exposition) as expos_max,<br />avg(exposition) as expos_avg,<br />--stdev(exposition) as expos_stdev,<br />p.the_geom<br />from bfn.ni_hoehendaten_bsp h,bfn.ni_polygone_bsp p<br />where st_within(h.the_geom, p.the_geom)<br />group by p.polygon_id, p.the_geom<br />order by p.polygon_id asc;<br /></pre>
</div>
<div id="ReportFooter">
Bericht erstellt von <a href="http://www.pgadmin.org/">pgAdmin</a></div>
<br />
</body>
</html>