Redshift Observatory

System Table Tracker

System view pg_catalog.stl_ghost_buffer_stats version 1.0.61191 / 2023-12-18

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 Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers