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)
Activity Statistics
Activity Statistics are recorded from TaskPlans executed, Actions triggered.
STATS_RECORD Column | Statistic | Detail |
|---|---|---|
| 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. |
Pipe Read Statistics
Not yet available.
Stream Write Statistics
This is a record of data volumes written to Streams and Exporters
STATS_RECORD Column | Statistic | Detail |
|---|---|---|
| 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 |
Pipe Cache Statistics
Not yet available.
In-Memory-Stream Statistics
Not yet available.
Database Statistics Record Structure
The table structure for a STATS_RECORD is as follows:
Member | Class | Description |
|---|---|---|
| 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) |