diff options
Diffstat (limited to 'doc/src/sgml/perform.sgml')
| -rw-r--r-- | doc/src/sgml/perform.sgml | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml index be161ead74..d4f0c9bcd7 100644 --- a/doc/src/sgml/perform.sgml +++ b/doc/src/sgml/perform.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/perform.sgml,v 1.16 2002/01/20 22:19:56 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/perform.sgml,v 1.17 2002/03/06 06:44:31 momjian Exp $ --> <chapter id="performance-tips"> @@ -96,7 +96,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/perform.sgml,v 1.16 2002/01/20 22:19:56 pet <programlisting> regression=# EXPLAIN SELECT * FROM tenk1; -NOTICE: QUERY PLAN: +INFO: QUERY PLAN: Seq Scan on tenk1 (cost=0.00..333.00 rows=10000 width=148) </programlisting> @@ -120,7 +120,7 @@ SELECT * FROM pg_class WHERE relname = 'tenk1'; <programlisting> regression=# EXPLAIN SELECT * FROM tenk1 WHERE unique1 < 1000; -NOTICE: QUERY PLAN: +INFO: QUERY PLAN: Seq Scan on tenk1 (cost=0.00..358.00 rows=1007 width=148) </programlisting> @@ -145,7 +145,7 @@ Seq Scan on tenk1 (cost=0.00..358.00 rows=1007 width=148) <programlisting> regression=# EXPLAIN SELECT * FROM tenk1 WHERE unique1 < 50; -NOTICE: QUERY PLAN: +INFO: QUERY PLAN: Index Scan using tenk1_unique1 on tenk1 (cost=0.00..181.09 rows=49 width=148) </programlisting> @@ -164,7 +164,7 @@ Index Scan using tenk1_unique1 on tenk1 (cost=0.00..181.09 rows=49 width=148) <programlisting> regression=# EXPLAIN SELECT * FROM tenk1 WHERE unique1 < 50 AND regression-# stringu1 = 'xxx'; -NOTICE: QUERY PLAN: +INFO: QUERY PLAN: Index Scan using tenk1_unique1 on tenk1 (cost=0.00..181.22 rows=1 width=148) </programlisting> @@ -179,7 +179,7 @@ Index Scan using tenk1_unique1 on tenk1 (cost=0.00..181.22 rows=1 width=148) <programlisting> regression=# EXPLAIN SELECT * FROM tenk1 t1, tenk2 t2 WHERE t1.unique1 < 50 regression-# AND t1.unique2 = t2.unique2; -NOTICE: QUERY PLAN: +INFO: QUERY PLAN: Nested Loop (cost=0.00..330.41 rows=49 width=296) -> Index Scan using tenk1_unique1 on tenk1 t1 @@ -227,7 +227,7 @@ regression=# set enable_nestloop = off; SET VARIABLE regression=# EXPLAIN SELECT * FROM tenk1 t1, tenk2 t2 WHERE t1.unique1 < 50 regression-# AND t1.unique2 = t2.unique2; -NOTICE: QUERY PLAN: +INFO: QUERY PLAN: Hash Join (cost=181.22..564.83 rows=49 width=296) -> Seq Scan on tenk2 t2 @@ -260,7 +260,7 @@ Hash Join (cost=181.22..564.83 rows=49 width=296) regression=# EXPLAIN ANALYZE regression-# SELECT * FROM tenk1 t1, tenk2 t2 regression-# WHERE t1.unique1 < 50 AND t1.unique2 = t2.unique2; -NOTICE: QUERY PLAN: +INFO: QUERY PLAN: Nested Loop (cost=0.00..330.41 rows=49 width=296) (actual time=1.31..28.90 rows=50 loops=1) -> Index Scan using tenk1_unique1 on tenk1 t1 |