GS_WORKLOAD_RULE_STAT
GS_WORKLOAD_RULE_STAT displays information about SQL concurrency control rules. Only the sysadmin user can access the system view.
| 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 rules take effect. If the value is NULL, the concurrency control rules take 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
