...
The following statistics are currently recorded and available as data records in the STATS_RECORD STATISTICS table. (See STATS_RECORD STATISTICS record definition)
Activity Statistics
Activity Statistics are recorded from TaskPlans executed, Actions triggered.
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 | 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. |
_TYPE | INITIATOR_TYPE | INITIATOR_ID | INITIATOR_NAME | CONTEXT_TYPE | CONTEXT_ID | CONTEXT_NAME | FULL_CONTEXT | DATA_TYPE | DATA_VALUE |
|---|---|---|---|---|---|---|---|---|---|
| Activity | TaskPlan, Action | TaskPlan/Action ID | TaskPlan/Action name | TaskPlan/Action Name | insertCount | {Vount of records inserted} | |||
| insertVolume | {Volume of records inserted} | ||||||||
| insertVolumeBytes | {Volume of bytes inserted} | ||||||||
| insertTimeTotal | {Time taken to insert records} | ||||||||
| updateCount | {Count of records updated} | ||||||||
| updateVolume | {Volume of records updated} | ||||||||
| updateVolumeBytes | {Volume of bytes updated} | ||||||||
| updateTimeTotal | {Time taken to update records} |
Pipe Read Statistics
Not yet available.
...
This is a record of data volumes written to Streams and Exporters
...
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 | Type | Stream Storage Type: SINGLE_TABLE (Database) PARTITIONED_TABLE (Database - Partitioned) IN_MEMORY (In Memory) |
| 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.
TYPE | INITIATOR_TYPE | INITIATOR_ID | INITIATOR_NAME | CONTEXT_TYPE | CONTEXT_ID | CONTEXT_NAME | FULL_CONTEXT | DATA_TYPE | DATA_VALUE |
|---|---|---|---|---|---|---|---|---|---|
| Stream | TaskPlan, Action | TaskPlan/Action ID | TaskPlan/Action name | Stream | Stream ID | Stream Name | Stream Name | insertCount | {Vount of records inserted} |
| insertVolume | {Volume of records inserted} | ||||||||
| insertVolumeBytes | {Volume of bytes inserted} | ||||||||
| insertTimeTotal | {Time taken to insert records} | ||||||||
| updateCount | {Count of records updated} | ||||||||
| updateVolume | {Volume of records updated} | ||||||||
| updateVolumeBytes | {Volume of bytes updated} | ||||||||
| updateTimeTotal | {Time taken to update records} |
Database Statistics Record Structure
The table structure for a STATS_RECORD STATISTICS is as follows:
Member | Class | Description |
|---|---|---|
| stats_type | enum | Statistics Type: E.g. 'activity_countActivity, Pipe, PipeLookup, PipeQueue, Stream' |
| 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_initiator_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_ object initiating the activity - eg. "TaskPlan", or "Action" | ||
| initiator_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_3ID of the initiating TaskPlan or Action / other object. | ||
| initiator_name | String | The name of the initiating TaskPlan or Action / other object. |
| context_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_4activity triggered by the initiator. eg "Stream" | ||
| context_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 e.g. The "Streams" ID that Analysis was run on. | ||
| context_name | String | eg. The name of the stream that Analysis was run on.` |
| full_context | String | This a dotted notation indicating the full context. eg. TaskPlan1.Stream X.in |
| data_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)type of statistics data being recorded for this stats type. Eg. totalRecordsWritten, totalWriteTime. |
| data_value | Double | The value of the statistic being recorded for the given data_type. |