Verificar o Tempo dos Backups da Logical Log

Algumas dicas com comandos SQL para checar o tempo dos backups da Logical Logs.

1. Tempo de backup da logical log

DATABASE sysutils;

SELECT a.obj_name::VARCHAR(10) AS logfile,
       b.act_start, b.act_end,
       (b.act_end - b.act_start)::INTERVAL SECOND(9) TO SECOND AS time_sec
 FROM bar_object a, bar_action b
  WHERE a.obj_oid = b.act_oid
    AND a.obj_type = 'L'
ORDER BY 1 ASC;