Sun N1 Grid Engine 6.1 User's Guide

sge_job_usage

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.