Redshift Observatory

System Table Tracker

System view pg_catalog.svv_mv_info version 1.0.54899 / 2023-08-15

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