Redshift Observatory

System Table Tracker

System view pg_catalog.stl_analyze_compression version 1.0.49676 / 2023-04-30

schema name column data type
pg_catalog stl_analyze_compression col int4
pg_catalog stl_analyze_compression mode char(14)
pg_catalog stl_analyze_compression new_encoding char(15)
pg_catalog stl_analyze_compression old_encoding char(15)
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
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