Alibaba Cloud AnalyticDB PostgreSQL¶

Alibaba Cloud AnalyticDB PostgreSQL Metrics Display, including CPU, memory, disk, coordinator nodes, instance queries, etc.

Configuration¶

Install Func¶

It is recommended to enable Guance Integration - Extension - Managed Func

If you deploy Func yourself, refer to Self-deployed Func

Enable Script¶

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

Managed Version Enable Script¶

Log in to the Guance Console
Click on the 【Manage】 menu and select 【Cloud Account Management】
Click 【Add Cloud Account】, choose 【Alibaba Cloud】, fill in the information required on the interface; if cloud account information has been configured before, skip this step
Click 【Test】, after testing successfully click 【Save】, if the test fails, please check whether the related configuration information is correct and retest
Click on the 【Cloud Account Management】 list to see the added cloud account, click the corresponding cloud account, and enter the details page
Click the 【Integration】 button on the cloud account details page, find Alibaba Cloud AnalyticDB PostgreSQL under the Not Installed list, click the 【Install】 button, and install it via the installation interface that pops up.

Manual Enable Script¶

Log in to the Func Console, click 【Script Market】, enter the official script market, search for:guance_aliyun_analyticdb_postgresql
After clicking 【Install】, input the corresponding parameters: Alibaba Cloud AK ID, AK Secret, and account name.
Click 【Deploy Start Script】, the system will automatically create a Startup script set and automatically configure the corresponding start scripts.
After enabling, you can see the corresponding automatic trigger configurations in 「Management / Automatic Trigger Configurations」. Click 【Execute】 to run it immediately 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 「Management / Automatic Trigger Configurations」 confirm whether the corresponding tasks have the corresponding automatic trigger configurations, and at the same time, check the task records and logs for any abnormalities.
In Guance, 「Infrastructure / Custom」 check if there is asset information.
In Guance, 「Metrics」 check if there are corresponding monitoring data.

Metrics¶

After configuring Alibaba Cloud AnalyticDB PostgreSQL, the default metric sets are as follows, and more metrics can be collected through configuration. Details of Alibaba Cloud Monitoring Metrics

MetricName	MetricCategory	MetricDescribe	Dimensions	Statistics	Unit	MinPeriods
node_cpu_used_percent	`gpdb`	【Storage Elastic & Serverless】Node CPU Usage	userId,instanceId,instance_component,hostname	Average,Maximum,Minimum	%	60 s
node_mem_used_percent	`gpdb`	【Storage Elastic & Serverless】Node Memory Usage	userId,instanceId,instance_component,hostname	Average,Maximum,Minimum	%	60 s
node_disk_used_percent	`gpdb`	【Storage Elastic & Serverless】Node Disk Usage	userId,instanceId,instance_component,hostname	Average,Maximum,Minimum	%	60 s
`adbpg_conn_count`	`gpdb`	【Storage Elastic & Serverless】Coordinator Node Total Connections	userId,instanceId,instance_component,hostname	Average,Maximum,Minimum	count	60 s
`adbpg_master_cnt_unhealth`	`gpdb`	【Storage Elastic & Serverless】Coordinator Node Unhealthy Count	userId,instanceId	Average,Maximum,Minimum	count	60 s
`adbpg_query_blocked`	`gpdb`	【Storage Elastic & Serverless】Instance Blocked Query Count	userId,instanceId	Average,Maximum,Minimum	count	60 s
`adbpg_query_queued`	`gpdb`	【Storage Elastic & Serverless】Instance Queued Query Count	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}}",
  }
}