Redshift Observatory

System Table Tracker

System view pg_catalog.stl_autovacuum_skip_reason version 1.0.40467 / 2022-08-08

schema	name	column	data type
pg_catalog	stl_autovacuum_skip_reason	diststyle	int4
pg_catalog	stl_autovacuum_skip_reason	eventtime	timestamp
pg_catalog	stl_autovacuum_skip_reason	id	int4
pg_catalog	stl_autovacuum_skip_reason	num_columns	int4
pg_catalog	stl_autovacuum_skip_reason	num_rows	int8
pg_catalog	stl_autovacuum_skip_reason	reason	char(48)
pg_catalog	stl_autovacuum_skip_reason	slice	int4
pg_catalog	stl_autovacuum_skip_reason	vacuum_mode	char(16)

View Text

SELECT stll_autovacuum_skip_reason.eventtime,
       stll_autovacuum_skip_reason.id,
       stll_autovacuum_skip_reason.slice,
       stll_autovacuum_skip_reason.diststyle,
       stll_autovacuum_skip_reason.vacuum_mode,
       stll_autovacuum_skip_reason.num_columns,
       stll_autovacuum_skip_reason.num_rows,
       stll_autovacuum_skip_reason.reason
FROM stll_autovacuum_skip_reason

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