SYSTEM_SERVICES

Provides information about background system services that the Workload Analyzer monitors.

Column Name Data Type Description
NODE_NAME

VARCHAR

Name of the node that is reporting the requested information.

SERVICE_TYPE

VARCHAR

Type of service; can be one of:

  • SYSTEM
  • TUPLE MOVER
SERVICE_GROUP

VARCHAR

Group name, if there are multiple services of the same type.

SERVICE_NAME

VARCHAR

Name of the service.

SERVICE_INTERVAL_SEC

INTEGER

How often the service is executed (in seconds) during the history interval.

IS_ENABLED

BOOLEAN

Denotes if the service is enabled.

LAST_RUN_START

TIMESTAMPTZ

Denotes when the service was started last time.

LAST_RUN_END

TIMESTAMPTZ

Denotes when the service was completed last time.

Privileges

No explicit privileges are required. You only see the records for tables that you have privileges to view.