Redshift Research Project

System Table Tracker

System view pg_catalog.stl_user_vacuum_history version 1.0.59117 / 2023-11-08

schema	name	column	data type
pg_catalog	stl_user_vacuum_history	database_name	char(128)
pg_catalog	stl_user_vacuum_history	duration	int8
pg_catalog	stl_user_vacuum_history	end_time	timestamp
pg_catalog	stl_user_vacuum_history	query_id	int8
pg_catalog	stl_user_vacuum_history	reclaimable_rows	int8
pg_catalog	stl_user_vacuum_history	reclaimed_blocks	int8
pg_catalog	stl_user_vacuum_history	reclaimed_rows	int8
pg_catalog	stl_user_vacuum_history	record_time	timestamp
pg_catalog	stl_user_vacuum_history	rows_before_vacuum	int8
pg_catalog	stl_user_vacuum_history	schema_name	char(128)
pg_catalog	stl_user_vacuum_history	size_before_vacuum	int8
pg_catalog	stl_user_vacuum_history	sortedrows_after_vacuum	int8
pg_catalog	stl_user_vacuum_history	sortedrows_before_vacuum	int8
pg_catalog	stl_user_vacuum_history	start_time	timestamp
pg_catalog	stl_user_vacuum_history	status	char(30)
pg_catalog	stl_user_vacuum_history	table_id	int4
pg_catalog	stl_user_vacuum_history	table_name	char(136)
pg_catalog	stl_user_vacuum_history	transaction_id	int8
pg_catalog	stl_user_vacuum_history	user_id	int4
pg_catalog	stl_user_vacuum_history	vacuum_type	char(30)

View Text

SELECT stll_user_vacuum_history.user_id,
       stll_user_vacuum_history.transaction_id,
       stll_user_vacuum_history.query_id,
       stll_user_vacuum_history.database_name,
       stll_user_vacuum_history.schema_name,
       stll_user_vacuum_history.table_name,
       stll_user_vacuum_history.table_id,
       stll_user_vacuum_history.vacuum_type,
       stll_user_vacuum_history.status,
       stll_user_vacuum_history.start_time,
       stll_user_vacuum_history.end_time,
       stll_user_vacuum_history.record_time,
       stll_user_vacuum_history.duration,
       stll_user_vacuum_history.rows_before_vacuum,
       stll_user_vacuum_history.size_before_vacuum,
       stll_user_vacuum_history.reclaimable_rows,
       stll_user_vacuum_history.reclaimed_rows,
       stll_user_vacuum_history.reclaimed_blocks,
       stll_user_vacuum_history.sortedrows_before_vacuum,
       stll_user_vacuum_history.sortedrows_after_vacuum
FROM stll_user_vacuum_history

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