AWS release "Redshift Utilities"

  • 12 February 2015
  • 0 replies

Userlevel 3

Looks very useful:

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!