Redshift Observatory

System Table Tracker

System table pg_catalog.stcs_cache_policy_stats version 1.0.60353 / 2023-11-24

schema name column data type PK U NN
pg_catalog stcs_cache_policy_stats blocks_in_cache int8 NN
pg_catalog stcs_cache_policy_stats capacity int8 NN
pg_catalog stcs_cache_policy_stats __cluster_type char(4) NN
pg_catalog stcs_cache_policy_stats cold_blocks int8 NN
pg_catalog stcs_cache_policy_stats cold_touched_blocks int8 NN
pg_catalog stcs_cache_policy_stats cold_untouched_blocks int8 NN
pg_catalog stcs_cache_policy_stats demote_cold_touch_to_cold_untouch int8 NN
pg_catalog stcs_cache_policy_stats demote_cold_untouch_to_untracked int8 NN
pg_catalog stcs_cache_policy_stats demote_hot_touch_to_hot_untouch int8 NN
pg_catalog stcs_cache_policy_stats demote_hot_untouch_to_cold_touch int8 NN
pg_catalog stcs_cache_policy_stats end_time int8 NN
pg_catalog stcs_cache_policy_stats ghost_buffer_hits int8 NN
pg_catalog stcs_cache_policy_stats hot_blocks int8 NN
pg_catalog stcs_cache_policy_stats hot_touched_blocks int8 NN
pg_catalog stcs_cache_policy_stats hot_untouched_blocks int8 NN
pg_catalog stcs_cache_policy_stats __log_generated_date char(8) NN
pg_catalog stcs_cache_policy_stats node_num int4 NN
pg_catalog stcs_cache_policy_stats __path varchar(2050) NN
pg_catalog stcs_cache_policy_stats promote_cold_touch_to_hot_untouch int8 NN
pg_catalog stcs_cache_policy_stats promote_cold_untouch_to_cold_touch int8 NN
pg_catalog stcs_cache_policy_stats promote_hot_untouch_to_hot_touch int8 NN
pg_catalog stcs_cache_policy_stats promote_untracked_to_cold_untouch int8 NN
pg_catalog stcs_cache_policy_stats reaccess_hot_touch int8 NN
pg_catalog stcs_cache_policy_stats rerep_writes int8 NN
pg_catalog stcs_cache_policy_stats __size int8 NN
pg_catalog stcs_cache_policy_stats __spectrum_oid varchar(128) NN
pg_catalog stcs_cache_policy_stats start_time int8 NN
pg_catalog stcs_cache_policy_stats write_accesses int8 NN


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