Analyzing Workloads

If queries perform suboptimally, you can get tuning recommendations for them, as well as for hints about optimizing database objects, by using the Workload Analyzer (WLA). WLA is a Vertica utility that analyzes system information in Vertica system tables.

WLA identifies the root causes of poor query performance through intelligent monitoring of query execution, workload history, resources, and configurations. It then returns a set of tuning recommendations based on statistics, system and data collector events, and database/table/projection design. You can use these recommendations to tune query performance, quickly and easily.

You can run WLA in two ways:

• Call the Vertica function ANALYZE_WORKLOAD.
• Use the Management Console interface.

See Understanding WLA Triggering Conditions for the most common triggering conditions and recommendations.