diff options
| author | Andres Freund <andres@anarazel.de> | 2018-03-12 23:09:58 -0700 |
|---|---|---|
| committer | Andres Freund <andres@anarazel.de> | 2018-03-13 16:12:31 -0700 |
| commit | 4f63e85eb149792492a703f01a3a5b89bf5509a7 (patch) | |
| tree | b7cb02d291f2f992e473d8b83d69c1921412ce2a | |
| parent | 0927d2f46ddd4cf7d6bf2cc84b3be923e0aedc52 (diff) | |
| download | postgresql-4f63e85eb149792492a703f01a3a5b89bf5509a7.tar.gz postgresql-4f63e85eb149792492a703f01a3a5b89bf5509a7.zip | |
Add COSTS off to two EXPLAIN using tests.
Discussion: https://postgr.es/m/20180312222023.i4sgkbl4oqtstus3@alap3.anarazel.de
| -rw-r--r-- | src/test/regress/expected/subselect.out | 24 | ||||
| -rw-r--r-- | 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) |