LICENSE_AUDITS

Lists the results of Vertica's license automatic compliance audits. See How Vertica Calculates Database Size in the Administrator's Guide.

Column Name Data Type Description
DATABASE_SIZE_BYTES
INTEGER

The estimated raw data size of the database

LICENSE_SIZE_BYTES
INTEGER

The licensed data allowance

USAGE_PERCENT
FLOAT

Percentage of the licensed allowance used

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

AUDITED_DATA
VARCHAR

The type of data audited, which includes regular (non-flex), flex, external, and total data