Redshift Observatory

System Table Tracker

System view pg_catalog.stl_mv_refresh version 1.0.39278 / 2022-07-23

schema name column data type
pg_catalog stl_mv_refresh db_oid int8
pg_catalog stl_mv_refresh endtime timestamp
pg_catalog stl_mv_refresh mvoid int8
pg_catalog stl_mv_refresh refresh_type char(32)
pg_catalog stl_mv_refresh schemaoid int8
pg_catalog stl_mv_refresh starttime timestamp
pg_catalog stl_mv_refresh status int4
pg_catalog stl_mv_refresh userid int8
pg_catalog stl_mv_refresh xid int8

View Text

SELECT stll_mv_refresh.userid,
       stll_mv_refresh.xid,
       stll_mv_refresh.starttime,
       stll_mv_refresh.endtime,
       stll_mv_refresh.schemaoid,
       stll_mv_refresh.mvoid,
       stll_mv_refresh.status,
       stll_mv_refresh.refresh_type,
       stll_mv_refresh.db_oid
FROM stll_mv_refresh


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