Tencent Cloud PostgreSQL¶

Use the "Cloud Sync" series of script packages in the script market to synchronize cloud monitoring and cloud asset data to Guance

Configuration¶

Install Func¶

It is recommended to activate the Guance integration - extension - hosted Func: all preconditions are automatically installed, please proceed with the script installation.

If deploying Func manually, refer to Manual Func Deployment

Activate Script¶

Note: Please prepare a Tencent Cloud AK with the required permissions in advance (for simplicity, you can directly grant the global read-only permission ReadOnlyAccess).

Activate Script for Hosted Version¶

1. Log in to the Guance console.
2. Click the 【Integration】 menu, select 【Cloud Account Management】.
3. Click 【Add Cloud Account】, select 【Tencent Cloud】, and fill in the required information on the interface. If you have already configured the cloud account information, ignore this step.
4. Click 【Test】, and after a successful test, click 【Save】. If the test fails, please check if the relevant configuration information is correct and test again.
5. Click 【Cloud Account Management】, and you can see the added cloud account in the list. Click the corresponding cloud account to enter the details page.
6. Click the 【Integration】 button on the cloud account details page, find Tencent Cloud PostgreSQL under the Not Installed list, and click the 【Install】 button to pop up the installation interface and install.

Activate Script Manually¶

1. Log in to the Func console, click 【Script Market】, enter the Guance script market, and search for integration_tencentcloud_postgresql.

2. Click 【Install】, then enter the corresponding parameters: Tencent Cloud AK, SK, and account name.

3. Click 【Deploy Startup Script】, the system will automatically create the Startup script set and configure the corresponding startup script.

4. After enabling, you can see the corresponding automatic trigger configuration in 「Management / Automatic Trigger Configuration」. Click 【Execute】 to immediately execute once without waiting for the scheduled time. After a short wait, you can view the execution task records and corresponding logs.

Verification¶

1. In 「Management / Automatic Trigger Configuration」, confirm whether the corresponding task has the corresponding automatic trigger configuration, and check the corresponding task records and logs to see if there are any exceptions.
2. In Guance, check if the asset information exists in 「Infrastructure / Custom」.
3. In Guance, check if there is corresponding monitoring data in 「Metrics」.

Metrics¶

After configuring Tencent Cloud Cloud Monitoring, the default measurement is as follows. More metrics can be collected through configuration Tencent Cloud Cloud Monitoring Metrics Details

Monitoring Metrics¶

Objects¶

The collected Tencent Cloud postgresql object data structure can be seen in 「Infrastructure - Custom」.

{
  "measurement": "tencentcloud_postgresql",
  "tags": {
    "ClusterType" : "0",
    "InstanceId"  : "cmxxxx",
    "InstanceName": "test_01",
    "InstanceType": "1",
    "MongoVersion": "MONxxxx",
    "NetType"     : "1",
    "PayMode"     : "0",
    "ProjectId"   : "0",
    "RegionId"    : "ap-nanjing",
    "Status"      : "2",
    "VpcId"       : "vpc-nf6xxxxx",
    "Zone"        : "ap-nanjing-1",
    "name"        : "cmxxxx"
  },
  "fields": {
    "CloneInstances"   : "[]",
    "CreateTime"       : "2022-08-24 13:54:00",
    "DeadLine"         : "2072-08-24 13:54:00",
    "ReadonlyInstances": "[]",
    "RelatedInstance"  : "{Instance JSON Data}",
    "ReplicaSets"      : "{Instance JSON Data}",
    "StandbyInstances" : "[]",
    "message"          : "{Instance JSON Data}",
  }
}

Logs¶

Slow Query Statistics¶

Prerequisites¶

Note 1: The code execution of this script depends on the PostgreSQL instance object collection. If the custom object collection for PostgreSQL is not configured, the slow log script cannot collect slow log data.

Install Log Collection Script¶

On the previous basis, you need to install another script package corresponding to PostgreSQL slow query statistics log collection.

In 「Management / Script Market」, click and install the corresponding script package:

• 「Guance Integration (Tencent Cloud-PostgreSQL Slow Query Log Collection)」(ID: integration_tencentcloud_postgresql_slowlog)

After the data is synchronized normally, you can view the data in the 「Logs」 of Guance.

The reported data example is as follows:

{
  "measurement": "tencentcloud_postgre_slowlog",
  "tags": {
      "AppId": "137185",
      "ClientAddr": "",
      "DBCharset": "UTF8",
      "DBEngine": "postgresql",
      "DBEngineConfig": "",
      "DBInstanceClass": "cdb.pg.ts1.2g",
      "DBInstanceId": "postgres-3coh1xgm",
      "DBInstanceName": "Unnamed",
      "DBInstanceStatus": "running",
      "DBInstanceType": "primary",
      "DBInstanceVersion": "standard",
      "DBVersion": "10.17",
      "DatabaseName": "postgres",
      "PayType": "postpaid",
      "ProjectId": "0",
      "Region": "ap-shanghai",
      "RegionId": "ap-shanghai",
      "SubnetId": "subnet-bp2jqhcj",
      "Type": "TS85",
      "Uid": "4147",
      "UserName": "postgres",
      "VpcId": "vpc-kcpy",
      "Zone": "ap-shanghai-2",
      "name": "postgres-3coh1xgm"
  },
  "fields": {
      "NormalQuery": "select $1 from information_schema.tables where table_schema = $2 and table_name = $3",
      "AvgCostTime" : "101.013005",
      "CostTime"    : "101.013025",
      "FirstTime"   : "2021-07-27 03:12:01",
      "LastTime"    : "2021-07-27 03:12:01",
      "MaxCostTime" : "101.828125",
      "MinCostTime" : "101.828125",
      "message"     : "{Slow Query JSON Data}"
  }
}

Note: The fields in tags and fields may change with subsequent updates. Note 1: The tags values are supplemented by custom objects. Note 2: fields.message is a JSON serialized string.

Appendix¶

TencentCloud-PostgreSQL 「Region」¶

Please refer to the Tencent official documentation:

• TencentCloud-MongoDB Region ID

TencentCloud-PostgreSQL 「Slow Log Information Documentation」¶

Please refer to the Tencent official documentation:

• TencentCloud-PostgreSQL Slow Log Detailed Information Documentation