Check out our free resources and eBooks like: "Effective Indexing in Postgres"

Step 1: Add Log Drain

Log output support is only available on Heroku Postgres Standard, Premium and higher plans.

Log output for Heroku Postgres databases is sent to the application that the database is attached to, so we need to add a log drain to that application that forwards log lines to the pganalyze collector app running in your account.

The collector receives log drains at the following URL:


For the [ALIAS] value we recommend you use the add-on attachment name you've chosen in the initial setup, which you can determine by viewing the current Heroku configuration of your collector app:

heroku config -a [your-collector-app-name]
=== [your-collector-app-name] Config Vars
TESTAPP_URL: postgres://...:...@...:.../...

So in this case we would use TESTAPP_URL as our alias, and then we would add the log drain like this:

heroku drains:add https://[your-collector-app-name] -a [your-app-name]

Make sure to replace [your-collector-app-name] with the name of your own collector application that you've deployed in your Heroku account, and [your-app-name] with the name of your main application (the one that owns the database for which you want to collect logs).

Continue to Step 2: Verify log drain

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →