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, SQLServer, PostgreSQL, Oracle, including version, uptime, average query duration, slow query count, etc.
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 database in the current workspace, including host name/tag, port, uptime, version, etc.
Uses chart forms such as Top List, pie chart, treemap, and grouped table chart, based on count, last, first, count_distinct operation modes, to filter data under by conditions.
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 the basic attributes, metrics, DBM monitoring, host, and other scattered data of this entry, avoiding repeated jumps for queries.
For SQLServer, MySQL, PostgreSQL databases, you can view all Table-level information, including table name, column count, primary key, engine, row format, creation time.