DEV Community

Karthik Sakthivel
Karthik Sakthivel

Posted on

Amazon Redshift introduces query identifiers for improved query performance monitoring.

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)