AWS redshift documentation change
Summary
Added documentation for Amazon Redshift Serverless WLM configuration, restructured metrics table to include predicate names, and clarified JSON parameter usage.
Security assessment
Changes focus on feature expansion (Serverless support) and documentation clarity. No security controls or vulnerabilities are referenced; metrics and configuration updates are operational improvements without security implications.
Diff
diff --git a/redshift/latest/dg/cm-c-wlm-query-monitoring-rules.md b/redshift/latest/dg/cm-c-wlm-query-monitoring-rules.md index b0f05e880..c6306b9b9 100644 --- a//redshift/latest/dg/cm-c-wlm-query-monitoring-rules.md +++ b//redshift/latest/dg/cm-c-wlm-query-monitoring-rules.md @@ -20,0 +21,4 @@ When all of a rule's predicates are met, WLM writes a row to the [STL_WLM_RULE_A +###### Note + +For Amazon Redshift Serverless, you can configure query queues and monitoring rules using the `wlm_json_configuration` parameter. This allows you to create multiple queues with different user roles, query groups, and monitoring rules. For more information about configuring serverless query queues, see [Setting query queues](https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-workgroup-query-queues.html) in the _Amazon Redshift Management Guide_. + @@ -134,9 +138,9 @@ The following table describes the metrics used in query monitoring rules for Ama -Metric | Name | Description ----|---|--- -Blocks read | `max_query_blocks_read` | Number of 1 MB data blocks read by the query.Valid values are 0–1,048,575. -Scan row count | `max_scan_row_count` | The number of rows in a scan step. The row count is the total number of rows emitted before filtering rows marked for deletion (ghost rows) and before applying user-defined query filters. Valid values are 0–999,999,999,999,999. -Query execution time | max_query_execution_time | Elapsed execution time for a query, in seconds. Execution time doesn't include time spent waiting in a queue. If a query exceeds the set execution time, Amazon Redshift Serverless stops the query. Valid values are 0–86,399. -Query queue time | `max_query_queue_time` | Time spent waiting in a queue, in seconds. Valid values are 0–86,399. -Memory to disk | `max_query_temp_blocks_to_disk` | Temporary disk space used to write intermediate results, in 1 MB blocks.Valid values are 0–319,815,679. -Rows joined | `max_join_row_count` | The number of rows processed in a join step.Valid values are 0–999,999,999,999,999. -Nested loop join row count | `max_nested_loop_join_row_count` | The number or rows in a nested loop join.Valid values are 0–999,999,999,999,999. +Metric | WLM Predicate Name | Name | Description +---|---|---|--- +Blocks read | `query_blocks_read` | `max_query_blocks_read` | Number of 1 MB data blocks read by the query.Valid values are 0–1,048,575. +Scan row count | `scan_row_count` | `max_scan_row_count` | The number of rows in a scan step. The row count is the total number of rows emitted before filtering rows marked for deletion (ghost rows) and before applying user-defined query filters. Valid values are 0–999,999,999,999,999. +Query execution time | `query_execution_time` | max_query_execution_time | Elapsed execution time for a query, in seconds. Execution time doesn't include time spent waiting in a queue. If a query exceeds the set execution time, Amazon Redshift Serverless stops the query. Valid values are 0–86,399. +Query queue time | `query_queue_time` | `max_query_queue_time` | Time spent waiting in a queue, in seconds. Valid values are 0–86,399. +Memory to disk | `query_temp_blocks_to_disk` | `max_query_temp_blocks_to_disk` | Temporary disk space used to write intermediate results, in 1 MB blocks.Valid values are 0–319,815,679. +Rows joined | `join_row_count` | `max_join_row_count` | The number of rows processed in a join step.Valid values are 0–999,999,999,999,999. +Nested loop join row count | `nested_loop_join_row_count` | `max_nested_loop_join_row_count` | The number or rows in a nested loop join.Valid values are 0–999,999,999,999,999. @@ -152,0 +157,2 @@ Nested loop join row count | `max_nested_loop_join_row_count` | The number or r +For Amazon Redshift Serverless, you can configure query queues and monitoring rules using the `wlm_json_configuration` parameter. This allows you to create multiple queues with different user roles, query groups, and monitoring rules using the metrics listed above. For more information about configuring serverless query queues, see [WLM JSON configuration structure](https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-workgroup-query-queues.html#serverless-wlm-json-configuration) in the _Amazon Redshift Management Guide_. +