Updated on 2024-05-07 GMT+08:00

GS_WORKLOAD_RULE_STAT

GS_WORKLOAD_RULE_STAT displays information about SQL concurrency control rules. Only the sysadmin user can access the system view.

Table 1 GS_WORKLOAD_RULE_STAT columns

Name

Type

Description

rule_id

bigint

Concurrency control rule ID.

rule_name

name

Name of a concurrency control rule, which is used to search for the concurrency control rule.

databases

name[]

List of databases on which the concurrency control rule takes effect. If the value is NULL, the concurrency control rule takes effect for all databases.

rule_type

text

Concurrency control rule type. Currently, only "sqlid", "select", "insert", "update", "delete", "merge", and "resource" are supported. Other values are invalid.

start_time

timestamp with time zone

Start time of the concurrency control rules. The value NULL indicates that the rules take effect from now on.

end_time

timestamp with time zone

End time of the concurrency control rules. The value NULL indicates that the rules are always effective.

max_workload

bigint

Maximum number of concurrent rule settings.

option_val

text[]

Parameter values of a concurrency control rule, including SQL ID, keyword list, and resource restriction.

For details, see the description of the gs_add_workload_rule API.

is_valid

Boolean

Determines whether the concurrency control rules take effect. If the concurrency control rules time out, the value is set to false.

validate_count

bigint

Number of SQL statements intercepted by the concurrency control rule.

node_names

text[]

List of nodes on which the concurrency control rules take effect. This parameter is reserved and does not take effect currently.

user_names

text[]

List of users for which the concurrency control rules take effect. This parameter is reserved and does not take effect currently.