LOAD_STREAMS

Monitors active and historical load metrics for load streams.

Monitors active and historical load metrics for load streams. This is useful for obtaining statistics about how many records got loaded and rejected from the previous load. Vertica maintains system table metrics until they reach a designated size quota (in kilobytes). This quota is set through internal processes, which you cannot set or view directly.

Column Name Data Type Description
SESSION_ID VARCHAR Identifier of the session for which Vertica captures load stream information. This identifier is unique within the cluster for the current session, but can be reused in a subsequent session.
TRANSACTION_ID INTEGER Identifier for the transaction within a session. If a session is active but no transaction has begun, this is NULL.
STATEMENT_ID INTEGER Unique numeric ID for the currently-running statement. NULL indicates that no statement is currently being processed. The combination of TRANSACTION_ID, STATEMENT_ID uniquely identifies a statement within a session.
STREAM_NAME VARCHAR

Load stream identifier. If the user does not supply a specific name, the STREAM_NAME default value is:
tablename-ID

where tablename is the table into which data is being loaded, and ID is an integer value, guaranteed to be unique with the current session on a node.

This system table includes stream names for every COPY statement that takes more than 1-second to run. The 1-second duration includes the time to plan and execute the statement.

SCHEMA_NAME VARCHAR Schema name for which load stream information is listed. Lets you identify two streams that are targeted at tables with the same name in different schemas
TABLE_ID INTEGER Catalog-assigned numeric value that uniquely identifies the table.
TABLE_NAME VARCHAR Name of the table being loaded.
LOAD_START VARCHAR Linux system time when the load started.
LOAD_DURATION_MS NUMERIC(54,0) Duration of the load stream in milliseconds.
IS_EXECUTING BOOLEAN Indicates whether the load is executing, where t is true and f is false.
ACCEPTED_ROW_COUNT INTEGER Number of rows loaded.
REJECTED_ROW_COUNT INTEGER Number of rows rejected.
READ_BYTES INTEGER Number of bytes read from the input file.
INPUT_FILE_SIZE_BYTES INTEGER

Size of the input file in bytes.

Note: When using STDIN as input, the input file size is zero (0).

PARSE_COMPLETE_PERCENT INTEGER Percent of rows from the input file that have been parsed.
UNSORTED_ROW_COUNT INTEGER

Cumulative number rows not sorted across all projections.

Note: UNSORTED_ROW_COUNT could be greater than ACCEPTED_ROW_COUNT because data is copied and sorted for every projection in the target table.

SORTED_ROW_COUNT INTEGER Cumulative number of rows sorted across all projections.
SORT_COMPLETE_PERCENT INTEGER Percent of rows from the input file that have been sorted.

Privileges

If you have the SYSMONITOR role or are the dbadmin user, this table shows all loads. Otherwise it shows only your loads.