The purpose of this document is to help you monitor your Vertica database. The document is categorized into sections of query execution. You can use the queries in this document to investigate and troubleshoot database issues by monitoring the queries. This document describes queries and techniques for monitoring the following areas of your Vertica database:
- System health
- Resource usage
- Active sessions
- Active transactions
- Recovery
- Rebalance
- Historical activities
- Object statistics
- Query performance
- Monitor DC tables
Continue reading here:
https://my.vertica.com/kb/Best-Practice ... ertica.htm