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: