Profiling Database Performance

You can profile database performance to evaluate how efficiently queries execute. For example, profiles can provide the following information:

Profiling information can help you evaluate query performance and determine whether to rewrite the query. You can use profiling when considering projection design issues, such as segmentation and sort order.

The topics in this section focus on obtaining profile data via vsql statements. The Vertica Management Console also provides an easy-to-read view of query profile data.