Analyzing query execution - Amazon Redshift

Analyzing query execution

To analyze a query

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. On the navigation menu, choose Queries and loads to display the list of queries for your account. You might need to change settings on this page to find your query.

  3. Choose the Query identifier in the list to display Query details.

    The Query details page includes Query details and Query plan tabs with metrics about the query.

    Note

    You can also navigate to the Query details page from a Cluster details page, Query history tab when you drill down into a query in a Query runtime graph.

The Query details page contains the following sections:

  • A list of Rewritten queries, as shown in the following screenshot.

  • A Query details section, as shown in the following screenshot.

  • A Query details tab that contains the SQL that was run and Execution details about the run.

  • A Query plan tab that contains the Query plan steps and other information about the query plan. This table also contains graphs about the cluster when the query ran.

    • Cluster health status

    • CPU utilization

    • Storage capacity used

    • Active database connections