|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/auto-explain.sgml,v 1.6 2009/12/15 04:57:47 rhaas Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/auto-explain.sgml,v 1.7 2010/02/20 22:24:29 adunstan Exp $ --> |
2 | 2 |
|
3 | 3 | <sect1 id="auto-explain"> |
4 | 4 | <title>auto_explain</title> |
@@ -188,17 +188,18 @@ auto_explain.log_min_duration = '3s' |
188 | 188 | </para> |
189 | 189 |
|
190 | 190 | <programlisting><![CDATA[ |
191 | | - LOG: duration: 0.986 ms plan: |
192 | | - Aggregate (cost=14.90..14.91 rows=1 width=0) |
193 | | - -> Hash Join (cost=3.91..14.70 rows=81 width=0) |
194 | | - Hash Cond: (pg_class.oid = pg_index.indrelid) |
195 | | - -> Seq Scan on pg_class (cost=0.00..8.27 rows=227 width=4) |
196 | | - -> Hash (cost=2.90..2.90 rows=81 width=4) |
197 | | - -> Seq Scan on pg_index (cost=0.00..2.90 rows=81 width=4) |
198 | | - Filter: indisunique |
199 | | - STATEMENT: SELECT count(*) |
200 | | - FROM pg_class, pg_index |
201 | | - WHERE oid = indrelid AND indisunique; |
| 191 | + LOG: duration: 3.651 ms plan: |
| 192 | + Query Text: SELECT count(*) |
| 193 | + FROM pg_class, pg_index |
| 194 | + WHERE oid = indrelid AND indisunique; |
| 195 | + Aggregate (cost=16.79..16.80 rows=1 width=0) (actual time=3.626..3.627 rows=1 loops=1) |
| 196 | + -> Hash Join (cost=4.17..16.55 rows=92 width=0) (actual time=3.349..3.594 rows=92 loops=1) |
| 197 | + Hash Cond: (pg_class.oid = pg_index.indrelid) |
| 198 | + -> Seq Scan on pg_class (cost=0.00..9.55 rows=255 width=4) (actual time=0.016..0.140 rows=255 loops=1) |
| 199 | + -> Hash (cost=3.02..3.02 rows=92 width=4) (actual time=3.238..3.238 rows=92 loops=1) |
| 200 | + Buckets: 1024 Batches: 1 Memory Usage: 4kB |
| 201 | + -> Seq Scan on pg_index (cost=0.00..3.02 rows=92 width=4) (actual time=0.008..3.187 rows=92 loops=1) |
| 202 | + Filter: indisunique |
202 | 203 | ]]> |
203 | 204 | </programlisting> |
204 | 205 | </sect2> |
|