query to check rebalancing status

[Jess.mic]

How o I check if rebalancing is going on the vertica cluster?? or which table rebalancing is going on??

[JimKnicely]

Perhaps these system tables contain the information you seek

Code: Select all

dbadmin=> select * from system_tables where table_name ilike '%rebalance%';
 table_schema_id | table_schema | table_id |         table_name          |              table_description               
-----------------+--------------+----------+-----------------------------+----------------------------------------------
            8302 | v_monitor    |    10132 | rebalance_projection_status | Rebalance progress for relevant projections.
            8302 | v_monitor    |    10192 | rebalance_table_status      | Rebalance progress for relevant tables.
(2 rows)