Below is a command to check Vertica cluster status via admintools.
admintools -t view_cluster
Cheers!
No comments
Month: March 2019
Vertica – Check System Resources
VERTICA – View the Number of ROS Containers Per Projection Per Mode
Below is the command to view the number of ROS containers per projection per node. A high number (over 500) of ROS containers indicates a problem with the PARTITION BY clauses of your tables. It can also indicate that the merging process is not functioning.
For more information, see Vertica Partitions: The FAQs in the Vertica Knowledge Base.
SELECT node_name, projection_schema, projection_name, SUM(ros_count) AS ros_count FROM v_monitor.projection_storage GROUP BY node_name, projection_schema, projection_name ORDER BY ros_count DESC;
