maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_monitor_partitions_alert(interval)
Parameters
Name
Type
Mode
min_premake_partitions
interval
IN
Definition
DECLARE current_date date; last_partition_date date; age interval; r record; BEGIN current_date := now()::date; select to_date(d,'______________YYYY_MM_DD') INTO last_partition_date FROM show_partitions('public.alert','DESC') d limit 1; age := (last_partition_date - current_date)::interval; RAISE WARNING '% - % = %',last_partition_date,current_date, age; IF age >= min_premake_partitions THEN RETURN true; ELSE RETURN false; END IF; END;