Looks very useful: https://github.com/awslabs/amazon-redshift-utils
Redshift Admin Scripts
Scripts objective is to help on tuning and troubleshooting.
If you are using psql, you can use \i <script.sql> to run.
|top_queries.sql||Return the top 50 most time consuming statements in the last 7 days|
|perf_alerts.sql||Return top occurrences of alerts, join with table scans|
|filter_used.sql||Return filter applied to tables on scans. To aid on choosing sortkey|
|commit_stats.sql||Shows information on consumption of cluster resources through COMMIT statements|