Vertica Analytics Platform Version 10.1.x Documentation

USER_AUDITS

Lists the results of database and object size audits generated by users calling the AUDIT function. See Monitoring Database Size for License Compliance in the Administrator's Guide for more information.

Column Name Data Type Description
SIZE_BYTES

INTEGER

The estimated raw data size of the database

USER_ID

INTEGER

The ID of the user who generated the audit

USER_NAME

VARCHAR

The name of the user who generated the audit

OBJECT_ID

INTEGER

The ID of the object being audited

OBJECT_TYPE

VARCHAR

The type of object being audited (table, schema, etc.)

OBJECT_SCHEMA

VARCHAR

The schema containing the object being audited

OBJECT_NAME

VARCHAR

The name of the object being audited

AUDITED_SCHEMA_NAME
VARCHAR

The name of the schema on which you want to query HISTORICAL data.

After running audit on a table, you can drop the table. In this case, object_schema becomes NULL.

AUDITED_OBJECT_NAME
VARCHAR

The name of the object on which you want to query HISTORICAL data.

After running audit on a table, you can drop the table. In this case, object_name becomes NULL.

LICENSE_NAME

VARCHAR

The name of the license. After running a compliance audit, the value for this column is always vertica.
AUDIT_START_TIMESTAMP

TIMESTAMPTZ

When the audit started

AUDIT_END_TIMESTAMP

TIMESTAMPTZ

When the audit finished

CONFIDENCE_LEVEL_PERCENT

FLOAT

The confidence level of the size estimate

ERROR_TOLERANCE_PERCENT

FLOAT

The error tolerance used for the size estimate

USED_SAMPLING

BOOLEAN

Whether data was randomly sampled (if false, all of the data was analyzed)

CONFIDENCE_INTERVAL_LOWER_BOUND_BYTES

INTEGER

The lower bound of the data size estimate within the confidence level

CONFIDENCE_INTERVAL_UPPER_BOUND_BYTES

INTEGER

The upper bound of the data size estimate within the confidence level

SAMPLE_COUNT

INTEGER

The number of data samples used to generate the estimate

CELL_COUNT

INTEGER

The number of cells in the database