Call the ModifySQLConcurrencyControlRule API to modify SQL throttling rules.

Request type

Asynchronous request.

Precautions

Only PostgreSQL 14 to PostgreSQL 17 instances created on or after October 15, 2026 support modifying SQL throttling rules.

Debug

API Explorer

You can initiate calls online through API Explorer without paying attention to the signature generation process and quickly obtain the call results.

Request parameters

Parameter	Type	Required?	Example	Description
InstanceId	String	Yes	postgres-5d27abexxxx	Instance ID. tip You can call the DescribeDBInstances API to query the instance ID.
DatabaseName	String	Yes	pg_demo	Target database name.
RuleId	Long	Yes	136734987028564xxxx	Rule ID of the SQL throttling rule.
Limit	Object of RuleConfig	Yes	Refer to the request example.	New throttling configuration.

RuleConfig

Parameter	Type	Required?	Example	Description
Type	String	Yes	qps	The type of SQL throttling rule. Values: concurrency: Concurrency throttling. qps: QPS throttling.
QPS	Integer	No	100	The number of requests allowed per second. Value range: 0 ~ 100000. tip This parameter is required only when the Type parameter is qps. When RuleMatch.Type is set to all, the value of this parameter must be greater than 1.
Burst	Integer	No	200	Token Bucket capacity. Value range: 1 ~ 100000. tip This parameter is required only when the Type parameter is qps.
MaxWaitMs	Integer	No	1000	Maximum waiting time. The default value is 0, which means no waiting time limit. Unit: millisecond. Value range: 0 ~ 864000000. tip This parameter is required only when the Type parameter is concurrency.
MaxWaiting	Integer	No	20	Maximum pending queue count. Value range: 0 ~ 100000. tip This parameter is required only when the Type parameter is concurrency.
MaxConcurrency	Integer	No	10	Maximum concurrency. Value range: 0 ~ 100000. tip This parameter is required only when the Type parameter is concurrency. When RuleMatch.Type is set to all, the value of this parameter must be greater than 1.

Response parameters

Parameter	Type	Example	Description
Code	Integer	0	Return status code. 0 means succeeded.
Message	String	success	Return information.

Sample

Sample request

Sample response