Amazon Redshift workload management (WLM)

• https://docs.aws.amazon.com/redshift/latest/dg/c_workload_mngmt_classification.html

WLM types:

• Automatic (default) (Sep 2019 )
• Manual

select * from stv_wlm_service_class_config where service_class >= 100;
https://docs.aws.amazon.com/redshift/latest/dg/automatic-wlm.html

• Amazon Redshift metrics:
  • WLMQueueLength
  • WLMQueueWaitTime
  • WLMQueriesCompletedPerSecond

See also

• aws redshift [ describe-clusters | describe-events | create-cluster ]
• Amazon Redshift, aws redshift, Amazon Redshift query editor, AQUA, WLM, Amazon Redshift Spectrum, metrics, VACUUM, Amazon RedShift Management Guide

https://aws.amazon.com/about-aws/whats-new/2019/09/amazon-redshift-announces-automatic-workload-management-and-query-priorities/