Amazon Redshift launches enhanced query monitoring to improve query monitoring and diagnostics

Amazon Redshift now offers enhanced query monitoring capabilities, enabling you to efficiently identify and isolate performance bottlenecks. This feature provides comprehensive insights to track, evaluate, and diagnose query performance within data warehouses, eliminating the need to manually analyze system tables and logs.

Accessible through the AWS console, enhanced query monitoring allows you to view performance history for trend analysis, detect workload changes and understand how query performance has changed over time and diagnose performance issues with query profiler. You can analyze a specific timeframe and find problematic queries, review performance trends, and drill down to detailed query plans. Enhanced query monitoring relies on system views like SYS_QUERY_DETAIL and requires users to connect to the Redshift data warehouse. A regular users can view only their queries whereas administrators with SYS:MONITOR role will be able to monitor queries for the entire data warehouse.

Enhanced query monitoring is now generally available for both Amazon Redshift Serverless and Amazon Redshift provisioned data warehouses in all AWS commercial and the AWS GovCloud (US) Regions where Amazon Redshift is available. To learn more, see the documentation.