Using System Tables to Evaluate Performance (Document)

[JimKnicely]

Here is a link to the awesome document "Using System Tables to Evaluate Performance" which is packed full of knowledge and is a must read!

This document describes Vertica system tables that contain useful information that can shed light on your query performance. When you execute a query, Vertica stores information in certain system tables. This information tells you what happens during query execution—what tasks the query is performing, what resources the query is using, and where there are any bottlenecks. Performance-tuning options for each query are different, so adapt the recommendations in this document for your own specific queries.

Get it here:

https://my.vertica.com/docs/SolutionsAr ... tables.pdf