Vertica monitors active and historical load metrics for load streams on each node. These load metrics are stored in the LOAD_STREAMS system table.
Query load streams table
To monitor the progress of and to view the results of the database load, query the load_streams table as follows:
Select * from load_streams
For additional information on load streams, see the Vertica Enterprise SQL Reference Manual and the Vertica Enterprise SQL Administrator’s Guide.