调用 DescribeDBInstanceParameters 接口查询实例的参数配置。
同步请求。
参数 | 类型 | 是否必选 | 示例值 | 描述 |
|---|---|---|---|---|
InstanceId | String | 是 | postgres-21a3333b**** | 实例 ID。 |
ParameterName | String | 否 | auto_explain.log_analyze | 参数名称,支持模糊查询。 说明 不传值或传空值时,会查询指定实例下的所有参数。 |
参数 | 类型 | 示例值 | 描述 |
|---|---|---|---|
InstanceId | String | postgres-21a3333b**** | 实例 ID。 |
DBEngineVersion | String | PostgreSQL_12 | 兼容版本。取值:
|
ParameterCount | String | 56 | 参数个数。 |
Parameters | Object[] | 请参见返回示例。 | 实例当前的参数配置(内核参数)。 |
NoneKernelParameters | Object[] | 请参见返回示例。 | 实例当前的参数配置(非内核参数)。 |
POST /?Action=DescribeDBInstanceParameters&Version=2022-01-01 HTTP/1.1 Content-Type: application/json Host: rds-postgresql.cn-beijing.volcengineapi.com X-Date: 20231002T101010Z Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20211202/cn-beijing/rds_postgresql/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c6458**** { "InstanceId": "postgres-ca7b7019****" }
{ "ResponseMetadata": { "RequestId": "20230804115231D0A40DAC141F3F09F3A9", "Action": "DescribeDBInstanceParameters", "Version": "2022-01-01", "Service": "rds_postgresql", "Region": "cn-beijing" }, "Result": { "DBEngineVersion": "PostgreSQL_12", "InstanceId": "postgres-ca7b7019****", "NoneKernelParameters": [ { "CheckingCode": "[60-3600]", "DefaultValue": "60", "Description": "For counting slow queries, you can customize the specified time range, with the unit being seconds (s). The default value is 60 seconds, which means it counts the number of slow queries in the last 60 seconds.", "DescriptionZH": "对于慢查询的计数,可以自定义指定时间范围,单位为s。默认值为60s,表示统计近60s内的慢查询数量,最大值为3600s。", "ForceRestart": false, "Name": "slow_query_custom_count_range", "Type": "integer", "Value": "60" } ], "ParameterCount": "40", "Parameters": [ { "CheckingCode": "[on|off]", "DefaultValue": "off", "Description": "Use EXPLAIN ANALYZE for plan logging.", "DescriptionZH": "启用 EXPLAIN ANALYZE 输出的采样。", "ForceRestart": false, "Name": "auto_explain.log_analyze", "Type": "bool", "Value": "off" }, ……, { "CheckingCode": "[replica|logical]", "DefaultValue": "replica", "Description": "Set the level of information written to the WAL.", "DescriptionZH": "设置写入 WAL 的信息级别。", "ForceRestart": true, "Name": "wal_level", "Type": "enum", "Value": "replica" } ] } }