Redshift Observatory

System Table Tracker

System view pg_catalog.stl_block_hdr_stats version 1.0.121010 / 2025-08-28

schema	name	column	data type
pg_catalog	stl_block_hdr_stats	hdr_sh_mem_usage	float8
pg_catalog	stl_block_hdr_stats	node	int4
pg_catalog	stl_block_hdr_stats	now	timestamp
pg_catalog	stl_block_hdr_stats	num_alloc_fails	int4
pg_catalog	stl_block_hdr_stats	num_sb_adds	int4
pg_catalog	stl_block_hdr_stats	num_sb_tosses	int4
pg_catalog	stl_block_hdr_stats	num_sh_mem_adds	int4
pg_catalog	stl_block_hdr_stats	num_sh_mem_tosses	int4
pg_catalog	stl_block_hdr_stats	sb_fragmentation	float8
pg_catalog	stl_block_hdr_stats	sh_mem_fragmentation	float8
pg_catalog	stl_block_hdr_stats	sh_mem_percentage	float8
pg_catalog	stl_block_hdr_stats	since	timestamp
pg_catalog	stl_block_hdr_stats	total_count_in_sh_mem	int4
pg_catalog	stl_block_hdr_stats	total_count_in_superblock	int4

View Text

SELECT stll_block_hdr_stats.now,
       stll_block_hdr_stats.since,
       stll_block_hdr_stats.node,
       stll_block_hdr_stats.total_count_in_sh_mem,
       stll_block_hdr_stats.total_count_in_superblock,
       stll_block_hdr_stats.num_sh_mem_adds,
       stll_block_hdr_stats.num_sh_mem_tosses,
       stll_block_hdr_stats.num_sb_adds,
       stll_block_hdr_stats.num_sb_tosses,
       stll_block_hdr_stats.num_alloc_fails,
       stll_block_hdr_stats.sh_mem_fragmentation,
       stll_block_hdr_stats.sb_fragmentation,
       stll_block_hdr_stats.hdr_sh_mem_usage,
       stll_block_hdr_stats.sh_mem_percentage
FROM stll_block_hdr_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