Redshift Observatory

System Table Tracker

System view pg_catalog.stl_ghost_buffer_stats version 1.0.54052 / 2023-07-28

schema name column data type
pg_catalog stl_ghost_buffer_stats end_time timestamp
pg_catalog stl_ghost_buffer_stats ghb_eviction_threshold int8
pg_catalog stl_ghost_buffer_stats ghb_size_before_addition int8
pg_catalog stl_ghost_buffer_stats node_num int4
pg_catalog stl_ghost_buffer_stats num_blocks_added int8
pg_catalog stl_ghost_buffer_stats num_blocks_evicted int8
pg_catalog stl_ghost_buffer_stats start_time timestamp

View Text

SELECT stll_ghost_buffer_stats.node_num,
       stll_ghost_buffer_stats.start_time,
       stll_ghost_buffer_stats.end_time,
       stll_ghost_buffer_stats.ghb_eviction_threshold,
       stll_ghost_buffer_stats.ghb_size_before_addition,
       stll_ghost_buffer_stats.num_blocks_evicted,
       stll_ghost_buffer_stats.num_blocks_added
FROM stll_ghost_buffer_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