Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_aggregate_bufmgr_stats version 1.0.116263 / 2025-06-28

schema	name	column	data type
pg_catalog	stl_catalog_aggregate_bufmgr_stats	buffer_write_dirtied_buffers	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	clean_evictions	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	clean_first_enabled	int4
pg_catalog	stl_catalog_aggregate_bufmgr_stats	contention_on_eviction	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	dirty_cache_size_end_of_interval	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	dirty_evictions	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	flush_buffer_calls	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	freelist_size_end_of_interval	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	frequency_cache_size_end_of_interval	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	get_buffer_evictions	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	get_buffer_in_free_list	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	hint_bit_dirtied_buffers	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	invalidate_buffer	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	log_time	timestamp
pg_catalog	stl_catalog_aggregate_bufmgr_stats	max_dirty_buffers	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	microseconds_flushing_dirty_buffers	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	microseconds_flushing_dirty_buffers_during_allocation	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	period_start	timestamp
pg_catalog	stl_catalog_aggregate_bufmgr_stats	pin_buffer_calls	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	read_buffer_cache_hits	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	read_buffer_cache_misses	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	rebuild_worker_dirtied_buffers	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	recency_cache_size_end_of_interval	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	unpin_buffer_calls	int8

View Text

SELECT stll_catalog_aggregate_bufmgr_stats.period_start,
       stll_catalog_aggregate_bufmgr_stats.log_time,
       stll_catalog_aggregate_bufmgr_stats.read_buffer_cache_hits,
       stll_catalog_aggregate_bufmgr_stats.read_buffer_cache_misses,
       stll_catalog_aggregate_bufmgr_stats.get_buffer_in_free_list,
       stll_catalog_aggregate_bufmgr_stats.get_buffer_evictions,
       stll_catalog_aggregate_bufmgr_stats.clean_evictions,
       stll_catalog_aggregate_bufmgr_stats.dirty_evictions,
       stll_catalog_aggregate_bufmgr_stats.contention_on_eviction,
       stll_catalog_aggregate_bufmgr_stats.microseconds_flushing_dirty_buffers_during_allocation,
       stll_catalog_aggregate_bufmgr_stats.microseconds_flushing_dirty_buffers,
       stll_catalog_aggregate_bufmgr_stats.pin_buffer_calls,
       stll_catalog_aggregate_bufmgr_stats.unpin_buffer_calls,
       stll_catalog_aggregate_bufmgr_stats.invalidate_buffer,
       stll_catalog_aggregate_bufmgr_stats.freelist_size_end_of_interval,
       stll_catalog_aggregate_bufmgr_stats.recency_cache_size_end_of_interval,
       stll_catalog_aggregate_bufmgr_stats.frequency_cache_size_end_of_interval,
       stll_catalog_aggregate_bufmgr_stats.dirty_cache_size_end_of_interval,
       stll_catalog_aggregate_bufmgr_stats.max_dirty_buffers,
       stll_catalog_aggregate_bufmgr_stats.clean_first_enabled,
       stll_catalog_aggregate_bufmgr_stats.buffer_write_dirtied_buffers,
       stll_catalog_aggregate_bufmgr_stats.rebuild_worker_dirtied_buffers,
       stll_catalog_aggregate_bufmgr_stats.hint_bit_dirtied_buffers,
       stll_catalog_aggregate_bufmgr_stats.flush_buffer_calls
FROM stll_catalog_aggregate_bufmgr_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