Business Team Meeting Discussion Working Concept
dbadmin=> SELECT start_time,
dbadmin-> AVG(average_cpu_usage_percent) AS avg_cpu_usage
dbadmin-> FROM v_monitor.cpu_usage
dbadmin-> WHERE start_time BETWEEN NOW() - INTERVAL '24 hours' AND NOW()
dbadmin-> GROUP BY start_time
dbadmin-> ORDER BY AVG(average_cpu_usage_percent) DESC
dbadmin-> LIMIT 5;
start_time | avg_cpu_usage
---------------------+---------------
2018-04-02 02:00:00 | 6.23
2018-04-01 23:59:00 | 5.94
2018-04-02 04:02:00 | 2.48
2018-04-01 21:57:00 | 2.18
2018-04-02 03:05:00 | 2.16
(5 rows)
Have Fun!
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
