Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_rebuild_worker version 1.0.39009 / 2022-06-08

schema name column data type
pg_catalog stl_catalog_rebuild_worker database int4
pg_catalog stl_catalog_rebuild_worker endtime timestamp
pg_catalog stl_catalog_rebuild_worker exception int4
pg_catalog stl_catalog_rebuild_worker force_lock int4
pg_catalog stl_catalog_rebuild_worker last_rebuild_time timestamp
pg_catalog stl_catalog_rebuild_worker num_rebuilds_reqd int4
pg_catalog stl_catalog_rebuild_worker pid int4
pg_catalog stl_catalog_rebuild_worker rebuild_needed_duration int8
pg_catalog stl_catalog_rebuild_worker rebuild_triggered int4
pg_catalog stl_catalog_rebuild_worker starttime timestamp
pg_catalog stl_catalog_rebuild_worker total_dead_tup_sz int8
pg_catalog stl_catalog_rebuild_worker total_live_tup_sz int8
pg_catalog stl_catalog_rebuild_worker xid int8

View Text

SELECT stll_catalog_rebuild_worker.xid,
       stll_catalog_rebuild_worker.pid,
       stll_catalog_rebuild_worker.database,
       stll_catalog_rebuild_worker.total_live_tup_sz,
       stll_catalog_rebuild_worker.total_dead_tup_sz,
       stll_catalog_rebuild_worker.starttime,
       stll_catalog_rebuild_worker.endtime,
       stll_catalog_rebuild_worker.num_rebuilds_reqd,
       stll_catalog_rebuild_worker.rebuild_triggered,
       stll_catalog_rebuild_worker.last_rebuild_time,
       stll_catalog_rebuild_worker.rebuild_needed_duration,
       stll_catalog_rebuild_worker.force_lock,
       stll_catalog_rebuild_worker.exception
FROM stll_catalog_rebuild_worker


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