DEPOT_FILES
Lists objects that are currently cached in the database depots.
Eon Mode only
Lists objects that are currently cached in the database depots.
| Column Name | Data Type | Description |
|---|---|---|
| NODE_NAME | VARCHAR | Name of the depot node. |
| SAL_STORAGE_ID | VARCHAR | Unique hexadecimal numeric ID assigned by the Vertica catalog, which identifies the storage. |
| STORAGE_OID | INTEGER | Numeric ID assigned by the Vertica catalog, which identifies the storage. |
| COMMUNAL_FILE_PATH | VARCHAR | Communal storage path to the file. On AWS, this is an S3 URI. |
| DEPOT_FILE_PATH | VARCHAR | Depot path to the file. |
| SHARD_NAME | VARCHAR | Name of the shard this file is a part of. |
| STORAGE_TYPE | VARCHAR | Type of system storing this file. |
| NUMBER_OF_ACCESSES | INTEGER | Number of times this file has been accessed. |
| FILE_SIZE_BYTES | INTEGER | How large the file is in bytes. |
| LAST_ACCESS_TIME | TIMESTAMPTZ | When the file was last accessed. |
| ARRIVAL_TIME | TIMESTAMPTZ | When OpenText™ Analytics Database loaded the file into the depot. |
| SOURCE | VARCHAR |
How the data came to be cached, one of the following:
|
| IS_PINNED | BOOLEAN | Whether a pinning policy is set on the cached data. |
| IS_ANTI_PINNED | BOOLEAN | Whether an anti-pinning policy is set on the cached data. |
Examples
=> \x
Expanded display is on.
=> SELECT * FROM depot_files LIMIT 2;
-[ RECORD 1 ]------+---------------------------------------------------------------
node_name | v_verticadb_node0001
sal_storage_id | 0275d4a7c99795d22948605e5940758900a000000001d1b1
storage_oid | 45035996273842075
communal_file_path | s3://mybucket/myfolder/mydb/475/0275d4a7c99795d22948605e5940758900a000000001d1
b1/0275d4a7c99795d22948605e5940758900a000000001d1b1_
depot_file_path | /vertica/data/verticadb/v_verticadb_node0001_depot/177/0275d4a7c99795d229486
05e5940758900a000000001d1b1/0275d4a7c99795d22948605e
shard_name | replica
storage_type | DFS
number_of_accesses | 0
file_size_bytes | 456465645
last_access_time | 2018-09-05 17:34:30.417274+00
arrival_time | 2018-09-05 17:34:30.417274+00
source | DEPOT FILL AT STARTUP
is_pinned | f
-[ RECORD 2 ]------+---------------------------------------------------------------
node_name | v_verticadb_node0001
sal_storage_id | 0275d4a7c99795d22948605e5940758900a000000001d187
storage_oid | 45035996273842079
communal_file_path | s3://mybucket/myfolder/mydb/664/0275d4a7c99795d22948605e5940758900a000000001d1
87/0275d4a7c99795d22948605e5940758900a000000001d187_
depot_file_path | /vertica/data/verticadb/v_verticadb_node0001_depot/135/0275d4a7c99795d229486
05e5940758900a000000001d187/0275d4a7c99795d22948605e
shard_name | replica
storage_type | DFS
number_of_accesses | 0
file_size_bytes | 40
last_access_time | 2018-09-05 17:34:30.417244+00
arrival_time | 2018-09-05 17:34:30.417244+00
source | DEPOT FILL AT STARTUP
is_pinned | f