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:

Documentation

Related Posts

  • October 15, 2014 Set Time Based Collection Policy This quick tip shows how to set a time based collection policy for data collector tables. The method to configure the data retention […]
  • 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 […]
  • 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 […]
  • July 10, 2014 July Release of VerticaKit The July 2014 release of the VerticaKit has the following changes: Fixes calculation on nodes with less than recommended disk […]
  • 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 a Technical Consultant and founder of vertica.tips. He is an HP Accredited Solutions Expert for Vertica Big Data Solutions. He author's his own blog at jadito.us and 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.