Namespace=QCE/POSTGRES
| Parameter | Metric | Description | Unit | Dimension |
|---|---|---|---|---|
| Connections | Connections | Historical trend of active connections to the instance | - | resourceId |
| Cpu | CPU utilization | Instance CPU utilization. Due to the flexible CPU limit policy adopted during idle time, the CPU utilization may be above 100% | % | resourceId |
| HitPercent | Buffer cache hit rate | Data cache hit rate | % | resourceId |
| InFlow | Inbound traffic | Inbound traffic for instance reads/writes | KB/s | resourceId |
| OutFlow | Outbound traffic | Outbound traffic for instance reads/writes | KB/s | resourceId |
| Iops | Disk IOPS | Instance IOPS (number of requests per second) | Requests/sec | resourceId |
| Memory | Memory usage | Available memory space used by the instance | KB | resourceId |
| OtherCalls | Other requests | Total number of requests (such as DROP) other than reads and writes accumulated by the minute | Requests/min | resourceId |
| Qps | Queries per second | Number of queries per second | Queries/sec | resourceId |
| WriteCalls | Write requests | Total number of write requests per minute | Requests/min | resourceId |
| ReadCalls | Read requests | Total number of read requests per minute | Requests/min | resourceId |
| ReadWriteCalls | Read and write requests | Total number of read and write (CRUD) requests per minute | Requests/min | resourceId |
| RemainXid | Remaining XIDs | Number of remaining transaction IDs. Maximum number: 2^32. If this value is below 1000000, we recommend you manually run `vacuum full` | - | resourceId |
| SqlRuntimeAvg | Average execution latency | Average execution time of all SQL requests, excluding SQL requests in transactions | Ms | resourceId |
| SqlRuntimeMax | Top 10 longest execution latency | Average execution time of the top 10 most time-consuming SQL requests | Ms | resourceId |
| SqlRuntimeMin | Top 10 shortest execution latency | Average execution time of the top 10 least time-consuming SQL requests | Ms | resourceId |
| Storage | Used storage space | Storage capacity used by the instance | GB | resourceId |
| XlogDiff | Primary/Secondary xlog sync delay | Primary/Secondary xlog sync delay sampled once per minute. The smaller, the better | Byte | resourceId |
| SlowQueryCnt | Slow queries | Number of queries that take more than the specified time (1s by default) to be executed | - | resourceId |
| StorageRate | Storage space utilization | Storage space utilization of the instance | % | resourceId |
Note：
The statistical granularity (
period) may vary by metric. The DescribeBaseMetrics API can be used to get theperiodvalues supported by each metric.
| Parameter | Dimension | Dimension Description | Format |
|---|---|---|---|
| Instances.N.Dimensions.0.Name | resourceId | resourceId dimension name |
Enter a String-type dimension name: resourceId |
| Instances.N.Dimensions.0.Value | resourceId | Specific instance resourceId |
Enter a specific instance resourceId, such as postgres-123456 |
To query the monitoring data of a TencentDB for PostgreSQL instance, use the following input parameters:
&Namespace=QCE/POSTGRES
&Instances.N.Dimensions.0.Name=resourceId
&Instances.N.Dimensions.0.Value=resourceId
Was this page helpful?