Statement Insight (PREVIEW)

Statement Insight provides multi-dimensional analysis of SQL resource consumption for your instances. It breaks down Request Unit (RU) consumption, latency, and execution counts by DB User, DB, Table, SQL Type, or SQL Digest, with leaderboards and trend charts that surface your top contributors at a glance. Use Statement Insight to establish RU and performance baselines from historical data and pinpoint what is driving RU consumption or slowdowns.

Statement Insight is a historical, baseline-oriented view.

Before you begin

Because Statement Insight only starts collecting data after it is enabled for your instance, keep the following in mind when you first open the page:

• No historical data is backfilled. You only see data from the time the feature was activated on your instance.
• The available time range grows day by day. For example, you see about one day of data after the feature has been running for a day.

Open Statement Insight

1. Log in to the TiDB Cloud console and navigate to your instance.
2. In the left navigation pane, click Monitoring > Diagnosis.
3. On the Diagnosis page, click the Statement Insight tab.

Set filters

Use the filters at the top of the page to narrow down the data:

• Time range: select a preset interval or a custom range.
• DB User: filter by the database user that executed the SQL statements.
• SQL Type: filter by SQL statement type, such as SELECT, INSERT, or UPDATE.
• Database: filter by the database that the SQL statements ran against.
• Table: filter by the table that the SQL statements ran against.
• Keyword: filter by a keyword that matches the SQL digest text.

All filters can be combined to narrow the analysis to the SQL statements you care about.

Analyze RU consumption, latency, and execution counts

The Top Contributors panel summarizes the SQL statements that match your filters, sliced by multiple dimensions. For each dimension, you can switch the Measured by control to change which metric drives both the leaderboard and the trend chart:

• Total RU: the sum of RU consumed.
• Mean RU: total RU divided by execution count.
• Total latency: the sum of execution latency.
• Mean latency: total latency divided by execution count.
• Execution count: the number of times the SQL statements were executed.

Top contributors by DB user, SQL type, SQL digest, DB, and table

For each dimension (DB User, SQL Type, SQL Digest, DB, or Table), the panel shows:

• Total count: the total number of distinct values for the dimension among the selected SQL statements. For example, the total number of distinct DB users that ran the selected SQL statements.
• Top values: the top values ranked by the metric selected in Measured by. For example, if Measured by is set to Total RU, the panel shows the top DB users, SQL types, SQL digests, DBs, or Tables that consumed the most RU.

Trend charts

The Resource Usage Over Time trend chart shows how the selected metric changes over time for the dimension you are viewing.

Limitations

• Statement Insight is intended for historical analysis and RU or performance baselining. The displayed RU differs from the RU usage reported on your TiDB Cloud invoice due to differences in data collection and aggregation (Statement Insight displays cumulative RU consumption). Do not use Statement Insight data for billing reconciliation.
• Data freshness interval is up to 10 minutes, matching the underlying collection cycle.

FAQ

Why is there no data, or only a short time range of data, in Statement Insight?

Statement Insight does not backfill historical data. Data starts accumulating from the moment the feature is enabled on your instance, and the available time range grows over time. If the feature was enabled for your instance recently, this is expected behavior, not a sign of missing or broken data.

What is the difference between Statement Insight and Top RU?

Top RU is a near-real-time tool for diagnosing an ongoing RU spike: it ranks SQL statements by cumulative RU consumption and focuses on the top RU-consuming SQL statements and key fields, including statements that are still executing, over a short, recent time window.

Statement Insight is a historical analysis tool. It collects and displays a larger volume of SQL statements (up to 3,000 SQL digests per collection interval) along with more detailed fields, and helps you understand RU consumption, latency, and execution count trends over a longer time range, broken down by DB User, SQL Type, SQL Digest, DB, or Table, so that you can establish RU and performance baselines and identify sustained optimization opportunities.

Is the RU shown in Statement Insight the same as the billed RU?

No. Statement Insight is intended for observability and optimization, not billing. For billing and cost management, refer to your TiDB Cloud billing console.