Check out our new Resources section: Read through our eBooks and learn how customers are using pganalyze. See all resources

Step 3: Configure the Collector

Configuring the collector with Docker

Create your configuration file (e.g. named pganalyze_collector.env) with environment variables like this:


Fill in the values step-by-step:

  1. The PGA_API_KEY can be found in the pganalyze API keys page for your organization
  2. The DB_HOST is the IP address of your Google Cloud SQL instance
  3. The DB_NAME is the database on the Google Cloud SQL instance you want to monitor
  4. The DB_USERNAME and DB_PASSWORD should be the credentials of the monitoring user we created in Step 1
  5. The GCP_PROJECT_ID should match the name of the GCP project that contains your Cloud SQL instance
  6. The GCP_CLOUDSQL_INSTANCE_ID should match the name of the Cloud SQL instance

Test snapshot

Then run the following:

docker run --env-file pganalyze_collector.env test

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 →