tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Tencent Cloud Observability Platform
    Documentation
    Download PDF

    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
      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
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy