TencentDB for PostgreSQL

Last updated: 2021-04-09 11:06:17

    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
    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 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?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help