Book Contents

Book Index

Next Topic

Home

VT_LOAD_STREAMS

VT_LOAD_STREAMS monitors load metrics for each load stream on each node.

Column Name

Description

TIMESTAMP

a VARCHAR value containing the Linux system time of query execution in a format that can be used as a Date/Time Expression.

NODE

a VARCHAR value containing the name of the node that is reporting the requested information.

STREAM

a VARCHAR value containing the name of the file being loaded or (if using the standard input) the name STDIN.

LOAD_START_TIMESTAMP

a VARCHAR value containing the Linux system time when the load started

ROWS_LOADED

an INTEGER value containing the number of rows loaded

ROWS_REJECTED

an INTEGER value containing the number of rows rejected

BYTES_READ

an INTEGER value containing the number of bytes read from the input file

INPUT_FILE_SIZE

an INTEGER value containing the size of the input file in bytes

When using STDIN as input size of input file size is zero (0).

PERCENT_COMPLETE

an INTEGER value containing the percent of the rows in the input file that have been loaded. If using STDIN, this column remains at zero (0) until the COPY statement is complete.

Example

=> \pset expanded