view_department_values
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) |
view_group_values
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) |
view_host_values
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) |
view_project_values
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) |
view_queue_values
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) |
view_user_values
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) |
List of Derived Values
Derived values stored in the database can highly reduce query processing time.
The reporting databasel contains aggregated values (sum, average, min, max) on an
hourly basis. After some time period (e.g. one year), these values can even be further
compressed to daily, weekly or monthly values.
The following derived values are delivered:
table | variable | description |
sge_host_values | h_sum_cpu, d_sum_cpu, m_sum_cpu | cpu usage per host and hour, day, month |
sge_user_values | h_sum_cpu, d_sum_cpu, m_sum_cpu | cpu usage per user and hour, day, month |
sge_group_values | h_sum_cpu, d_sum_cpu, m_sum_cpu | cpu usage per group and hour, day, month |
sge_department_values | h_sum_cpu, d_sum_cpu, m_sum_cpu | cpu usage per department and hour, day, month |
sge_project_values | h_sum_cpu, d_sum_cpu, m_sum_cpu | cpu usage per project and hour, day, month |
sge_host_values | h_avg_load | average host load |
sge_host_values | h_max_load | maximum host load |
| | |
Rules for the generation of any derived value can be specified in a configuration
file.
|