Alibaba Cloud AnalyticDB PostgreSQL¶

Alibaba Cloud AnalyticDB PostgreSQL metrics display, including CPU, memory, disk, coordination nodes, instance queries, etc.

Configuration¶

Install Func¶

It is recommended to activate the TrueWatch integration - extension - DataFlux Func (Automata): all prerequisites will be automatically installed. Please continue with script installation.

If you deploy Func on your own, refer to Self-deployed Func

Installation Script¶

Note: Please prepare an Alibaba Cloud AK that meets the requirements in advance (for simplicity, you can directly grant global read-only permission ReadOnlyAccess)

To synchronize monitoring data for Alibaba Cloud AnalyticDB PostgreSQL, we install the corresponding collection script: "TrueWatch Integration (Alibaba Cloud-AnalyticDB PostgreSQL Collection)" (ID: truewatch_aliyun_analyticdb_postgresql)

After clicking [Install], enter the corresponding parameters: Alibaba Cloud AK, Alibaba Cloud account name.

Click [Deploy Startup Script], and the system will automatically create a Startup script set and automatically configure the corresponding startup script.

Once enabled, you can see the corresponding automatic trigger configuration under "Manage / Automatic Trigger Configuration". Click [Execute] to immediately run it without waiting for the scheduled time. After a short wait, you can view the execution task records and corresponding logs.

We default collect some configurations; for more details, see the metrics section.

Configure Custom Cloud Object Metrics

Verification¶

In "Manage / Automatic Trigger Configuration", confirm whether the corresponding tasks have been configured with automatic triggers. You can also check the corresponding task records and logs for any anomalies.
On the TrueWatch platform, under "Infrastructure / Custom", check if there are asset information entries.
On the TrueWatch platform, under "Metrics", check if there are corresponding monitoring data.

Metrics¶

After configuring Alibaba Cloud AnalyticDB PostgreSQL, the default metric sets are as follows. You can collect more metrics through configuration Alibaba Cloud Cloud Monitoring Metric Details

MetricName	MetricCategory	MetricDescribe	Dimensions	Statistics	Unit	MinPeriods
node_cpu_used_percent	`gpdb`	[Storage Elastic & Serverless] Node CPU Usage Rate	userId,instanceId,instance_component,hostname	Average,Maximum,Minimum	%	60 s
node_mem_used_percent	`gpdb`	[Storage Elastic & Serverless] Node Memory Usage Rate	userId,instanceId,instance_component,hostname	Average,Maximum,Minimum	%	60 s
node_disk_used_percent	`gpdb`	[Storage Elastic & Serverless] Node Disk Usage Rate	userId,instanceId,instance_component,hostname	Average,Maximum,Minimum	%	60 s
`adbpg_conn_count`	`gpdb`	[Storage Elastic & Serverless] Total Number of Coordination Node Connections	userId,instanceId,instance_component,hostname	Average,Maximum,Minimum	count	60 s
`adbpg_master_cnt_unhealth`	`gpdb`	[Storage Elastic & Serverless] Number of Unhealthy Coordination Nodes	userId,instanceId	Average,Maximum,Minimum	count	60 s
`adbpg_query_blocked`	`gpdb`	[Storage Elastic & Serverless] Number of Blocked Instance Queries	userId,instanceId	Average,Maximum,Minimum	count	60 s
`adbpg_query_queued`	`gpdb`	[Storage Elastic & Serverless] Number of Queued Instance Queries	userId,instanceId	Average,Maximum,Minimum	count	60 s

Objects¶

The collected Alibaba Cloud AnalyticDB PostgreSQL object data structure can be viewed from "Infrastructure - Custom"

{
  "measurement": "aliyun_analyticdb_postgresql",
  "tags": {
    "DBInstanceCategory": "Basic",
    "DBInstanceId": "gp-bp17993xt44lmgyga",
    "DBInstanceMode": "StorageElastic",
    "DBInstanceNetType": "2",
    "DBInstanceStatus": "CREATING",
    "Engine": "gpdb",
    "EngineVersion": "6.0",
    "InstanceDeployType": "cluster",
    "InstanceNetworkType": "VPC",
    "LockMode": "Unlock",
    "LockReason": "0",
    "PayType": "Postpaid",
    "RegionId": "cn-hangzhou",
    "ResourceGroupId": "rg-acfmv3ro3xnfwaa",
    "StorageType": "cloud_essd",
    "VSwitchId": "vsw-bp1k8o6a4cb1pnq6ximgb",
    "VpcId": "vpc-bp1pftfpllxna4t75e73v",
    "ZoneId": "cn-hangzhou-j",
    "name": "gp-bp17993xt44lmgyga"
  },
  "fields": {
    "CreateTime": "2023-08-16T03:07:45Z",
    "DBInstanceDescription": "gp-bp17993xt44lmgyga",
    "ExpireTime": "2999-09-08T16:00:00Z",
    "MasterNodeNum": 1,
    "SegNodeNum": "2",
    "StorageSize": "50",
    "message": "{instance json data}}"
  }
}