Skip to content

Configuration Manual for the "Tencent Cloud - PostgreSQL Slow Query Details Logs" Collector

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

The code execution of this script depends on the collection of PostgreSQL instance objects. If custom object collection for PostgreSQL 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. Example: 'ap-nanjing'
See appendix for full list

2. Configuration Example

Specified Region

Collect MongoDB slow query log data from the Nanjing region.

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

3. Data Reporting Format

After the data has been synchronized successfully, you can view it in the 'LOG' section of 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
{
  "measurement": "tencentcloud_postgre_slowlog",
  "tags": {
      "AppId"            : "131185",
      "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-kcphyzty",
      "Zone"             : "ap-shanghai-2",
      "name"             : "postgres-3coh1xgm"
  },
  "fields": {
      "ClientAddr"      : "::1:34301",
      "Duration"        : "155.283",
      "RawQuery"        : "select count(*)::text as value from pg_stat_activity where now()-backend_start < '5  second';",
      "SessionStartTime": "2021-07-25 02:25:09 CST",
      "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 serialized in JSON format.

X. Appendix

TencentCloud-PostgreSQL "Regions"

Refer to the official Tencent documentation:

TencentCloud-PostgreSQL "Slow Log Details Information Documentation"

Refer to the official Tencent documentation: