PhixFlow Help

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Next »

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 record definition)

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
typeType

Statistics Type: StreamSet

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

Stream Id

context_1_typeActivity Type

Stream Type

context_1_name NameStream Name
value_1Insert Count (Number)Total inserts count
value_2Insert Volume (Records)Total Records inserted
value_3Insert Volumne (Bytes)Average bytes written for records inserted
value_4Update Count (Number)Total updates count
value_5Update Volume (Records)Total Records updated
value_6Insert 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
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_idUid

The first context object (id); may be null.

context_1_typeStringThe first context object (type); may be null.
context_1_name String

The first context object (name); may be null.

value_1DoubleThe first context object (value)
context_2_idUid

The first context object (id); may be null.

context_2_typeStringThe first context object (type); may be null.
context_2_name String

The first context object (name); may be null.

value_2DoubleThe first context object (value)
context_3_idUid

The first context object (id); may be null.

context_3_typeStringThe first context object (type); may be null.
context_3_name String

The first context object (name); may be null.

value_3DoubleThe first context object (value)
context_4_idUid

The first context object (id); may be null.

context_4_typeStringThe first context object (type); may be null.
context_4_name String

The first context object (name); may be null.

value_4DoubleThe first context object (value)
context_5_idUid

The first context object (id); may be null.

context_5_typeStringThe first context object (type); may be null.
context_5_name String

The first context object (name); may be null.

value_5DoubleThe first context object (value)
context_1_idUid

The first context object (id); may be null.

context_1_typeStringThe first context object (type); may be null.
context_1_name String

The first context object (name); may be null.

value_1DoubleThe first context object (value)
context_6_idUid

The first context object (id); may be null.

context_6_typeStringThe first context object (type); may be null.
context_6_name String

The first context object (name); may be null.

value_6DoubleThe first context object (value)
context_7_idUid

The first context object (id); may be null.

context_7_typeStringThe first context object (type); may be null.
context_7_name String

The first context object (name); may be null.

value_7DoubleThe first context object (value)
context_8_idUid

The first context object (id); may be null.

context_8_typeStringThe first context object (type); may be null.
context_8_name String

The first context object (name); may be null.

value_8DoubleThe first context object (value)
context_9_idUid

The first context object (id); may be null.

context_9_typeStringThe first context object (type); may be null.
context_9_name String

The first context object (name); may be null.

value_9DoubleThe first context object (value)
context_10_idUid

The first context object (id); may be null.

context_10_typeStringThe first context object (type); may be null.
context_10_name String

The first context object (name); may be null.

value_10DoubleThe first context object (value)
  • No labels