Redshift Observatory

System Table Tracker

System view pg_catalog.stl_auto_maintenance_worker version 1.0.41533 / 2022-09-18

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