USER_AUDITS

Lists the results of database and object size audits generated by users calling the AUDIT function.

Lists the results of database and object size audits generated by users calling the AUDIT function. See Monitoring database size for license compliance 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