System Table Updates

This section contains information on system tables updates for Vertica Analytic Database 8.1.x.

GRACE_PERIOD Column

System tables SESSIONS and USERS now include a GRACE_PERIOD column that is set by SET SESSION GRACEPERIOD and CREATE USER/ALTER USER, respectively. For general information, see Handling Session Socket Blocking in the Administrator's Guide.

Table for Auditing External Tables

System table EXTERNAL_TABLE_DETAILS records information about external tables. You can use this table to audit the amount of ORC and Parquet data you are using, which might be limited by your license.

Table for Monitoring Memory Pool Allocations

System table ALLOCATOR_USAGE provides information on memory pool allocation and usage for each Vertica node. You can use the information presented in the table to help diagnose memory pool issues.

Table for Monitoring Notifier Errors

The system table NOTIFIER_ERRORS now provides information on errors encountered by notifiers.

For More Information

See Vertica System Tables.