Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_rebuild_worker version 1.0.52931 / 2023-07-07

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	within_blockout_window	int4
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,
       stll_catalog_rebuild_worker.within_blockout_window
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