Updated on 2023-12-29 GMT+08:00

GS_WLM_SESSION_INFO

GS_WLM_SESSION_INFO records load management information about a completed job executed on all CNs. The data is dumped from the kernel to a system catalog. If the GUC parameter enable_resource_record is set to on, the system imports records in GS_WLM_SESSION_HISTORY to this system catalog every three minutes. You are not advised to enable this function because it occupies storage space and affects performance. For details about the columns, see Table 1.

  • This system catalog's schema is dbms_om.
  • The pg_catalog has the GS_WLM_SESSION_INFO view.