query to check rebalancing status
Moderator: NorbertKrupa
query to check rebalancing status
How o I check if rebalancing is going on the vertica cluster?? or which table rebalancing is going on??
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: query to check rebalancing status
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)
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.