Product Documentation

Appearance

sys.unload ​

This system view captures information about active unload (ybunload) operations.

This view has the same columns as sys.log_unload, except for the last_activity_time column, which replaces the end_time column. The last_activity_time column returns a timestamp that shows when unload activity was last reported.

For example:

premdb=# select * from sys.unload;
...
-[ RECORD 2 ]---------+-----------------------------------------------------------------
session_key           | Atd2C9bb37QtHfKGgvM4M84OoWsnuyzZOcrOYfA_NZ1-6Md6QHlKZnSgaLxlq0To
state                 | DONE
error_string          | [NULL]
database_id           | 16423
user_id               | 16434
session_id            | 16790
database_name         | premdb
user_name             | bobr
client_hostname       | localhost
client_username       | yb100
start_time            | 2018-05-02 17:35:36-07
last_activity_time    | 2018-05-02 17:35:47-07
elapsed_ms            | 10453
sql_query             | select * from "newmatchstats"
sent_rows             | 25990128
sent_bytes            | 659797740
sent_rows_per_second  | 2362738.90909091
sent_bytes_per_second | 59981612.7272727

Parent topic:System Views