PhixFlow generates processing statstics which are saved to the database. These statics are for use by administrators and designers who are tuning for performance.
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 context_1_type context_1_name | Uid String String | The first context object (id, type and name); may be null. |
| value_1 | Double | The first value; may be null. |
| .... | {NOTE There are 10 data contexts/values available for recording stats. Only 1 is show in this table definition. } |
Processing Statistics
The following statistics are currently recorded and available as data records in the STATS_RECORD table.
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.