NEW: Paste your query and schema data and we give you the best index. Launch pganalyze Index Advisor

Step 3: Verify Configuration

You can verify that your database has been attached by checking the heroku config of the collector application:

heroku config -a testapp-pganalyze-collector

This will output something like the following:

=== testapp-pganalyze-collector Config Vars
MYDB_PRIMARY_URL: postgres://...:...@...:.../...
PGA_API_KEY: ...

Now, you can verify the configuration by running the test command:

$ heroku run -a testapp-pganalyze-collector collector --test

This should output something similar to the following:

Running collector --test on ⬢ testapp-pganalyze-collector... up, run.6337 (Hobby)
2019/12/18 10:41:10 I [MYDB_PRIMARY_URL] Testing statistics collection...
2019/12/18 10:41:12 I [MYDB_PRIMARY_URL]   Test submission successful (362 KB received, server ...)
2019/12/18 10:41:12 I [MYDB_PRIMARY_URL] Testing activity snapshots...
2019/12/18 10:41:13 I [MYDB_PRIMARY_URL]   Test submission successful (20.7 KB received, server ...)

Once you've confirmed the install is successful and you're receiving query data in pganalyze, we recommend setting up Log Insights as a follow-up step, to automatically track log events in your database.


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