CenterView generates processing statistics which are saved to the database. These statics are for use by administrators and designers who are tuning for performance.
See System Configuration for how to enable and manage stats generation.
Processing Statistics
The following statistics are currently recorded and available as data records in the STATS_RECORD table. (See STATS_RECORD record definition)
...
STATS_RECORD Column | Statistic | Detail |
|---|---|---|
| stats_type | Type | Statistics Type: ACTIVITY |
| fromDtm | Datetime | The start time of the period that this measure refers to |
| toDtm | Datetime | The end time of the period that this measure refers to |
| context_1_id | Id | TaskPlanId or ActionId |
| context_1_type | Activity Type | Activity Types : TASK_PLAN - for task plans executed ACTION - for actions triggered |
| context_1_name | Name | Name of TaskPlan or Action |
| value_1 | Count | The number of times this TaskPlan or action has been executed. |
...
STATS_RECORD Column | Statistic | Detail |
|---|---|---|
| stats_type | Type | Statistics Type: StreamSet |
| fromDtm | Datetime | The start time of the period that this measure refers to |
| toDtm | Datetime | The end time of the period that this measure refers to |
| context_1_id | Id | Stream Id |
| context_1_type | Activity Type | Stream Type |
| context_1_name | Name | Stream Name |
| value_1 | Insert Count (Number) | Total inserts count |
| value_2 | Insert Volume (Records) | Total Records inserted |
| value_3 | Insert Volumne (Bytes) | Average bytes written for records inserted |
| value_4 | Update Count (Number) | Total updates count |
| value_5 | Update Volume (Records) | Total Records updated |
| value_6 | Insert Volumne (Bytes) | Average bytes written for records updated |
...
The table structure for a STATS_RECORD is as follows:
Member | Class | Description |
|---|---|---|
| stats_type | enum | Statistics Type: E.g. 'activity_count' |
| fromDtm | Datetime | The start time of the period that this measure refers to |
| toDtm | Datetime | The end time of the period that this measure refers to |
| context_1_id | Uid | The first context object (id); may be null. |
| context_1_type | String | The first context object (type); may be null. |
| context_1_name | String | The first context object (name); may be null. |
| value_1 | Double | The first context object (value) |
| context_2_id | Uid | The second context object (id); may be null. |
| context_2_type | String | The second context object (type); may be null. |
| context_2_name | String | The second context object (name); may be null. |
| value_2 | Double | The second context object (value) |
| context_3_id | Uid | The third context object (id); may be null. |
| context_3_type | String | The third context object (type); may be null. |
| context_3_name | String | The third context object (name); may be null. |
| value_3 | Double | The third context object (value) |
| context_4_id | Uid | The fourth context object (id); may be null. |
| context_4_type | String | The fourth context object (type); may be null. |
| context_4_name | String | The fourth context object (name); may be null. |
| value_4 | Double | The fourth context object (value) |
| context_5_id | Uid | The fifth context object (id); may be null. |
| context_5_type | String | The fifth context object (type); may be null. |
| context_5_name | String | The fifth context object (name); may be null. |
| value_5 | Double | The fifth context object (value) |
| context_6_id | Uid | The sixth context object (id); may be null. |
| context_6_type | String | The sixth context object (type); may be null. |
| context_6_name | String | The sixth context object (name); may be null. |
| value_6 | Double | The sixth context object (value) |
| context_7_id | Uid | The seventh context object (id); may be null. |
| context_7_type | String | The seventh context object (type); may be null. |
| context_7_name | String | The seventh context object (name); may be null. |
| value_7 | Double | The seventh context object (value) |
| context_8_id | Uid | The eigth context object (id); may be null. |
| context_8_type | String | The eigth context object (type); may be null. |
| context_8_name | String | The eigth context object (name); may be null. |
| value_8 | Double | The eigth context object (value) |
| context_9_id | Uid | The ninth context object (id); may be null. |
| context_9_type | String | The ninth context object (type); may be null. |
| context_9_name | String | The ninth context object (name); may be null. |
| value_9 | Double | The ninth context object (value) |
| context_10_id | Uid | The tenth context object (id); may be null. |
| context_10_type | String | The tenth context object (type); may be null. |
| context_10_name | String | The tenth context object (name); may be null. |
| value_10 | Double | The tenth context object (value) |