Tencent Cloud TDSQL-C PostgreSQL Monitoring Integration

Utilize Site24x7 Tencent Cloud TDSQL-C PostgreSQL Monitoring Integration to:

Track read and write request rates on this cloud-native PostgreSQL-compatible database.
Monitor slow queries to identify and resolve performance bottlenecks.
Observe network bytes received and sent to detect traffic anomalies.
Track storage usage to plan capacity for growing TDSQL-C PostgreSQL clusters.

This help document contains instructions to set up Tencent Cloud TDSQL-C PostgreSQL Monitoring Integration and related information.

Setup and configuration

During your Tencent Cloud monitor setup, if you have selected TDSQL-C PostgreSQL in the Services/Resources drop-down, all your TDSQL-C PostgreSQL resources will be auto-detected and monitored without the need to manually create a monitor for each resource.

If you haven't selected TDSQL-C PostgreSQL during Tencent Cloud monitor creation, follow these instructions:

Log in to your Site24x7 account.
Go to Cloud > Tencent Cloud, select your Tencent Cloud monitor, then go to any of the dashboards on the left pane.
Click the hamburger icon and select Edit, which brings you to the Edit Tencent Cloud Monitor page.
On the Edit Tencent Cloud Monitor page, select TDSQL-C PostgreSQL from the Services/Resources drop-down and click Save.
After successful configuration, go to Cloud > Tencent Cloud > TDSQL-C PostgreSQL. Now you can view the discovered resources.

Data collection frequency

Performance metrics of your Tencent Cloud TDSQL-C PostgreSQL resources will be collected every five minutes and updated in the Site24x7 portal every five minutes by default; metrics are also collected based on the selected poll interval.

Supported metrics

Metric name	Description	Unit
Bytes Received	Volume of data received by the cluster from clients per second	Bytes/second
Bytes Sent	Volume of data sent from the cluster to clients per second	Bytes/second
Read Requests	Number of read query requests executed per second	Requests/second
Write Requests	Number of write query requests executed per second	Requests/second
Slow Queries	Number of queries exceeding the slow query threshold per second	Queries/second
Storage Usage	Total disk space consumed by the TDSQL-C PostgreSQL cluster	GB

Threshold configuration

Global configuration

Go to the Admin section in the left navigation pane.
Select Configuration Profiles from the left pane and choose the Threshold and Availability (+) tab from the drop-down menu. Click Add Threshold Profile from the top-right corner.
Set the monitor type as Tencent Cloud TDSQL-C PostgreSQL. Now you can set the threshold values for all the metrics mentioned above.

Monitor-level configuration

Go to Cloud > Tencent Cloud > TDSQL-C PostgreSQL.
Choose a resource for which you would like to set a threshold, then click the hamburger icon . Select Edit, which directs you to the Edit Tencent Cloud TDSQL-C PostgreSQL Monitor page.
You can set the threshold values for the metrics by selecting Threshold and Availability. You can also configure IT Automation at the attribute level.

IT Automation

Site24x7's IT Automation tools help with automatically resolving performance degradation issues. When a breach occurs, the alarm engine continuously examines the system events for which thresholds have been defined and performs the mapped automation.

How to configure IT Automation for a monitor

Configuration Rules

With Site24x7's Configuration Rules, you can set parameters like Threshold Profile, Notification Profile, Tags, and Monitor Group for multiple monitors and automate the configuration settings of your monitoring resources.

How to add a Configuration Rule