Загрузка данных


SELECT
    cron AS job_id,
    scheduled_at,
    started,
    finished,
    status,
    message
FROM schedule.get_log()
WHERE cron IN (44, 45)
  AND scheduled_at >= current_date
ORDER BY scheduled_at DESC;




SELECT
    l.id,
    l.record_date,
    l.status,
    l.message
FROM robot.log l
WHERE l.record_date >= current_date + time '16:25'
  AND l.session_id IN (
      SELECT DISTINCT x.session_id
      FROM robot.log x
      WHERE x.record_date >= current_date + time '16:25'
        AND x.message ~
            'id[[:space:]]*=[[:space:]]*(14|40)([^0-9]|$)'
  )
ORDER BY l.id;