PhixFlow generates processing statstics which are saved to the database. These statics are for use by administrators and designers who are tuning for performance.
Processing Statistics
The following statistics are currently recorded and available as data records in the STATS_RECORD table. (See STATS_RECORD Table Structure)
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 first context object (id); may be null. |
| context_2_type | String | The first context object (type); may be null. |
| context_2_name | String | The first context object (name); may be null. |
| value_2 | Double | The first context object (value) |
| context_3_id | Uid | The first context object (id); may be null. |
| context_3_type | String | The first context object (type); may be null. |
| context_3_name | String | The first context object (name); may be null. |
| value_3 | Double | The first context object (value) |
| context_4_id | Uid | The first context object (id); may be null. |
| context_4_type | String | The first context object (type); may be null. |
| context_4_name | String | The first context object (name); may be null. |
| value_4 | Double | The first context object (value) |
| context_5_id | Uid | The first context object (id); may be null. |
| context_5_type | String | The first context object (type); may be null. |
| context_5_name | String | The first context object (name); may be null. |
| value_5 | Double | The first context object (value) |
| 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_6_id | Uid | The first context object (id); may be null. |
| context_6_type | String | The first context object (type); may be null. |
| context_6_name | String | The first context object (name); may be null. |
| value_6 | Double | The first context object (value) |
| context_7_id | Uid | The first context object (id); may be null. |
| context_7_type | String | The first context object (type); may be null. |
| context_7_name | String | The first context object (name); may be null. |
| value_7 | Double | The first context object (value) |
| context_8_id | Uid | The first context object (id); may be null. |
| context_8_type | String | The first context object (type); may be null. |
| context_8_name | String | The first context object (name); may be null. |
| value_8 | Double | The first context object (value) |
| context_9_id | Uid | The first context object (id); may be null. |
| context_9_type | String | The first context object (type); may be null. |
| context_9_name | String | The first context object (name); may be null. |
| value_9 | Double | The first context object (value) |
| context_10_id | Uid | The first context object (id); may be null. |
| context_10_type | String | The first context object (type); may be null. |
| context_10_name | String | The first context object (name); may be null. |
| value_10 | Double | The first context object (value) |