Database monitoring 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#
To use Datadog Database Monitoring with your Aiven for PostgreSQL® services, you must perform the following steps:
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 you want 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 --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 }
See also
Learn more about Datadog and Aiven.
Learn more about Datadog Deep Database Monitoring from their product page.