Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_analyze_compression	best_compression_bytes	int8
pg_catalog	stl_analyze_compression	best_compression_encoding	char(15)
pg_catalog	stl_analyze_compression	col	int4
pg_catalog	stl_analyze_compression	mode	char(14)
pg_catalog	stl_analyze_compression	ndv	int8
pg_catalog	stl_analyze_compression	new_encoding	char(15)
pg_catalog	stl_analyze_compression	old_encoding	char(15)
pg_catalog	stl_analyze_compression	recommended_bytes	int8
pg_catalog	stl_analyze_compression	start_time	timestamp
pg_catalog	stl_analyze_compression	tablename	char(128)
pg_catalog	stl_analyze_compression	tbl	int4
pg_catalog	stl_analyze_compression	userid	int4
pg_catalog	stl_analyze_compression	xid	int8

View Text

SELECT stll_analyze_compression.userid,
       stll_analyze_compression.start_time,
       stll_analyze_compression.xid,
       stll_analyze_compression.tbl,
       stll_analyze_compression.tablename,
       stll_analyze_compression.col,
       stll_analyze_compression.old_encoding,
       stll_analyze_compression.new_encoding,
       stll_analyze_compression.mode,
       stll_analyze_compression.best_compression_encoding,
       stll_analyze_compression.recommended_bytes,
       stll_analyze_compression.best_compression_bytes,
       stll_analyze_compression.ndv
FROM stll_analyze_compression

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