31.3 查询分析器用户界面

要打开查询分析器,请从导航菜单中选择查询。

图 31.1 默认查询分析器视图

默认查询分析器视图的示例。

表 31.2 默认查询分析器视图的控件

控制 描述

过滤器

查询分析器:包含以下默认系统过滤器:

  • 管理语句:过滤 GRANTREVOKERESETSETSHOWFLUSHCACHEKILLSHUTDOWN类型的语句。

  • 所有语句:(默认)未定义过滤。显示所有语句。

  • DDL 语句:过滤CREATEDROPALTERTRUNCATERENAME类型的语句。

  • DML 语句:过滤器类型为SELECTINSERTUPDATEDELETEREPLACECALLLOADDOHANDLER的语句。

  • 准备好的语句:过滤PREPAREEXECUTEDEALLOCATE类型的语句。

  • 复制语句:筛选STARTSTOPRESETCHANGE类型的语句

  • Statements with Errors :过滤Total Errors > 0的高级过滤选项。

  • Statements with Full Table Scans :在Table Scan notices 和 Total Table Scans > 0的高级过滤选项上进行过滤 。

  • Statements with Max Exec Time Over 1 Second: filters on the advanced filter options of Max Exec Time > 1.

  • Statements with Temporary Tables: filters on the advanced filter options of Total Temporary Tables > 0.

  • Statements with Temporary Tables on Disk: filters on the advanced filter options of Total Temporary Disk Tables > 0

  • Statements with Warnings: filters on the advanced filter options of Total Warnings > 0

  • Table Maintenance Statements: filters on statements of type OPTIMIZE, ANALYZE, CHECK, REPAIR, and CHECKSUM.

  • Transactional and Locking Statements: filters on statements of type BEGIN, COMMIT, ROLLBACK, SAVEPOINT, RELEASE, LOCK, and UNLOCK.

  • Customized versions of the system filters are created using the name of the filter with a -clone suffix.

Configure View

Opens the configuration view.

The Configure View enables you to customize the data displayed on the Query Analyzer view. For more information, see Section 31.5, “Query Analyzer Configuration View”.

Statements

The statements panel displays the statement data. The data displayed is configured in the Data View section of the Configuration View.

For more information, see Data View.

By default, the Statements view displays the following:

  • QRTi pie chart: visual representation of the Query Response Time index. Hover the cursor over the pie chart to see a summary of the Optimal, Acceptable, and Unacceptable QRTi percentages.

  • Query: displays the normalized query. Hover the cursor over the statement to see the full version. Or click the query to open the Details page.

  • Database: the name of the database on which the query was executed.

  • First Seen: the time and data at which this query was first seen on the database.

  • Latency: sparkline graph displaying the latency of the query. Hover the cursor over the graph to display a tooltip containing the summary of the latency.

  • Total: total amount of time spent on this query.

  • Execution Counts: number of times this query was executed.

  • Rows: number of rows affected by this query.

语句视图的所有元素都是可配置的,除了始终显示的语句本身。要显示完整的声明,请将光标悬停在声明行上。完整的声明显示在弹出窗口中。要查看报表的详细信息,请单击报表或报表面板右侧的更多选项按钮。

有关详细信息页面 的更多信息,请参阅第 31.4 节,“详细查询信息”