STORAGE_LOCATIONS
Provides information about storage locations, their IDs labels, and status.
Column Name | Data Type | Description |
---|---|---|
LOCATION_ID |
INTEGER |
A unique numeric ID assigned by the Vertica catalog, which identifies the storage location. |
NODE_NAME |
VARCHAR |
The node name on which the storage location exists. |
LOCATION_PATH |
VARCHAR |
The path where the storage location is mounted. |
LOCATION_USAGE |
VARCHAR |
The type of information stored in the location:
|
IS_RETIRED |
BOOLEAN |
Whether the storage location has been retired. This column has a value of |
LOCATION_LABEL |
VARCHAR |
The label associated with a specific storage location, added with the ALTER_LOCATION_LABEL function. |
RANK |
INTEGER |
The Access Rank value either assigned or supplied to the storage location, as described in Prioritizing Column Access Speed. |
THROUGHPUT |
INTEGER |
The throughput performance of the storage location, measured in MB/sec. You can get location performance values using MEASURE_LOCATION_PERFORMANCE, and set them with the SET_LOCATION_PERFORMANCE function. |
LATENCY |
INTEGER |
The measured latency of the storage location as number of data seeks per second. You can get location performance values using MEASURE_LOCATION_PERFORMANCE, and set them with the SET_LOCATION_PERFORMANCE function. |
Privileges
Must be a superuser.