Database¶

The Database view displays the various infrastructure database data that DataKit supports for collection. Through a centralized Explorer, you can monitor key metrics of databases such as MySQL, SQL Server, PostgreSQL, and Oracle in real time, including version, uptime, load trends, and blockage rate.

Data Display¶

The Database Explorer provides multiple professional analysis views in the form of lists and charts.

Data List¶

The database list page shows the core status of each instance in card-style rows. The corresponding type icon is displayed before the database address for quick identification of database types such as MySQL, PostgreSQL, Oracle, SQL Server, and MongoDB.

The list fields are described as follows:

Time Widget¶

In the upper-right corner of the Explorer, you can select different time ranges for data:

• Last 2 hours
• Last 6 hours
• Last 1 day
• Last 2 days

Data Details¶

Click a single data entry in the Database Explorer to slide out the corresponding details page. You can view the Summary, Queries, Sessions, Metrics, Logs, custom associated views, and other scattered data of that entry, avoiding repeated navigation.

Summary¶

The Summary page displays the core running status of the database instance. The top of the page shows the instance name, version, uptime, slow query log status, and the host it belongs to, helping you quickly locate the infrastructure resources of the database instance.

Execution Count / Total Execution Time¶

The left Y-axis shows the total execution count of all queries within the time interval as a bar chart, and the right Y-axis shows the total execution time of all queries as a line chart.

Top 5 Queries¶

Displays the top queries sorted by total execution time, including the query statement, execution count, average time, total time, and performance overhead percentage. Click any query to view details in the Query Summary.

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

Key Metrics¶

1. Query Wait Status Distribution

Displays the wait event distribution of current database sessions as a donut chart, aggregated by wait status dimension.

2. Load Trend Chart by Wait Type / Database / User

A bar chart showing database load distribution by wait type / database / user dimension, visually presenting the proportion changes of 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 is located, 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 usage

Metrics¶

Displays the full set of database performance metrics in visual charts, including session count, response time, cache hit rate, tablespace usage, PGA memory, and other core metrics.

Queries¶

Focuses on SQL performance analysis to help locate slow queries and performance bottlenecks.

The top shows a load trend chart aggregated by wait type, database, and user dimensions. Below is the query list, displaying the execution count, average time, total time, and performance overhead percentage of each SQL statement, supporting sorting by each dimension.

• Click any query to enter the Query Summary slide-out page to view the SQL statement, performance trend chart, and sample records.
• Click a sample record to drill down to the query details and view the complete log data of that sample.

• In the upper-right corner of the SQL statement area, click AI Optimization Suggestions to invoke the Obsy Copilot side panel, which automatically performs optimization analysis for that Query.

Sessions¶

Focuses on connection sessions, lock waits, and blocking analysis to help diagnose concurrency conflict issues.

• The top shows a load trend chart aggregated by wait type, database, and user dimensions. The vertical axis represents the number of active sessions at the corresponding time point.
• Below is a snapshot list, aggregating session data by collection time point, including key metrics such as current connection count, wait event distribution, number of connections waiting, involved users, and average execution time.
  • Click a snapshot to expand and view details. After expansion, it shows a statistical summary of the number of root blocking sessions and waiting queries, as well as a session detail list.
  • Provides a filter toggle for "Show only blocking connections":
    • Upper-right corner of the snapshot list: globally filter snapshots with blocking activity.
    • Upper-right corner of the expanded snapshot details: only display blocking-related sessions in the current snapshot.

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

Logs¶

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

Tables¶

View database table structure information. Switch the target database using the Database dropdown, or search for a table name in the search box.

The list shows all tables in the current database, including table name, number of columns, primary key, engine, row format, and creation time. Click 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 pairs, supporting searching for field names or values.

Custom Views¶

Centrally stores user-defined views and supports adding new views.