GS_WORKLOAD_RULE

rule_id

bigint

Concurrency control rule ID, which is automatically generated by the system.

rule_name

name

Name of the concurrency control rule, which is used for search. The name may not be unique and can be NULL.

databases

name[]

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

max_workload

bigint

Maximum number of concurrent rule settings.

is_valid

boolean

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

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.

rule_type

text

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

option_val

text[]

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

For details, see the description of the gs_add_workload_rule API.

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.