postgres.git / summary / log / commit / refs
commit 4f63e85eb149792492a703f01a3a5b89bf5509a7
Author: Andres Freund <andres@anarazel.de>
Date: Tue Mar 13 06:09:58 2018 +0000
First released in: 11.0
Add COSTS off to two EXPLAIN using tests.
Discussion: https://postgr.es/m/20180312222023.i4sgkbl4oqtstus3@alap3.anarazel.de
src/test/regress/expected/subselect.out | 24 ++++++++++++------------
src/test/regress/sql/subselect.sql | 4 ++--
2 files changed, 14 insertions(+), 14 deletions(-)
diff --git a/src/test/regress/expected/subselect.out b/src/test/regress/expected/subselect.out
index 3b2bf3273e8..2904ae43e55 100644
--- a/src/test/regress/expected/subselect.out
+++ b/src/test/regress/expected/subselect.out
@@ -232,23 +232,23 @@ SELECT *, pg_typeof(f1) FROM
(3 rows)
-- ... unless there's context to suggest differently
-explain verbose select '42' union all select '43';
- QUERY PLAN
--------------------------------------------------
- Append (cost=0.00..0.05 rows=2 width=32)
- -> Result (cost=0.00..0.01 rows=1 width=32)
+explain (verbose, costs off) select '42' union all select '43';
+ QUERY PLAN
+----------------------------
+ Append
+ -> Result
Output: '42'::text
- -> Result (cost=0.00..0.01 rows=1 width=32)
+ -> Result
Output: '43'::text
(5 rows)
-explain verbose select '42' union all select 43;
- QUERY PLAN
-------------------------------------------------
- Append (cost=0.00..0.05 rows=2 width=4)
- -> Result (cost=0.00..0.01 rows=1 width=4)
+explain (verbose, costs off) select '42' union all select 43;
+ QUERY PLAN
+--------------------
+ Append
+ -> Result
Output: 42
- -> Result (cost=0.00..0.01 rows=1 width=4)
+ -> Result
Output: 43
(5 rows)
diff --git a/src/test/regress/sql/subselect.sql b/src/test/regress/sql/subselect.sql
index 0100367b8d7..9b7125c111c 100644
--- a/src/test/regress/sql/subselect.sql
+++ b/src/test/regress/sql/subselect.sql
@@ -99,8 +99,8 @@ SELECT *, pg_typeof(f1) FROM
-- ... unless there's context to suggest differently
-explain verbose select '42' union all select '43';
-explain verbose select '42' union all select 43;
+explain (verbose, costs off) select '42' union all select '43';
+explain (verbose, costs off) select '42' union all select 43;
-- check materialization of an initplan reference (bug #14524)
explain (verbose, costs off)
[parent: 0927d2f46ddd]