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:


Related Posts

  • July 27, 2015 License Audit Calculation Change in 7.1.2 As of version 7.1.2, the license audit calculation has changed to no longer include a 1-byte cost for delimiters. Vertica continues to […]
  • October 23, 2013 Disk Space Utilization This post will show how to query the host_resources, disk_storage and storage_usage system tables to determine compressed disk space […]
  • January 25, 2014 Table Size This post will show how to get the compressed size of Vertica tables from column_storage and projection_storage system tables in the […]
  • July 28, 2015 Estimating the Compression Ratio for a Vertica Schema Depending on the size of your database it may take a long time for the audit function to complete. HP Vertica cautions against doing a […]
  • January 4, 2014 Using Query Labels In an earlier post, I wrote about the importance of using stream names for COPY loads in Vertica. This post continues on that topic with […]
  • December 5, 2013 Data Collector Tables There exist tables in Vertica which give very granular historical resource information. While the collection tables themslves reside in […]

About Norbert Krupa

Norbert is the founder of and a Solutions Architect at HP Vertica. 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

%d bloggers like this: