Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_bufmgr_stats version 1.0.69451 / 2024-06-27

schema	name	column	data type
pg_catalog	stl_catalog_bufmgr_stats	contentions_on_eviction	int8
pg_catalog	stl_catalog_bufmgr_stats	dirty_evictions	int8
pg_catalog	stl_catalog_bufmgr_stats	evictions	int8
pg_catalog	stl_catalog_bufmgr_stats	free_buffers_found	int8
pg_catalog	stl_catalog_bufmgr_stats	hits	int8
pg_catalog	stl_catalog_bufmgr_stats	logtime	timestamp
pg_catalog	stl_catalog_bufmgr_stats	period_start	timestamp
pg_catalog	stl_catalog_bufmgr_stats	pid	int8
pg_catalog	stl_catalog_bufmgr_stats	read_buffer	int8

View Text

SELECT stll_catalog_bufmgr_stats.logtime,
       stll_catalog_bufmgr_stats.period_start,
       stll_catalog_bufmgr_stats.read_buffer,
       stll_catalog_bufmgr_stats.hits,
       stll_catalog_bufmgr_stats.free_buffers_found,
       stll_catalog_bufmgr_stats.evictions,
       stll_catalog_bufmgr_stats.dirty_evictions,
       stll_catalog_bufmgr_stats.contentions_on_eviction,
       stll_catalog_bufmgr_stats.pid
FROM stll_catalog_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