Redshift Observatory

System Table Tracker

System view pg_catalog.stl_result_cache_stats version 1.0.59596 / 2023-11-12

schema	name	column	data type
pg_catalog	stl_result_cache_stats	evict_count	int8
pg_catalog	stl_result_cache_stats	hit_count	int8
pg_catalog	stl_result_cache_stats	invalidate_count	int8
pg_catalog	stl_result_cache_stats	lookup_count	int8
pg_catalog	stl_result_cache_stats	match_count	int8
pg_catalog	stl_result_cache_stats	mem_usage	int8
pg_catalog	stl_result_cache_stats	num_entries	int4
pg_catalog	stl_result_cache_stats	num_valid_entries	int4
pg_catalog	stl_result_cache_stats	populate_count	int8
pg_catalog	stl_result_cache_stats	recordtime	timestamp
pg_catalog	stl_result_cache_stats	telemetry	char(500)

View Text

SELECT stll_result_cache_stats.recordtime,
       stll_result_cache_stats.num_entries,
       stll_result_cache_stats.num_valid_entries,
       stll_result_cache_stats.lookup_count,
       stll_result_cache_stats.hit_count,
       stll_result_cache_stats.populate_count,
       stll_result_cache_stats.evict_count,
       stll_result_cache_stats.invalidate_count,
       stll_result_cache_stats.mem_usage,
       stll_result_cache_stats.match_count,
       stll_result_cache_stats.telemetry
FROM stll_result_cache_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