Viewing SQL statistics in the Performance Insights dashboard - Amazon Aurora
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Viewing SQL statistics in the Performance Insights dashboard

In the Performance Insights dashboard, SQL statistics are available in the Top SQL tab of the Database load chart.

To view SQL statistics

  1. Open the Amazon RDS console at https://console.amazonaws.cn/rds/.

  2. In the left navigation pane, choose Performance Insights.

  3. At the top of the page, choose the database whose SQL statistics you want to see.

  4. Scroll to the bottom of the page and choose the Top SQL tab.

  5. Choose an individual statement (Aurora MySQL only) or digest query.

    Viewing metrics for running queries

  6. Choose which statistics to display by choosing the gear icon in the upper-right corner of the chart. For descriptions of the SQL statistics for the Amazon RDSAurora engines, see SQL statistics for Performance Insights.

    The following example shows the preferences for Aurora PostgreSQL.

    Preferences for metrics for running queries for Aurora PostgreSQL DB instances

    The following example shows the preferences for Aurora MySQL DB instances.

    Preferences for metrics for running queries for Aurora MySQL DB instances.

  7. Choose Save to save your preferences.

    The Top SQL table refreshes.