DATABASE¶
The DATABASE display covers various infrastructure database data supported by DataKit collection. Through a centralized Explorer, it provides real-time monitoring of key metrics for databases such as MySQL, SQL Server, PostgreSQL, and Oracle, including version, uptime, average query duration, slow query count, and more.
Note
The DataKit collector has been updated. Please contact your administrator to upgrade the version to enable the new DATABASE monitoring experience.
Data Display¶
The DATABASE Explorer provides multiple professional analysis views based on lists and charts.
Displays the latest metric data (within the last 2 days) for the corresponding databases in the current workspace, including database address, database type, version, uptime, QPS, average query duration, slow query count, and other data.
Uses chart forms such as Top List, pie chart, treemap, and grouped table chart to filter data under by conditions based on operation modes like count, last, first, and count_distinct.
Data List¶
Time Widget¶
In the upper right corner of the Explorer, you can select data for different time ranges, including:
- Last 2 hours
- Last 6 hours
- Last 1 day
- Last 2 days
Data Details¶
Click on a single data entry in the DATABASE Explorer to slide out the corresponding details page. You can view scattered data for that entry, such as Overview, Query, Session, Metrics, Log, and custom associated views, avoiding the need for repeated jumps and queries.
Overview¶
The Overview page displays the core operational status of the database instance:
| Field | Description |
|---|---|
| Version | Database version number |
| Uptime | Database continuous runtime (e.g., 1 month) |
| Region | Database region |
| Slow Query Log | Slow query log enablement status |
Tags¶
1. Load Trend Chart
Load trend chart displayed by wait type, database, and user dimensions.
The Average Load chart includes the following dimensions:
- Load trend chart by wait type: Idle, CPU, Application, System I/O, etc.
- Load trend chart by database: Load distribution across databases/PDBs.
- Load trend chart by user: Session load situation for each user.
2. High-Frequency Query List
Displays Top queries sorted by total duration, including execution count, average duration, total duration, and performance cost percentage. Click on any query to enter the Query Overview for details.
| Field | Description |
|---|---|
| Query Statement | SQL statement summary |
| Execution Count | Total execution count of this query |
| Average Duration | Average duration per execution |
| Total Duration | Total execution duration of this query |
| Performance Cost Percentage | Current query total duration / Sum of all queries total duration |
- Default sorting is by total duration in descending order.
- Click any row to enter the Query Overview slide-out page.
Extended Attributes¶
Displays the complete metadata of the instance in key-value pair format, supporting search by field name or value.
Metrics¶
Displays the full range of database performance metrics in visual chart form, including core metrics such as session count, response time, cache hit rate, tablespace usage, PGA memory, and more.
Query¶
Focuses on SQL performance analysis, helping to locate slow queries and performance bottlenecks.
The top displays a three-dimensional load trend chart, and below is the Query list, supporting sorting by dimensions such as execution count and duration.
- Click any query to enter the Query Overview slide-out page, viewing the SQL statement, performance trend chart, and sampling records.
- Click a sampling record to drill down to the Query Details, viewing the complete log data for that sample.
Session¶
Focuses on connection session, lock wait, and blocking analysis, helping to diagnose concurrency conflict issues.
- The top displays a three-dimensional load trend chart.
-
Below is the snapshot list, which packages and displays session data from the same collection time point.
-
Supports expanding to view details. Provides a "Show only blocking connections" filter switch to quickly locate blocking issues.
-
After expanding a snapshot, session details are displayed, automatically identifying Root Blocker (blocking source) and Waiter (blocked sessions), and supports the "Show only blocking activity" filter.
-
Log¶
View database-related log data, including slow query logs, error logs, etc.
Custom View¶
Unified collection of user-defined views, supporting the addition of new views.