Skip to content

Database


Database provides centralized Explorer and query analysis capabilities for various types of infrastructure database data collected by DataKit. It monitors key metrics of MySQL, PostgreSQL, Oracle, SQL Server, MongoDB, and other databases in real time, including version, uptime, load trends, and blocking rate, and supports cross-instance normalized SQL performance analysis and execution plan viewing.

Note

The DataKit collector has been updated. Contact your administrator to upgrade to the new database monitoring experience.

Data Collection

For first-time use, refer to How to collect database data, select the corresponding DataKit collector, configure database permissions, connections, and required DBM features, and verify data reporting.

Entry Points

The Database module provides two core analysis entry points for different troubleshooting scenarios:

Entry Purpose Use Cases
Explorer Single-instance view View the running status list of all database instances; click an instance to open its details and analyze its overview, queries, sessions, metrics, logs, table schema, and more.
Query Analysis Cross-instance normalized aggregation Aggregate performance data for the same business SQL across multiple instances, and use collected execution plans to analyze how the database executes it, identifying slow query bottlenecks from a global perspective.

Data List

The Explorer's data list displays the address, instance name, type, version, uptime, and other information for each database instance in one place. Click an instance to view details.

Overview

Open instance details in the Database Explorer to view basic information and a runtime overview of the instance through Overview.

Query

Use the Explorer's Query tab to analyze SQL performance for a single instance. For cross-instance aggregated queries, go to the standalone Query Analysis page.


Data Scope

Currently supported database types include:

  • MySQL
  • PostgreSQL
  • Oracle
  • SQL Server
  • MongoDB
  • Redis (Explorer only)

Execution plan collection and display are currently supported for MySQL, PostgreSQL, Oracle, SQL Server, and MongoDB. Before viewing, ensure that the corresponding execution plan data has been collected in the current environment.

Feedback

Is this page helpful?