Version Release History
Platform Requirements

YMatrix

Quick Start

Standard Cluster Deployment

Data Modeling

Connecting to The database

Data Writing

Data Migration

Data Query

Maintenance and Monitoring

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

scenario

Workload Analysis

This document describes the workload analysis feature in the YMatrix graphical user interface.

Query execution history is a critical resource in daily database operations. It provides deep insights into the behavior of the database system, enabling users to extract valuable information for performance tuning, troubleshooting, resource management, capacity planning, and query optimization. This ensures stable and efficient operation of the database system.

1 Entry Point

2 Overview

Click Overview and select a database to drill down into the types of SQL statements executed on that database. The larger the area, the higher the execution count for that type of SQL. The same principle applies to the treemap view Execution Time.

You can view query history from two perspectives: SQL Execution Count and SQL Total Execution Time. Selecting a bar displays the number of SQL executions within that time period. Each color in the bar represents a different SQL category, with categories ranked by execution frequency in descending order. By default, the top three most frequently executed SQL types are displayed.

Hovering over a specific SQL category shows its execution count and highlights the same SQL category across other time periods, helping identify problematic or optimization-targeted SQL statements.

Select a SQL category and click Details to locate the corresponding SQL statements in the table. The details table supports sorting by total execution count, total execution time, and other metrics.

Clicking on a specific SQL entry reveals additional details for further analysis.

3 Configuration

Allows modification of data collection parameters.

← Previous
Routine Vacuuming
Next →
Statistics Query