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

Upcoming Events

  • December 2, 2015 10:00 AMWebinar: Self-Service Analytics Visualization
  • December 10, 2015 10:00 AMHow HP Vertica Uses Apache Kafka and Spark
  • December 10, 2015 6:30 PMJoin the Customer Analytics Meetup @ Machine Zone
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.
%d bloggers like this: