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.