View a markdown version of this page

Viewing SQL statistics in the Performance Insights dashboard - Amazon Aurora

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.aws.amazon.com/rds/.

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

  3. Choose the database whose SQL statistics you want to see.

  4. 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. 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.