Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_column_stats	col	int4
pg_catalog	stl_column_stats	missing_count	int8
pg_catalog	stl_column_stats	missing_runtime	int8
pg_catalog	stl_column_stats	report_time	timestamp
pg_catalog	stl_column_stats	stale_count	int8
pg_catalog	stl_column_stats	stale_runtime	int8
pg_catalog	stl_column_stats	tbl	int4
pg_catalog	stl_column_stats	total_count	int8
pg_catalog	stl_column_stats	total_runtime	int8

View Text

SELECT stll_column_stats.tbl,
       stll_column_stats.col,
       stll_column_stats.total_count,
       stll_column_stats.total_runtime,
       stll_column_stats.stale_count,
       stll_column_stats.stale_runtime,
       stll_column_stats.missing_count,
       stll_column_stats.missing_runtime,
       stll_column_stats.report_time
FROM stll_column_stats

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