Process metrics table information
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) |