General discussion on using the Kognitio Analytical Platform.
Single Poster
User avatar
Posts: 1
Joined: Tue Jan 06, 2015 9:17 pm

CPU Useage

by Joe Nik » Tue Jan 06, 2015 9:21 pm

I have a manager requesting me to get CPU useage, but I am always getting 9%. I am using the SYS.IPE_CPUINFO table to get my data, and the idle % is pretty much a consant. Is this really the CPU use, or am I doign something wrong? It doesn't make sense to me for the cpu use to be constant.

Any input would be helpful.


Reply with quote Top
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: CPU Useage

by markc » Wed Jan 07, 2015 9:51 am


IPE_CPUINFO is a virtual table giving a snapshot of the system state. It includes a timestamp field, so you can insert from it into a logging table you've created, then do some work, then insert again, and look at the differences.

You can also do spot-checks of IPE_CPUINFO whilst a workload is running - for example, if you do something which e.g. skews to one node (e.g. hashing a table t1 on column c1 which always has the same value, then self-joining on that column - note you should do this on a dev/test machine rather than a production one!) and then look at IDLE_PC you will see it is likely to be 0 for one of the cores on the node the data skews to, and much higher values (typically > 90%) on cores on other nodes assuming there is no other activity.

Reply with quote Top

Who is online

Users browsing this forum: Google [Bot] and 2 guests