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/
(7 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
WLM types: | WLM types: | ||
− | * Automatic (default) | + | * Automatic (default) (Sep 2019 <ref>https://aws.amazon.com/about-aws/whats-new/2019/09/amazon-redshift-announces-automatic-workload-management-and-query-priorities/</ref>) |
* Manual | * 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]]: | ||
+ | ** <code>WLMQueueLength</code> | ||
+ | ** <code>WLMQueueWaitTime</code> | ||
+ | ** <code>WLMQueriesCompletedPerSecond</code> | ||
== See also == | == See also == |
Latest revision as of 11:19, 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[edit]
- 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: