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
andaiven_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 totrue
:{
"datadog_dbm_enabled": true
}
Related pages
- Learn more about Datadog and Aiven.
- Monitor PgBouncer with Datadog.
- Learn more about Database monitoring with Datadog from the Datadog product page.