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

Postgres

Published and supported by Boundless - Production


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

Index size, miss rate, and count Cache miss rate Idle and active connection counts BGWriter metrics Tuple metrics Transactions committed and rolled back Requirements

Proxy host

You need a host to install the plugin on that is able to poll the desired Postgres database. That host also needs Ruby (tested with 2.0.0), and support for rubygems. Heroku is a great choice for this. A fully deployable example app is provided.

https://github.com/GoBoundless/heroku_postgres_monitor

Postgres

This plugin has been tested with with a few different Postgres version and should work with any version compatible with the pg gem.

Installation and Running

Install this gem from RubyGems:

gem install newrelic_postgres_plugin

Create an installation directory (like /opt/newrelic/postgres ).

In the installation directory, execute

pg_monitor install -l LICENSE_KEY

using the license key from your New Relic account.

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

pg_monitor run

You should now see your results in the left-hand navigation of the NewRelic web UI under a tab labeled 'Postgres'.

Heroku Instructions

Unlike the default NewRelic Postgres plugin, this plugin is designed to be fully compatible with monitoring Heroku Postgres. In fact, we've even created a simple app you can run on Heroku to monitor your existing apps.

Instructions for using Heroku as your proxy host can be found in the heroku_postgres_monitor repo.

The Postgres 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