Redshift Observatory

System Table Tracker

System view pg_catalog.stl_mv_state version 1.0.51304 / 2023-06-04

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