Monitoring

System Resource Usage

0

The system resource usage tables in the v_monitor schema of Vertica provide a high level summary of memory, CPU, IO and network usage. This post will examine the CPU and IO usage, and how to establish high usage of each.

CPU Usage

The cpu_usage system table in the v_monitor schema shows the average CPU usage in percent of total CPU time (0-100) between the interval of start_time and end_time for each node1. The following query aggregates the average CPU usage at the cluster level by start time.

To look at the past 15 minutes, you can add:

For in-depth CPU usage details, you can try the cpu_aggregate_* or cpu_info_* data collector tables. Read more about the data collector tables here.

Establishing High CPU Usage

To establish high CPU usage, you can try the following query to get the top 10 highest average CPU usage over the past 24 hours. You can increase or remove the interval to get a better holistic view.

Disk IO Usage

The io_usage system table in the v_monitor schema shows the disk I/O bandwidth usage history in kilobytes read and written per second for each node2. The following query aggregates the total reads, writes and combined read/writes at the cluster level by start time.

To look at the past 15 minutes, you can add:

Establishing High IO Usage

To establish high IO usage, you can try the following query to get the top 10 highest total read/write kilobytes over the past 24 hours. You can increase or remove the interval to get a better holistic view.

For in-depth IO usage details, you can try the io_info_* data collector tables. Read more about the data collector tables here.

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: