Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_aggregate_bufmgr_stats version 1.0.77433 / 2024-11-01

schema	name	column	data type
pg_catalog	stl_catalog_aggregate_bufmgr_stats	clean_evictions	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	contention_on_eviction	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	dirty_evictions	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	invalidate_buffer	int8
pg_catalog	stl_catalog_aggregate_bufmgr_stats	log_time	timestamp
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	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
FROM stll_catalog_aggregate_bufmgr_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