24h Efficiency Evaluation

With this report, you can evaluate the efficiency over the last 24 hours.

The evaluation makes it possible to determine the efficiency of the machines for each of the past 24 hours. In addition, the average over the last 24 hours, the floating value over the last hour and the value since the last change of hours are provided.

Call-up parameters

Parameter

Type

Description

_amcids

Integer[]

SKR machine IDs of the machines whose efficiency is to be determined.
E.g. Array[1399537164, 1399537135]

_used_calc_algorithmen

integer

Evaluation Criteria:

1 – Only evaluate times when the machines are switched on

2 – Evaluate times when the machines are switched off as well

Return Table

Column

Type

Content

MC_KEY

integer

Selected time grouping of the data

ACTIVATED

boolean

True if the machine is active (not inoperative) in the SKR

CONNECTED

boolean

True if the PollClient has established a TCP/IP connection to the machine

DATA_UP_TO_DATE

boolean

True if it is highly probable that the content of the data for this machine is the current one.

Uncertainty due to:
If a TCP/IP is interrupted for example due to a network error, this is often or sometimes not detected by the communication partner until the next time data is sent because of the missing receipt notification.

TS

timestamp

Timestamp of the last event processed

EFF_OVER_CURRENT_1H

real

Floating efficiency value over the last hour to identify a trend early.

EFF_INCOMPLETE_SINCE_01

real

Efficiency value after the last change of hours. The evaluation period increases accordingly from 1-59 minutes after the change of hours)

EFF_01

real

Efficiency of the last hour

EFF_02

real

Efficiency 2 hours ago

.
.
.

EFF_24

real

Efficiency 24 hours ago

EFF_OVER_24H

real

Mean value of efficiency over the last 24 hours

EFF_OVER_24H_SUM_T

integer

Period taken into account of the last 24 hours

Code example skr_get_mc_efficiency_states.sql

Important:
This evaluation does not require the prior creation of evaluation auxiliary tables.

SELECT skrpps_02.skr_mcid2mcname( "MC_KEY",'skr'::cstring) AS "MC_NAME"    -- adds machine network name to table

,* FROM skrpps_02.skr_get_mc_efficiency_states(
ARRAY[1649425129, 1649425130] –- list of skr machine IDs

, 1 -- 1: only times where MCs were powered on
);

Mean value of efficiency of all machines

Mean value of efficiency across all machines may also be of interest. The call for this would use the above Stored Procedure and add it like this:

SELECT

string_agg(skrpps_02.skr_mcid2mcname( "MC_KEY",'skr'::cstring), ', ') AS "MC_NAMES"

,string_agg("MC_KEY"::text, ', ') AS "MC_KEYS"

,MIN("TS") as "MIN_TS"

,MAX("TS") as "MAX_TS"

,AVG("EFF_OVER_CURRENT_1H") AS "EFF_OVER_CURRENT_1H"

,AVG("EFF_INCOMPLETE_SINCE_01") AS "EFF_INCOMPLETE_SINCE_01"

,AVG("EFF_01") AS "EFF_01" ,AVG("EFF_02") AS "EFF_02"

,AVG("EFF_03") AS "EFF_03" ,AVG("EFF_04") AS "EFF_04"

,AVG("EFF_05") AS "EFF_05" ,AVG("EFF_06") AS "EFF_06"

,AVG("EFF_07") AS "EFF_07" ,AVG("EFF_08") AS "EFF_08"

,AVG("EFF_09") AS "EFF_09" ,AVG("EFF_10") AS "EFF_10"

,AVG("EFF_11") AS "EFF_11" ,AVG("EFF_12") AS "EFF_12"

,AVG("EFF_13") AS "EFF_13" ,AVG("EFF_14") AS "EFF_14"

,AVG("EFF_15") AS "EFF_15" ,AVG("EFF_16") AS "EFF_16"

,AVG("EFF_17") AS "EFF_17" ,AVG("EFF_18") AS "EFF_18"

,AVG("EFF_19") AS "EFF_19" ,AVG("EFF_20") AS "EFF_20"

,AVG("EFF_21") AS "EFF_21" ,AVG("EFF_22") AS "EFF_22"

,AVG("EFF_23") AS "EFF_23" ,AVG("EFF_24") AS "EFF_24"

,AVG("EFF_OVER_24H") AS "EFF_OVER_24H"

,AVG("EFF_OVER_24H_SUM_T") AS "EFF_OVER_24H_SUM_T"

FROM skrpps_02.skr_get_mc_efficiency_states(ARRAY[1649425129, 1649425130, 1649425132]

, 2)