[slurm-users] Slurm database field for SystemCPU, UserCPU, TotalCPU

[Rémi Palancher]

Hi Simon,

Le samedi 12 mars 2022 à 00:26, Simon Gao <simon.gao at schrodinger.com> a écrit :

> HI,
>
> We export SLURM database job_table and step_table to CSV files for data analysis.
>
> Which table fields store CPU data for SystemCPU, UserCPU, TotalCPU?

I think they are the user_[u]sec, sys_[u]sec fields from the cluster step_table. The total is computed, it is the sum of these fields, as you can see here:

https://github.com/SchedMD/slurm/blob/fd6fef3e14a0c6d1484230744289749c0e4b19d0/src/plugins/accounting_storage/mysql/as_mysql_jobacct_process.c#L1063

Best,
--
Rémi Palancher
Rackslab: Open Source Solutions for HPC Operations
https://rackslab.io