Troubleshooting Vertica Query Performance with System Tables

This is the second document in the three part series on performance tuning, containing these articles:

Part 1: Reading Query Plans

Part 2: Troubleshooting Vertica Query Performance with System Tables

Part 3: Redesigning Projections for Query Optimization

We've provided a detailed description of each data set--how to analyze the results and what steps you need to take to improve query performance based on those results.

You can download a detailed PDF that explains the analysis in detail, or you can download a PDF that just lists the queries and what problem they're trying to solve. Choose which document best suits your needs, or download them both.