Redshift Observatory

System Table Tracker

System view pg_catalog.stl_autovacuum_detail version 1.0.54239 / 2023-08-04

schema name column data type
pg_catalog stl_autovacuum_detail commit_time int4
pg_catalog stl_autovacuum_detail endtime timestamp
pg_catalog stl_autovacuum_detail fetch_info_time int4
pg_catalog stl_autovacuum_detail max_commit_time int4
pg_catalog stl_autovacuum_detail min_commit_time int4
pg_catalog stl_autovacuum_detail num_commits int4
pg_catalog stl_autovacuum_detail num_vacdel int4
pg_catalog stl_autovacuum_detail num_vacrp int4
pg_catalog stl_autovacuum_detail num_vacsort int4
pg_catalog stl_autovacuum_detail pause_time int4
pg_catalog stl_autovacuum_detail pid int4
pg_catalog stl_autovacuum_detail skip_time int4
pg_catalog stl_autovacuum_detail space_reclaimed_mb int4
pg_catalog stl_autovacuum_detail starttime timestamp
pg_catalog stl_autovacuum_detail tables_done int4
pg_catalog stl_autovacuum_detail tables_skipped int4
pg_catalog stl_autovacuum_detail window_time int4

View Text

SELECT stll_autovacuum_detail.pid,
       stll_autovacuum_detail.starttime,
       stll_autovacuum_detail.endtime,
       stll_autovacuum_detail.window_time,
       stll_autovacuum_detail.pause_time,
       stll_autovacuum_detail.commit_time,
       stll_autovacuum_detail.max_commit_time,
       stll_autovacuum_detail.min_commit_time,
       stll_autovacuum_detail.num_commits,
       stll_autovacuum_detail.tables_skipped,
       stll_autovacuum_detail.tables_done,
       stll_autovacuum_detail.num_vacdel,
       stll_autovacuum_detail.num_vacrp,
       stll_autovacuum_detail.num_vacsort,
       stll_autovacuum_detail.space_reclaimed_mb,
       stll_autovacuum_detail.skip_time,
       stll_autovacuum_detail.fetch_info_time
FROM stll_autovacuum_detail


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