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

• Amazon Redshift: aws redshift, aws redshift describe-clusters, aws redshift describe-events, aws redshift create-cluster
• Amazon Redshift, aws redshift, Amazon Redshift query editor, GRANT, AQUA, has schema privilege, WLM, Amazon Redshift Spectrum, metrics, VACUUM, SET

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