Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_bufmgr_stats version 1.0.39278 / 2022-07-23

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 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
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