Redshift Observatory

System Table Tracker

System view pg_catalog.stl_cache_policy_stats version 1.0.41465 / 2022-09-10

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