Redshift Observatory

System Table Tracker

System view pg_catalog.stl_superblock version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	stl_superblock	active_log	int4
pg_catalog	stl_superblock	bloat	int4
pg_catalog	stl_superblock	crc	int4
pg_catalog	stl_superblock	defrag_version	int8
pg_catalog	stl_superblock	flags	int4
pg_catalog	stl_superblock	freelist_size	int4
pg_catalog	stl_superblock	fs_version	int8
pg_catalog	stl_superblock	high_qid	int8
pg_catalog	stl_superblock	is_extended_superblock	int4
pg_catalog	stl_superblock	leader_snapshot_blocks	int4
pg_catalog	stl_superblock	logchain_blocks	int4
pg_catalog	stl_superblock	metachain_blocks	int4
pg_catalog	stl_superblock	node	int4
pg_catalog	stl_superblock	num_blocks	int4
pg_catalog	stl_superblock	num_uncommitted	int8
pg_catalog	stl_superblock	perm_blocks	int4
pg_catalog	stl_superblock	pg_wal_blocks	int4
pg_catalog	stl_superblock	record_time	timestamp
pg_catalog	stl_superblock	sb_tree_blocks	int4
pg_catalog	stl_superblock	sb_tree_height	int4
pg_catalog	stl_superblock	sb_tree_mode	int4
pg_catalog	stl_superblock	sb_tree_root_guid	char(36)
pg_catalog	stl_superblock	sb_tree_root_pos	int4
pg_catalog	stl_superblock	sb_version	int8
pg_catalog	stl_superblock	superblock_capacity	int8
pg_catalog	stl_superblock	tombstoned_sb_tree_blocks	int4

View Text

SELECT stll_superblock.node,
       stll_superblock.record_time,
       stll_superblock.fs_version,
       stll_superblock.sb_version,
       stll_superblock.defrag_version,
       stll_superblock.num_blocks,
       stll_superblock.high_qid,
       stll_superblock.crc,
       stll_superblock.flags,
       stll_superblock.num_uncommitted,
       stll_superblock.active_log,
       stll_superblock.is_extended_superblock,
       stll_superblock.superblock_capacity,
       stll_superblock.perm_blocks,
       stll_superblock.freelist_size,
       stll_superblock.bloat,
       stll_superblock.sb_tree_root_pos,
       stll_superblock.sb_tree_height,
       stll_superblock.sb_tree_mode,
       stll_superblock.sb_tree_blocks,
       stll_superblock.sb_tree_root_guid,
       stll_superblock.tombstoned_sb_tree_blocks,
       stll_superblock.leader_snapshot_blocks,
       stll_superblock.pg_wal_blocks,
       stll_superblock.logchain_blocks,
       stll_superblock.metachain_blocks
FROM stll_superblock

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