DEPOT_FETCHES

Records data of depot fetch requests.

Eon Mode only

Records data of depot fetch requests.

Note

Vertica reports all fetches to this table, including failed fetch attempts and their causes.

Column Name	Data Type	Description
START_TIME	TIMESTAMP	Demarcate the start and end of each depot fetch operation.
END_TIME	TIMESTAMP	Demarcate the start and end of each depot fetch operation.
NODE_NAME	VARCHAR	Identifies the node that initiated fetch request.
TRANSACTION_ID	INTEGER	Uniquely identifies the transaction of the query that required the fetched file.
STORAGE_ID	VARCHAR	Unique hexadecimal numeric ID assigned by the Vertica catalog, to identify the storage.
STORAGE_OID	INTEGER	Numeric ID assigned by the Vertica catalog, which identifies the storage.
FILE_SIZE_BYTES	INTEGER	Fetch size in bytes.
SOURCE_FILE	VARCHAR	Source file path used, set to null if the file was fetched from a peer.
DESTINATION_FILE	VARCHAR	Destination file path
SOURCE_NODE	VARCHAR	Source node from which the file was fetched, set to one of the following: Name of the source node if file was fetched from a peer Null if file was fetched from communal storage
IS_SUCCESSFUL	BOOLEAN	Boolean, specifies whether this fetch succeeded.
REASON	VARCHAR	Reason why the fetch failed, null if IS_SUCCESSFUL is true.

Examples

=> \x
Expanded display is on.

=> SELECT * FROM DEPOT_FETCHES LIMIT 2;
-[ RECORD 1 ]----+-------------------------------------------------------------
start_time       | 2019-08-30 15:16:15.125962+00
end_time         | 2019-08-30 15:16:15.126791+00
node_name        | v_verticadb_node0001
transaction_id   | 45035996273706225
storage_id       | 0239ef74126e70db410b301610f1e5b500b0000000020d65
storage_oid      | 45035996273842065
file_size_bytes  | 53033
source_file      |
destination_file | /vertica/data/verticadb/v_verticadb_node0001_depot/957/0239e
                     f74126e70db410b301610f1e5b500b0000000020d65_0.gt
source_node      | v_verticadb_node0002
is_successful    | t
reason           |
-[ RECORD 2 ]----+-------------------------------------------------------------
start_time       | 2019-08-30 15:16:15.285208+00
end_time         | 2019-08-30 15:16:15.285949+00
node_name        | v_verticadb_node0001
transaction_id   | 45035996273706234
storage_id       | 0239ef74126e70db410b301610f1e5b500b0000000020dc7
storage_oid      | 45035996273842075
file_size_bytes  | 69640
source_file      |
destination_file | /vertica/data/verticadb/v_verticadb_node0001_depot/055/0239e
                     f74126e70db410b301610f1e5b500b0000000020dc7_0.gt
source_node      | v_verticadb_node0002
is_successful    | t
reason           |

=> select node_name,transaction_id,storage_id,is_successful,reason FROM
   depot_fetches WHERE is_successful = 'f' LIMIT 3;
-[ RECORD 1 ]--+-------------------------------------------------
node_name      | v_verticadb_node0001
transaction_id | 45035996273721070
storage_id     | 0289281ac4c1f6580b95096fab25290800b0000000027d09
is_successful  | f
reason         | Could not create space in the depot
-[ RECORD 2 ]--+-------------------------------------------------
node_name      | v_verticadb_node0001
transaction_id | 45035996273721070
storage_id     | 0289281ac4c1f6580b95096fab25290800b0000000027d15
is_successful  | f
reason         | Could not create space in the depot
-[ RECORD 3 ]--+-------------------------------------------------
node_name      | v_verticadb_node0002
transaction_id | 45035996273721070
storage_id     | 02693f1c68266e38461084a840ee42aa00c0000000027d09
is_successful  | f
reason         | Could not create space in the depot