summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/sysviews.sql
diff options
context:
space:
mode:
authorFujii Masao2020-08-26 01:52:02 +0000
committerFujii Masao2020-08-26 01:52:02 +0000
commitadc8fc6167aa3f68b951ddd60ea32a62b13f18d6 (patch)
treeb4f4f3221f68044794cf62abeac2d6b2fa0c7ff1 /src/test/regress/sql/sysviews.sql
parent50db5964ee333bc148e0c8844ffafaf585c719c6 (diff)
Add regression test for pg_backend_memory_contexts.
Author: Atsushi Torikoshi Reviewed-by: Michael Paquier, Fujii Masao Discussion: https://postgr.es/m/[email protected]
Diffstat (limited to 'src/test/regress/sql/sysviews.sql')
-rw-r--r--src/test/regress/sql/sysviews.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/src/test/regress/sql/sysviews.sql b/src/test/regress/sql/sysviews.sql
index 28e412b7353..ac4a0e1cbba 100644
--- a/src/test/regress/sql/sysviews.sql
+++ b/src/test/regress/sql/sysviews.sql
@@ -12,6 +12,11 @@ select count(*) >= 0 as ok from pg_available_extension_versions;
select count(*) >= 0 as ok from pg_available_extensions;
+-- The entire output of pg_backend_memory_contexts is not stable,
+-- we test only the existance and basic condition of TopMemoryContext.
+select name, ident, parent, level, total_bytes >= free_bytes
+ from pg_backend_memory_contexts where level = 0;
+
-- At introduction, pg_config had 23 entries; it may grow
select count(*) > 20 as ok from pg_config;