Updated on 2023-10-23 GMT+08:00

GS_WLM_OPERATOR_HISTORY

GS_WLM_OPERATOR_HISTORY displays records of operators in jobs that have been executed by the current user on the current CN. Only the user with sysadmin permission can query this view.

Data in the kernel is cleared every 3 minutes. If the GUC parameter enable_resource_record is set to on, the records in the view are dumped to the GS_WLM_OPERATOR_INFO system catalog every 3 minutes and deleted from the view. If enable_resource_record is set to off, the records are retained in the view for 3 minutes and then deleted. The recorded data is the same as that described in Table 1.