The process metrics data is contained in the metric and metric_detail tables within the database. There is no master table. The tables are created after process metrics data collection is configured. The metric_detail table has a foreign key relationship to the metric table.
The following two tables offer details about the fields in each process metrics table.
Fields in the metric table
Field |
Description |
---|---|
ID |
Unique record identifier of the metric and primary key |
GRID_NAME |
The name of the grid on which the process occurred for which the metric is recorded |
PEER_NAME |
The name of the peer where the process occurred for which the metric is recorded |
START_TIME |
Start time of the process or action whose information is recorded as a metric |
CATEGORY |
The type of metric being recorded |
DESCRIPTION |
Description of the process or action whose information is recorded as a metric |
DURATION |
Length of time the process or action took to finish |
STATUS |
Status of the process or action |
ENTITY_ID |
Unique identifier of the process or action |
USER_ID |
User name of the person or system who invoked the process or the action |
Fields in the metric_detail table
Field |
Description and sample values |
---|---|
ID |
The unique record identifier and primary key |
NAME |
Metric for which the VALUE is captured |
VALUE |
Metric value that corresponds to the NAME attribute or item |
METRIC_ID |
Cross-referenced value for the ID in the metric table |
SEQUENCE_NUM |
Sequence number of the metric detail records of a metric record (internal use only) |