How to obtain Explain Plans for Amazon Redshift queries?
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:
