Database¶

The Database view provides a centralized Explorer for monitoring key metrics of various infrastructure databases supported by DataKit, including MySQL, SQL Server, PostgreSQL, Oracle, etc. It displays metrics such as version, uptime, load trends, and blocking rate.

Data Display¶

The Database Explorer provides multiple professional analysis views based on lists and charts.

Data List¶

The database list page displays the core status of each instance in a card-style row. An icon corresponding to the database type is displayed before the database address for quick identification of database types such as MySQL, PostgreSQL, Oracle, SQL Server, MongoDB, etc.

The list field descriptions are as follows:

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 detail 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 navigation.

Overview¶

The Overview page displays the core operational status of the database instance. The top of the page shows the instance name, version, uptime, slow query log status, and host information, helping you quickly locate the infrastructure resource where this database instance resides.

Execution Count / Total Execution Time¶

The left Y-axis uses a bar chart to display the total number of query executions within the time interval. The right Y-axis uses a line chart to display the total execution time of all queries within the time interval.

Top 5 Queries¶

Displays the top queries sorted by total execution time, including the query statement, execution count, average execution time, total execution time, and performance cost percentage. Click on any query to enter the Query Overview to view details.

• Sorted in descending order of total execution time by default.
• Click on any row to enter the Query Overview slide-out page.

Key Metrics¶

1. Query Wait State Distribution

Displays the distribution of wait events for current database sessions in a donut chart, aggregated by wait state dimension.

2. Load Trend Chart by Wait Type

A bar chart displays the database load distribution by wait type dimension, intuitively showing the proportion changes of various load types such as Idle, CPU, Application, System I/O, etc.

3. Key Resource Metrics

Displays the core resource consumption trends of the node where the database resides, including:

• CPU: CPU usage, CPU load
• Disk: Disk read/write time, bytes read/written per second, IOPS, disk usage
• Network: Network traffic/sec, network packets/sec
• Memory: Memory usage, memory consumption

Metrics¶

Displays the full range of database performance metrics in visual charts, including core metrics such as session count, response time, cache hit rate, tablespace usage, PGA memory, etc.

Query¶

Focuses on SQL performance analysis, helping to identify slow queries and performance bottlenecks.

The top displays load trend charts aggregated by three dimensions: wait type, database, and user. Below is the query list, showing the execution count, average execution time, total execution time, and performance cost percentage for each SQL statement, supporting sorting by various dimensions.

• Click on any query to enter the Query Overview slide-out page, where you can view the SQL statement, performance trend charts, and sampling records.
• Click on 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 load trend charts aggregated by three dimensions: wait type, database, and user. The vertical axis represents the number of active sessions at the corresponding time point.
• Below is the snapshot list, displaying session data aggregated by collection time points, including key metrics such as current connection count, wait event distribution, number of waiting connections, involved users, and average execution time.
  • Click on a snapshot to expand and view details. After expansion, it shows statistical summaries of root blocking session count and waiting query count, as well as a detailed session list.
  • Provides a "Show only blocking connections" filter switch:
    • Top right of the snapshot list: Globally filters snapshots with blocking activity.
    • Top right after expanding snapshot details: Only displays sessions related to blocking in the current snapshot.

Click on a query statement in the session list to further drill down and view detailed SQL performance data.

Log¶

View log data related to the database, including slow query logs, error logs, etc.

Table¶

View database table structure information. Switch the target database via the Database dropdown, or search for table names in the search box.

The list displays all tables under the current database, including table name, column count, primary key, engine, row format, and creation time. Click on a table name to expand and view the field structure details of that table.

Extended Fields¶

Displays the complete metadata of the instance in key-value pair format, supporting searching by field name or value.

Custom Views¶

A unified collection for user-defined views, supporting the addition of new views.