Profiling Database Performance
You can profile database performance to evaluate how efficiently queries execute. For example, profiles can provide the following information:
- How much memory and how many threads each operator is allocated.
- How data flows through each operator at different points in time during query execution.
- Whether a query is network bound.
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.