Vertica provides an application programming interface (API) for monitoring various features and functions within a database in the form of system tables. These tables provide a set of views that let you monitor information about your system’s resources, background processes, workload, and performance, allowing you to more efficiently profile, diagnose, and view historical data.
System Tables and SchemasVertica stores system tables in the following schemas:
Using System Tables
Vertica collects and retains information stored in the system tables automatically, so you do not have to manually set anything.
You query the system tables the same way you perform query operations on base tables or temporary tables – by using SELECT statements.
You can use expressions, predicates, aggregates, analytics, subqueries, and joins. You can also save system table query results into a user table for future analysis.
System Table OrganizationMost of the system tables are grouped into the following categories:
- System information
- System resources
- Background processes
- Workload and performance
Learn MoreTo view a list of all Vertica system tables, see the following topics in the Vertica core documentation:
V_CATALOG Schema System Tables
V_MONITOR Schema System Tables