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 →