Search code examples
sqldatabaseamazon-web-servicesperformanceamazon-redshift

Is there a AWS Redshift alternative to Athenas EXPLAIN ANALYZE

I am searching for a way to "profile" an SQL query that runs in AWS Redshift database.

Redshift does support "EXPLAIN" - which does describe the execution plan, however Athena for example supports "EXPLAIN ANALYZE" which shows data on the actual query execution.

Is there something similar for Redshift?

Notes:

  1. A solution which does not require access to the Redshift console is preferred
Solution

  • SVL_QUERY_SUMMARY and SVL_QUERY_REPORT system views may help https://docs.aws.amazon.com/redshift/latest/dg/c-analyzing-the-query-summary.html