Redshift Observatory

System Table Tracker

System view pg_catalog.stl_mv_state version 1.0.40496 / 2022-08-08

schema	name	column	data type
pg_catalog	stl_mv_state	base_table_name	char(128)
pg_catalog	stl_mv_state	base_table_schema	char(128)
pg_catalog	stl_mv_state	db_name	char(128)
pg_catalog	stl_mv_state	event_desc	char(500)
pg_catalog	stl_mv_state	mv_name	char(128)
pg_catalog	stl_mv_state	mv_schema	char(128)
pg_catalog	stl_mv_state	starttime	timestamp
pg_catalog	stl_mv_state	state	char(32)
pg_catalog	stl_mv_state	userid	int8
pg_catalog	stl_mv_state	xid	int8

View Text

SELECT stll_mv_state.userid,
       stll_mv_state.starttime,
       stll_mv_state.xid,
       stll_mv_state.event_desc,
       stll_mv_state.db_name,
       stll_mv_state.base_table_schema,
       stll_mv_state.base_table_name,
       stll_mv_state.mv_schema,
       stll_mv_state.mv_name,
       stll_mv_state.state
FROM stll_mv_state

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