O'Reilly logo

Heroku Cookbook by Mike Coutermarsh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Analyzing Heroku Postgres's performance

Database performance is critical to have a highly responsive web application. Heroku gives us a handful of tools to analyze our Postgres database for performance issues. Knowledge is power, and having visibility into emerging issues can help us fix them before they turn into major problems. In this recipe, you will learn about your cache hit rate, slow queries, and unused indexes.

Getting ready

In this recipe, we will be making use of the pg-extras plugin for Heroku. It gives us access to additional commands to administer our Postgres database.

To install it, you need to open a terminal and run the following command:

$ heroku plugins:install git://github.com/heroku/heroku-pg-extras.git

How to do it…

We'll be ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required