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 corresponding third-party dependency packages

This script's code execution 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 data from
regions[#] str Required Region ID. For example: 'ap-nanjing'
Refer to the appendix for the full table

2. Configuration Example

Specify Region

Collect PostgreSQL slow query log data from the Nanjing region.

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

3. Data Reporting Format

After the data is synchronized successfully, you can view it in the 'LOG' section of Guance and TrueWatch.

An example of the reported data is as follows:

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 JSON serialized string

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: