kerbelp/redshift-utils

A repo for Redshift utilities

redshift-utils

A repo for different Redshift utilities that you might find helpful.

AWS have a great repo with great Redshift utilities. You should check it out: https://github.com/awslabs/amazon-redshift-utils

This repo contains more useful queries and views that I use on a daily basis.

All views assume you have a schema called admin.

Query/View	Description
capacity_usage.sql	View for overall capacity usage
copies_run_time.sql	Query displaying yesterdays average copy runtime in seconds
current_locks.sql	Query displaying current locks
open_sessions.sql	Query displaying open sessions
running_queries.sql	Query displaying runninq queries
select_run_time.sql	Query displaying yesterdays average select query runtime in seconds
stl_load_errors.sql	Query displaying stl_load_errors by error by day
v_encoded_columns_percentage.sql	View for displaying percentage of encoded columns
v_table_locks.sql	View for displaying locks by users
v_tables_to_vacuum.sql	View for displaying recommended tables to vacuum
v_usage_by_schema.sql	View for displaying space usage by schema
v_usage_by_table.sql	View for displaying space usage by table
v_users_groups.sql	View for displaying users and groups
v_vacuum_jobs_summary.sql	View for displaying vacuum status