PrevNext
search by keyword

Recent Pages

Documentation
Basic Cloud Monitor
    Documentation
    Download PDF

    TencentDB for PostgreSQL Monitoring Metrics

    Last updated: 2021-08-23 14:33:02
    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
      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

      tencent
      Copyright © 2013-2022 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy