GS_WORKLOAD_RULE

The GS_WORKLOAD_RULE system catalog records information about SQL concurrency control rules. There is no permission restriction on this system catalog. All users can query this system catalog.

**Table 1** GS_WORKLOAD_RULE columns
Name	Type	Description
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(rule_type, rule_name, databases, start_time, end_time, max_workload, option_val) 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.