This quickstart guide will help you get started monitoring your Crunchy Bridge database with pganalyze. We recommend you start with the Container Apps Quickstart to get a general understanding of Container Apps.
pganalyze provides deep analytics and insights into your Postgres database performance and surfaces areas you can improve.
pganalyze with Postgres Container Apps Quickstart
First, make sure you have Container Apps enabled. As a user with superuser privileges, run
CREATE EXTENSION pgpodman; to install the extension in the
postgres database of the desired cluster.
Next, find your cluster’s database URL to include as the
DATABASE_URL parameter when you run the container. You can find the URL in the Connection section of the cluster dashboard (choose the
application role), or by running
cb uri --role application <cluster name> on the command line.
You will also need to locate your API key from pganalyze to include in the command.
To start the pganalyze collector, run the following using your own values for
SELECT run_container('-dt -e DB_URL="your-database-URL" -e PGA_API_KEY="your-API-key" quay.io/pganalyze/collector:stable');
The collector should be sending data to pganalyze within about 10 minutes. Visit the pganalyze documentation for more tuning of pganalyze.