AWS Redshift Monitoring Extension

AWS Redshift Monitoring Extension

Use Case

Captures AWS Redshift statistics from Amazon CloudWatch and displays them in the AppDynamics Metric Browser.


  1. Before the extension is installed, the prerequisites mentioned here need to be met. Please do not proceed with the extension installation if the specified prerequisites are not met.
  2. Please give the following permissions to the account being used to with the extension.
  3. In order to use this extension, you do need a Standalone JAVA Machine Agent or SIM Agent. For more details on downloading these products, please visit here.
  4. The extension needs to be able to connect to AWS Cloudwatch in order to collect and send metrics. To do this, you will have to either establish a remote connection in between the extension and the product using access key and secret key, or have an agent running on EC2 instance, which you can use with instance profile.


  1. Download and unzip AWSRedshiftMonitor-\<version\>.zip into \<machine_agent_dir\>/monitors/.
  2. Edit the file config.yml located at <MachineAgent_Dir>/monitors/AWSRedshiftMonitor The metricPrefix of the extension has to be configured as specified here. Please make sure that the right metricPrefix is chosen based on your machine agent deployment, otherwise this could lead to metrics not being visible in the controller.
  3. Restart the Machine Agent.


In order to use the extension, you need to update the config.yml file that is present in the extension folder. The following is a step-by-step explanation of the configurable fields that are present in the config.yml file.

  1. Edit the file config.yml located at <MachineAgent_Dir>/monitors/AWSRDSMonitor The metricPrefix of the extension has to be configured as specified here. Please make sure that the right metricPrefix is chosen based on your machine agent deployment, otherwise this could lead to metrics not being visible in the controller.
  2. Provide accessKey(required) and secretKey(required) of your account(s), also provide displayAccountName(any name that represents your account) and
    regions(required). If you are running this extension inside an EC2 instance which has IAM profile configured then you don’t have to configure accessKey and secretKey values, extension will use IAM profile to authenticate. You can provide multiple accounts and regions as below -

      - awsAccessKey: "XXXXXXXX1"
        awsSecretKey: "XXXXXXXXXX1"
        displayAccountName: "TestAccount_1"
        regions: ["us-east-1","us-west-1","us-west-2"]
      - awsAccessKey: "XXXXXXXX2"
        awsSecretKey: "XXXXXXXXXX2"
        displayAccountName: "TestAccount_2"
        regions: ["eu-central-1","eu-west-1"]
  3. If you want to encrypt the awsAccessKey and awsSecretKey then follow the “Credentials Encryption” section and provide the encrypted values in awsAccessKey and awsSecretKey. Configure enableDecryption of credentialsDecryptionConfig to true and provide the encryption key in encryptionKey.
    For example,

    #Encryption key for Encrypted password.
        enableDecryption: "true"
        encryptionKey: "XXXXXXXX"
  4. Provide all valid proxy information if you use it. If not, leave this section as is.

  5. To report metrics only from specific dimension values, configure the dimension section as below -

       - name: "latency"
         displayName: "Latency"
         values: ["short", "long", "medium"]
       - name: "NodeID"
         displayName: "Node ID"
         values: ["Leader", "Compute-0", "Compute-1"]
       - name: "ClusterIdentifier"
         displayName: "Cluster ID"
         values: ["my-redshift"]
       - name: "service class"
         displayName: "Service Class"
         values: ["6","5","15","14"]
       - name: "Stage"
         displayName: "Query Execution Stage"
         values: [""]
       - name: "wmlid"
         displayName: "Workload Mgmt Queue"
         values: [""]

    If these fields are left empty [], the metrics which require that dimension will not be reported.
    In order to monitor everything under a dimension, you can simply use “.*” to pull everything from your AWS Environment.

  6. Configure the metrics section.
    For configuring the metrics, the following properties can be used:

    PropertyDefault valuePossible valuesDescription
    aliasmetric nameAny stringThe substitute name to be used in the metric browser instead of metric name.
    statType“ave”“AVERAGE”, “SUM”, “MIN”, “MAX”AWS configured values as returned by API
    aggregationType“AVERAGE”“AVERAGE”, “SUM”, “OBSERVATION”Aggregation qualifier
    timeRollUpType“AVERAGE”“AVERAGE”, “SUM”, “CURRENT”Time roll-up qualifier
    clusterRollUpType“INDIVIDUAL”“INDIVIDUAL”, “COLLECTIVE”Cluster roll-up qualifier
    multiplier1Any numberValue with which the metric needs to be multiplied.
    convertnullAny key value mapSet of key value pairs that indicates the value to which the metrics need to be transformed. eg: UP:0, DOWN:1
    deltafalsetrue, falseIf enabled, gives the delta values of metrics instead of actual values.

For example,

      - name: "CPUUtilization"
        alias: "CPU Utilization (Unit - %; StatType - ave)"
        statType: "ave"
        delta: false
        multiplier: 1
        aggregationType: "AVERAGE"
        timeRollUpType: "AVERAGE"
        clusterRollUpType: "INDIVIDUAL"

All these metric properties are optional, and the default value shown in the table is applied to the metric(if a property has not been specified) by default.

  1. CloudWatch metrics are delivered on a best-effort basis. This means that the delivery of metrics is not guaranteed to be on-time.
    There may be a case where the metric is updated in CloudWatch much later than when it was processed, with an associated delay.
    For Redshift, the delay can be 4 - 5 minutes. There is a possibility that the extension does not capture the metric, which is the reason there is a time window. The time window allows
    the metric to be updated in CloudWatch before the extension collects it.

      startTimeInMinsBeforeNow: 9
      endTimeInMinsBeforeNow: 4
  2. This field is set as per the defaults suggested by AWS. You can change this if your limit is different.

    getMetricStatisticsRateLimit: 400
  3. The maximum number of retry attempts for failed requests that can be re-tried.

    maxErrorRetrySize: 3

Please avoid using tab (\t) when editing yaml files. Please copy all the contents of the config.yml file and go to Yaml Validator . On reaching the website, paste the contents and press the “Go” button on the bottom left.
If you get a valid output, that means your formatting is correct and you may move on to the next step.


  • The AWS Redshift Extension provides AWS Redshift performance metrics as listed
    The entire list of metrics and dimensions that are fetched by this extension is listed in Monitoing AWS Redshift Performance .
  • The Query/Load Performance data listed here is not published as CloudWatch Metrics and hence not monitored as part of this extension. they can be viewed in the Amazon Redshift console.
  • AppDynamics AWS Redshift Extension provides node level and cluster level metrics to monitor the performance and health of the clusters.

Credentials Encryption

Please visit this page to get detailed instructions on password encryption. The steps in this document will guide you through the whole process.

Extensions Workbench

Workbench is an inbuilt feature provided with each extension in order to assist you to fine tune the extension setup before you actually deploy it on the controller. Please review the following document on How to use the Extensions WorkBench


Please look at the troubleshooting document and make sure that everything is followed correctly.

Support Tickets

If after going through the Troubleshooting Document you have not been able to get your extension working, please file a ticket and add the following information.

Please provide the following in order for us to assist you better.

  1. Stop the running machine agent.

  2. Delete all existing logs under <MachineAgent>/logs.

  3. Please enable debug logging by editing the file <MachineAgent>/conf/logging/log4j.xml. Change the level value of the following <logger> elements to debug.

    <logger name="com.singularity">
    <logger name="com.appdynamics">
  4. Start the machine agent and please let it run for 10 mins. Then zip and upload all the logs in the directory <MachineAgent>/logs/*.

  5. Attach the zipped <MachineAgent>/conf/* directory here.

  6. Attach the zipped <MachineAgent>/monitors/ExtensionFolderYouAreHavingIssuesWith directory here.

For any support related questions, you can also contact


Always feel free to fork and contribute any changes directly here on GitHub.


Extension Version2.0.1
Controller Compatibility4.4 or Later
Last UpdateMar 22, 2019
List of ChangesChange Log