GS_WLM_SESSION_INFO

GS_WLM_SESSION_INFO displays load management information about a completed job executed by the current CN. (The current feature is a lab feature. Contact Huawei engineers for technical support before using it.) Only the user with sysadmin permission can query this view.

Data is dumped from the kernel to this system catalog. If enable_resource_record is set to on, the system imports the query information from the kernel to GS_WLM_SESSION_QUERY_INFO_ALL every 3 minutes. This operation occupies storage space and affects performance. You can query the GS_WLM_SESSION_INFO to view the top SQL statements that have been dumped. For details about the columns, see Table 1.