Viewing Storage Locations and Policies
You can monitor information about available storage location labels and your current storage policies.
Viewing Disk Storage Information
Query the V_MONITOR.DISK_STORAGE system table for disk storage information on each database node. For more information, see Using System Tables and Altering Location Use. The V_MONITOR.DISK_STORAGE
system table includes a CATALOG annotation, indicating that the location is used to store catalog files.
You cannot add or remove a catalog storage location. Vertica creates and manages this storage location internally, and the area exists in the same location on each cluster node.
Viewing Location Labels
Three system tables have information about storage location labels in their location_labels
columns:
storage_containers
storage_locations
partitions
Use a query such as the following for relevant columns of the storage_containers
system table:
VMART=> select node_name,projection_name, location_label from v_monitor.storage_containers; node_name | projection_name | location_label ------------------+----------------------+----------------- v_vmart_node0001 | states_p | v_vmart_node0001 | states_p | v_vmart_node0001 | t1_b1 | v_vmart_node0001 | newstates_b0 | FAST3 v_vmart_node0001 | newstates_b0 | FAST3 v_vmart_node0001 | newstates_b1 | FAST3 v_vmart_node0001 | newstates_b1 | FAST3 v_vmart_node0001 | newstates_b1 | FAST3 . . .
Use a query such as the following for columns of the v_catalog.storage_locations
system_table:
VMart=> select node_name, location_path, location_usage, location_label from storage_locations; node_name | location_path | location_usage | location_label ------------------+-------------------------------------------+----------------+---------------- v_vmart_node0001 | /home/dbadmin/VMart/v_vmart_node0001_data | DATA,TEMP | v_vmart_node0001 | home/dbadmin/SSD/schemas | DATA | v_vmart_node0001 | /home/dbadmin/SSD/tables | DATA | SSD v_vmart_node0001 | /home/dbadmin/SSD/schemas | DATA | Schema v_vmart_node0002 | /home/dbadmin/VMart/v_vmart_node0002_data | DATA,TEMP | v_vmart_node0002 | /home/dbadmin/SSD/tables | DATA | v_vmart_node0002 | /home/dbadmin/SSD/schemas | DATA | v_vmart_node0003 | /home/dbadmin/VMart/v_vmart_node0003_data | DATA,TEMP | v_vmart_node0003 | /home/dbadmin/SSD/tables | DATA | v_vmart_node0003 | /home/dbadmin/SSD/schemas | DATA | (10 rows)
Use a query such as the following for columns of the v_monitor.partitions
system table:
VMART=> select partition_key, projection_name, location_label from v_monitor.partitions; partition_key | projection_name | location_label ---------------+----------------------+--------------- NH | states_b0 | FAST3 MA | states_b0 | FAST3 VT | states_b1 | FAST3 ME | states_b1 | FAST3 CT | states_b1 | FAST3 . . .
Viewing Storage Tiers
Query the storage_tiers
system table to see both the labeled and unlabeled storage containers and information about them:
VMart=> select * from v_monitor.storage_tiers; location_label | node_count | location_count | ros_container_count | total_occupied_size ----------------+------------+----------------+---------------------+--------------------- | 1 | 2 | 17 | 297039391 SSD | 1 | 1 | 9 | 1506 Schema | 1 | 1 | 0 | 0 (3 rows)
Viewing Storage Policies
Query the storage_policies
system table to view the current storage policy in place.
VMART=> select * from v_monitor.storage_policies; schema_name | object_name | policy_details | location_label -------------+-------------+------------------+----------------- | public | Schema | F4 public | lineorder | Partition [4, 4] | M3 (2 rows)