Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_bufmgr_stats version 1.0.76642 / 2024-10-18

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