Redshift Research Project

System Table Tracker

System view pg_catalog.svl_mv_refresh_status version 1.0.59117 / 2023-11-08

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 = -15
           THEN CAST('Refresh failed. An external base table was not found' AS text)
         WHEN a.status = -14
           THEN CAST('Refresh failed. An external database was not found' AS text)
         WHEN a.status = -13
           THEN CAST('Refresh failed. An external base table schema was not found' AS text)
         WHEN a.status = -12
           THEN CAST('Refresh failed. A base table has been RLS-protected' AS text)
         WHEN a.status = -11
           THEN CAST('Refresh failed. A base table schema was renamed' AS text)
         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) || CASE
                                                                                    WHEN a.no_new_rows = CAST('t' AS bpchar)
                                                                                     AND a.skipped_rows = CAST('f' AS bpchar)
                                                                                      THEN CAST('. Stream returned no new data' AS text)
                                                                                    WHEN a.no_new_rows = CAST('t' AS bpchar)
                                                                                     AND a.skipped_rows = CAST('t' AS bpchar)
                                                                                      THEN CAST('. All records received from the stream were skipped' AS text)
                                                                                    WHEN a.no_new_rows = CAST('f' AS bpchar)
                                                                                     AND a.skipped_rows = CAST('t' AS bpchar)
                                                                                      THEN CAST('. Some stream records were skipped' AS text)
                                                                                    ELSE CAST('' AS text)
                                                                                  END) || CASE
                                                                                            WHEN a.may_have_more_rows = CAST('t' AS bpchar)
                                                                                              THEN CAST('. The stream may contain more data' AS text)
                                                                                            ELSE CAST('' AS text)
                                                                                          END
         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('Auto refresh aborted due to conflicting user workload' AS text)
         WHEN a.status = 12
           THEN CAST('Refresh aborted' 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