Redshift Observatory

System Table Tracker

System view pg_catalog.stl_stats_cache version 1.0.81462 / 2025-01-09

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 Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace System Table Tracker The Known Universe White Papers