SYSTEM_SERVICES

Provides information about background system services that Workload Analyzer monitors.

Provides information about background system services that 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

Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.