The sge_job_usage table holds the job's resource usage over time.
For N1GE 5.3 systems, only one record exists per finished job, array task and parallel task. The ju_curr_time column holds the job's end time (j_end_time in sge_job).
For N1GE 6.0 systems, the online usage is stored as well; this results in multiple records for one job, array task, and parallel task stored in sge_job. The resource usage of a job can be monitored over time (ju_curr_time), the last record per job, array task, or parallel task holds the total usage that can be used in accounting, ju_curr_time for this record will equal j_end_time from sge_job.
Column |
Type |
Description |
---|---|---|
ju_id |
Integer |
Unique record identifier |
ju_parent |
Integer |
Reference to sge_job table |
ju_curr_time |
Integer |
current time for usage |
ju_qname |
text |
Name of the queue the job was running in. In N1GE 6.0 systems this will be the cluster queue name. References to queues in the queue table. |
ju_hostname |
text |
Name of the host the job was running on. References to hosts in the host table. |
ju_start_time |
timestamp |
Time when the job was started. |
ju_end_time |
timestamp |
Time when the job finished. |
ju_failed |
integer |
if != 0 indicates a problem |
ju_exit_status |
integer |
exit status of the job |
ju_granted_pe |
text |
The parallel environment which was selected for that job. |
ju_slots |
integer |
The number of slots which were dispatched to the job. |
ju_state |
text |
job state |
ju_ru_wallclock |
integer |
end_time – start_time |
ju_ru_utime |
double |
user time used |
ju_ru_stime |
double |
system time used |
ju_ru_maxrss |
integer |
maximum resident set size |
ju_ru_ixrss |
integer |
currently 0 |
ju_ru_ismrss |
integer | |
ju_ru_idrss |
integer |
integral resident set size |
ju_ru_isrss |
integer |
currently 0 |
ju_ru_minflt |
integer |
page faults not requiring physical I/O |
ju_ru_majflt |
integer |
page faults requiring physical I/O |
ju_ru_nswap |
integer |
swaps |
ju_ru_inblock |
integer |
block input operations |
ju_ru_oublock |
integer |
block output operations |
ju_ru_msgsnd |
integer |
messages sent |
ju_ru_msgrcv |
integer |
messages received |
ju_ru_nsignals |
integer |
signals received |
ju_ru_nvcsw |
integer |
voluntary context switches |
ju_ru_nivcsw |
integer |
involuntary context switches |
ju_cpu |
double |
The cpu time usage in seconds. |
ju_mem |
double |
The integral memory usage in Gbytes seconds. |
ju_io |
double |
The amount of data transferred in input/output operations. |
ju_iow |
double |
The io wait time in seconds. |
ju_maxvmem |
double |
The maximum vmem size in bytes. |