Skip to content

Configuration Manual for Collector 「Tencent Cloud - PostgreSQL Slow Query Logs」

Before reading this article, please read the following first:

Before using this collector, you must install the 「Integration Core Package」and its associated third-party dependency packages

The code execution of this script depends on the collection of PostgreSQL instance objects. If PostgreSQL custom object collection is not configured, the slow log script will not be able to collect slow log data.

1. Configuration Structure

The configuration structure of this collector is as follows:

Field Type Required Description
regions list Required List of regions to collect from
regions[#] str Required Region ID. For example: 'ap-nanjing'
Refer to the appendix for the full table

2. Configuration Example

Specified Region

Collect PostgreSQL slow query log data from Nanjing region.

Python
1
2
3
collector_configs = {
    'regions': ['ap-nanjing'],
}

3. Data Reporting Format

After data synchronization is successful, you can view the data in the 「Logs」 section of TrueWatch.

Example of reported data:

JSON
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
{
  "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}"
  }
}

Fields in tags and fields may change with subsequent updates

Tag values are supplemented by custom objects

fields.message is a string after JSON serialization

X. Appendix

TencentCloud-PostgreSQL「Regions」

Please refer to the official Tencent documentation:

TencentCloud-PostgreSQL「Slow Log Information Documentation」

Please refer to the official Tencent documentation: