DEPOT_SIZES

Eon Mode only

Reports depot caching capacity on Vertica nodes.

Column Name Data Type Description
NODE_NAME VARCHAR The name of the node containing the depot.
LOCATION_OID INTEGER

Catalog-assigned integer value that uniquely identifies the storage location storing the depot.
LOCATION_PATH VARCHAR The path where the depot is stored.
LOCATION_LABEL VARCHAR The label associated with the depot's storage location.
MAX_SIZE_BYTES INTEGER The maximum size the depot can contain, in bytes.
CURRENT_USAGE_BYTES INTEGER The current size of the depot, in bytes.

Example

=> \x 
Expanded display is on. 
=> SELECT * FROM Depot_Sizes; 

-[ RECORD 1 ]-------+--------------------------------------------------- 

node_name           | v_verticadb_node0003 
location_oid        | 45035996273823200 
location_path       | /vertica/data/verticadb/v_verticadb_node0003_depot 
location_label      | auto-data-depot 
max_size_bytes      | 0 
current_usage_bytes | 0 

-[ RECORD 2 ]-------+--------------------------------------------------- 
node_name           | v_verticadb_node0001 
location_oid        | 45035996273823196 
location_path       | /vertica/data/verticadb/v_verticadb_node0001_depot 
location_label      | auto-data-depot 
max_size_bytes      | 33686316032 
current_usage_bytes | 206801871 

-[ RECORD 3 ]-------+--------------------------------------------------- 
node_name           | v_verticadb_node0002 
location_oid        | 45035996273823198 
location_path       | /vertica/data/verticadb/v_verticadb_node0002_depot 
location_label      | auto-data-depot 
max_size_bytes      | 0 
current_usage_bytes | 0