Script to Find Stale Projections in Vertica

The script will list all the projections that were not refreshed in the last month.

SELECT p.projection_schema,
       p.projection_name,
       DATEDIFF(day, refresh_start, SYSDATE()) AS days_last_refresh
  FROM v_catalog.projections p
  LEFT JOIN v_monitor.projection_refreshes pr ON pr.projection_id =
                                                 p.projection_id
 WHERE DATEDIFF(month, refresh_start, SYSDATE()) >= 1
    OR pr.projection_id IS NULL
 ORDER BY DATEDIFF(day, refresh_start, SYSDATE()) DESC;