EAR  4.2.1
EAR Reference Manual
EAR-database-table-descriptions

EAR's database contains several tables, as described here. Each table contains different information, as described here:

All the metrics in this table refer to the period of time where the Signature is computed. Typically is 10 sec. Signatures are only reported when the application uses the EAR library.

  1. Each signature corresponds to either a Loop or an Application. When it’s an application it is the average values for its entire runtime. For a loop, the values are the average of only the period comprised by the loop’s start and end.
  2. Signatures are only reported when an application is running with EARL.
  3. The GPU signature values are inclusive, i.e. if a signature has a min_id = 1 and max_id = 3, the GPU_signatures with ids 1,2,3 will be from this application.

Power signatures are measured and reported by the EARD and reported for all the jobs/steps/nodes. It’s independent of the EAR library utilization.

If an application has more than 1 GPU there will be a signature for each of them.

Loops are only reported when the EAR library is used.

  1. the combination even-size-level forms the Primary Key for the table loops.
  2. Loops will always have a signature because they are only reported when EAR is used
  3. When a loop is inserted, the corresponding Job is probably not in the database yet, because Jobs are inserted only when an application finishes. JOIN queries with Jobs can only be done once an application has finished (only the current step id needs to finish, not the entire job).

The origins of an event are indicated by its cardinality:

  1. EARL events’ type is always < 100
  2. EARD init events’ type is always >=100 <=200
  3. EARD runtime events’ type is always >=300 and <=400
  4. EARD powercap events’ type is always >=500 and <=600
  5. EARGM events’ type is always >=600 and <=700

Certain events do not require a value, so it is set to 0 by default on those cases.

This table is used by the EARGM.

The warning level also indicates which inc_th and p_states are being sent to the EARDs