Troubleshooting Vertica Query Performance with System Tables

Posted August 29, 2016 by Sarah Lemaire, Manager, Vertica Documentation

Designers discussing project in office sample library

Do you want to learn how to troubleshoot your query performance issues?  We’ve got you covered. Just attend the Query Performance Tuning and Troubleshooting Issues session at Vertica’s Big Data Conference.

Can’t attend the conference? We’ve got that covered, too. The same Best Practices engineers from the conference have put together a comprehensive list of SQL statements that query Vertica system tables and return query performance data. 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.

Paper copies of these documents will be available at the Big Data Conference.