Question

AWS release "Redshift Utilities"

  • 12 February 2015
  • 0 replies
  • 74 views

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.




























Script Purpose
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


0 replies

Be the first to reply!

Reply