Redshift Observatory

System Table Tracker

System view pg_catalog.stl_stats_cache version 1.0.76759 / 2024-10-18

schema	name	column	data type
pg_catalog	stl_stats_cache	num_cache_puts	int4
pg_catalog	stl_stats_cache	num_higher_priority_replacements	int4
pg_catalog	stl_stats_cache	num_local_scans_without_row_stats	int4
pg_catalog	stl_stats_cache	num_misestimations	int4
pg_catalog	stl_stats_cache	num_new_cache_entries	int4
pg_catalog	stl_stats_cache	num_s3_scans	int4
pg_catalog	stl_stats_cache	num_s3_scans_using_stats_cache	int4
pg_catalog	stl_stats_cache	num_s3_scans_without_row_stats	int4
pg_catalog	stl_stats_cache	query	int4
pg_catalog	stl_stats_cache	total_scans	int4

View Text

SELECT stll_stats_cache.query,
       stll_stats_cache.total_scans,
       stll_stats_cache.num_s3_scans,
       stll_stats_cache.num_local_scans_without_row_stats,
       stll_stats_cache.num_s3_scans_without_row_stats,
       stll_stats_cache.num_s3_scans_using_stats_cache,
       stll_stats_cache.num_misestimations,
       stll_stats_cache.num_cache_puts,
       stll_stats_cache.num_new_cache_entries,
       stll_stats_cache.num_higher_priority_replacements
FROM stll_stats_cache

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