on 27-07-202005:21 PM - edited on 28-07-202010:51 AM by exa-Nico
Details about backups are stored in the table EXA_SYSTEM_EVENTS. This table shows the start and stop times of backups, in addition to restarts, fail safety, and more. We can query this table to find the duration of a backup.
Calculate the backup duration from the system events table
You can use the below query to calculate the duration of backups.
with intermediate as
, lead(event_type) over (orderby measure_time) end_event
, lead(measure_time) over (orderby measure_time) end_time
, cast(trunc(measure_time, 'DD') asdate) start_date
, cast(round(minutes_between(end_time, measure_time)/60, 2) asdecimal(10,2)) backup_duration
event_type = 'BACKUP_START'and end_event notlike'%START'and measure_time > trunc(now(), 'YYYY')