Redshift Observatory

System Table Tracker

System view pg_catalog.stl_cache_policy_stats version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	stl_cache_policy_stats	blocks_in_cache	int8
pg_catalog	stl_cache_policy_stats	capacity	int8
pg_catalog	stl_cache_policy_stats	cold_blocks	int8
pg_catalog	stl_cache_policy_stats	cold_touched_blocks	int8
pg_catalog	stl_cache_policy_stats	cold_untouched_blocks	int8
pg_catalog	stl_cache_policy_stats	demote_cold_touch_to_cold_untouch	int8
pg_catalog	stl_cache_policy_stats	demote_cold_untouch_to_untracked	int8
pg_catalog	stl_cache_policy_stats	demote_hot_touch_to_hot_untouch	int8
pg_catalog	stl_cache_policy_stats	demote_hot_untouch_to_cold_touch	int8
pg_catalog	stl_cache_policy_stats	end_time	timestamp
pg_catalog	stl_cache_policy_stats	ghost_buffer_hits	int8
pg_catalog	stl_cache_policy_stats	hot_blocks	int8
pg_catalog	stl_cache_policy_stats	hot_touched_blocks	int8
pg_catalog	stl_cache_policy_stats	hot_untouched_blocks	int8
pg_catalog	stl_cache_policy_stats	node_num	int4
pg_catalog	stl_cache_policy_stats	promote_cold_touch_to_hot_untouch	int8
pg_catalog	stl_cache_policy_stats	promote_cold_untouch_to_cold_touch	int8
pg_catalog	stl_cache_policy_stats	promote_hot_untouch_to_hot_touch	int8
pg_catalog	stl_cache_policy_stats	promote_untracked_to_cold_untouch	int8
pg_catalog	stl_cache_policy_stats	reaccess_hot_touch	int8
pg_catalog	stl_cache_policy_stats	rerep_writes	int8
pg_catalog	stl_cache_policy_stats	start_time	timestamp
pg_catalog	stl_cache_policy_stats	write_accesses	int8

View Text

SELECT stll_cache_policy_stats.node_num,
       stll_cache_policy_stats.promote_untracked_to_cold_untouch,
       stll_cache_policy_stats.promote_cold_untouch_to_cold_touch,
       stll_cache_policy_stats.promote_cold_touch_to_hot_untouch,
       stll_cache_policy_stats.promote_hot_untouch_to_hot_touch,
       stll_cache_policy_stats.reaccess_hot_touch,
       stll_cache_policy_stats.demote_hot_touch_to_hot_untouch,
       stll_cache_policy_stats.demote_hot_untouch_to_cold_touch,
       stll_cache_policy_stats.demote_cold_touch_to_cold_untouch,
       stll_cache_policy_stats.demote_cold_untouch_to_untracked,
       stll_cache_policy_stats.cold_blocks,
       stll_cache_policy_stats.hot_blocks,
       stll_cache_policy_stats.blocks_in_cache,
       stll_cache_policy_stats.start_time,
       stll_cache_policy_stats.end_time,
       stll_cache_policy_stats.capacity,
       stll_cache_policy_stats.write_accesses,
       stll_cache_policy_stats.rerep_writes,
       stll_cache_policy_stats.hot_touched_blocks,
       stll_cache_policy_stats.hot_untouched_blocks,
       stll_cache_policy_stats.cold_touched_blocks,
       stll_cache_policy_stats.cold_untouched_blocks,
       stll_cache_policy_stats.ghost_buffer_hits
FROM stll_cache_policy_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