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

Sentry image

See why 4M developers consider Sentry, β€œnot bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

Top comments (0)

Billboard image

Deploy and scale your apps on AWS and GCP with a world class developer experience

Coherence makes it easy to set up and maintain cloud infrastructure. Harness the extensibility, compliance and cost efficiency of the cloud.

Learn more

πŸ‘‹ Kindness is contagious

Dive into an ocean of knowledge with this thought-provoking post, revered deeply within the supportive DEV Community. Developers of all levels are welcome to join and enhance our collective intelligence.

Saying a simple "thank you" can brighten someone's day. Share your gratitude in the comments below!

On DEV, sharing ideas eases our path and fortifies our community connections. Found this helpful? Sending a quick thanks to the author can be profoundly valued.

Okay