Cette page n'est pas encore disponible en français, sa traduction est en cours.
Si vous avez des questions ou des retours sur notre projet de traduction actuel,
n'hésitez pas à nous contacter.
On the Databases page, you can assess the health and activity of your database hosts and clusters. Sort and filter the list to prioritize hosts and clusters with triggered alerts, high query volume, and other criteria. Click on any host in the list to open a details panel:
In addition to a filterable graph of active connections for that host, the host details panel displays the following features.
Cluster grouping
A Group into clusters toggle appears with the list of database hosts if host tags indicate the presence of cluster topology. Enable this toggle to group hosts into clusters within the list.
Cluster rows display a Cluster badge and show the number of instances in the cluster. Columns for cluster rows display aggregated data from all instances within the cluster. Select a cluster row to expand it and view a list of all instances that the cluster contains.
Cluster grouping supports the following database technology and cluster topologies:
| Database | Topologies | Grouping Tags | Cluster Name Source |
|---|
Amazon RDS
(AWS integration required) | - Multi-AZ clusters
- Read replicas
| dbclusteridentifierregionaws_account
| |
PostgreSQL
(Agent v7.58+ required) | | | postgresql_cluster_name (from instance cluster_name config)- Primary instance name
system_identifier
|
MySQL
(Agent v7.68+ required) | - Regular replication (not group replication)
| | - Primary instance name
cluster_uuid
|
Top queries
On the Top Queries tab of the host details panel, you can sort the most common queries by maximum duration, average latency, and more.
Click on any query statement to open a details panel that includes:
- query insights
- graphs for average latency and other key metrics
- explain plans
- blocking activity
- hosts that have run the query
- calling services
Stored procedures
Where supported, the Top Queries tab includes a Stored Procedures section that lists each stored procedure by name, along with its average duration, logical reads count, logical writes count, and more. Expand a stored procedure to view its individual SQL queries, and click on a query to view its details panel.
Metrics
On the Metrics tab of the host details panel, you can view and filter metrics for system health, query activity, blocking operations, function performance, and other key areas.
Active connections
The Active Connections tab of the host details panel displays the live queries being executed on the host. Click on a query statement to open a panel that includes event attributes, related traces, and other relevant details.
Schema
Use the Schema tab to explore database structures, tables, columns, data types, existing foreign keys, and indexing strategies for every database on a host.
Blocking queries
On the Blocking Queries tab of host details panel, you can view visualizations for:
- blocking query durations
- blocking query executions
- the number of waiting queries
You can search and filter the queries or samples. Click any individual query row to view details.
Calling services
On the Calling Services tab of the host details panel, you can view the list of services that have called the host. The displayed service information includes when the service was deployed, the number of requests made to the host per second, how many database queries were executed, and more.
Click any service row to view its APM dashboard.
Configuration details
The Configuration tab of the host details panel provides a direct view into the host’s configuration parameters without compromising database security. Use it to identify misconfigured database parameters and adjust settings to optimize database performance.
