maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_mon_alertdate(timestamp with time zone)
Parameters
Name
Type
Mode
_aenddate
timestamp with time zone
IN
Definition
DECLARE _astartdate timestamptz; _estartdate timestamptz; _eenddate timestamptz; _result float; BEGIN /* To measure the time between an event arrival and an alert generation (panic button) */ _astartdate := _aenddate - '5 minutes'::interval; _eenddate := _aenddate; _estartdate := _aenddate - '2 hours'::interval; select avg(extract('epoch' from (a.creationdate - e.creationdate))) INTO _result FROM alert a JOIN alert_event ae ON ae.idalert = a.idalert JOIN event e ON e.idevent = ae.idevent JOIN device d ON d.iddevice = a.iddevice where a.creationdate BETWEEN _astartdate AND _aenddate AND e.senddate between _estartdate and _eenddate AND d.idmodeldevice = 4 ; RETURN _result; END;