Return
-
Title
How to obtain Explain Plans for Amazon Redshift queries? -
Description
How to obtain Explain Plans for Amazon Redshift queries?
-
Resolution
Amazon Redshift doesn’t support EXPLAIN ANALYZE (unlike other data sources). This means that Toad can’t fetch execution statistics for visualization. We can however analyze queries via the Editor as I’ve shown below. Amazon Redshift Query Editor provides the same text-based EXPLAIN output.
See below as an example:
