Load status information

You can query the _v_load_status system view to display information about active load operations on your NPS system.

The view shows information such as the table name, database name, data file, number of processed rows, and number of rejected rows. A sample view query follows. The output was reformatted to fit the page width.

SYSTEM.ADMIN(ADMIN)=> select * from _v_load_status;
 PLANID | DATABASENAME | TABLENAME | SCHEMANAME | USERNAME | BYTESPROCESSED | ROWSINSERTED | 
--------+--------------+-----------+------------+----------+----------------+--------------+
ROWSREJECTED | BYTESDOWNLOADED
-------------+-----------------
   2932 | SYSTEM       | LINEITEM  | ADMIN      | ADMIN    |      142606226 |      1136931 |
           4 |       131911476
(1 row)

The nzlog load log file contains two fields, Rows/Second and Bytes/Second, that provide more performance-related details about the load operation.