Redshift Observatory

System Table Tracker

System view pg_catalog.svv_mv_info version 1.0.60353 / 2023-11-24

schema name column data type
pg_catalog svv_mv_info autorefresh char(1)
pg_catalog svv_mv_info autorewrite char(1)
pg_catalog svv_mv_info database_name char(128)
pg_catalog svv_mv_info is_stale char(1)
pg_catalog svv_mv_info name char(128)
pg_catalog svv_mv_info schema_name char(128)
pg_catalog svv_mv_info state int4
pg_catalog svv_mv_info user_name char(128)

View Text

SELECT s.db_name AS database_name,
       s.schema AS schema_name,
       s.owner_user_name AS user_name,
       s.name,
       s.is_stale,
       s.state,
       s.autorewrite,
       s.autorefresh
FROM stv_mv_info AS s


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