redshift_v_vacuum_jobs_summary.sql

CREATE OR REPLACE VIEW admin.v_vacuum_jobs_summary
AS 
 SELECT DISTINCT us.usename, perm.name, vac.eventtime, trunc(vac.eventtime) AS date, vac.status, vac."rows", vac.sortedrows
   FROM stl_vacuum vac
   JOIN stv_tbl_perm perm ON perm.id = vac.table_id
   JOIN pg_user us ON us.usesysid = vac.userid
  WHERE trunc(vac.eventtime) >= trunc('now' - 1)
  ORDER BY vac.eventtime DESC;