|
1 | 1 | <!--
|
2 |
| -$Header: /cvsroot/pgsql/doc/src/sgml/ref/explain.sgml,v 1.17 2002/03/2404:31:07 tgl Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/explain.sgml,v 1.18 2002/03/2416:57:29 tgl Exp $ |
3 | 3 | PostgreSQL documentation
|
4 | 4 | -->
|
5 | 5 |
|
@@ -220,13 +220,13 @@ EXPLAIN SELECT * FROM foo WHERE i = 4;
|
220 | 220 | using an aggregate function:
|
221 | 221 |
|
222 | 222 | <programlisting>
|
223 |
| -EXPLAIN SELECT sum(i) FROM foo WHERE i< 4; |
| 223 | +EXPLAIN SELECT sum(i) FROM foo WHERE i< 10; |
224 | 224 | <computeroutput>
|
225 | 225 | QUERY PLAN
|
226 | 226 | ---------------------------------------------------------------------
|
227 | 227 | Aggregate (cost=23.93..23.93 rows=1 width=4)
|
228 |
| - -> Index Scan using fi on foo (cost=0.00..23.92 rows=6 width=4) |
229 |
| - Index Filter: (i< 10) |
| 228 | + -> Index Scan using fi on foo (cost=0.00..23.92 rows=6 width=4) |
| 229 | + Index Filter: (i< 10) |
230 | 230 | (3 rows)
|
231 | 231 | </computeroutput>
|
232 | 232 | </programlisting>
|
|