We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


How can I translate dc_cpu_aggregate_by_second values to cpu usage per second — Vertica Forum

How can I translate dc_cpu_aggregate_by_second values to cpu usage per second

zvika_gutkinzvika_gutkin
in General Discussion
Hi All,

I'm trying to get cpu usage per second from vertica but all system tables that has the usage are one minute avg .
When looking at 
dc_cpu_aggregate_by_second I see columns with *_microseconds_start_value and  *_microseconds_end_value.

Can I translate those numbers to cpu usage per second ?

I tried (idle_microseconds_end_value - idle_microseconds_start_value ) / cpu cores / 1000000 
but got  unrealistic numbers .

Any Idea ?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...