Difference between revisions of "Amazon Redshift workload management (WLM)"
Jump to navigation
Jump to search
↑ https://aws.amazon.com/about-aws/whats-new/2019/09/amazon-redshift-announces-automatic-workload-management-and-query-priorities/
| Line 10: | Line 10: | ||
https://docs.aws.amazon.com/redshift/latest/dg/automatic-wlm.html | https://docs.aws.amazon.com/redshift/latest/dg/automatic-wlm.html | ||
| − | * [[Amazon Redshift metrics]]: WLMQueueLength | + | * [[Amazon Redshift metrics]]: |
| + | ** WLMQueueLength | ||
| + | ** WLMQueueWaitTime | ||
| + | ** WLMQueriesCompletedPerSecond | ||
== See also == | == See also == | ||
Revision as of 11:18, 31 January 2022
WLM types:
- Automatic (default) (Sep 2019 [1])
- 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
Advertising:
