Skip to content

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

Before reading this article, please first read:

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

This script's code execution depends on the collection of PostgreSQL instance objects. If custom object collection for PostgreSQL is not configured, the slow log script will be unable 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 be collected
regions[#] str Required Region ID. For example: 'ap-nanjing'
See the full table in the appendix

2. Configuration Example

Specifying Regions

Collect MongoDB slow query log data from the Nanjing region.

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

3. Data Reporting Format

After data synchronization, you can view the data in the "LOG" section of Guance or TrueWatch.

An example of reported data is shown below:

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 after JSON serialization

X. Appendix

TencentCloud-PostgreSQL "Regions"

Please refer to the official Tencent documentation:

TencentCloud-PostgreSQL "Slow Log Details Information Documentation"

Please refer to the official Tencent documentation: