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 |
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