Database¶

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, Oracle, etc., including version, uptime, load trends, blocking rate, and more.

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. The corresponding type icon is displayed before the database address for quick identification of database types such as MySQL, PostgreSQL, Oracle, SQL Server, MongoDB, etc.

The list fields are described as follows:

Time Widget¶

In the upper right corner of the explorer, you can select data from 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 such as the overview, queries, sessions, metrics, logs, and custom associated views for that entry, avoiding repeated jumps for queries.

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 resources where this database instance resides.

Execution Count / Total Execution Time¶

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

Top 5 Queries¶

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

• By default, sorted in descending order by total time consumed.
• Click 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 form, aggregated by wait state dimension.

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

The bar chart displays the database load distribution by wait type/database/user 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 full performance metrics of the database in visual chart form, 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 locate 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 time consumed, total time consumed, and performance cost proportion for each SQL statement, supporting sorting by various dimensions.

• 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.

• In the upper right corner of the SQL statement area, click the AI optimization suggestion to invoke the TOBY AI AI side panel, which automatically performs optimization analysis for that Query.

Sessions¶

Focuses on connection sessions, lock waits, 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 Y-axis represents the number of active sessions at the corresponding time point.
• Below is the snapshot list, aggregating and displaying session data by collection time point, including key metrics such as current connection count, wait event distribution, number of waiting connections, involved users, and average execution duration.
  • Click a snapshot to expand and view details. After expansion, it displays statistical summaries of root blocking session count and waiting query count, as well as a session detail list.
  • Provides a "Show only blocking connections" filter switch:
    • Upper right corner of the snapshot list: Globally filters snapshots with blocking activities.
    • Upper right corner after expanding snapshot details: Only displays blocking-related sessions within the current snapshot.

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

Logs¶

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

Tables¶

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 the 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 form, supporting searching by field name or value.

Custom Views¶

Unified collection of user-defined views, supporting adding new views.