Redshift Observatory

System Table Tracker

System view pg_catalog.svl_mv_refresh_status version 1.0.39278 / 2022-07-23

View Text

SELECT e.datname AS db_name,
       a.userid,
       b.nspname AS schema_name,
       d.relname AS mv_name,
       a.xid,
       a.starttime,
       a.endtime,
       CASE
         WHEN a.status = -10
           THEN CAST('Refresh failed. Table changed by vacuum/truncate concurrently' AS text)
         WHEN a.status = -9
           THEN CAST('Refresh failed. Serializable isolation violation.' AS text)
         WHEN a.status = -8
           THEN CAST('Refresh failed due to an internal error' AS text)
         WHEN a.status = -7
           THEN CAST('Refresh failed. Schema of MV was renamed' AS text)
         WHEN a.status = -6
           THEN CAST('Refresh failed. A base table column was renamed' AS text)
         WHEN a.status = -5
           THEN CAST('Refresh failed. A base table was renamed' AS text)
         WHEN a.status = -4
           THEN CAST('Refresh failed. A base table column type was changed' AS text)
         WHEN a.status = -3
           THEN CAST('Refresh failed. A base table column was dropped' AS text)
         WHEN a.status = -2
           THEN CAST('Refresh failed. MV was not found' AS text)
         WHEN a.status = -1
           THEN CAST('Refresh failed due to an internal error' AS text)
         WHEN a.status = 1
           THEN CAST('Refresh successfully updated MV incrementally' AS text)
         WHEN a.status = 2
           THEN CAST('MV was already updated' AS text)
         WHEN a.status = 3
           THEN CAST('Refresh successfully recomputed MV from scratch' AS text)
         WHEN a.status = 4
           THEN CAST('Refresh could not update MV further due to an active transaction' AS text)
         WHEN a.status = 5
           THEN CAST('Refresh partially updated MV incrementally up to an active transaction' AS text)
         WHEN a.status = 6
           THEN CAST('Refresh partially recomputed MV from scratch up to an active transaction' AS text)
         WHEN a.status = 7
           THEN CAST('Auto refresh aborted due to excessive user workload' AS text)
         WHEN a.status = 8
           THEN CAST('MV was already updated, but depends on an MV that is not up to date.' AS text)
         WHEN a.status = 9
           THEN CAST('Refresh successfully updated MV incrementally, but MV depends on an MV that is not up to date.' AS text)
         WHEN a.status = 10
           THEN CAST('Refresh successfully recomputed MV from scratch, but MV depends on an MV that is not up to date.' AS text)
         WHEN a.status = 11
           THEN CAST('Refresh successfully updated streaming MV incrementally, but the stream returned no new data.' AS text)
         WHEN a.status = 12
           THEN CAST('Refresh successfully updated streaming MV incrementally, but some records were skipped.' AS text)
         ELSE CAST('Unknown refresh status' AS text)
       END AS status,
       a.refresh_type
FROM stl_mv_refresh AS a, pg_namespace AS b, pg_class AS d, pg_database AS e
WHERE CAST(a.schemaoid AS oid) = b.oid
  AND CAST(a.mvoid AS oid) = d.oid
  AND CAST(a.db_oid AS oid) = e.oid

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers