本页介绍天翼云TeleDB数据库系统视图user_cons_columns的内容。 视图的作用:提供当前用户所拥有的表中与约束相关的列的信息。 名称 类型 定义 constraint_schema name 约束所在的模式(schema)名称。 constraint_name name 约束的名称。 table_schema name 表所在的模式(schema)名称。 table_name name 表的名称。
teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#
teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#
teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#
teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#
teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#
teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#