| schema | name | column | data type |
|---|---|---|---|
| pg_catalog | svl_mv_refresh_status | db_name | name |
| pg_catalog | svl_mv_refresh_status | endtime | timestamp |
| pg_catalog | svl_mv_refresh_status | mv_name | name |
| pg_catalog | svl_mv_refresh_status | refresh_type | char(32) |
| pg_catalog | svl_mv_refresh_status | schema_name | name |
| pg_catalog | svl_mv_refresh_status | starttime | timestamp |
| pg_catalog | svl_mv_refresh_status | status | text |
| pg_catalog | svl_mv_refresh_status | userid | int8 |
| pg_catalog | svl_mv_refresh_status | xid | int8 |
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 = -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)
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