Accounting records for jobs, array tasks, and tightly integrated tasks. Contains only finished jobs.
Column |
Type |
Description |
---|---|---|
job_number |
integer |
Job number |
task_number |
integer |
Array task id |
pe_taskid |
text |
ID of a tightly integrated parallel task |
name |
text |
job name (script name or value set with the submit option -N) |
groupname |
text |
UNIX group name of the primary group the job was executed in. References the group table. |
username |
text |
UNIX user account the job was running in. References the user table. |
account |
text |
Account string set with the submit option -A |
project |
text |
Project, References the project table |
department |
text |
Department, References the department table |
submission_time |
timestamp |
Time of the job submission |
start_time |
timestamp |
Time when the job was started |
end_time |
timestemp |
Time when the job finished |
wallclock_time |
integer |
end_time - start_time |
cpu |
double |
The CPU time usage in seconds |
io |
double |
The amount of data transferred in input/outputoperations |
iow |
double |
The io wait time in seconds |
maxvmem |
double |
The maximum vmem size in bytes |
wait_time |
integer |
start_time - submission_time |
turnaround_time |
integer |
end_time - submission_time |
This is the same as view_accounting, but no tasks of tightly integrated parallel jobs are listed.
Finished jobs per hour, one record per hour.
Column |
Type |
Description |
---|---|---|
completed |
integer |
Completed jobs |
time |
timestamp |
Time when the jobs finished |
Job logging (e.g. Submission, state changes, job finish).
Column |
Type |
Description |
---|---|---|
job_number |
integer |
Job number |
task_number |
integer |
Array task id |
pe_taskid |
text |
ID of a tightly integrated parallel task |
name |
text |
job name (script name or value set with the submit option -N) |
username |
text |
UNIX group name of the primary group the job was executed in. References the group table |
account |
text |
UNIX user account the job was running in.References the user table |
project |
text |
Project. References the project table |
department |
text |
Department. References the department table |
time |
timestamp |
Time when the job logging entry was generated |
event |
text |
Event being recorded |
state |
text |
Job state after the reported event |
initiator |
text |
User who initiated action for the event |
host |
text |
Host on with the event action was initiated |
message |
text |
A message explaining what happened |
Department specific variables.
Column |
Type |
Description |
---|---|---|
department |
text |
Name of the department |
time_start |
timestamp |
Start time for the validity of a value |
time_end |
timestamp |
End time for the validity of a value |
variable |
text |
Variable name, e.g. h_sum_jobs |
str_value |
text |
Variable value, e.g. 5 |
num_value |
double precision |
Variable value as number |
num_config |
double precision |
In case of consumables: Consumable maximum available value (configured value) |
Group specific variables
Column |
Type |
Description |
---|---|---|
groupname |
text |
Name of the group |
time_start |
timestamp |
Start time for the validity of a value |
time_end |
timestamp |
End time for the validity of a value |
variable |
text |
Variable name, e.g. h_sum_jobs |
str_value |
text |
Variable value, e.g. 53 |
num_value |
double precision |
Variable value as number |
num_config |
double precision |
In case of consumables: Consumable maximum available value (configured value) |
Host specific variables
Column |
Type |
Description |
---|---|---|
hostname |
text |
The hostname |
time_start |
timestamp |
Start time for the validity of a value |
time_end |
timestamp |
End time for the validity of a value |
variable |
text |
Variable name, e.g. load_avg |
str_value |
text |
Variable value, e.g. 0.34 |
num_value |
double precision |
Variable value as number |
num_config |
double precision |
In case of consumables: Consumable maximum available value (configured value) |
Project specific variables
Column |
Type |
Description |
---|---|---|
project |
text |
Name of the project |
time_start |
timestamp |
Start time for the validity of a value |
time_end |
timestamp |
End time for the validity of a value |
variable |
text |
Variable name, e.g. h_avg_cpu |
str_value |
text |
Variable value, e.g. 345.5 |
num_value |
double precision |
Variable value as number |
num_config |
double precision |
In case of consumables: Consumable maximum available value (configured value) |
Queue specific variables
Column |
Type |
Description |
---|---|---|
qname |
text |
Name of the queue |
hostname |
text |
Name of host |
time_start |
timestamp |
Start time for the validity of a value |
time_end |
timestamp |
End time for the validity of a value |
variable |
text |
Variable name, e.g. slots |
str_value |
text |
Variable value, e.g. 5 |
num_value |
double precision |
Variable value as number |
num_config |
double precision |
In case of consumables: Consumable maximum available value (configured value) |
User specific variables.
Column |
Type |
Description |
---|---|---|
username |
text |
Name of the user |
time_start |
timestamp |
Start time for the validity of a value |
time_end |
timestamp |
End time for the validity of a value |
variable |
text |
Variable name, e.g. h_sum_cpu |
str_value |
text |
Variable value, e.g. 23.2 |
num_value |
double precision |
Variable value as number |
num_config |
double precision |
In case of consumables: Consumable maximum available value (configured value) |