Redshift Observatory

System Table Tracker

System view pg_catalog.stl_mv_refresh version 1.0.73589 / 2024-08-29

schema name column data type
pg_catalog stl_mv_refresh database_name char(128)
pg_catalog stl_mv_refresh db_oid int8
pg_catalog stl_mv_refresh endtime timestamp
pg_catalog stl_mv_refresh may_have_more_rows char(1)
pg_catalog stl_mv_refresh mv_name char(128)
pg_catalog stl_mv_refresh mvoid int8
pg_catalog stl_mv_refresh no_new_rows char(1)
pg_catalog stl_mv_refresh refresh_type char(32)
pg_catalog stl_mv_refresh schema_name char(128)
pg_catalog stl_mv_refresh schemaoid int8
pg_catalog stl_mv_refresh session_id int4
pg_catalog stl_mv_refresh skipped_rows char(1)
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,
       stll_mv_refresh.no_new_rows,
       stll_mv_refresh.skipped_rows,
       stll_mv_refresh.may_have_more_rows,
       stll_mv_refresh.session_id,
       stll_mv_refresh.database_name,
       stll_mv_refresh.schema_name,
       stll_mv_refresh.mv_name
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