This page contains a quickstart to help you get started monitoring your Crunchy Bridge database with pganalyze. We recommend you start with the quickstart to get an 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 ensure you have Container Apps enabled with
CREATE EXTENSION pgpodman;. Once enabled you’ll need your DATABASE_URL from Crunchy Bridge and your API_KEY from Pganalyze to include in the command. To start the Pganalyze collector you can run:
SELECT run_container('-dt -e DB_URL="DATABASE_URL" -e PGA_API_KEY="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.