Amazon Redshift introduces query profiler for enhanced query visibility and troubleshooting. The query profiler is a feature in the AWS console that provides a visual and graphical representation of query execution plans and statistics, letting you easily monitor, analyze, and troubleshoot query performance without the need for manual analysis of system tables and logs.
Enhanced query profiling in Amazon Redshift expands the current capabilities in the AWS console that let you monitor both running and completed queries. With the new query profiler, you can now further introspect your queries and review execution plans to discover query performance bottlenecks. The query profiler uses data from system views like SYS_QUERY_DETAIL to include performance metrics that help you optimize queries, including execution time, total input/output rows, and bytes read/written for each step of the query.
The query profiler capability 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 get started and learn more about using the query profiler, visit the Amazon Redshift database developer guide.
Source:: Amazon AWS