提升 Amazon Redshift 查询性能的十大技巧.pdf

1、 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.A N T 3 2 1Top 10 tips to improve query performance in Amazon RedshiftAndre HassSr.Specialist TAM AnalyticsNita ShahSr.Specialist Solution Architect-Redshift 2025,Am

2、azon Web Services,Inc.or its affiliates.All rights reserved.AgendaTop 10 Tips to improve query performance in Amazon Redshift 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.What are your Performance challenges?2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Ama

3、zon Redshift MonitoringCloud Watch MetricsQuery Monitoring RulesQuery Performance summaryQuery HistoryQuery Profiler Monitor your Amazon Redshift Queries 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Metrics-based performance thresholds for queriesQuery Monitoring Rules(QMR)quer

4、y_cpu_time -Total CPU seconds consumed by queryquery_execution_time-Elapsed time query spends executingquery_queue_time -Time query waits in queue before execution startsscan_row_count -Total rows examined before filteringActionsLOG Record to STL_WLM_RULE_ACTION tableABORT Cancel the query immediate

5、ly 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.7 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.DemoRedshift Query Performance SummaryRedshift Query Profiler 2025,Amazon Web Services,Inc.or

6、its affiliates.All rights reserved.2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Whats Next?10Physical Data Model TuningDistribution Styles Sort KeyAutomatic Table OptimizationStatistics 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Distribution style for Am