What's new at AWS 📢
⭕ #AmazonRedshift introduces query identifiers for improved query performance monitoring
⭕ The unique identifier assigned to SQL queries, which lets effectively track query performance over time and identify recurring patterns in resource-intensive queries.
⭕ This new feature, called a 'query hash', uniquely identifies SQL queries based on their textual representation and predicate values.
⭕ Query hash is a unique query signature that is generated for executed queries on a data warehouse.
⭕ With query hash, customer can investigate query performance by either performing trend analysis of queries over a period of time or comparing performance for a query across different time periods.
⭕ This feature adds two new columns to SYS_QUERY_HISTORY view:
1️⃣ user_query_hash - A hash with query literals
2️⃣ generic_query_hash - The hash without query literals.
⭕ Key note:
❎ Amazon Redshift query hash is available for both Amazon Redshift provisioned clusters and Serverless data warehouses.
📌 Explore more about Redshift SYS_QUERY_HISTORY view:
https://docs.aws.amazon.com/redshift/latest/dg/SYS_QUERY_DETAIL.html
📌 Explore more about Redshift features:
https://aws.amazon.com/redshift/features/?nc=sn&loc=2&dn=1&refid=deb887a1-f224-4899-8adc-78bb65d1b8db
Top comments (0)