Skip to main content

Monitor a database with Datadog

Database Monitoring with Datadog enables you to capture key metrics on the Datadog platform for any Aiven for PostgreSQL® service with Datadog Metrics integration.

Datadog Database Monitoring allows you to view query metrics and explain plans in a single place, with the ability to drill into precise execution details, along with query and host metrics correlation.

Prerequisites

  • Apply any outstanding maintenance updates mentioning the Datadog integration.
  • Ensure the Datadog Metrics integration is enabled.
  • The PostgreSQL extensions - pg_stat_statements and aiven_extras, must be enabled by executing the following CREATE EXTENSION SQL commands directly on the Aiven for PostgreSQL® database service.
CREATE EXTENSION pg_stat_statements;
CREATE EXTENSION aiven_extras;

Enable monitoring

You can individually enable Datadog Database Monitoring for the specific Datadog Metrics integration for Aiven for PostgreSQL®, by configuring the datadog_dbm_enabled parameter. Repeat this action for every Datadog Metrics integration for Aiven for PostgreSQL®, which you plan to monitor.

Using the avn service integration-list Aiven CLI command, you can obtain the Datadog Metric integration to monitor and enable the Datadog Database monitoring functionality by using the datadog_dbm_enabled configuration parameter. For example:

  • Find the UUID of the Datadog Metrics integration for a particular service:

    avn service integration-list --project <project name> <service name>
  • Enable the Datadog Database Monitoring for the Datadog Metrics integration with the following command, substituting the <INTEGRATION_UUID> with the integration UUID retrieved at the previous step:

    avn service integration-update --project <PROJECT_NAME> --user-config '{"datadog_dbm_enabled": true}' <INTEGRATION_UUID>
  • Check if user-config datadog_dbm_enabled set correctly:

    avn service integration-list <SERVICE_NAME> \
    --project <PROJECT_NAME> \
    --json | jq '.[] | select(.integration_type=="datadog").user_config'

    datadog_dbm_enabled should be set to true:

    {
    "datadog_dbm_enabled": true
    }