Redshift Observatory

System Table Tracker

System view pg_catalog.stl_ghost_buffer_stats version 1.0.41881 / 2022-09-30

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