tencent cloud

All product documents
TencentDB for PostgreSQL
DocumentationTencentDB for PostgreSQLOperation GuideMonitoring and AlarmsMonitoring Feature
Monitoring Feature
Download PDF
Last updated: 2024-01-24 11:20:59
Monitoring Feature
Last updated: 2024-01-24 11:20:59
Download PDF

Monitoring in Console

To make it easier for you to view and stay up to date with how instances work, TencentDB for PostgreSQL provides a wide variety of performance monitoring metrics. You can log in to the TencentDB for PostgreSQL console and view them on the System Monitoring tab on the corresponding instance management page.

Monitoring metrics

Metric Name
Metric
Unit
Description
CPU Utilization
cpu
%
Actual CPU utilization
Used Storage Space
storage
GB
Used instance space
Data File Size
data_file_size
GB
Size of data files
WAL File Size
log_file_size
GB
Size of WAL log files
Temp File Size
temp_file_size
MB
Size of temporary files
Storage Space Utilization
storage_rate
%
Total storage space utilization, which includes temporary, data, and log files, as well as other types of database files
Queries per Second
qps
Counts/sec
Average number of executed SQL statements per second
Connection Count
connections
-
Total number of current connections when metric collection is initiated on the database
Connections Created in the Last 5 Sec
new_conn_in5s
-
Total number of connections established in the past five seconds when metric collection is initiated on the database
Active Connections
active_conns
-
Number of currently active (non-idle) connections when metric collection is initiated on the database
Idle Connections
idle_conns
-
Number of idle connections when metric collection is initiated on the database
Waiting Sessions
waiting
-
Number of sessions in waiting status when metric collection is initiated on the database
Sessions Waiting for More Than 5 Sec
long_waiting
-
Number of sessions that stay in waiting status for over five seconds in a collection period
Idle Transactions
idle_in_xact
-
Number of idle transactions when metric collection is initiated on the database
Transactions Executed for More Than 1 Sec
long_xact
-
Number of transactions with an execution duration longer than one second in a collection period
Transactions Idle for More Than 5 Sec
long_idle_in_xact
-
Number of transactions that remain idle for over five seconds during a collection period
Transactions per Second
tps
Counts/sec
Average number of successfully executed transactions (including rollbacks and commits) per second
Transactions Committed /sec
xact_commit
Counts/sec
Average number of committed transactions per second
Transactions Rolled Back /sec
xact_rollback
Counts/sec
Average number of rolled back transactions per second
Request Count
read_write_calls
-
Total number of requests in a statistical period
Read Request Count
read_calls
-
Number of read requests in a statistical period
Write Request Count
write_calls
-
Number of write requests in a statistical period
Other Request Count
other_calls
-
Number of other requests (BEGIN, CREATE, Non-DML, DDL, and DQL operations) in a statistical period
Buffer Cache Hit Rate
hit_percent
%
Hit rate of execution of all SQL statements in a request period
Average Execution Latency
sql_runtime_avg
ms
Average execution latency of all SQL statements in a statistical period
Average of Top 10 Longest SQL Execution Time
sql_runtime_max
ms
Average execution latency of the top ten SQL statements with the longest latency in a statistical period
Average of Top 10 Shortest SQL Execution Time
sql_runtime_min
ms
Average execution latency of the top ten SQL statements with the shortest latency in a statistical period
Remaining XID Count
remain_xid
-
Number of remaining XIDs of the database with the fewest remaining XIDs when metric collection is initiated on the database. This metric is unavailable for read-only instances
Differences Between sent_lsn and replay_lsn
xlog_diff
Byte
Difference between the size of the log sent from the primary node to the standby node and the log replayed on the standby node, which mainly reflects the log application speed of the standby node as well as its performance and network transfer speed. This metric is unavailable for read-only instances
WAL Flush Lag
xlog_diff_time
s
Time difference between the time point when the log is sent from the primary node to the standby node and the time point when the standby node receives the log and flushes it. This metric is unavailable for read-only instances and instances earlier than v10.x
Primary-Standby Sync Delay
slave_apply_delay
s
Primary-Standby sync delay. For primary instances, this metric can reflect the RTO of failover. For read-only instances, it indicates the time after which the data written to primary instances can be queried on the read-only instances. The metric for read-only instances has the same name
Slow Query Count
slow_query_cnt
-
Number of slow queries in a collection period
SQLs Executed for More Than 1 Sec
long_query
-
Number of SQL statements with execution time over one second when metric collection is initiated on the database
2PC Transactions
2pc
-
Number of current 2PC transactions when metric collection is initiated on the database
2PC Transactions Uncommitted for More Than 5 Sec
long_2pc
-
Number of current transactions with execution time over five seconds when metric collection is initiated on the database
Rows Deleted /sec
tup_deleted
-
Average number of deleted tupes per second. This metric is unavailable for read-only instances
Rows Inserted /sec
tup_inserted
-
Average number of inserted tupes per second. This metric is unavailable for read-only instances
Rows Updated /sec
tup_updated
-
Average number of updated tupes per second. This metric is unavailable for read-only instances
Rows Scanned in Index Scans /sec
tup_fetched
-
Average number of tupes scanned by the index per second
Rows Scanned in Sequential Scans /sec
tup_returned
-
Average number of tupes scanned in the full table per second
Deadlocks
deadlocks
-
Total number of deadlocks in a collection period

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