Redshift Observatory

System Table Tracker

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

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