Skip to content

Latest commit

 

History

History
 
 

AdminScripts

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Redshift Admin Scripts

Scripts objective is to help on tuning and troubleshooting. If you are using psql, you can use psql [option] -f <script.sql> to run.

Script Purpose
copy_performance.sql Shows longest running copy for past 7 days
current_session_info.sql Query showing information about sessions with currently running queries
filter_used.sql Return filter applied to tables on scans. To aid on choosing sortkey
generate_calendar.sql Creates a calendar dimension table useful for star-schema joins
missing_table_stats.sql Query shows EXPLAIN plans which flagged "missing statistics" on the underlying tables
perf_alert.sql Return top occurrences of alerts, join with table scans and SQL Text
table_alerts.sql Return top occurrences of table access related alerts
predicate_columns.sql Return Information about Predicate Columns on tables
queuing_queries.sql Query showing queries which are waiting on a WLM Query Slot
queue_resources_hourly.sql Returns hourly resources usage for WLM query queues
running_queues.sql Returns queries running and queueing and resources consumed
table_info.sql Return Table storage information (size, skew, etc)
table_inspector.sql Table Analysis based on content in Analyzing Table Design. Complements table_info.sql
top_queries.sql Return the top 50 most time consuming statements in the last 7 days
top_queries_and_cursors.sql Return the top 50 most time consuming statements in the last 7 days - include cursor text
unscanned_table_summary.sql Summarizes storage consumed by unscanned tables
wlm_apex.sql Returns overall high water-mark for WLM query queues and time queuing last occurred
wlm_apex_hourly.sql Returns hourly high water-mark for WLM query queues
wlm_qmr_rule_candidates.sql Calculate candidates for new WLM Query Monitoring rules
user_to_be_dropped_objs.sql Find objects owned by a user that cannot be dropped
user_to_be_dropped_privs.sql Find privileges granted to a user that cannot be dropped