Working with the experts at AWS, we augmented our existing Redshift Administration Block to include performance optimization views, explores and dashboards. We’ve also included a guide to help users identify and diagnose performance issues, as well as suggested actions to take based on those issues. We include several pieces of analysis:
Based on the information provided by the query inspector, users should take corrective action to improve query performance. In this Block, we have a matrixed guide offering remedial actions for poorly performing queries.