Redshift Observatory

System Table Tracker

System view pg_catalog.stl_disks_blocks_stats version 1.0.50300 / 2023-05-09

schema	name	column	data type
pg_catalog	stl_disks_blocks_stats	allocated_blks	int8
pg_catalog	stl_disks_blocks_stats	local_backedup_blks	int8
pg_catalog	stl_disks_blocks_stats	local_cap	int8
pg_catalog	stl_disks_blocks_stats	logtime	timestamp
pg_catalog	stl_disks_blocks_stats	mirror_allocated_blks	int8
pg_catalog	stl_disks_blocks_stats	mirror_rerep_blks	int4
pg_catalog	stl_disks_blocks_stats	node	int4
pg_catalog	stl_disks_blocks_stats	num_mirror_reserved	int8
pg_catalog	stl_disks_blocks_stats	num_primary_reserved	int8
pg_catalog	stl_disks_blocks_stats	perm_blks	int8
pg_catalog	stl_disks_blocks_stats	primary_allocated_blks	int8
pg_catalog	stl_disks_blocks_stats	primary_rerep_blks	int4
pg_catalog	stl_disks_blocks_stats	sb_cap	int8
pg_catalog	stl_disks_blocks_stats	temp_blks	int8
pg_catalog	stl_disks_blocks_stats	to_backup_blks	int8

View Text

SELECT stll_disks_blocks_stats.node,
       stll_disks_blocks_stats.logtime,
       stll_disks_blocks_stats.local_cap,
       stll_disks_blocks_stats.sb_cap,
       stll_disks_blocks_stats.allocated_blks,
       stll_disks_blocks_stats.primary_allocated_blks,
       stll_disks_blocks_stats.mirror_allocated_blks,
       stll_disks_blocks_stats.perm_blks,
       stll_disks_blocks_stats.to_backup_blks,
       stll_disks_blocks_stats.temp_blks,
       stll_disks_blocks_stats.local_backedup_blks,
       stll_disks_blocks_stats.primary_rerep_blks,
       stll_disks_blocks_stats.mirror_rerep_blks,
       stll_disks_blocks_stats.num_primary_reserved,
       stll_disks_blocks_stats.num_mirror_reserved
FROM stll_disks_blocks_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