Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Enhancement]: obdiag observer.perf_sql 收集后提示统计信息是否有效 #555

Open
askdb opened this issue Nov 14, 2024 · 0 comments
Assignees
Milestone

Comments

@askdb
Copy link

askdb commented Nov 14, 2024

在收集的报告中:

1、执行计划部分:Optimization Info 的 stats info:[version=1729605609851028, is_locked=0, is_expired=0]

  • 如果 version=0 ,表示该表没有收集过统计信息。
  • 如果该时间( select usc_to_time(1729605609851028); 和当前时间差距较大,可以提示核对一下是否有必要收集一下统计信息。

2、根据各算子的估行和吐行情况,当吐行远大于估行时,需要检查统计信息是不是过期,提示收集一把统计信息。

@Teingi Teingi self-assigned this Dec 4, 2024
@Teingi Teingi added this to the v3.0.0 milestone Dec 4, 2024
@Teingi Teingi modified the milestones: v3.0.0, v3.1.0 Dec 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants