Previous Topic: usp_kpi TableNext Topic: usp_kpi_ticket_data Table


usp_kpi_data Table

Contains the KPI data periodically retrieved from system daemons by the kpi_daemon. Provides raw data for web reporting.

Field

Data Type

Reference

Remarks

id

integer

 

Specifies the id of the record.

kpi_id

integer

 

Provides a REF to the id in the KPI.

kpi_time_stamp

integer

 

Indicates the time when a new KPI record is inserted into this table.

metric_type

integer

 

Indicates the type of metric the KPI produces (count, sum, max, or duration).

kpi_value

integer

 

Indicates the value of the metric produced by the KPI. The value matches the metric_type (count, sum, max, or duration).

duration_max

integer

 

Specifies the maximum value of duration for KPIs of duration metric_type. The time unit is millisecond.

duration_sum

integer

 

Specifies the total duration for KPIs of duration metric_type. The time unit is seconds.

duration_count

integer

 

Indicates the amount of duration data that has been collected in a period of time.

duration_average

integer

 

Indicates the average duration in a period of time for KPIs with duration metric_type. The time unit is milliseconds.

execute_time

integer

 

Indicates the total time for retrieving the KPI data, from the time the request is sent to time the result is received. The time unit is milliseconds.

version_number

integer

 

Indicate the version of this KPI.