Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

PhixFlow generates processing statstics 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 table structure for a STATS_RECORD is as follows:

Member
Class
Description
typeenum

Statistics Type:

E.g. 'activity_count'

fromDtmDatetimeThe start time of the period that this measure refers to
toDtmDatetimeThe 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_1DoubleThe 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
typeType

Statistics Type: ACTIVITY

fromDtmDatetimeThe start time of the period that this measure refers to
toDtmDatetimeThe end time of the period that this measure refers to
context_1_idId

TaskPlanId or ActionId

context_1_typeActivity Type

Activity Types :

TASK_PLAN - for task plans executed

ACTION - for actions triggered

context_1_name NameName of TaskPlan or Action
value_1CountThe 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

...

following statistics are currently recorded and available as data records in the STATS table. (See STATS record definition)

Activity Statistics

Activity Statistics are recorded from TaskPlans executed, Actions triggered.

STATS_TYPE
INITIATOR_TYPE
INITIATOR_ID
INITIATOR_NAMECONTEXT_TYPECONTEXT_IDCONTEXT_NAMEFULL_CONTEXTDATA_TYPEDATA_VALUE
ActivityTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action name   TaskPlan/Action NamenumStarted

{Number of tasks started in this timeslot. The timeslot is set in the System Configuration > System Tuning Tab

Stats DB Logging Seconds field}

ActivityTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action name   TaskPlan/Action NamenumActive{Number of tasks still running at the end of this timeslot. The timeslot is set in the System Configuration > System Tuning Tab -

Stats DB Logging Seconds field}

ActivityTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action name   TaskPlan/Action NamenumEnded{Number of tasks ended in this timeslot. The timeslot is set in the System Configuration > System Tuning Tab - Stats DB Logging Seconds field}
ActivityTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action name   TaskPlan/Action NamesumDuration (seconds){Total duration of task ending in this timeslot. The timeslot is set in the System Configuration > System Tuning Tab -

Stats DB Logging Seconds field}

Stream Statistics

This is a record of data volumes written to Streams and Exporters

STATS_TYPE
INITIATOR_TYPE
INITIATOR_ID
INITIATOR_NAMECONTEXT_TYPECONTEXT_IDCONTEXT_NAMEFULL_CONTEXTDATA_TYPEDATA_VALUE
StreamTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action nameStreamStream IDStream NameTaskPlan/Action Name.Stream NameinsertCount{Count of database insert batches}
StreamTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action nameStreamStream IDStream NameTaskPlan/Action Name.Stream NameinsertVolume{Volume of individual records inserted}
StreamTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action nameStreamStream IDStream NameTaskPlan/Action Name.Stream Name

insertVolumeBytes

(bytes)

{Volume of records bytes inserted}
StreamTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action nameStreamStream IDStream NameTaskPlan/Action Name.Stream Name

insertTimeTotal

(seconds)

{Time taken to insert records}
StreamTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action nameStreamStream IDStream NameTaskPlan/Action Name.Stream NameupdateCount{Count of database updated batches}
StreamTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action nameStreamStream IDStream NameTaskPlan/Action Name.Stream NameupdateVolume{Volume of individual records updated}
StreamTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action nameStreamStream IDStream NameTaskPlan/Action Name.Stream Name

updateVolumeBytes

(bytes)

{Volume of records bytes updated}
StreamTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action nameStreamStream IDStream NameTaskPlan/Action Name.Stream Name

updateTimeTotal

(seconds)

{Time taken to update records}

The timeslot is set in the System Configuration > System Tuning Tab

Stats DB Logging Seconds field

Pipe Statistics

This is a record of Pipe Read Statistics

STATS_TYPE
INITIATOR_TYPE
INITIATOR_ID
INITIATOR_NAMECONTEXT_TYPECONTEXT_IDCONTEXT_NAMEFULL_CONTEXTDATA_TYPEDATA_VALUE
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe NamereadCount{Numer of reads}
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe Name

readTime

(seconds)

{Time taken to read}
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe Name

readTimeMax

(seconds)

{Maximum read time}
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe NamereadRecCount{Number of records read}

This is a record of Pipe Queue Statistics

STATS_TYPE
INITIATOR_TYPE
INITIATOR_ID
INITIATOR_NAMECONTEXT_TYPECONTEXT_IDCONTEXT_NAMEFULL_CONTEXTDATA_TYPEDATA_VALUE
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe Name

sumEnqueueTime

(seconds)

{Time take to add to queue}
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe NameenqueueCount{Pipe added to queue}
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe Name

sumDequeueTime

(seconds)

{Time take to remove from queue}
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe NamedequeueCount{Pipe removed from queue}

This is a record of Pipe Lookup Statistics

STATS_TYPE
INITIATOR_TYPE
INITIATOR_ID
INITIATOR_NAMECONTEXT_TYPECONTEXT_IDCONTEXT_NAMEFULL_CONTEXTDATA_TYPEDATA_VALUE
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe NamecacheSize{Size of lookup pipe cache}
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe NameaddedToCache{Lookup pipe added to cache}
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe NameremovedFromCache{Lookup pipe removed from cache}
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe NamecacheHits{Count a read done from cache}
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe NamecacheMisses{Count a read not yet from the cache}
PipeTaskPlan, Action

TaskPlan/Action ID

TaskPlan/Action namePipePipe IDPipe NameTaskPlan/Action Name.Stream Name.pipe NamecacheParallelMisses{Total reads from cache by two simulatneous processes}

Database Statistics Record Structure

The table structure for STATS is as follows:

...

Member
Class
Description
stats_typeenum

Statistics Type:

E.g. 'Activity, Pipe, PipeLookup, PipeQueue, Stream'

fromDtmDatetimeThe start time of the period that this measure refers to
toDtmDatetimeThe end time of the period that this measure refers to
context_1_idId

TaskPlanId or ActionId

context_1_typeActivity Type

Activity Types :

TASK_PLAN - for task plans executed

ACTION - for actions triggered

context_1_name NameName of TaskPlan or Actionvalue_1CountThe number of times this TaskPlan or action has been executed.

Pipe Cache Statistics

Not yet available.

In-Memory-Stream Statistics

initiator_typeString

The object initiating the activity - eg. "TaskPlan", or "Action"

initiator_idUidThe ID of the initiating TaskPlan or Action / other object.
initiator_nameString

The name of the initiating TaskPlan or Action / other object.

context_typeStringThe activity triggered by the initiator. eg "Stream"
context_idUid

e.g. The "Streams" ID that Analysis was run on.

context_nameStringeg. The name of the stream that Analysis was run on.`
full_contextString

This a dotted notation indicating the full context.

eg. TaskPlan1.Stream X.in

data_typeStringThe type of statistics data being recorded for this stats type. Eg. totalRecordsWritten, totalWriteTime.
data_valueDouble

The value of the statistic being recorded for the given data_type.