DEPOT_SIZES

Reports depot caching capacity on Vertica nodes.

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.

Examples

=> \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