Redshift Observatory

System Table Tracker

System view pg_catalog.stl_vacuum version 1.0.56754 / 2023-09-21

schema	name	column	data type
pg_catalog	stl_vacuum	blocks	int4
pg_catalog	stl_vacuum	cutoff_xid	int8
pg_catalog	stl_vacuum	eventtime	timestamp
pg_catalog	stl_vacuum	is_recluster	int4
pg_catalog	stl_vacuum	max_merge_partitions	int4
pg_catalog	stl_vacuum	reclaimable_rows	int8
pg_catalog	stl_vacuum	reclaimable_space_mb	int8
pg_catalog	stl_vacuum	rows	int8
pg_catalog	stl_vacuum	sortedrows	int8
pg_catalog	stl_vacuum	status	char(30)
pg_catalog	stl_vacuum	table_id	int4
pg_catalog	stl_vacuum	userid	int4
pg_catalog	stl_vacuum	xid	int8

View Text

SELECT stll_vacuum.userid,
       stll_vacuum.xid,
       stll_vacuum.table_id,
       stll_vacuum.status,
       stll_vacuum.rows,
       stll_vacuum.sortedrows,
       stll_vacuum.blocks,
       stll_vacuum.max_merge_partitions,
       stll_vacuum.eventtime,
       stll_vacuum.reclaimable_rows,
       stll_vacuum.reclaimable_space_mb,
       stll_vacuum.cutoff_xid,
       stll_vacuum.is_recluster
FROM stll_vacuum

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