tencent cloud

All product documents
Tencent Cloud Observability Platform
DocumentationTencent Cloud Observability PlatformCloud Product MonitoringTencent Cloud Service Metrics TencentDBTencentDB for PostgreSQL Monitoring Metrics
TencentDB for PostgreSQL Monitoring Metrics
Download PDF
Last updated: 2024-01-27 17:44:47
TencentDB for PostgreSQL Monitoring Metrics
Last updated: 2024-01-27 17:44:47
Download PDF

Namespace

Namespace=QCE/POSTGRES

Monitoring Metrics

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
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 the period values supported by each metric.

Overview of Parameters in Each Dimension

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

Input Parameter Description

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?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon