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 11: | Line 11: | ||
* [[Amazon Redshift metrics]]: | * [[Amazon Redshift metrics]]: | ||
| − | ** WLMQueueLength | + | ** <code>WLMQueueLength</code> |
| − | ** WLMQueueWaitTime | + | ** <code>WLMQueueWaitTime</code> |
| − | ** WLMQueriesCompletedPerSecond | + | ** <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:
