Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

Redshift

Published and supported by Chirag Parmar


NewRelic Redshift Plugin

A NewRelic Redshift Plugin

The New Relic Redshift Plugin enables integrated monitoring of your Redshift database in a custom NewRelic dashboard. Currently the following metrics are recorded:

  • Database Memory Statistics -Total Disk Space -Free Space -Percentage Utilized
  • Table Statistics -Total Rows Per Table -Sorted Rows Per Table -Unsorted Rows Per Table -Percentage of Unsorted Region Per Table -Size of Table in Proportion to the Cluster Size -Staleness of the Table Stats (real size vs size recorded in stats)

More metrics coming!

Requirements

Proxy host

You need a host to install the plugin on that is able to poll the desired Redshift database. That host also needs Ruby (tested with 2.2.0), and support for rubygems.

Installation and Running

      1. Install this gem from RubyGems: gem install newrelic_redshift_plugin
      2. Create an installation directory (like /opt/newrelic/redshift ).
      1. Download the latest newrelic_redshift_plugin-X.Y.Z.tar.gz from the tag list https://github.com/ChiragKParmar/newrelic_redshift_plugin/tags
      2. Extract the downloaded archive to the location you want to run the Redshift agent from
      3. Run bundle install to install required gems
  1. In the installation directory, execute

    ./bin/redshift_plugin install -l LICENSE_KEY

    using the license key from your New Relic account.

  2. Edit the config/newrelic_plugin.yml file generated in step 4. Setup host/port/user/password/dbname/schema for your redshift connection.
  3. Execute

    ./bin/redshift_plugin run

  4. Wait a few minutes for New Relic to begin processing the data sent from your agent.

  5. Log into your New Relic account at http://newrelic.com and click on Redshift on the left hand nav bar to start seeing your Redshift metrics.

Source Code

This plygin can be found at https://github.com/ChiragKParmar/newrelic_redshift_plugin/

Support

Please use Github issue for support at https://github.com/ChiragKParmar/newrelic_redshift_plugin/issues

Frequently Asked Questions

Q: What is the default polling time ?

A: Default polling period is 60 seconds.

Q: How can I change the default polling time ?

A: You can change the default value by editing the newrelic_plugin.yml (https://github.com/ChiragKParmar/newrelic_redshift_plugin/config/newrelic_plugin.yml#L12) and Please read Newrelic's note on time periods for metrics

Contributing

Pull requests welcome!

More Metrics Coming Soon!!!

The Redshift plugin extends the power of New Relic's monitoring capabilities.


Get This Plugin

Already have a New Relic account? Log in and begin using this plugin.

If you don't have a New Relic account, follow these three simple steps:

How To Install A Plugin

Installing a plugin is simple and fast.

Installing
a Plugin
  1. Step One

    Sign in to your New Relic account

  2. Step Two

    Select and install plugin

  3. Step Three

    Start seeing data

That’s it. You’re done. Simple.

Sign Up for New Relic

Back to top icon