Vertica Analytics Platform Version 10.1.x Documentation

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.