How to control postgres Heroku database

Question

NewRelic provides a good analysis of the database, however it seems to only track web application transactions.

I myself managed the servers that query and load my postgresql database in Heroku. Is there a way to get diagnostics and analysis of database activity so that it includes all connections to it?

Answer 1

The new Relic application monitoring will only collect data for database queries that are part of a web transaction or background task that is being monitored. If you use one of the supported New Relic languages ​​to query your database, you can track this code as a background task (see https://newrelic.com/docs/features/monitoring-background-processes ). If you want to use the generic monitoring plugin for your postgresql database, you can check out the postgresql plugin for New Relic (created and maintained by Boundless): http://newrelic.com/plugins/boundless/109 .

Answer 2

You should also try Heroku PG Extras: https://github.com/heroku/heroku-pg-extras . This will give information about deleting the cache, indexes, long queries, etc.