数据库与MPP数仓(二十五)：Vertica的优化/运维高频使用语句

Vertica的优化/运维高频使用语句，包括系统级别，表级别，ROS和WOS，以及锁优化等；

-----------------------------------------------------------------查看系统参数
SELECT
node_name,
parameter_name,
current_value,
default_value
FROM configuration_parameters
WHERE current_value <> default_value order by 2, 1;
----------------------------------------------------------------- 系统表相关
 
select * from system;
 
select * from resource_pools where name='tm';
 
select projection_name,count(distinct partition_key) from partitions group by projection_name having count(distinct partition_key) >50 order by projection_name;
 
select node_name,projection_name,sum(ros_count) as ros_count from projection_storage group by node_name,projection_name having sum(ros_count)>100 order by ros_count desc;
 
select table_schema,table_name,column_name,data_type,is_nullable from columns where table_name='locks';
 
select * from elastic_cluster;
 
select * fr