Viewing SQL statistics in the Performance Insights dashboard - Amazon Relational Database Service

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. 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 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 RDS engines, see SQL statistics for Performance Insights.

    The following example shows the statistics preferences for Oracle DB instances.

    
                    Preferences for metrics for running queries for Oracle DB instances

    The following example shows the preferences for MariaDB and MySQL DB instances.

    
                    Preferences for metrics for running queries for MariaDB and MySQL DB instances.
  7. Choose Save to save your preferences.

    The Top SQL table refreshes.

    The following example shows statistics for an Oracle SQL query.

    
                    Statistics for a SQL query