Monitoring

Disk Space Utilization

0

This post will show how to query the host_resources, disk_storage and storage_usage system tables to determine compressed disk space utilization for nodes or hosts in Vertica.

host_resources

The host_resources system table shows the free disk available, disk space used, and total free disk available. The columns for determining disk space utilization in this table are:

Column Name Description1
disk_space_free_mb Free disk space available, in megabytes, for all storage location file systems (data directories)
disk_space_used_mb Disk space used, in megabytes, for all storage location file systems
disk_space_total_mb Total disk space, in megabytes, for all storage location file systems.

disk_storage

For the disk_storage system table, the space used and space free columns must be added to return the total used disk space. This table additionally provides the type of information stored in a location (data, temp, user, catalog), its throughput, latency, and storage status2.

The following query will return the disk space details at the node level for data and temp file types.

storage_usage

The storage_usage system table seems to provide the most granularity by showing the path, device, and file system for each node3. The used_bytes and free_bytes must be added and converted to a larger order of magnitude like above. This table may be most useful for monitoring disk space storage, as it already provides a percent of storage in use. The query below looks specifically at the Vertica file system.

1 HOST_RESOURCES Documentation

2 DISK_STORAGE Documentation

3 STORAGE_USAGE Documentation

About the author / 

Norbert Krupa

Norbert is the founder of vertica.tips 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

  • 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.

Notice

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: