maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_monitor_alert_recent()
Parameters
Name
Type
Mode
Definition
/*RETURNS FALSE IF THE alert_recent partitioning schema is lagging behind _daysahead partitions in UTC */ DECLARE _daysahead INTEGER; _oidalertrecent OID; _newestpartition varchar; BEGIN SET timezone = 'UTC'; SELECT oid INTO _oidalertrecent FROM pg_class WHERE relname = 'alert_recent'; SELECT c.oid::pg_catalog.regclass::varchar INTO _newestpartition FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i WHERE c.oid=i.inhrelid AND i.inhparent = _oidalertrecent ORDER BY 1 DESC LIMIT 1; RETURN (to_date(_newestpartition,'alert_pYYYY_MM_DD') - now()::date)::integer; /* days ahead on alert_recent */ END;