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 |