Updated on 2024-09-02 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 from 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.
  • This system catalog has a distribution column, the gaussdb column, in PostgreSQL databases only, not other databases.
  • The pg_catalog has the GS_WLM_SESSION_INFO view.