Administration, Monitoring

License Utilization


It’s important to remain compliant with license limits and not exceed space utilization in Vertica. Space utilization for licenses are based on the raw data size. This post will briefly cover the mechanisms for getting license usage and the uncompressed database size.

To calculate the raw uncompressed size for licensing, execute SELECT AUDIT('');. Note that Vertica automatically performs an audit at the set audit time. The audit time can be retrieved from SELECT GET_AUDIT_TIME(); and set with SELECT SET_AUDIT_TIME('11:59 PM');. To get the result of the most recent audit, execute SELECT GET_COMPLIANCE_STATUS();.

For license information, execute SELECT DISPLAY_LICENSE();.

The results of license audits are stored in the license_audits table in the v_catalog schema. The following query will return the 30 most recent rows with uncompressed database size, license size, usage percent and the audit time.

To get an estimated distribution of raw data size based on the license audit, I take the ratio between the uncompressed and compressed database size and apply it across the projection_storage table against super-projections only:


About the author / 

Norbert Krupa

Norbert is the founder of and a Solutions Engineer at Talend. He is an HP Accredited Solutions Expert for Vertica Big Data Solutions. He has written the Vertica Diagnostic Queries which aim to cover monitoring, diagnostics and performance tuning. The views, opinions, and thoughts expressed here do not represent those of the user's employer.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.


This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.
%d bloggers like this: