使用 Performance Explorer 分析查询工作负载¶

Full access to Performance Explorer data in the account¶

You have full access to Performance Explorer data for your account when any role granted to you meets one of the following conditions:

• Your role is the ACCOUNTADMIN role.

• Your role has been granted IMPORTED PRIVILEGES on the shared SNOWFLAKE database (see 允许其他角色使用 SNOWFLAKE 数据库中的架构).

• Your role has been granted the SNOWFLAKE.PERFORMANCE_EXPLORER_USER application role.

For example, to give the user jdoe full Performance Explorer access by using a custom role, run:

USE ROLE ACCOUNTADMIN;

CREATE ROLE pe_viewer_role;
GRANT APPLICATION ROLE SNOWFLAKE.PERFORMANCE_EXPLORER_USER TO ROLE pe_viewer_role;
GRANT ROLE pe_viewer_role TO USER jdoe;

Seeing query metrics without full account access¶

If you do not have full access as described above, you can still see query activity when any role granted to you satisfies one of the following:

• Your role has been granted the GOVERNANCE_VIEWER database role in the SNOWFLAKE database (account-wide query activity).

• Your role has the MONITOR privilege on the account, or the MANAGE WAREHOUSES privilege on the account, which effectively covers all warehouses (query activity that uses warehouses).

• Your role has OWNERSHIP, MONITOR, or OPERATE on at least one warehouse (query activity only for queries that ran on warehouses you can monitor or operate). For details, see Warehouse privileges.

If none of the above apply and you cannot MONITOR or OPERATE any warehouse, Performance Explorer shows a permission error for query activity. This is intentional: without at least one authorized warehouse, no query metrics would be visible. In practice, many accounts include a default warehouse that all users can monitor; see Snowsight templates.

Warehouse filters list warehouses you are allowed to use in filters (for example, warehouses you can MONITOR or OPERATE, and in some cases warehouses that had query activity in the retention window). Warehouse-scoped visibility is similar in spirit to the rules for Query History in 使用 Query History 监控查询活动, but Performance Explorer uses all roles granted to you and combines several privilege types, so the exact rules differ.

Database filters and database-oriented breakdowns¶

To see all databases in database filters (and related aggregations by database), any role granted to you must satisfy one of the following:

• Your role meets the conditions for full access to Performance Explorer data in the account (see the preceding section).

• Your role has been granted the OBJECT_VIEWER database role in the SNOWFLAKE database.

• Your role has RESOLVE ALL on the account.

• Your role has MONITOR on the account.

Otherwise, you only see databases where any role granted to you has at least one privilege on the database. Queries can still appear in other sections even if they touch a database you cannot list, except where the UI explicitly names databases (for example, certain side-panel breakdowns).

Warehouse events¶

To see warehouse events for all warehouses that appear in your authorized query activity, any role granted to you must satisfy one of the following:

• Your role meets the conditions for full access to Performance Explorer data in the account (see the preceding section).

• Your role has been granted the USAGE_VIEWER database role in the SNOWFLAKE database.

• Your role has the MONITOR privilege on the account.

• Your role has the MANAGE WAREHOUSES privilege on the account.

Otherwise, warehouse events are limited to warehouses where you have OWNERSHIP, MONITOR, or OPERATE. If you have none of those warehouse privileges or usage-related database roles, Performance Explorer shows a permission error for warehouse events.

Top tables and table change events¶

The Top tables section and table change events require full access or the GOVERNANCE_VIEWER database role in the SNOWFLAKE database. Snowflake does not offer a lower-privilege, per-table alternative for these sections due to security and performance constraints. If you do not meet this bar, those sections show a permission error.

Empty charts, filtered results, and permission errors¶

For security reasons, an empty chart or table can mean either that there was no activity in the selected period or that your roles cannot see that activity. Tile-level permission errors call out missing privileges (for example, governance visibility for table metrics).

Privilege changes and data freshness¶

Updates to grants and revocations can take a few hours to affect what Performance Explorer shows.

Performance Explorer 筛选器¶

在 Performance Explorer 仪表板的顶部，您可以应用以下筛选器：

• Preset - Choose None or a saved combination of period, warehouse, database, and role filters. From the menu you can save the current filters as a new preset, clear all filters, copy a link that encodes the current filters, and manage saved presets (for example set or change a default preset).

  

• Period – 选择时间段，例如上周、最近两周或自定义范围。仪表板显示指定时间段的指标。

  默认情况下，Performance Explorer 显示一周的指标。它支持最长一个月的期限，可以追溯到当前日期。

  多个 Performance Explorer 图表显示了与上一时段相比的变化百分比。上一时段的范围与当前时段范围相对应。例如，如果当前时段为两周，则上一时段为当前时段开始前的两周。

• Warehouse – 选择一个仓库以仅查看使用该仓库运行的查询活动的指标。要限制列表中的仓库，请使用搜索字段。要清除筛选器，请选择 X。

• Database - Select a database to view metrics only for query activity that accessed that database. To limit the databases in the list, use the search field. To clear the filter, select X.

• Role – 选择一个角色以仅查看该角色发起的查询活动的指标。要限制列表中的角色，请使用搜索字段。要清除筛选器，请选择 X。

Performance Explorer 图表¶

Performance Explorer 以不同类型的图表显示指标。了解每种图表中的组成部分以及如何解释它们非常重要。

在 Queries 选项卡上，折线图指标 使用的折线图与下图类似：

下表描述了图中的标注：

有些图表包含较大的平均值或中位数以及该时段的变化百分比。当有多条线时，图表上方的关键信息是对应线条的说明。

有些图表的标题旁边有 information icon。将鼠标悬停在图标上可查看与图表中指标有关的信息。

您可以将鼠标悬停在折线图中的某个点上，以查看特定小时的值：

The Top warehouses section on the Warehouses tab and the Top tables section on the Tables tab have bar charts that are similar to the following image:

下表描述了图中的标注：

On both line charts and bar charts, select View details > to open a side panel that displays more detailed information about the metrics on the chart. The detailed information varies based on the metrics shown in the chart. Most side panels present sortable tables that you can use to review metrics for specific warehouses, roles, databases, and queries in the period.

Use the Search results field above the table to filter rows; search is case-insensitive and applies across the side-panel aggregation tabs (for example, By warehouse and By role). Select the download control to export the table as a CSV file. The downloaded file name reflects the chart and the active dashboard filters.

You can select a custom period of time in a side panel by clicking where the custom period starts and dragging to where the custom period ends.

In a side panel, you can select one of the following tabs:

• By warehouse - Shows the activity by warehouses in the period.

• By database - Shows the activity by databases in the period.

• By role - Shows the activity by roles in the period.

• By grouped queries - Shows the queries that were run in the period. Some queries are redacted for security reasons. For information about how queries are grouped, see 在 Snowsight 中使用分组查询历史记录视图.

If you select a custom period, these tabs refresh to show the metrics only for the selected custom period.

The Top warehouses and Top tables sections also include events charts that are similar to the following image:

事件图表显示了该对象类型的可排序事件表。您可以检查数据中是否存在意外事件。有关仓库事件的更多信息，请参阅 WAREHOUSE_EVENTS_HISTORY 视图。有关表事件的更多信息，请参阅 TABLES 视图。