ISSUE WITH AUDITING

Joseph

When we run the audit with schema granularity level, the license size of schema 'ASD' is 10 TB.
command:select AUDIT('ASD', 'schema');

However, when we run the audit on the schema with table granularity level, the sum of the sizes of tables is only 4TB command:select AUDIT('ASD', 'table');

Why is there such a difference, which one is correct?

LenoyJ

Can you share your Vertica version and the query you are using to query the V_CATALOG.USER_AUDITS system table?
 
Reference:
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/LicenseManagement/AUDIT.htm#Querying
Also check out error‑tolerance & confidence‑level parameters for the audit() function in the same page.