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/
| (6 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 | + | 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:
WLMQueueLengthWLMQueueWaitTimeWLMQueriesCompletedPerSecond
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:
