Query to check CPU and Memory Usage

  • Document ID:KM03604332
  • Creation Date:01-Mar-2020
  • Modified Date:01-Mar-2020
    • Micro Focus Products:
      vertica

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

Query to check CPU and Memory usage sorted in a descending order

Question

Query to check CPU and Memory usage sorted in a descending order


Answer

QUERY FOR MEMORY

select * from memory_usage where end_time between '2020-01-04 17:10:00' and '2020-01-04 17:30:00' order by average_memory_usage_percent desc ;

QUERY FOR CPU

select * from cpu_usage where end_time between '2020-01-04 17:10:00' and '2020-01-04 17:30:00' order by average_cpu_usage_percent desc ;