STORAGE_LOCATIONS

Provides information about storage locations, their IDs labels, and status.

Column Name Data Type Description
LOCATION_ID

INTEGER

Catalog-assigned integer value that uniquely 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:

  • DATA: Only data is stored in the location.
  • TEMP: Only temporary files that are created during loads or queries are stored in the location.
  • DATA,TEMP: Both types of files are stored in the location.
  • USER: The storage location can be used by non-dbadmin users, who are granted access to the storage location
  • CATALOG: The area is used for the Vertica catalog. This usage is set internally and cannot be removed or changed.
SHARING_TYPE
VARCHAR

How this location is shared among database nodes, if it is:

  • SHARED: The path used by the storage location is used by all nodes.  See the SHARED parameter to CREATE LOCATION.
  • COMMUNAL: the location is used for communal storage in Eon Mode.
  • NONE: The location is not shared among nodes.
IS_RETIRED

BOOLEAN

Whether the storage location has been retired. This column has a value of t (true) if the location is retired, or f (false) if it is not.

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.

MAX_SIZE INTEGER Maximum size of the storage location in bytes.

Privileges

Must be a superuser.

Example

=> SELECT * FROM STORAGE_LOCATIONS;
-[ RECORD 1 ]--+------------------------------------------
location_id | 45035996273704984
node_name | v_vmart_node0001
location_path | /home/dbadmin/VMart/v_vmart_node0001_data
location_usage | DATA,TEMP
sharing_type | NONE
is_retired | f
location_label |
rank | 0
throughput | 0
latency | 0
max_size | 20G -[ RECORD 2 ]--+------------------------------------------
location_id | 45035996273705108
node_name | v_vmart_node0002
location_path | /home/dbadmin/VMart/v_vmart_node0002_data
location_usage | DATA,TEMP
sharing_type | NONE
is_retired | f
location_label |
rank | 0
throughput | 0
latency | 0
max_size | 10G ...