Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_auto_maintenance_worker	db_id	int4
pg_catalog	stl_auto_maintenance_worker	error_message	char(200)
pg_catalog	stl_auto_maintenance_worker	eventtime	timestamp
pg_catalog	stl_auto_maintenance_worker	mode	char(15)
pg_catalog	stl_auto_maintenance_worker	pause_count	int4
pg_catalog	stl_auto_maintenance_worker	pid	int4
pg_catalog	stl_auto_maintenance_worker	status	char(16)
pg_catalog	stl_auto_maintenance_worker	table_id	int4
pg_catalog	stl_auto_maintenance_worker	tables_skipped	int4
pg_catalog	stl_auto_maintenance_worker	userid	int4
pg_catalog	stl_auto_maintenance_worker	xid	int8

View Text

SELECT stll_auto_maintenance_worker.userid,
       stll_auto_maintenance_worker.pid,
       stll_auto_maintenance_worker.mode,
       stll_auto_maintenance_worker.db_id,
       stll_auto_maintenance_worker.xid,
       stll_auto_maintenance_worker.table_id,
       stll_auto_maintenance_worker.eventtime,
       stll_auto_maintenance_worker.pause_count,
       stll_auto_maintenance_worker.tables_skipped,
       stll_auto_maintenance_worker.status,
       stll_auto_maintenance_worker.error_message
FROM stll_auto_maintenance_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