STORAGE_LOCATIONS

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

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

Column Name Data Type Description
LOCATION_ID INTEGER Catalog-assigned integer value that uniquely identifies thestorage 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 users without their own credentials or dbadmin access. Users gain access to data by being granted access to the user 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.
DISK_PERCENT VARCHAR Maximum percentage of available node disk space that this storage location can use, set only if depot size is defined as a percentage, otherwise blank.

Privileges

Superuser

See also