Can the dashboard find SQL executed within the last 5 minutes?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: dashboard可以查到5分钟内已经执行过的sql吗

| username: chenhanneu

【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】
【Reproduction Path】What operations were performed when the issue occurred
【Encountered Issue: Problem Phenomenon and Impact】
Querying the select records of a table for 5 minutes, within the 5-minute range, it was found that an SQL was executed three times. When the time range is adjusted to 15 minutes, the same SQL cannot be found. When the range is shortened back to 5 minutes, the previously found SQL cannot be found either. What could be the reason for this?
【Resource Configuration】Enter TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
【Attachments: Screenshots / Logs / Monitoring】

| username: tidb菜鸟一只 | Original post link

Could it be because your query has been running for over 5 minutes…?

| username: xfworld | Original post link

Check this out…

| username: Fly-bird | Original post link

It can be found.

| username: Kongdom | Original post link

Could it be that after the time is magnified, this statement is no longer at the front?

| username: Kongdom | Original post link

It means that for queries within 5 minutes, check statements_summary, and for queries exceeding 15 minutes, check statements_summary_history?

| username: ti-tiger | Original post link

You can check the SQL that has been executed within the last 5 minutes.

| username: Soysauce520 | Original post link

Are you looking at SQL analysis?

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.